Ch%206_P3

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

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Chapter 6 Problem 3 Year Sales Total VC Revenues Net Cash Flow Total Truck Sales Competitors Competitors Leave Truck VC Truck Price Interest rate 0 1 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? $12,000 $15,000 2 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? $13,000 $16,000 3 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? $14,000 $17,000 2 0.1 a.) mean = 1.4574 billion, variance = 1.01581E+16 S.D. = 100,787,700 Distribution for Net Cash Flow / Total NPV/G7 2 1.5 Values in 10^ -10 1 0.5 0 -5 -4 -3 -2 -1 0 1 2 3 4 5 6 Values in Billions d.) Regression Sensitivity for Net Cash Flow / Total NPV/G7 Fixed Cost/B10 -0.53 Sales/D3 0.31 Unit VC/C11 -0.3 Regression Sensitivity for Net Cash Flow / Total NPV/G7 Fixed Cost/B10 -0.53 Sales/D3 0.31 Unit VC/C11 -0.3 Year 1 Sales/B9 0.29 Sales/E3 0.23 -1 -0.8 -0.6 -0.4 -0.2 0 0.2 0.4 0.6 0.8 1 Std b Coefficients Total NPV #ADDIN? Chapter 6 Problem 3 Year Sales Total VC Revenues Net Cash Flow Total Truck Sales Competitors Competitors Leave Truck VC Truck Price Interest rate 0 1 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? $12,000 $15,000 2 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? $13,000 $16,000 3 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? $14,000 $17,000 2 0.1 a.) mean = 1.5012 billion, variance =9.342E+15 S.D. = 96,652,730 1.50E+09 9.67E+07 9.34E+15 Distribution for Net Cash Flow / Total NPV/G7 2 1.5 Values in 10^ -10 1 0.5 0 -5 -4 -3 -2 -1 0 1 2 3 4 5 6 Values in Billions d.) Regression Sensitivity for Net Cash Flow / Total NPV/G7 Fixed Cost/B10 -0.53 Sales/D3 0.31 Unit VC/C11 -0.3 Regression Sensitivity for Net Cash Flow / Total NPV/G7 Fixed Cost/B10 -0.53 Sales/D3 0.31 Unit VC/C11 -0.3 Year 1 Sales/B9 0.29 Sales/E3 0.23 -1 -0.8 -0.6 -0.4 -0.2 0 0.2 0.4 0.6 0.8 1 Std b Coefficients Total NPV #ADDIN? ...
View Full Document

This note was uploaded on 05/09/2010 for the course MD 605 taught by Professor Silks during the Fall '10 term at box.

Ask a homework question - tutors are online