Write a VBA macro to calculate straight line depreciation from an excel spreadsheet
$30-100 USD
In Progress
Posted almost 12 years ago
$30-100 USD
Paid on delivery
Please do not solicit other work here, do not advertise and just address the request. Thank you
There is a data dump in excel, in a pretty clean condition. I can run depreciation calculations on my own. This is easy.
All I need is someone to write a clear (with notes) VBA code that **automatically** grabs the values from cells and then calculates the depreciation for these assets.
This is a very easy and straightforward project for anyone who has a good VBA in excel understanding.
I attach an example (and not the actual) spreadsheet.
## Deliverables
Please do not solicit other work here, do not advertise and just address the request. Thank you
There is a data dump in excel, in a pretty clean condition. I can run depreciation calculations on my own. This is easy.
All I need is someone to write a clear (with notes) VBA code that **automatically** grabs the values from cells and then calculates the depreciation for these assets.
There are many assets available, bought at different times and with different depreciation rates and salvage values. The method is straight line. (SLN function in excel)
The goal for this is to calculate the depreciation for each asset in a 15 year horizon.
I attach an example (and not the actual) spreadsheet.
* * *This broadcast message was sent to all bidders on Sunday May 27, 2012 1:38:41 PM:
Hello The method is straight line (SLN excel function). This method requires you to know the asset purchase price, the salvage value and the depreciation rate (8%, 20% etc) I will supply all of those. Thanks