EXCEL AVANZADO / FUNCIONES FINANCIERAS / METODOS DE DEPRECIACION123456789101112131415161718192021A B C D E F GS12 Costo $30,000Valor_residual$7,500Vida10Factor =2Ao Depreciacin Saldo Depreciacin Saldo Depreciacin Saldo1 $2,250.00 $27,750.00 $4,090.91 $25,909.09 $6,000.00 $24,000.002 $2,250.00 $25,500.00 $3,681.82 $22,227.27 $4,800.00 $19,200.003 $2,250.00 $23,250.00 $3,272.73 $18,954.55 $3,840.00 $15,360.004 $2,250.00 $21,000.00 $2,863.64 $16,090.91 $3,072.00 $12,288.005 $2,250.00 $18,750.00 $2,454.55 $13,636.36 $2,457.60 $9,830.406 $2,250.00 $16,500.00 $2,045.45 $11,590.91 $1,966.08 $7,864.327 $2,250.00 $14,250.00 $1,636.36 $9,954.55 $364.32 $7,500.008 $2,250.00 $12,000.00 $1,227.27 $8,727.27 $0.00 $7,500.009 $2,250.00 $9,750.00 $818.18 $7,909.09 $0.00 $7,500.0010 $2,250.00 $7,500.00 $409.09 $7,500.00 $0.00 $7,500.00SLN(costo,valor residual,vida)SYD(costo,valor residual, vida,periodo)DDB(costo,valor residual, vida,periodo,factor)METODOS DE DEPRECIACIONMtodo Directo (SLN) Mtodo de Anualidades (SYD)Mtodo por doble disminucin de saldo (DDB)