Insurance quotes belong in your first spreadsheet

How the quote enters the math

The lender divides the rent by the full monthly payment. Add flood or windstorm coverage and the payment climbs. A rental that clears 1.05 with a modest premium can fall below 1.0 when the actual quote is much larger. Nothing about the tenant has changed. Only the denominator did.

What moves the premium

• Roof age and material. Insurers often price older roofs higher, and some decline them.
• Location. Coastal, floodplain, wildfire and heavy-hail areas can need special policies or higher deductibles.
• Use. A short-term rental needs a policy written for that use, which can cost more than a standard landlord policy.
• Building features. Wind mitigation, newer wiring and plumbing and protective systems can lower cost.
• Deductibles. Percentage-based wind or hail deductibles can be large, even if the premium looks low.

Coverage questions investors forget

• Rental use. A policy written for an owner who lives in the home may not cover a rental. Make sure the policy is a landlord or dwelling policy for the property.
• Liability limits. Ask what the lender expects and what you would want if a tenant or guest is injured.
• Loss of rents. Some policies reimburse rent while a covered repair is underway, and some do not.
• Separate perils. Flood, wind and hail can be excluded or carry separate deductibles, which changes the real cost of a claim.
• Roof and system age. Older roofs can raise premiums or limit coverage, so ask what the carrier needs before you offer.

Insurance and the ratio over time

Premiums change at renewal, and they have a way of rising after a claim-heavy year in your area. A ratio that clears with a small margin on today's quote can slip later, so keep a cushion in your model instead of running the number to the minimum. If you hold several properties, review each policy once a year and compare quotes, because a single carrier switch can change several ratios at once.

A quick routine

1. Ask an insurance agent for a quote on the address before the offer is final.
2. Ask about flood, wind and hail separately, and note the deductibles.
3. Type the total into the calculator with the tax estimate.
4. Recheck once the appraisal or inspection reveals roof or system details.

State notes on weather and insurance appear on each page of the state index.

A quote beats an estimate

Rule-of-thumb insurance numbers are the quickest way to a wrong ratio. Premiums depend on the age and condition of the roof, the construction type, the distance to a fire station, local claims experience, whether the home is a rental, and the coverage and deductible you choose. Two houses on the same street can quote very differently. Put a real quote in the sheet, label the date, and refresh it when anything about the property or coverage changes.

What the lender will ask to see

A lender typically wants evidence of coverage that names the borrower or the entity as the insured, lists the lender as the mortgagee, and meets a minimum dwelling coverage and liability limit. If the borrower is an LLC, the policy has to name the LLC. A homeowner policy written for an owner who lives in the house does not fit a rental, so ask the agent for a landlord or dwelling fire policy. Confirm whether the policy covers loss of rents, because a covered repair that leaves a unit empty is a cash flow problem.

Wind, hail and flood deductibles

Many policies apply a separate and often percentage-based deductible for wind or hail, and some exclude flood entirely. A percentage deductible is applied to the insured value, so it can be far larger than a flat figure. Ask the agent what you would actually pay after a roof claim. For flood, check the FEMA flood map for the address, ask whether a flood policy through the national program or a private carrier fits, and ask whether an elevation certificate could change the premium.

Condos and multiple units

A condo owner usually needs an interior policy designed for unit owners and relies on the association's master policy for the building. Ask for the master policy summary and the association's deductible rules, because an assessment after a loss can land on owners. For a two to four unit building, the policy covers the structure and the landlord's liability for each unit, and the premium belongs in the ratio for the whole building.

Keeping the sheet honest after closing

Premiums change at renewal, and a claims-heavy year in your area can raise them across the board. Set a reminder to shop coverage a month before each renewal and update the ratio in your records. If the cushion above the lender's minimum is thin, a premium jump matters, and that is a reason to leave a margin when you first run the numbers.