Get instant live Excel expert help to learn how to apply financial function in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function
Solved by I. A. in 12 mins
Use the VBA Editor to create a new module.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function
Solved by G. S. in 30 mins
Use the Depreciation function in cell D13 to calculate depreciation based on the Total Estimated Value on All Items (cell D14) and the Depreciation Rate (D12).
Solved by X. W. in 28 mins
In cell B7, enter a formula using the function for the Double-declining balance depreciation method. Use the cell names Cost and Salvage for the Cost and Salvage function arguments. Use the appropriate cell reference for the Life argument. Use the appropriate cell reference for the Period argument. Be sure to use the appropriate cell reference types to allow you to copy the formula to the rest of the column. Use a multiplier of 3.
Solved by G. U. in 26 mins
How do I make a depreciation schedule excel change according to the depreciation method selected from a drop down list?
Also how would I make that drop down list?
Solved by T. F. in 23 mins
I wanted to calculate a depreciation on asset, i need formula for it, i have described full rules in sheet
Solved by Z. Y. in 17 mins
I have an excel problem that needs me to come up with a formula that uses syd, sln and ddb depreciation function but be able to drag down instead of insert all of them how do I do that
Solved by V. W. in 21 mins
Need help correcting a formula in D182 and 183. When D180 says "no depreciation" it should be calculated as a "0"
Solved by D. D. in 12 mins
I need help creating a formula that fills out the shaded cells depreciation figures
Solved by V. D. in 30 mins
In cell B7, enter a formula using the function for the Declining balance depreciation method. Use the cell names Cost and Salvage for the Cost and Salvage function arguments. Use the appropriate cell reference for the Life argument. Use the appropriate cell reference for the Period argument. Be sure to use the appropriate cell reference types to allow you to copy the formula to the rest of the column. The asset will be in use in year 1 for 5 months.
Solved by E. H. in 18 mins