Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function to calculate the straight line -- a standard ...
Begin with the following formula:=PV*(1+R)^NEither write this formula in an Excel spreadsheet cell or elsewhere for reference. Enter the present value in an Excel spreadsheet cell in place of "PV," ...