All working has to be shown with the correct formula. The subject is Financial Management but I'm not seeing the option so I chose the option that's was provided

Questions 1 8. 2 are to be done using Excel - Total Payment; Interest Payment and Principal Payment are to be calculated using the financial functions in excels. Grades will assigned based on the use ofthese formulas Question 1 Michael Brooks is buying a house for $2 000 000. He made an agreement with the National Housing Trust (NHT) to provide 45% financing for his new home. It was agreed with the NHT that he will make monthly payments over five [5) years at 12% per annum. The remainder of the funds required to cover the cost of the house will be borrowed from his commercial bank. The terms of the agreement for the bank loan are, 25% down payment, and the balance is to be repaid at 20% interest over a three [3) year period. a. Calculate the monthly payments to be paid over to the National Housing Trust (NHT) if payments are made at the end of each month. [5 marks] b. Calculate the annual end of year payments to be paid to the commercial bank. [6 marks] c. Considering part (b), prepare the amortization schedule for this loan. [9 marks] (CCCJ) Question 2 Carona has just taken a loan at an annual rate of15%. She plans to repay it over 2 years, paying $52 250 at the beginning of each monthly. a. How much did Carona borrow?I [5 marks] b. Prepare the loan amortization schedule [12 marks] 0. If payments are made at the end of each month, what is the effective annual rate of the loan? [3 marks] Question 3 The Plush Corporation is planning on expanding its operations and decides to fund this by issuing a new series of bonds on January 1, 2020. The 10% coupon bonds will be sold at par ($1 200), and will mature on December 31, 2044. Coupon payments are made semi-annually. a. What will be the YTM of Plush's bonds on January 1, 2020? [2 marks] b. What will be the price of the bond on January 1, 2027, given interest rates is expected to fall to 7 T J L 8%? [5 marks] c. Find the expected current yield and expected capital gains yield on the bond on January 1. 2027, given the price as determined in Part 'b' above [6 marks] d. If Plush Corporation bonds are expected to be sold for $1 100 on July 1, 2037, what is the expected rate of return on that date? [6 marks] e. What would be expected current yield and expected capital gains yield on July 1, 2037? [6 marks] f. Would you buy Plush bonds when they are selling for $1 100 if you require a rate of return of 13% per year. (Show calculations to support your answer) [10 marks]