business Finance

business Finance

CAPITAL BUDGETING AND RISK ANALYSIS

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 Excel’s 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?

For this question, it is necessary to develop your own Excel spreadsheet.