Capital Budget Risk Analysis Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in Years determining whether the project is feasible. All you work should be in a spreadsheet file. After your analysis is completed answer these follow-up questions:

1). How does this capital budget risk analysis fit into a Balanced Scorecard analysis?

2). Would you recommend approval of this project? Explain. Does the risk analysis effect your decision?

Project Inputs:

WACC Determine the cost of capital for your discounted cash flow. Debt to Equity is 75%

Interest rate on the debt is 5.50%

Current Risk-Free Rate is 1.13%

Current Market Premium Rate is 8.25%

The firms beta is 1.30 Project Investment Outlay, Year 0 - $700,000

Project Investment Life 7 years

Project Depreciation - $100,000 / year

Project Salvage Value - $55,000

Working Capital Base of Annual Sales 8%

Expected inflation rate per year, Selling Price Per Unit 2.00%

Expected inflation rate per year, Manufacturing Cost per unit 1.50%

Expected inflation rate per year, Fixed operating costs per year 1.50%

Project Tax Rate 20%

Units sold per year 40,000

Selling Price per Unit, Year 1 - $45.00

Fixed operating costs per year excluding depreciation - $75,000

Manufacturing costs per unit, Year 1 - $35.00

In addition to your base case analysis, please provide a scenario and sensitivity analysis based on the following:

Worst Case Scenario = 20% decrease in sales units sold per year: 25% Probability

Base Case Scenario = 40,000 units sold per year: 55% Probability

Best Case Scenario = 20% increase in sales units sold per year: 20% Probability

Sensitive Variables:

Selling Price Per Unit

Manufacturing (variable) Cost Per Unit

Weighted Average Cost of Capital +- 10%, 20%, 30%

How does this risk analysis effect Net Present Value? Please show the calculations