Question

My yearly salary is $ 63,800. Assume you are planning on spending a certain amount of...

My yearly salary is $ 63,800. Assume you are planning on spending a certain amount of income towards a mortgage. if you spend 22% of your monthly salary towards a house, what is the highest price you can afford? what is the highest priced house a high school graduate can afford. Use absolute or relative change statement to compare the house prices of the high school graduate to your house. Assume standard APR is 1.85% for 30 years. Make sure to show at least 1 sample formula that you used in excel to the house price.

Homework Answers

Answer #1

Salary = 63800 pa

Amount spent on mortgage (C) = 22% * 63800 pa = 14036 pa

r: annual rate of interest = 1.85%

Maximum value of mortagage = Sum of present value of all the future cash flows

Maximum value of mortagage = M (assume)

This becomes a GP with a =C/(1 + r) ; r = 1/(1 + r) & n = 30

M = 320,938.11 (maximum value of mortgage the person can buy)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
*Round all values to 4 decimal places. 1. What is the present value of $10,000 paid...
*Round all values to 4 decimal places. 1. What is the present value of $10,000 paid at the end of each of the next 71 years if the interest rate is 8% per​ year? The present value is $______. ​(Round to the nearest​ cent.) 2. Assume that your parents wanted to have $110,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned...
This case will enable you to practice conducting planning and substantive analytical procedures for accounts in...
This case will enable you to practice conducting planning and substantive analytical procedures for accounts in the acquisition and payment cycle. When analyzing the financial data, you may assume that the 2015 information is unaudited, while prior-year data is audited. As you complete this case, consider the following features of and trends in the pharmaceutical industry and for PharmaCorp specifically: After a long period of industry dominance by companies in the United States, the United Kingdom, and Europe, these companies...
In narrative essay format, I want you to address a business/organization case study using multiple concepts...
In narrative essay format, I want you to address a business/organization case study using multiple concepts from class. The case question and case text begin on page 5 of this document. You need to demonstrate their best understanding of management and organizational behavior theory, and the application of those ideas to improve the understanding of various issues. You need to clearly identify at least 3 distinct, substantive issues. For each issue you need to 1), identify evidence from the case...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills, online shopping, coffees, vouchers, food,...
CASE: Sharesies: NZ investment platform Everyday investment company Sharesies was launched in February 2017, after conducting...
CASE: Sharesies: NZ investment platform Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills,...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills, online shopping, coffees, vouchers, food,...
The Harborside Inn, located on the New England coast, is a 125-room luxury hotel. The inn's...
The Harborside Inn, located on the New England coast, is a 125-room luxury hotel. The inn's guests are predominantly upper middle class in that the going rate is about $100 per day per person. The hotel grounds include 30 acres of lawns and gardens. Their nine-hole golf course winds its way around a picturesque trout pond. The hotel grounds were meticulously cared for and yet efforts at cultivating beauty could not match the natural beauty which was so much a...
Using the model proposed by Lafley and Charan, analyze how Apigee was able to drive innovation....
Using the model proposed by Lafley and Charan, analyze how Apigee was able to drive innovation. case:    W17400 APIGEE: PEOPLE MANAGEMENT PRACTICES AND THE CHALLENGE OF GROWTH Ranjeet Nambudiri, S. Ramnarayan, and Catherine Xavier wrote this case solely to provide material for class discussion. The authors do not intend to illustrate either effective or ineffective handling of a managerial situation. The authors may have disguised certain names and other identifying information to protect confidentiality. This publication may not be...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...