REAL ESTATE / FINANCIAL ANALYSIS

Investment Dashboard

Evaluate new-build rental properties with the numbers that matter.

Overall investment assessment

Very Good Investment

Combined income performance, debt coverage, operating efficiency, and built-in equity.

INVESTMENT RATING
83.5 / 100
VERY GOOD
Monthly cash flow ↗
$1,056.66
After all expenses and mortgage
Capitalization rate ◎
5.85%
NOI ÷ appraised value
Debt coverage (DSCR) ▤
1.39×
NOI ÷ annual debt payments
Cash-on-cash return %
5.88%
Annual cash flow ÷ invested cash

Property assumptions

Change any input. All calculations update instantly.

Development & property value 01 / 03

$
Enter the total build cost with quantity 1, or a $/sq. ft. rate
$
$
Rental income
$
Monthly operating expenses
$
$
$
$
%
%
Percentage of gross scheduled rent
The uploaded Numbers calculator did not include separate vacancy, maintenance or management allowances. These are optional additions, initially set to 0% so the original example remains unchanged.

Mortgage financing 02 / 03

Loan calculation method
%
%
300 months = 25 years
The original sheet finances 60% of appraised value (not 60% of construction cost). Choose “Loan amount” if you want to enter your mortgage directly.

Investment breakdown

Built from your spreadsheet’s calculations.

Construction & equity

Construction cost × quantity—
Land price—
Total project cost—
Appraised property value—
Mortgage amount—
Actual loan-to-value—
Financing / down payment ratio—
Capital invested (cost − loan)—
Value created (appraisal − cost)—
Total property equity (value − loan)—
Your Numbers sheet calls “appraisal − project cost” Equity. The app shows that as value created, and separately shows actual property equity (appraisal − mortgage).

Monthly income statement

Gross potential rent—
Vacancy loss—
Effective rental income—
Fixed operating expenses—
Repairs / reserve / management—
Total operating expenses—
Net operating income (NOI)—
Monthly mortgage payment—
Mortgage + operating expenses—
Net monthly cash flow—
Annual gross scheduled rental income—
Annual NOI—
Annual cash flow (pre-tax)—

Performance & investment ratings

Objective financial metrics with colour-coded thresholds.

Ratings are decision-support indicators, not guarantees.

Key metric assessments Weighted score / 100

Capitalization rate—  —
Property income return, before financing—
Operating expense ratio—  —
Lower operating costs are better—
Debt-service coverage ratio—  —
NOI relative to debt payments—
Cash-on-cash return—  —
Pre-tax cash yield on invested capital—
METRICS RATING85Very Good / 100
OVERALL INVESTMENT83.5Very Good / 100

The metrics rating averages scores for cap rate, operating expense ratio, DSCR, and cash-on-cash return. The overall investment rating weights those metrics at 70% and the value-creation score at 30%. This scoring model is calibrated to the uploaded example (85 and 83.5); ratings are illustrative, not a lending or appraisal standard.

Additional investment indicators

Gross rental yield—
Net operating margin—
Operating expense ratio—
Break-even occupancy—
Debt service / year—
Equity as % of appraisal—
Build value created / project cost—
Rental income / month per unit—
Annual cash flow / unit—
Debt-free cap rate—
View cash flow, financing, and operational sensitivity before making an investment decision.
Items to review

10-year ownership forecast

Optional long-term projection using amortization and growth assumptions.

%
%
%
EST. PROPERTY VALUE—At year 10
EST. PROPERTY EQUITY—Value less remaining mortgage
CUMULATIVE CASH FLOW—Before tax / without reinvesting
Property valueOwner equityRemaining debt
YearProperty valueMortgage balanceProperty equityAnnual NOICash flowCumulative cash
This projection assumes your mortgage rate remains constant, monthly payments are made on schedule, and rent/expenses grow annually. It excludes tax, land transfer costs, refinancing, sale costs, capital gains taxes, and one-time major repairs beyond the reserve you enter.

Cash-flow stress testing

See how financing and occupancy changes affect your investment.

BASE CASE CURRENT INPUTS
—Monthly pre-tax cash flow
DSCR—
Mortgage rate—
Revenue—
STRESS CASE –10% RENT, +1% RATE
—Monthly pre-tax cash flow
DSCR—
Mortgage rate—
Revenue—
UPSIDE CASE +5% RENT, –0.5% RATE
—Monthly pre-tax cash flow
DSCR—
Mortgage rate—
Revenue—
Scenario calculations assume the full outstanding mortgage is financed at the scenario interest rate for the stated amortization, not a guaranteed rate reset. They are quick sensitivity checks, not forecasts.