Case study 2 -Mortgages Mr. and Mrs. Minott and their four children live in their own home at 40 Park Place, on which they have a mortgage balance of $2.500,000. As the Minotts reckon that the family has outgrown the property, it has been put up for sale at its current appraised value of $10,250,000. A purchaser has been identified but the proceeds from the sale is not due to be paid to the Minotts until June 30, 2021. In the meantime the Minotts have contracted to purchase a new home at Hill Glades for $25,000, 000, although this property is valued at only $23,000,000. The sale agreement on this property requires a deposit of 20% on signing which took place on February 16, 2021, with the balance which will not be covered by a mortgage, payable in 45 days after signing. Based on their high salaries, Caribbean Building Society have pre-approved the Minotts for a 25-year mortgage of 75% of purchase price or value, whichever is less, up to a maximum of $20,000,000. This will attract an interest rate of 5.50% per annum with monthly compounding and will be disbursed on June 30, 2021. MVBS Ltd, a commercial bank, is offering a bridging loan of up to $26,000,000 for up to 91 days at an interest rate of 8.50% per annum and the Minotts will only use the minimum amount needed of this loan. The outstanding balance on the bridging loan account after the mortgage loan has been applied to it will be repaid from the net proceeds of the sale from the Minot's old house. A closing cost of $1.250.000, which must be paid on signing of the sale agreement, will be associated with purhase of the new home. The Minotts also have savings of $2,250,000 which will be available for use in their new home transactions. Final payment for the new property, possession of both properties and disbursement of the bridging loan will take place on April 1, 2021. The Minotts also plan to use some of the proceeds from the sale of their property to pay off the outstanding principal and interest on the bridging loan and from the balance to make a deposit on a new car on July 2021. The Minotts also plan to use some of the proceeds from the sale of their property to pay off the outstanding principal and interest on the bridging loan and from the balance to make a deposit on a new car on July 2021. The Minotts also have a zero coupon bond with a face value of $14,000,000 ( that means that they will only get $14.000.000 at maturity) that will mature on June 30, 2031, that is, 10 years after the mortgage was disbursed. They are contemplating using all the proceeds from that bond at maturity to pay on their mortgage loan. a. How much cash must the Minotts pay on signing the sale agreement for their new home? (2 Marks) b. How much of the purchase price will be financed by the long-term mortgage? (2Marks) C. How much should they pay on the second deposit? (2 Marks) d. How much equity does the Minotts have in their old house? (2 Marks) When the Minotts move in, what will be their equity in the property, assuming that the value of the new home remains at its current valution? (2marks) f. How much should they borrow if they take a bridge loan? (bearing in mind that they will only use the minimum needed). (3 Marks) e. g. What is the maximum that the Minotts can afford to pay on the new car? (2Marks) h. Use Excel to construct a full amortisation table showing the balance of the loan at maturity. (Upload the Excel worksheet) (4 Marks) 1. In the event that the Minotts decide to use proceeds from the bond immediately it matures to pay off their mortgage, will this provide sufficient funds to do so? How much Interest will they have paid over the period? This question must be manually calculated showing all workings. (4 Marks) J. If the Minotts are planning to keep their new mortgage until maturity, what would be the total Interest payable over the period, assuming that the interest rate remains unchanged? This question must be manually calculated showing all workings. (2 Marks)