A buyer can afford no more than $1,200 per month in payments. The most favorable loan available in the market is a 30-year loan at 5%. What is the maximum affordable house with a 20% down payment?
please show using financial calc.
The PV of payments for 30 years
Rate per month = 5%/12
Number of Periods = 20*12 = 360
PV of Payments using financial calculator
N = 360; I/Y = 5%/12; PMT = 1200; CPT PV
PV = 223,537.94
Maximum affordable House = Down payment + PV of Monthly
Payments
Maximum affordable House = 20% of Loan amount + 223,537.94
Maximum affordable House = 223,537.94/0.8 = 279,422.43
Please Discuss in case of Doubt
Best of Luck. God Bless
Please Rate Well
A buyer can afford no more than $1,200 per month in payments. The most favorable loan...
2. If you can afford an $1150 per month mortgage, how much house can you afford with a 5% annual rate on 30 year mortgage with a 20% down payment?
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...
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...
A couple purchasing a home budget $1,200 per month for their loan payment. If they have $17,000 available for a down payment and are considering a 25-year loan, how much can they spend on the home at each of the f (a) 6.6% compounded monthly (b) 7.8% compounded monthly
You can afford a $250 per month car payment. You've found a 4 year loan at 2% interest. How big of a loan can you afford? ----- 9 License Points available on this attempt: 7.7 of original 11 This is attempt 2 of 3. Score on last attempt: 0. Score in gradebook: 0 100 Submit
You can afford a $1350 per month mortgage payment. You've found a 30 year loan at 8% interest. a) How big of a loan can you afford? $ b) How much total money will you pay the loan company? $ c) How much of that money is interest? $
James wants to take out a loan. He can afford to make monthly payments of 100 dollars and wants to pay the loan off after exactly 30 years. What is the maximum amount that James can afford to borrow if the bank charges interest at an annual rate of 8 percent, compounded monthly? (Give your answer, in dollars, correct to the nearest dollar.) Nicola borrows 60000 dollars from a bank that charges interest at an annual rate of 10 percent,...
If the most you can afford each month on a car payment is $300, the applicable discount rate is 6.0% per year, and an auto-loan is for 5 years paid monthly, what's the most expensive car you should purchase today assuming you finance the whole car (no money down)?
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...
2. You can afford a $1150 per month mortgage payment. You've found a 30 year loan at 8% interest. a) How big of a loan can you afford? $ b) How much total money will you pay the loan company? $ c) How much of that money is interest? $