View Categories

Funded Reserves and Capital Improvements

One reason you might need to set aside funded reserves is to pay for capital improvements in a future year. For example, suppose you plan to do some rehab work that will cost $30,000 in year 1, and $20,000 in year 2. You want the total of $50,000 to be part of your initial investment.

You would enter the $30,000 as Capital Improvements from Initial Investment in cell D87 of the “Cash Flow & Resale Assumptions” worksheet.

You would then enter the year 2 amount of $20,000 in 3 places:

  • in cell D90, as Funded Reserves from Initial Investment,
  • in cell E94, to apply these reserves in year 2, and
  • in cell E88, to show the actual year 2 capital improvements.

Also, check the “Apply reserves (if available) as follows” checkbox in row 94. When you are done, the “Capital Improvements & Funded Reserves” section will look something like this:

cifr