Skip to main content

All calculators

Investment pro forma

Short-term rental: 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

Purchase 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.

Due diligence

What you spend checking the property before you're committed: inspection, sewer scope, survey, appraisal, and an environmental report on commercial. Inspections, survey, appraisal.

Assignment fee

The fee to a wholesaler when you buy their contract instead of buying from the seller directly. Paid to a wholesaler.

Work budget

Hard 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.

Draw schedule

How the work money goes out over the months. Even spends the same each month; slow, fast, slow spends most in the middle, like most builds.

Timeline

Predevelopment months

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

Rehab 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.

Max LTC

The lender's limit as a share of everything it costs: the price plus the work. Loan to cost. Of the price plus the work.

Max LTV of ARV

The lender's limit as a share of what it will be worth when the work is done. Loan to after-repair value.

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.

Lender fees

The lender's other charges in dollars: underwriting, processing, draw inspections and document fees. Underwriting, draw and doc fees.

Loan term

When the whole loan has to be paid back, in months. Months, for the warning if it runs longer.

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

Interest payments

Whether you pay the interest every month, or it adds up and is paid when the loan is paid off.

Second loan

Amount

A second loan on top of the first, funded at closing, such as private money for the gap. Funded at closing.

Interest rate

The second loan's yearly interest rate.

Points

The second loan's upfront fee as a share of it. One point is 1%.

Interest payments

Whether the second loan's interest is paid monthly, or adds up and is paid at the end.

Value

After-repair value (ARV)

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.

Other monthly income

Income besides rent each month: laundry, parking, storage, pet fees. Laundry, parking, storage, reimbursements.

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.

Monthly owner-paid utilities

Utilities you pay as the owner, each month, such as water or common area power.

Monthly HOA dues

Homeowners or condo association dues each month.

Other monthly expenses

Any other monthly costs: lawn care, snow removal, pest control, software. Lawn, snow, pest control, accounting.

Property management

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

Annual rent growth

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

Annual expense growth

How much you expect running costs to change each year. Put a minus sign for a fall.

Refinance

Refinance

Whether you refinance into a long-term loan once it's rented.

Refinance month

The month, counted from buying, when the refinance closes. Blank means right after it's leased.

Blank: once it's leased

Appraised value

The value the appraiser gives at the refinance. The new loan is a share of it. Blank uses the after-repair value.

Blank: the after-repair value

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.

Refinance costs

Closing costs on the refinance: lender fees, appraisal and title.

Minimum DSCR

The lender's least debt coverage: the rent left after running costs, divided by the loan payment. 1.25 means the rent covers the payment and a quarter more. Such as 1.25.

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.

Exit cap rate

The cap rate a buyer would pay at the sale: yearly net income divided by the price. Lower means a higher price. Blank uses value growth instead.

Blank: annual appreciation instead

Selling costs at exit

Your costs to sell at the end of the hold, as a share of the price.

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.