Investment Property Analyzer

Meloni Realty • income, valuation, financing, taxes and investment returns

Workbook Fidelity ModelStage 5 Pro
Not signed in
Ready

Projected After-Tax Cash Flow

Annual operating cash flow; sale proceeds are shown separately.

After-tax operating cash flowNOI

Investment Snapshot

Valuation Assessment

Financing & Coverage

Sale & Tax Summary

Return Requirements

Model Health

This application intentionally follows the supplied Investment Property Analysis workbook, including its simplified depreciation, operating-tax, financing-cost amortization, and sale-tax conventions. It is an analytical model and not legal, lending, accounting, or tax advice.

Analysis Setup

Yellow fields are inputs. Results update when you click Recalculate.

Property & Operations

Financing

Mortgage points are entered as points (for example, 2 = two points). The workbook treats the origination fee as a dollar amount and amortizes both over the mortgage time horizon.

Taxes & Required Return

Valuation Benchmarks

Direct capitalization uses Year 1 NOI ÷ desired cap rate. GRM value uses Year 1 potential gross income × desired GRM, matching the workbook.
Projection range

The original workbook supports holding periods and debt schedules through 40 years. This web model supports the same 40-year analysis horizon and up to 480 monthly amortization rows.

After-Tax Cash Flow Statement

Equivalent to the assumptions worksheet operating projection.

Years 1–40 supported

Annual Cash Flow Table

After-Tax Equity Reversion

Debt Service: Annual Totals & Coverage

Taxes From Operations

Taxes Due on Sale

Monthly Loan Amortization Schedule

Includes the workbook's separate point and origination-fee amortization schedules.

Rate Buydown Comparison Tool

Replicates the workbook's separate analysis of paying points for a lower rate.

Separate Model

Loan 1 — Without Points

Loan 2 — With Points

Break-Even Assessment

Financing Scenario Lab

Compare three financing structures against the same property and operating assumptions.

Side-by-Side

Scenario Comparison

Price, Rent & NOI Support

Reverse-engineer the operating performance needed to support the purchase price and financing.

Decision Support

Target Support Assumptions

Interpretation

IRR Sensitivity

Purchase price and monthly rent sensitivity around the current assumptions.

Cloud Workspace

Secure cross-device storage for clients, properties, analyses and financing scenarios.

Sign in to use cloud storage.

Clients

Sign in to load clients.

Properties

Select a client or sign in.

Cloud Analyses

Select a property to load analyses.

Client Record

Property Record

Saved Financing Scenarios

Persist Scenario A/B/C sets with the current cloud analysis.

Load a cloud analysis to view saved scenarios.

PDF Report

The generated PDF includes the executive conclusion, assumptions, Year 1 operating results, income valuation, return metrics, sale/tax analysis, and up to 10 years of projected cash flow. It downloads directly as a branded PDF instead of opening the browser print dialog.