Home purchase due diligence: six inspected houses in Manhattan, Kansas

Purchase risk, fair offer prices and loan choice for six houses inspected in October 2026.

Prepared by Robert M. ShollConsulting reportMarket data through August 2026

Summary

House Cbest purchase; buying beats renting in 50% of forecasts over 7 years
$206krecommended maximum offer for House C (asking $225k)
$38k–$48kexpected repairs on A, B, E, F
$27kcash reserve to hold for the first five years

Six houses listed at $157,000 to $255,000 were inspected and run through 4,000 simulated ten-year futures for local prices, rents and mortgage rates. The inspections separate the houses more than their prices do. House C and House D need $9k and $14k of expected work; the other four need $38k to $48k, mainly roofs and foundations. Repairs are counted as cost with no resale value.

Recommendation. Offer on House C up to $206,000. Offer on House D up to $193,000, conditional on a roof inspection or a seller credit for the roof. Do not pursue A, B, E or F at current prices; each would need to fall to $97k–$147k.

Financing. Use the 6.25% 30-year fixed loan. The 7/6 ARM is cheaper only if you expect to sell within seven years. Hold about $27,000 in cash until the loan falls below 80% of the home’s value.

Table 1. Scorecard. Monthly cost includes mortgage, tax, insurance, upkeep and mortgage insurance. Maximum offer is the price at which buying beats renting in 60% of forecasts.
HouseAsking priceExpected repairsMonthly cost, year 1Buying beats renting, 7 yrsExpected loss if forced to sellMaximum offerDecision
House A$157,000$39,600$1,39525%$12,900$97,000Pass
House B$224,500$38,100$1,99420%$11,600$137,000Pass
House C$225,000$9,000$1,95350%$4,200$206,000Below asking
House D$225,000$14,300$1,96244%$5,400$193,000Below asking
House E$250,000$38,100$2,23218%$11,500$147,000Pass
House F$255,000$48,500$2,25913%$14,700$129,000Pass
1 2 3 4 5 6 7 8 9 10 Years after purchase 0% 10% 20% 30% 40% 50% 60% 70% even odds Chance that buying leaves you better off than renting House F House E House B House A House D House C Only Houses C and D reach even odds within ten years
Figure 1. Buying starts behind because of closing costs, repairs and the cost of selling, and catches up as the loan is paid down and the house gains value.

Inspection findings

Each house was scored on 40 items as good, fair or a problem. Every problem is costed as a repair at purchase, using local price ranges toward the high end. Each note from the inspector is costed as a possible bill: a probability that it comes due and a range for its size. Each simulated future draws its own bill. Condition also sets yearly upkeep: 1% of value for a house in good order, rising to 2% for one in poor order.

Table 2. Repair costs at purchase. The 1-in-20 total is exceeded in one future in twenty. Upkeep is a share of the home’s value.
HouseGood / fair / problemProblems to fixInspector’s notesExpected total1-in-20 totalUpkeep per year
House A20 / 11 / 9$16,200$23,400$39,600$66,8001.4%
House B20 / 10 / 9$32,000$6,100$38,100$58,9001.4%
House C32 / 5 / 2$3,000$6,000$9,000$17,5001.1%
House D31 / 5 / 4$6,000$8,300$14,300$30,4001.2%
House E17 / 13 / 10$31,800$6,300$38,100$58,5001.4%
House F20 / 12 / 7$33,100$15,400$48,500$61,0001.3%
$0k $10k $20k $30k $40k $50k $60k House C House D House B House E House A House F Repairs at purchase, 4,000 simulated outcomes per house Dot: expected · bar: middle 50% · line: middle 90% Four houses carry $38k–$48k of expected repairs
Figure 2. Houses A and B have the widest ranges because their largest items, a structural repair and a roof tear-off, may or may not be needed.
Table 3. The inspector’s notes, costed. Expected cost is the probability times the midpoint of the range.
Inspector’s noteHouseProbabilityCost if neededExpected cost
Roof tear-off: several shingle layers, possible water damageHouse A70%$20,000–$30,000$17,500
Structural repair for a possible lean in the roof or a wallHouse A30%$10,000–$30,000$6,000
Garage door repairHouse B100%$300–$1,500$900
Roof rated fair, may need replacingHouse B25%$17,000–$25,000$5,250
Soft exterior walls: rot and framing repairHouse C60%$5,000–$15,000$6,000
Roof of unknown age, may need replacingHouse D40%$17,000–$25,000$8,400
Garage floor crackHouse E100%$600–$1,500$1,050
Roof rated fair, may need replacingHouse E25%$17,000–$25,000$5,250
Water damage under the roofHouse F60%$2,000–$8,000$3,000
Sewer line repair or replacementHouse F50%$4,500–$16,500$5,250
Back patio replacementHouse F100%$3,000–$8,000$5,500
Diseased trees removedHouse F100%$500–$3,000$1,750

How the forecasts are built

The analysis simulates 4,000 possible futures for the next ten years. Each is consistent with Manhattan home prices since 1986 and with the usual behaviour of inflation and mortgage rates. The model starts from long-run inflation, adjusts that with forty years of local prices, and carries the remaining uncertainty into every future. Each future is then priced for every house: loan payments, tax, insurance, upkeep, inspection repairs and, on a sale, selling costs. All six houses face the same 4,000 futures, so differences between them come from the houses.

0 1 2 3 4 5 6 7 8 9 10 Years after purchase $200k $300k $400k $500k $600k 1 in 20 low median $328k 1 in 20 high Market value: 30 of 4,000 simulated paths, with the middle 50% and 90% shaded House C: simulated value over ten years
Figure 3. Each thin line is one simulated future. After ten years the median value is $328,000; one future in twenty ends below $236,000.
100 150 200 250 300 FHFA price index, 1995 = 100 Manhattan home prices since 1986 1990 1995 2000 2005 2010 2015 2020 2025 0 10 Change from the year before, %
Figure 4. Prices have risen 3.6% a year on average. The largest fall from a peak was 6%, supported by steady demand from the university and Fort Riley. Homes now sell in a median 16 days at list price.

Buying against renting

Each house is compared with renting a similar home and investing the money that buying would have tied up (down payment, closing costs, repairs and any difference in monthly cost) at 5% a year. The comparison is made after 7 years, net of selling costs.

−$150k −$100k −$50k $0k $50k $100k House A House B House C House D House E House F Wealth from buying minus wealth from renting, after selling costs Dot: median · bar: middle 50% · line: middle 90% After seven years, only House C breaks even on a typical outcome
Figure 5. Right of the zero line, buying left the household better off than renting and investing the difference.

Risk of an early sale

Each year carries an 8% chance that the household must move (job, family), close to the national rate for homeowners. A move means selling at that year’s market price. The expected loss weighs each year by the chance a move happens then. The reserve is the cash needed to close a forced sale in the first five years in 99 futures out of 100.

1 4 7 10 Years after purchase 0% 2% 4% 6% 8% 10% 12% 14% Chance a sale would not repay the loan Underwater risk fades by year five $0k $2k $4k $6k $8k $10k $12k $14k $16k House C House D House E House B House A House F $4k $5k $12k $12k $13k $15k Averaged over when a move might happen Expected loss from a forced sale
Figure 6. With 10% down and 6% selling costs, the chance of being underwater is the same for every house; repair bills make the loss larger for the four houses that need work.

Fixed rate or adjustable

1 4 7 10 Years after purchase $1,000 $1,100 $1,200 $1,300 $1,400 fixed 6.25% ARM median Principal and interest; shaded 50% and 90% ranges House C: monthly payment, 7/6 ARM 0 10 20 30 40 50 Largest rise in payment, % 9% of futures rise more than 20% Share of 4,000 futures Payment shock
Figure 7. The ARM starts at 5.75% against 6.25% fixed and can change only after year seven, by at most 5 points at the first reset and 1 point a year after.

For a stay of seven years or less, the ARM costs less than the fixed loan in every simulated future, for every house, because its lower starting rate covers the whole stay. Beyond seven years the payment can reset upward. The fixed loan costs more in a typical future and removes that risk.

Keeping the house as a rental

If the household moves after year 3 and rents the house out, rent is collected net of 6% vacancy and a 9% management fee. Costs are the mortgage, tax, insurance, upkeep and repairs.

−$1,000 −$800 −$600 −$400 −$200 $0 House A House C House D House B House E House F Monthly rent less costs in year 4 Dot: median · bar: middle 50% · line: middle 90% No house covers its costs as a rental
Figure 8. Left of zero, the owner adds money every month. House A comes closest because its rent is the largest share of its price.
Table 4. Rental cash flow from year four. Gross yield is a year’s rent as a share of the price. Rents start at the Manhattan median for a house ($1,500 a month, Rentometer) and scale with price.
HouseMarket rentGross yieldMonthly shortfall (median)
House A$1,250/mo9.6%−$300
House B$1,500/mo8.0%−$690
House C$1,500/mo8.0%−$640
House D$1,500/mo8.0%−$650
House E$1,580/mo7.6%−$870
House F$1,600/mo7.5%−$870

As rentals, all six lose money every month and rely on price growth for any return. Homes here sell for 10 to 13 times a year’s rent, so an owner-landlord needs other income to cover the shortfall.

Assumptions and limits

Table 5. Inputs used for every house.
AssumptionValue
Down payment / closing costs / selling costs10% / 3% / 6% of price
Fixed loan6.25%, 30 years
Adjustable loan7/6 ARM from 5.75%; caps 5 / 1 / 5 points
Property tax / insurance1.45% of value / 0.75% of price, rising 4% a year
Mortgage insurance0.5% of the loan a year, until the loan falls to 78% of the price
Upkeep1% to 2% of value a year, by inspection condition
Renter’s return on savings5% a year
Chance of a forced move8% a year
Rental vacancy / management6% / 9% of rent

Not modelled: income tax and the mortgage-interest deduction, refinancing, and any resale value from repairs. Repair costs come from published ranges for Manhattan and Kansas City (roofing, foundations, plumbing, windows); where no source existed, a stated allowance was used. Inspection scores were transcribed from handwritten forms and should be confirmed against the originals before an offer is made.

Appendix: model checks

0 5 Long-run growth, %/yr 0.0 0.5 1.0 Persistence 0 100 200 300 400 500 600 Sampler step (every fourth kept) 4 6 Yearly swing, %
Figure 9. Four runs from different starting points overlap in the same range, which indicates the fit has converged.
Table 6. Price-model parameters. R-hat close to 1 means the runs agree.
ParameterEstimate90% rangeR-hatEffective draws
Long-run growth, %/yr3.612.27 to 4.991.005879
Persistence0.310.04 to 0.561.005571
Yearly swing, %4.113.38 to 5.011.003902

Mortgage rates use the same kind of model, fitted to Freddie Mac yearly averages since 2000. Rents grow about 3% a year with yearly swings of 2%.