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, you 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