What is the most expensive house they can afford to buy

Assignment Help Financial Management

Reference no: EM132021161

Kate and Miles are shopping for a new home. They can afford a down payment of $60,000 and monthly payments of at most $2,500.

Sterling Bank has offered to finance a loan at 8.75% per year compounded monthly for 30 years. What is the most expensive house (to the nearest dollar) they can afford to buy?

Kate and Miles ultimately make a downpayment of $50,000 on a $300,000 home and finance the balance through Creative Financing Inc. at 8.25% per year compounded monthly for 30 years. What monthly payments should Kate and Miles make to pay off the house?

Referring to part (b), use EXCEL to set up an Amortisation Schedule for the first 12 months of the loan. Attach the printout or copy your EXCEL amortisation into your assignment submission.

EXCEL Instructions: Please refer to the amortisation example in Week 3 lecture notes and Topic 3 in the EXCEL Booklet.

Referring to the Amortisation Schedule from part (c), how much interest in total will Kate and Miles pay over the first year of their loan? How much equity (downpayment plus repaid principal) in the house will they have at the end of the first year?

Reference no: EM132021161

Questions Cloud

What will be the net cash flow for year one of this project : Your Company has spent $250,000 on research to develop a new computer game. What will be the net cash flow for year one of this project

Considering the purchase of an office building : Real Estate Investment Trust is considering the purchase of an office building.

Draw a line and construct an angle : Draw a line and construct an angle - bisect the angle xoy and mark a point A on the bisector so that OA = 7cm

Explain the various ways you plan on distributing toothbrush : The basic idea is: How do I get my product into my consumers' hands? Some companies have become recognized worldwide not for their product but for the way.

What is the most expensive house they can afford to buy : What is the most expensive house (to the nearest dollar) they can afford to buy?

Indicate the variables under the control of the decision : Identify a decision situation and indicate the variables under the control of the decision maker and those not directly under his or her control.

Discuss the market research implementation plan : Write a 350-word detailed outline of your Market Research Implementation Plan in which you address the following.

Five digit number n to a string of its spoken equivalent : Using python 3,design a function digit_to_string(n): that converts a five digit number n to a string of its spoken equivalent.

Contain a mix of nested lists and integers : For the purpose of this problem, a nested list is a list that may contain a mix of nested lists and integers.

User Account

All Pages