Posted: September 17th, 2017

# Mortgage

You are planning to buy a holiday villa in Spain which costs £300,000. You have a deposit of £30,000 and want to pay the rest through a mortgage. Your local bank offers you a 3.99%fixed rate for 5 years.

1. a) Compute the monthly repayments that you will have to make if you want to repay the mortgage in full in 25 years using the PMT function in Excel.

1. b) Check your answer to part (a) by using Goal Seek.

1. c) What would the outstanding balance be when you have to remortgage your loan after 5years?

1. d) If you think you can afford a monthly repayment of £2000, how long will it take you to repaythe mortgage?

e) Build a two-way data table to show how the monthly payment varies with changes in the down payment and in the term of the loan. Use values between 20,000 and 40,000 inincrements of 5,000 for the down payment and values between 15 and 30 years in steps of5 for the term of the loan.

Do you want your assignment written by the best essay experts? Order now, for an amazing discount.

### Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00