{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Solutions - Chapter 11

Fundamentals of Corporate Finance Standard Edition

Info icon This preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 11 Problems 1-28 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Chapter 11 Question 1 Input area: Variable material cost $1.43 Variable labor cost $2.44 b. Fixed costs $650,000 Production 320,000 c. Sales price $10.00 Depreciation $190,000 Output area: a. Total variable cost $3.87 b. Total variable cost/year $1,888,400 c. Cash breakeven 106,036 Accounting breakeven 137,031
Image of page 2
Chapter 11 Question 2 Input area: Variable material cost $16.15 Variable labor cost $18.50 Sales price $105.00 Production 150,000 Fixed costs $800,000 Extra order 10,000 Output area: Total costs $5,997,500 Marginal cost $34.65 Average cost $39.98 Minimum acceptable revenue $346,500 Additional units should be produced only if the cost of producing those units can be recovered.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Chapter 11 Question 3 Input area: Price/unit $1,900 Variable cost/unit $170 Fixed costs $6,000,000 Quantity 105,000 Price accuracy 15% Variable cost accuracy 15% Fixed cost accuracy 15% Quantity accuracy 15% Output area: Scenario Unit sales Unit price Unit variable cost Fixed costs Base case 105,000 $1,900.00 $170.00 $6,000,000 Best case 120,750 $2,185.00 $144.50 $5,100,000 Worst case 89,250 $1,615.00 $195.50 $6,900,000
Image of page 4
Chapter 11 Question 4 Output area: An estimate for the impact of changes in price on the profitability of the project ca the NPV at any two different price levels and forming the ratio of the changes in th Whenever a sensitivity analysis is performed, all other variables are held constan values the sensitivity of NPV with respect to price: NPV/ P. This measure can be calcu
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
an be found from hese parameters. nt at their base-case ulated by finding
Image of page 6
Chapter 11 Question 5 Input area: Initial cost $896,000 Project life 8 Units sales 100,000 Price/unit $38.00 Variable cost/unit $25.00 Fixed costs $900,000 Tax rate 35% Required return 15% b. New quantity for calculation 105,000 Projected sales change (500) c. New VC for calculation $24.00 Projected VC change $(1.00) Output area: a. Depreciation per year $112,000 Accounting breakeven 77,846 DOL 9.036 b. Base OCF $299,200 Base NPV $446,606.60 New quantity 105,000 OCF $341,450 NPV $636,195.93 $37.918 For a sales change of (500) the NPV would change $(18,958.93) c. New variable cost $24.00 OCF $364,200 $(65,000.00) If variable costs change by $(1.00) then OCF would change by $65,000.00 NPV/ Q OCF/ VC
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
Chapter 11 Question 6 Input area: Initial cost $896,000 Project life 8 Units sales 100,000 Price/unit $38.00 Variable cost/unit $25.00 Fixed costs $900,000 Tax rate 35% Required return 15% Price uncertainty 10% Quantity uncertainty 10% Variable cost uncertainty 10% Fixed cost uncertainty 10% Output area: Annual depreciation $112,000 Scenario Unit sales Unit price Unit variable cost Fixed costs Base case 100,000 $38.00 $25.00 $900,000 Best case 110,000 $41.80 $22.50 $810,000 Worst case 90,000 $34.20 $27.50 $990,000 Best-case OCF $892,650.00 Best-case NPV $3,109,607.54 Worst-case OCF $(212,350.00) Worst-case NPV $(1,848,882.72)
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Chapter 11 Question 7 Input area: Unit price Unit variable cost Fixed costs Depreciation a. $3,000 $2,275 $15,000,000 $6,500,000 b. 39 27 73,000 140,000 c. 8 3 1,200 840 Output area: a. Accounting breakeven 29,655
Image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern