You are considering the following two projects for investment: Conduct an analysis using your knowledge of capital budgeting and the time value of money to decide which of the options is better. All analysis must be done in Excel. (This will require all calculations to be done using cell references and excel functions). Required A. Calculate the following values for the investment proposals: i. The payback period assuming end-of-the-year cash flows. ii. The discounted payback period assuming a required rate of return of 10% and end-ofthe-year cash flows. iii. The NPV of each project. iv. The PI of each project. v. The IRR of each project