Go to File
Click "File" top left
Make a copy
Click "Make a copy" from dropdown
Input current year
For example, type "2023" in green cell
Go to information tab
Click "INFO" bottom left
Input reserves per property
For example, "$1,000" for property #1
Input years per property item
For example, it might look something like this for a new construction purchase in "2015"
Return back to first tab
Formulas change colors based on your current year and the life expectancy of important/major items. Important items are safety related and major items are things that could cost over $10k to replace or repair.
Using the example below, here's how this forecaster can help you...
Upon review, the cells that changed color need your attention, and below I'll explain how you use this info...