1 / 26

Capital Budgeting Analysis

Capital Budgeting Analysis. Michael Bootsma Rachel Duschen Greg Ross. Cabernet-Merlot Project Overview. This presentation will walk you through my analysis of the proposed implementation of a new wine and give you my recommendation according to: NPV MIRR IRR Sensitivity Analysis.

jeneva
Download Presentation

Capital Budgeting Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Capital Budgeting Analysis Michael Bootsma Rachel Duschen Greg Ross

  2. Cabernet-Merlot Project Overview • This presentation will walk you through my analysis of the proposed implementation of a new wine and give you my recommendation according to: • NPV • MIRR • IRR • Sensitivity Analysis

  3. Key Base-Case Assumptions • The $333,000 outlay to rehabilitate the section of the main plant to be used in the making of the new wine is a sunk cost and therefore is not incorporated into the analysis

  4. Key Base-Case Assumptions • The wholesale price and fixed cash operating costs were inflated at a constant rate of 2.8% and 5% accordingly for entire duration of the project. • The number of units expected to be sold in the first year is 171,500 units, determined by marketing and production managers

  5. Key Base-Case Assumptions • A 3% T-bill rate and a 9.2% market risk premium were used in calculating the cost of capital • An asset beta of 1.79 and a capital structure of 44% debt and 56% equity were also used in formulating the cost of capital

  6. Key Base-Case Assumptions • Depreciation is calculated according to 5-year MACRS • Machinery will have a $125,000 market value at the end of 8 years

  7. Point of Controversy • An issue that evolved during the process of calculating final cash flow estimates was whether to include the effects of the new wine on the sales of existing wines • The amount of the decreased revenues was netted with the amount of decreased variable cash costs resulting in a $152,000 reduction in existing revenues

  8. Key Figures • Expected Price per Unit = $38.50 • Receivables Factor = .125 • calculated using a 360-day year and Days Sales Outstanding ratio of 45 days • receivables will increase as a function of current-year sales • Variable Cost per Unit = $17.25

  9. Key Figures • Variable Cost Payables Factor = .0428 • calculated using a 360-day year • 27% of variable costs represent credit purchases and are paid an average of 30 days later • the remaining 73% of variable costs consist of wages which are paid an average of 10 days later

  10. Key Figures • Annual Cash Fixed Costs = $795,000 • Fixed Cost Payables Factor = .0542 • calculated using a 360-day year • 65% of fixed costs are paid for with credit and are paid an average of 30 days later • 35% of fixed costs are paid immediately

  11. Key Figures • Opportunity Cost of Capital = 19% • calculated using the Asset Beta Model, which consists of adding the risk-free rate to the market risk premium multiplied by the asset beta • Sales in Years 2-5 are projected to be 35% higher than in Year 1 • Sales in Years 6-8 are projected to be 19% higher than in Year 1

  12. Key Figures • Initial Investment = $4,100,000 • includes: • new machinery costing $3,700,000 • shipping and installation charges of $400,000 • Income Tax Rate = 30% • Initial Change in NWC= $288,000

  13. Year 0 = - $4,218,293 Year 1 = $1,355,290 Year 2 = $3,003,712 Year 3 = $3,137,237 Year 4 = $3,012,215 Year 5 = $2,959,870 Year 6 = $2,582,466 Year 7 = $2,340,491 Year 8 = $3,223,669 Resulting Net Cash Flow Estimates-Base-Case

  14. Final Estimates-Base Case • NPV = $5,897,016 • MIRR = 33.3% • IRR = 54.9%

  15. Sensitivity Analysis • For every 5,000 change in unit sales there is an increase of $359,696 in NPV • For every $2 change in price there is an increase of $1,154,535 in NPV • For every $1 change in variable cost there is a decrease of $573,172 in NPV • Changes in price and cost inflation are insignificant along with a percent change in Cost of Capital

  16. Sensitivity Chart

  17. Sensitivity Chart

  18. Sensitivity Chart

  19. Scenario Analysis • In the worst case, 40,000 units would be sold and the price per bottle would be $20 • NPV = $(4,449,304) • Probability = 15%

  20. Scenario Analysis • In the base-case, 171,500 were assumed to be sold • NPV = $5,885,865 • Probability = 70%

  21. Scenario Analysis • In the best case, 244,500 units would be sold, causing variable cash operating costs to rise to $20 per unit • NPV = $8,890,280 • Probability = 15%

  22. Scenario Analysis • By multiplying each NPV by its respective probability, the expected NPV is found to be $4,786,252 • The deviation was calculated to be $4,020,844

  23. Risks • The worst case scenario would result in significant losses • The project is extremely sensitive to unit sales and price fluctuations • One deviation could nearly eliminate the positive NPV • Key Base-Case Assumptions could fluctuate

  24. Recommendation • Our recommendation is to accept the Project • The Base Case NPV is positive • The IRR and MIRR are also Positive for the Base Case • The Cash flows are also substantial when compared to the initial investment

  25. Recommendation Cont. • The Best Case Scenario presents a chance to almost double our NPV • The product is superior and would help expand our market share • The risks are justified with the potential returns • The company is well established and can assume the risks involved

More Related