Select a company in which you have an interest. For that company, describe a capital budgeting project (i.e., an investment in fixed assets) that might be undertaken by the company. Make sure that the project has an initial investment in Year 0, followed by a series of annual cash flows for at least seven (7) years.

1. Determine (make estimate) of the discount rate, or hurdle rate, that is appropriate for this project and explain the determination of that rate?

2. Develop your own Excel spreadsheet model that can be used to determine the Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), and Profitability Index (PI)? The Excel spreadsheet that you develop must use Excels automated financial functions for determining the NPV, IRR and MIRR. What is the NPV, IRR, MIRR, and PI for the project?

3. Using results of the spreadsheet analysis, explain whether, or not, the project should be implemented? Also, discuss what the various indicators (i.e., NPV, IRR, MIRR and PI) mean?See 6-1 Capital Budget Analysis Model.xlsx

Capital Budgeting Analysis ENTER CORRECT DATA IN YELLOW-CODED CELLS ($750,000,000) Projected Initial Cost 10.92% WACC 0 ($750,000,000) 1 ($10,000,000) ($760,000,000) $23,164,711 11.84% 11.59% 4.025 NPV IRR MIRR Payback years 2 $200,000,000 ($560,000,000) 3 $250,000,000 ($310,000,000) 4 $300,000,000 ($10,000,000) 5 $400,000,000 0.025 Year Cash flows Cumulative cash flows