Title of this worksheet is in cell at right. Next instruction is in cell A4.
UNIT ADDRESS:
Projected Monthly Income label is in cell at right. Enter Income 1 in cell E4 and Extra Income in E5 to calculate Total monthly income in E6. Next instruction is in cell A6. 100% $ 528 $ 167,950 7.171%
Calculated Income 100% $ 167,950
Actual Monthly Income label is in cell at right. Enter Income 1 in cell E8 and Extra Income in E9 to calculate Total monthly income in E10. Next instruction is in cell A12. 2 $ 58,783 3 $ 4,899
$ 950,000
Annual Monthly
Property Tax Estimate $ 9,500 $ 792
Insurance $ 694 $ 58
Utility Estimate4$ 3,096 $ 258
HOA Fees $ 6,336 $ 528
Available for Mortgage $ 39,157 $ 3,263
$482,115.43
5% $ 25,374
QUALIFIED AFFORDABLE MORTGAGE
Qualified Mortgage
Down Payment
Affordable Sales Price $507,490
HOUSEHOLD SIZE
ELIGIBLE
Number of Bedrooms AVAILABLE
HOUSING EXPENSE2
Annual Income
Assumed Household Size Monthly Income
Market Value Comps3
HOUSING COSTS
1.0000%
0.07%
$258
CITY OF SOUTH SAN FRANCISCO
AFFORDABLE HOUSING ANALYSIS
INPUTS
2230 Gellert Boulevard, Unit 3209
INCOME LIMIT
TO QUALIFY
Income Limit to Qualify
HOUSING COSTS
Monthly HOA Fees
Household Income to Qualify Mortgage Interest Rate1