I have a table in microsoft access and need to create a report showing straight line depreciation for 6 years with 0 salvage value.
I have started it but need help finishing it.
Fiscal Year: July 1 (7/1) to June 30 (6/30)
The purchase date, purchased price, and fiscal year columns, accumulated depreciation , and net to be depreciated columns will be affect.
Calculate straight line depreciation for 6 years from the current fiscal year.
if the purchased date is not a full year then, for the first year, subtract the unused months. Ex: if purchased in august, then it will be 11 months instead of full year.
The following years will be same, except the last year will show the remaining balance if within the years shown from the current fiscal year.
Otherwise, future amounts will be summed in the "net to be depreciated" column. No need to show future year columns. This report should be 5 years back from the current fiscal year.
"accumulated depreciation" will consist of sum of all the amounts minus any "net to be depreciated amount"
28 freelance font une offre moyenne de $86 pour ce travail
Dear, I am Access/VBA expert since 11 years. I can fix your issue today. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice