I am trying to get a formula for working out a series of cash flows based on input start date and fixed distribution of spending over 14months.
The solution provided by a Gotit Pro last week, works well, but there is some sort of error in it, for the last month. No matter when the start date is, the last month of 6.25% of spending does not show up.
Solved by A. F. in 23 mins