Excel amortization: The SYD function

Excel amortization: The SYD function


YOUR OBJECTIVE
Your company just acquired a new machine for $10,000. This machine has a useful life of ten years. It has been estimated that it will then have a residual value of $2,500. Bookkeeping asked you to use the sum-of-years’ digits depreciation method to calculate how much it should be depreciated each year. [Read more...]