| Monthly Values | End of Y1 | End of Y2 | End of Y3 | End of Y4 | End of Y5 | |
|---|---|---|---|---|---|---|
| Property Value | ||||||
| Property Value | - | 0 | 0 | 0 | 0 | 0 |
| Income | ||||||
| 0 | 0 | 0 | 0 | 0 | ||
| Effective Rental Income | 0 | 0 | 0 | 0 | 0 | 0 |
| Operating Expenses | ||||||
| 0 | 0 | 0 | 0 | 0 | ||
| 0 | 0 | 0 | 0 | 0 | ||
| 0 | 0 | 0 | 0 | 0 | ||
| Interest | 0 | 0 | 0 | 0 | 0 | 0 |
| Management Fee | 0 | 0 | 0 | 0 | 0 | 0 |
| Maint. & Repairs | 0 | 0 | 0 | 0 | 0 | 0 |
| Turnover Costs | 0 | 0 | 0 | 0 | 0 | 0 |
| CapEx Reserves | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Op. Expenses | 0 | 0 | 0 | 0 | 0 | 0 |
| Net Operating Income (NOI) | ||||||
| NOI Before Depreciation | 0 | 0 | 0 | 0 | 0 | 0 |
| Building Depreciation | 0 | 0 | 0 | 0 | 0 | 0 |
| NOI (Taxable Income) | 0 | 0 | 0 | 0 | 0 | 0 |
| Tax Liability | 0 | 0 | 0 | 0 | 0 | 0 |
| Cash Flow After Tax* | 0 | 0 | 0 | 0 | 0 | 0 |
| CoC Return After Tax (%)* | 0 | 0 | 0 | 0 | 0 | 0 |
| Appreciation ($) | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Return ($)* | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Return (%)* | 0 | 0 | 0 | 0 | 0 | 0 |
Note: 'Cash Flow After Tax' = actual cash flows (NOI Before Depreciation) + tax liability or tax savings from depreciation.
Note: 'CoC Return After Tax (%)' = 'Cash Flow After Tax' / 'Initial Cash Investment'.
Note: 'Total Return ($)' = 'Cash Flow After Tax' + 'Appreication'
Note: 'Total Return (%)' = 'Total Return ($)' / 'Initial Cash Investment'.
Caveat: This tool currently treats 'CapEx reserves' as immediately tax-deductible expenses. In reality, capital expenditures should be capitalized and depreciated over time when actually spent, not deducted as operating expenses.
Caveat: Negative 'Tax Liability' values (ie tax savings) only apply if your Modified Adjusted Gross Income (MAGI) is under $100,000. If so, you can deduct up to $25,000 in rental real estate losses against other income. This $25,000 allowance phases out between MAGI of $100,000-$150,000. Above $150,000 MAGI, investors generally cannot use rental losses to offset non-passive income. Real estate professionals have it different - they can deduct unlimited rental losses against any type of income, with no MAGI restrictions.
| Yr | Property Value | Rental Income | Operating Expenses | NOIBD | Deprec. | Taxable Income | Tax Liability | Cash Flow After Tax | CoC After Tax (%) | Apprec. ($) | Total Return ($) | Total Return (%) |
|---|
Note: Capital Gains Tax applies to the difference between Sale Price and Tax Basis (Purchase Price + Improvements + Closing Costs - Total Depreciation)
Note: Depreciation Recapture Tax is calculated at a fixed 25% rate on all depreciation taken
| Year | Payment | Principal | Interest | Balance |
|---|
Built by George Leon