HELP

Introduction to Finance Final Assessment [Question 2: Bond Valuation] You have the following information on four bonds. Fill in the information and show your computation processes. (Blank A \& C: 5 points each; Blank B \& D: 10 points each) [Question 3: Valuation Methods] Here is some information for a project: - The initial outlay is $56,000 today; - The project will provide annual after-tax profits of $15,000 for five years: - After five years, the project can still be sold at $4,500; - The project requires an inventory outflow of $3,000 today; but the $3,000 could be recovered at the end of the five years: - Discount rate =10% (a) Construct a cash flow scheme from year 0 to year 5. (10 points) (b) Write the equation for calculating net present value ( 10 points) and profitability index (6 points) of the project. Find the value of the NPV and PI using either a calculator or Excel. (4 points) (c) BONUS: Using Excel, calculate the IRR of this project. (5 bonus points)