Calculates straigh-light depreciation of an asset for a single period, sum-of-years' digits depreciation of an asset for a specified period, depreciation of an asset for a specified period using the fixed-declining balance method, depreciation of an asset for a specified period using the double-declining balance method or some other method you specify, depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.
The free bonus: sec.xls - contains 26 annuities Excel templates: templates for coupons (6 templates), teplates for price calculation (6 templates), templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duratinn for a security. Full instructions.