( Show steps, do not use excel plz)

4. . The ABC company needs to borrow $3,200,000 and they have narrowed their choices to two loans: Loan A - ;(2) = 6%, amortized over 25-years with semi-annual payments Loan B ;(2) = 5%, semi-annual payments of interest only are made over 25-years, with the principal repaid in one lump sum at the end of 25-years (a) In order to even consider Loan B, what rate of interest, il2), must ABC earn on a sinking fund? (4 marks) (b) Let's supposed ABC ended up choosing Loan B and end up being able to earn il2) = 3% on their sinking fund. After 10-years, senior executives at the company decide to change to the amortization method. At that time the company will pay back the $3,200,000 to the original lender and then finance the rest of the loan (the book value at that time) with a lender who charges il2) = 4.5%. ABC will payoff the loan over 12 more years with semi-annual payments. What is the total amount of interest ABC ends up paying on the loan over the entire 22 years? Give the answer as the total interest they paid AND also as the total net interest they paid (remember, they had a sinking fund earning them interest for part of the 22 years). (8 marks) 4. . The ABC company needs to borrow $3,200,000 and they have narrowed their choices to two loans: Loan A - ;(2) = 6%, amortized over 25-years with semi-annual payments Loan B ;(2) = 5%, semi-annual payments of interest only are made over 25-years, with the principal repaid in one lump sum at the end of 25-years (a) In order to even consider Loan B, what rate of interest, il2), must ABC earn on a sinking fund? (4 marks) (b) Let's supposed ABC ended up choosing Loan B and end up being able to earn il2) = 3% on their sinking fund. After 10-years, senior executives at the company decide to change to the amortization method. At that time the company will pay back the $3,200,000 to the original lender and then finance the rest of the loan (the book value at that time) with a lender who charges il2) = 4.5%. ABC will payoff the loan over 12 more years with semi-annual payments. What is the total amount of interest ABC ends up paying on the loan over the entire 22 years? Give the answer as the total interest they paid AND also as the total net interest they paid (remember, they had a sinking fund earning them interest for part of the 22 years). (8 marks)