financial modeling - best practices
DESCRIPTION
Mo taTRANSCRIPT
Sheet1NonSuch Financial ModelCalculationsInput
LinksAsset:Original Cost:Life (years):Salvage
Value:Printer$35,0007$500Depreciation CalculationDepreciation
AmountYearSLN
tung.nguyen: tung.nguyen:Straight-line methodDB
tung.nguyen: tung.nguyen:Declining balance methodDDB
tung.nguyen: tung.nguyen:Double-declining balance methodSYD
tung.nguyen: tung.nguyen:Sum of the years digits
method1$4,928.57$15,925.00$10,000.00$8,625.002$4,928.57$8,679.13$7,142.86$7,392.863$4,928.57$4,730.12$5,102.04$6,160.714$4,928.57$2,577.92$3,644.31$4,928.575$4,928.57$1,404.96$2,603.08$3,696.436$4,928.57$765.71$1,859.34$2,464.297$4,928.57$417.31$1,328.10$1,232.14