investment projection spreadsheet 2

This video is Part 2 of "Building out an Investment Projection Spreadsheet. It includes an additional couple of features that may make the decision making process easier for you in the end.
The original video will show you how to build out a rudimentary spreadsheet to help estimate future investment forecasts. It can be found at: • Building out an Invest...
It is built on an annual (year-by-year) basis and should not be used for precise forecasts. The idea is to build out a first model and then you can do whatever you want with it later.
This is a rough Future Value (FV) calculation model and will be imprecise given our violation of basic input compounding. For example, there is an obvious conflict between making monthly contributions and assessing those contributions on an annual basis. Let this spreadsheet get you started and then build yours out as you see fit.

[@mohammedissaq7832]

Hello, Dr. Garcia. I work in a government facility as an accountant of contracts and expenses. The nature of my work requires me to make a record of the contractors' monthly payments. As you know, monthly payments come from different locations, each site has a referral decision, a purchase order is different from the other, and there are fines for the contractors. Can you give us a record of them through Excel ? I would be thankful ❤

[@HerbShoufler]

Just watched your Part 2. Is there a formula to add a percent factor to contributions and withdrawals if you want to increase those to keep up with inflation? i.e. 1st year contribution $300 per month, 2nd year contribution $309 per month and so on. The same thing with withdrawals, if you want that to increase by 3 or 4% each year.