Financial Planning

[frankday]

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.

 

[wideboydixon]

Like this?

Book1
	A	B
1	Cost of project:	£300,000
2	Completion year:	2025
3	Number of years to save:	3
4
5	Year	Amount to save
6	2018
7	2019
8	2020
9	2021
10	2022	£100,000
11	2023	£100,000
12	2024	£100,000
13	2025
14	2026
15	2027
Sheet1

Cell Formulas
Range	Formula
B6	=IF(AND($A6>=$B$2-$B$3,$A6<$B$2),$B$1/$B$3,"")

Copy B6 down as necessary.

WBD

 

[frankday]

Perfect, I forgot all about IF AND. It worked. Thanks

 

[Drakefo71]

Financial advice to invest and save in higher return funds is very important. Hopefully I will succeed in my personal financial planning as have started learning things and concept of my own as could never trust someone else advice.<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>