Question

(c) You have just borrowed $10,000 and will be required to make monthly payments for the next five years in order to fully repay the loan. How much is the monthly repayments on the loan if the interest rate is 13% per year? (5 marks) (d) The CIMB's new saving account pays interest quarterly. It wishes to pay effective annual return) 16% per year on this account. CIMB desires to advertise the annual percentage rate on this new account, instead of the effective rate, since its competitors state their interest on an annualized basis. What is the annualized rate that corresponds to an effective rate of 16% for this new account? (5 marks) (e) Wallace Container Company issued $100 par value preferred stock 12 years ago. The stock provided a 9 percent dividend yield at the time of issue. The preferred stock is now selling for $72. What is the cost of the preferred stock? (5 marks)

Answer 1

c) We will calculate the monthly repayments using Excel's PMT function

Attaching the excel snapshot with final value and formulas :-

LAWN 10,000 Principal No of monthly instalments Interest Rate 13% Monthly repayments ($1,300.85)

Principal 10000 No of monthly instalments =5*12 Interest Rate 0.13 Monthly repayments PMT(C6, C5, C4)

Hence, monthly repayment = $1,300.85