Financial Planning

I am working on a 30-year plan. I want to have a row of years and the amount that would have to be put away each year. Lets say we had a $200,000 project that we wanted to do in year 2025 and we wanted to save for 3 years. 2019 would be 0, 2020 would be 0, 2021 would be 0 , 2022 would be one third of $200,000 and so on until year 2025 when the project would be completed. I know there is a formula for each years cell but I can't think of it.

Any help would be appreciated.

Capture.JPG

I'm assuming that the cell under in the 2019 column where you want the formula to go is E3 (it's not clear from your picture which rows and columns you are using) - you can use this formula:

=IF(E$1>=$D3,"",IF($D3-E$1>$C3,"",ROUND($B3/$C3,0)))

then copy this across and down as required.

Hope this helps.

Pete