Ch%206_P3 - Chapter 6 Problem 3 Year Sales Total VC Revenues Net Cash Flow Total Truck Sales Competitors Competitors Leave Truck VC Truck Price Interest

Ch%206_P3 - Chapter 6 Problem 3 Year Sales Total VC...

This preview shows page 1 - 8 out of 8 pages.

Chapter 6 Problem 3Year0123Sales#ADDIN?#ADDIN?#ADDIN?Total VC#ADDIN?#ADDIN?#ADDIN?Revenues#ADDIN?#ADDIN?#ADDIN?Net Cash Flow#ADDIN?#ADDIN?#ADDIN?Total Truck Sales#ADDIN?#ADDIN?#ADDIN?Competitors2 #ADDIN?#ADDIN?#ADDIN?Competitors Leave#ADDIN?#ADDIN?#ADDIN?Truck VC$12,000 $13,000 $14,000 Truck Price$15,000 $16,000 $17,000 Interest rate0.1a.) mean = 1.4574 billion, variance = 1.01581E+16 S.D. = 100,787,700d.)-5-4-3-2-1012345600.511.52Distribution for Net Cash Flow / Total NPV/G7Values in BillionsValues in 10^ -10Fixed Cost/B10-0.53Regression Sensitivity for Net Cash Flow / Total NPV/G7
Sales/D3Unit VC/C11Year 1 Sales/B9Sales/E3-1-0.8-0.6-0.4-0.200.20.40.60.810.31-0.30.290.23Std b Coefficients
Total NPV#ADDIN?
Background image
Chapter 6 Problem 3Year0123Sales#ADDIN?#ADDIN?#ADDIN?Total VC#ADDIN?#ADDIN?#ADDIN?Revenues

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture