In range B3:V3, one will record Purchase price of various Assets purchased in different months. In the next two rows one specifies whether the Assets purchased in that month have to be amortised or not and the months over which the Assets has to be amortised respectively.
The task is to determine the amount to be amortised each month. Cost of amortization each month will be for Assets purchased in that month + Assets purchased in previous months.
You may refer to my solution in the this workbook.
Compute monthly asset amortisation expense
{ 0 Comments }