Select a company in which you have an interest. Choose TARGET, WALMART, or AMAZON.

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 Excel