Question: A company plans to buy equipment for Ghc 200m, half of which is due on delivery, with the balance due exactly one year later. The year-end cash flows are expected to be Ghc 50m per annum for five years. After exactly five years, the equipment will be sold for Ghc 10m,
i. If the company has to borrow at 20% per annum, analyze whether it is a worthwhile purchase.
ii. Solve question (c) above using a combination of Excel's financial functions. Show your work and formulas/functions. ii. Effective annual interest rate.
iii. Find (i) again using an appropriate Excel function.
iv. Find (ii) again using Excel's "EFFECT" function. Show your Excel formulas.
v. Suppose a true effective annual rate is 22.5%. A bank would like to quote the equivalent nominal rate that would be compounded per month. What nominal rate should be quoted by the bank? Show your work.