financial modeling - best practices

1
NonSuch Financial Model Calculations Input Links Asset: Original Cost: Life (years): Salvage Value: Printer $ 35,000 7 $ 500 Depreciation Calculation Depreciation Amount Year SLN DB DDB SYD 1 $4,928.57 $15,925.00 $10,000.00 $8,625.00 2 $4,928.57 $8,679.13 $7,142.86 $7,392.86 3 $4,928.57 $4,730.12 $5,102.04 $6,160.71 4 $4,928.57 $2,577.92 $3,644.31 $4,928.57 5 $4,928.57 $1,404.96 $2,603.08 $3,696.43 6 $4,928.57 $765.71 $1,859.34 $2,464.29 7 $4,928.57 $417.31 $1,328.10 $1,232.14

Upload: steven-galford

Post on 17-Sep-2015

214 views

Category:

Documents


1 download

DESCRIPTION

Mo ta

TRANSCRIPT

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