Please provide answers in EXCEL with formulas following the format provide below. Thank you
An investment firm has a new security for sale. You pay them $ today and the company
will give you back $ at the end of the first year, $ at the end of year $ at
the end of year dots,$ at the end of year and $ at the end of year Total
Points
a Calculate the NPV of this investment if the discount rate is points
b Calculate the IRR of this investment. points
c Use the IRR computed in part B above as the discount rate and compute a loan
amortization table for the investment. points
d Assume the discount rate for the first five years is but for the last four years it is
What is the NPV of the investment? points
