Question
Question 3 This question will require you to use Excel's Rate function.You can use the IRR function, but in case of an Annuity with a
Question 3
This question will require you to use Excel's Rate function.You can use the IRR function, but in case of an Annuity with a large number of periods, it can become cumbersome.
A firm purchases Treasury bonds for$250,000. The Face Value of the bonds are $300,000. It receives yearly coupons of $12,000 for 8 years. At the end of 8 years the firm receives the Face Value of $300,000 plus the coupon payment for the 8th year, and then the bonds are extinguished.
What is the IRR from the investment in the bonds?
Here is an example of the format of Excel's RATE function:
=RATE(3,10,-100,150,0,0.1)
3 is the number of periods, 10 the periodic payments, -100 the time 0 cash flow, and 150 the additional cash flow on the last period.
The 0, is format saying the payments occur at the end of every period, and 0.10 is the initial guess for the return.
Answer should be a number given as a %. That is, for example 3.18% should be answered as 3.18 rather than 3.18% or 0.0318
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