Summary
1. If the income-affordable ratio is 30%, Aiden and Jesse qualify for the mortgage.
2. If the income-affordable ratio is 25%, Aiden and Jesse Not qualify for the mortgage.
Home Affordability Worksheet (Based on Monthly Income) | |||||
Particulars | Working | High value | Low value | Amount | |
1 | Annual Income | 1,45,000.00 | |||
2 | Monthly Income | 145000/12 | 12,083.33 | ||
3 | Lender's monthly income affordable ratio | 30% | 25% | ||
4 | Maximum monthly Mortgage payment | (12083.33*30%,12083.33*25%) | 3,625.00 | 3,021.00 | |
5 | Estimated monthly property tax and insurance | 129.17 | |||
6 | Maximum monthly Loan payment (P and I only) | (Given) | 2,115.00 | 2,115.00 | |
7 | Expected Interest rate | 7.50% | |||
8 | Planned loan maturity (years) | 15.00 | |||
9 | Mortgage payment factor per $10000 | 92.7012 | |||
10 | Maximum loan based on monthly income | (4)-(6) | 1,510.00 | 906.00 | |
11 | Funds available for down payment and closing costs | 38,500.00 | |||
12 | Required downpayment(20%) | 155000*20% | 31,000.00 | ||
13 | Maximum purchase price based on monthly income | 1,510.00 | 906.00 | ||
14 | Amount to be paid as per mortgage payment factor | 155000/10000*92.7012 | 1,437.00 |
9. Can I afford this home? - Part 1 Can Alden and Jesse Afford This Home...
Can Jacob and Madison Afford This Home Using the Installment Debt Loan Criterion? Next week, your friends Jacob and Madison want to apply to the Tenth National Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $185,000. Given your knowledge of personal finance, they've asked for your help in completing the Home Affordability Worksheet that follows. (Note: When completing the form, round each dollar amount to the nearest whole dollar.) To...
Can Josh and Mia Afford This Home Using the Monthly Income Loan Criterion? Next week, your friends Josh and Mia want to apply to the Fourth Global Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $155,000. Given your knowledge of personal finance, they've asked for your help in completing the Home Affordability Worksheet that follows. (Note: When completing the form, round each dollar amount to the nearest whole dollar.) To assist in...
Can Abigail and Alexander Afford This Home Using the Installment Debt Loan Criterion? Next week, your friends Abigail and Alexander want to apply to the Third Universal Bank for a mortgage loan. They are considering the purchase of a home that is expected to cost $215,000. Given your knowledge of personal finance, they've asked for your help in completing the Home Affordability Worksheet that follows. (Note: When completing the form, round each dollar amount to the nearest whole dollar.) To...
Estimate the affordable monthly mortgage payment, the affordable mortgage amount, and the affordable home purchase price for the following situation. (Refer to Exhibit 9-8 and Exhibit 9-9) (Round time value factor to 2 decimal places, intermediate and final answers to the nearest whole number.) Monthly gross income $ 3,450 Down payment to be made (percent of purchase price) 20 Percent Other debt (monthly payment) $ 220 Monthly estimate for property taxes and insurance $ 280 30-year loan 7.0 Percent Affordable...
Estimate the affordable monthly mortgage payment, the affordable mortgage amount, and the affordable home purchase price for the following situation. (Refer to Exhibit 9-8 and Exhibit 9-9) (Round time value factor to 2 decimal places, intermediate and final answers to the nearest whole dollar.) Monthly gross income $ 4,700 Down payment to be made (percent of purchase price) 20 percent Other debt (monthly payment) $ 260 Monthly estimate for property taxes and insurance $ 490 30-year loan 8.5...
Estimate the affordable monthly mortgage payment, the affordable mortgage amount, and the affordable home purchase price for the following situation. Use Exhibit 7-6. Exhibit 7-7. (Round your intermediate and final answers to the nearest whole dollar.) Monthly gross income Other debt (monthly payment) 15-year loan at Down payment to be made (percent of purchase price) Monthly estimate for property taxes and insurance $3,498 25e 6 percent 15 percent 180 Affordable monthly mortgage payment Affordable mortgage amount Affordable home purchase Exhibit...
you want to purchase a home for $300,000. you have calculated that you can afford monthly payments of $1300 for principal and interest and that you can obtain a 30 year mortgage with monthly payments at an APR of 4.5% how much is maximum loan amount? based on the loan amount, how much must your down payment be in order to purchase the home? Please show work and BAII Plus
Hello, Can you help with the below? 15. Estimating a Monthly Mortgage Payment: Estimate the affordable monthly mortgage payment, the affordable mortgage amount, and the affordable home purchase price for the following situation: Monthly gross income, $2,950 Down payment to be made, 15 percent of purchase price Other debt (monthly payment), $160 Monthly estimate for property taxes and insurance, $210 25-year loan at 6.5 percent. A: NOTE: This problem is based on example A (with other debts), Exhibit 7-7. A: Affordable...
The largest expense and biggest investment for many people is their home. As can be seen from the graphic to the left, the most common mortgage is one that lasts 30 years or 360 payments. Of course, this certainly benefits the bank, but does it benefit you. The calculation for mortgage payment is more complex than the exercise we are going to do, but we want to examine the impacts of different loan periods. Let’s take a look at what...
Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 28% of monthly gross income. From this, you must subtract total nonmortgage housing expenses, which would include insurance and property taxes and any other additional expenses. This defines the affordable monthly mortgage payment. In addition, guidelines also suggest that total affordable monthly debt payments, including housing...