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.66After 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 rentThe 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.
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
| Year | Property value | Mortgage balance | Property equity | Annual NOI | Cash flow | Cumulative 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 flowDSCR—
Mortgage rate—
Revenue—
STRESS CASE –10% RENT, +1% RATE
—Monthly pre-tax cash flowDSCR—
Mortgage rate—
Revenue—
UPSIDE CASE +5% RENT, –0.5% RATE
—Monthly pre-tax cash flowDSCR—
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.