Question
c. A company plans to buy equipment for Ghc 200m, half of which is due on delivery, with the balance due exactly one year later.
c. 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 Excels 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 Excels 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started