Investment property analysis with capital improvements

This will calculate: a full year-by-year projection on an income property, out to 5, 10, 15 or 20 years, and give you the IRR and FMRR both before and after tax.

Enter the purchase and both loans (including any balloons), your sale assumptions, first year operations, depreciation and tax brackets. Purchase price must equal the down payment plus the two loan amounts, or the form will tell you.

Two buttons open small windows where you enter figures year by year. Capital improvements are money spent on the building, deducted from spendable income in the year you spend it. User determined sales price lets you override the appreciated value in any year with a figure of your own — those years show in blue on the schedule.

Each block of five years prints on its own page. Figures shown in red are negative.