Quote Originally Posted by JohnTopley View Post
Will look at the conversion.

in "Straightline" to get the last value (Mar 18) you have

=D8-74355.45

where does the 74355.45 come from?
74355.45 is the total of all amounts already expensed. So that would be = (Acquisition Cost - Opening WDV) + Expenses for July-Feb ie. 74495-16506+(16366.45) ie. D8-I8+(K8:R8)

The end date might vary from time to time depending on when the asset will be purchased and when will be it's term end date so I guess that's why it is important that the formula can identify when will be the end date. So that by the time it reaches that date, it can just return a value that is equal to the amount that will complete the acquisition cost. I hope that makes sense?