Skip to main content

All calculators

Investment pro forma

Build, rent, refinance: what it costs, what it earns and when the cash comes back.

Unit types

One row for each kind of unit, like 2 bed apartments or retail suites. Calculate adds a blank row; clear a row's boxes to take it away.

Unit type 1

Name

What you call this kind of unit, like 3 bed townhome or Suite A.

How many

How many units of this kind the building has.

Square feet each

Square feet of one unit. For commercial, the rentable square feet of one suite.

Beds

Bedrooms in one unit. Leave beds and baths blank for commercial space.

Rent each

The rent for one unit. Commercial rent is often quoted per square foot a year; pick that beside it.

Rent is

A month for apartments; square feet a year for commercial space, as it's usually quoted.

Purchase

Land price

What you pay the seller for the property, or for the land on a build.

Closing costs

Your closing costs when you buy: title insurance, settlement and recording fees, prorated taxes and the lender's closing costs. Title, recording, lender's closing costs.

Work budget

Construction costs

Labor and materials for the rehab or the build itself: the contractor's bids or the builder's price. Labor and materials.

Soft costs

Costs around the work that aren't labor or materials: plans, engineering, surveys, permits, impact and tap fees. Design, engineering, permits, tap fees.

Contingency

A share of the hard costs set aside for surprises. Older homes and heavy rehabs need more than new builds. Of hard costs.

Timeline

Predevelopment months

Months from buying until work starts, for plans, permits and bids. Design, permits, bids.

Construction months

How long the rehab or build takes.

Lease-up months

Months from the end of the work until it's sold and closed, or rented with a signed lease. After the work, until it closes or is rented.

Holding costs

Monthly carrying costs

What it costs each month to own it while it's worked on and marketed: taxes, insurance, utilities and upkeep. Taxes, insurance, utilities, lawn.

Main loan

Loan type

The kind of loan paying for the purchase and the work, or no loan for cash.

Purchase LTV

The share of the purchase price the lender lends at closing. Of the price, lent at closing.

Rehab funded

The share of the work budget the lender pays as the work gets done, through draws. Of the work budget, through draws.

Interest rate

The yearly interest rate on the loan. Yearly.

Points

An upfront fee as a share of the loan. One point is 1% of the loan amount. Of the loan, at closing.

Amortization

Years the payments are spread over when the loan pays down principal. Blank means 30 years; 0 means interest only.

Years; 0 for interest only, blank is 30 on long-term loans

Value

Value when built

What it should sell for once the work is done, from recent sales of similar finished homes nearby. ARV. What it sells or appraises for when done.

Rent and running costs

Units

How many rentable units the property has.

Gross monthly rent

Rent for all the units together each month, at full occupancy. All units.

Vacancy and credit loss

The share of the rent you expect to lose to empty months and late or missed rent. Of income, empty or unpaid.

Monthly property taxes

Property taxes, as a monthly amount.

Monthly insurance

The landlord's insurance policy, as a monthly amount.

Monthly repairs and maintenance

Everyday repairs and upkeep each month.

Monthly CapEx reserves

Money set aside each month for big replacements: roof, furnace, water heater, flooring. For roofs, furnaces and other replacements.

Property management

A property manager's fee as a share of the rent collected. Of collected income.

Refinance

Refinance LTV

The share of the appraised value the new lender will lend. Loan to value; often 70% to 80%.

Interest rate

The yearly interest rate on the new long-term loan.

Amortization

Years the new loan's payments are spread over, often 30. Years.

The hold

Hold period

How many years you keep it before selling. Years.

Annual appreciation

How much you expect the value to change each year. Put a minus sign for a fall.

Your estimate

Enter your numbers and select Calculate to see your estimate.

Estimate only

Not a loan offer, appraisal or tax advice. Your lender, title company and tax pro will have the final numbers.
How this is calculated

The pro forma works month by month. The purchase and its costs come at closing, the work budget is spread over the months of work, and interest runs only on what the loans have lent so far.

A sale pays off the loans and returns the rest. A hold collects rent less vacancy and running costs, pays the loan, refinances when set, and sells at the end of the years held.

IRR is the yearly return that makes every month's cash in and out net to zero. Tap How under any figure to see its math with your numbers.