Hello this is my first post so thanks in advance for your help. I have a spreadsheet I am developing that requires the user to enter three variables (1) Project Start Date, (2) Project End Date, (3) Total Project Cost. I then need the Total Project cost to be distributed based on a specific 12 month cash flow profile (i.e. 5% in the first month, 7% in the second month, 3% in the third month, etc...). The % allocation by month is fixed over 12 periods, but I would like it to be applied to a project that may be longer or shorter than 12 months yet still maintain the same profile (cash flow curve shape). I have looked into Fourier Analysis, but it can't be applied in this case. Anyone know if a quick solution?
Bookmarks