Ch%206_P2

Ch%206_P2 - Chapter 6 Problem 2 Year 1 2 3 Sales #ADDIN?...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Chapter 6 Problem 2 Year 1 2 3 Sales #ADDIN? #ADDIN? #ADDIN? a.) mean = FC #ADDIN? Total VC #ADDIN? #ADDIN? #ADDIN? Revenues #ADDIN? #ADDIN? #ADDIN? Net Cash Flow #ADDIN? #ADDIN? #ADDIN? #ADDIN? Year 1 Sales #ADDIN? Fixed Cost #ADDIN? Unit VC #ADDIN? #ADDIN? #ADDIN? Car Price $13,000 $13,000 #ADDIN? #ADDIN? Interest rate 0.1 Std of Actual Sales 50000 b.) Name Workbook Worksheet Cell Sim# Output 1 Net Cash Flow / ToCh 6_p2.xls Sheet1 G7 1 Input 1 Sales Ch 6_p2.xls Sheet1 D3 1 Input 2 Sales Ch 6_p2.xls Sheet1 E3 1 Input 3 Year 1 Sales Ch 6_p2.xls Sheet1 B9 1 Input 4 Fixed Cost Ch 6_p2.xls Sheet1 B10 1 Input 5 Unit VC Ch 6_p2.xls Sheet1 C11 1 c.) d.)-5-4-3-2-1 1 2 3 4 5 6 0.5 1 1.5 2 1 2 1 Distribution for Net Cash Flow / Total NPV/G7 Values in Billions Values in 10^ -10 Fixed Cost/B10-0.53 Regression Sensitivity for Net Cash Flow / Total NPV/G7 Sales/D3 Unit VC/C11 Year 1 Sales/B9 Sales/E3-1-0.8-0.6-0.4-0.2 0.2 0.4 0.6 0.8 1 0.31-0.3 0.29 0.23 Std b Coefficients- 4.962 million, S.D. = 1.8776 billion Total NPV #ADDIN? Minimum Mean Maximum x1 p1 x2-4.21E+09-4.96E+08 5.23E+09-3.32E+09 5% 2.96E+09 39767.23 200134 404707.9 93076.44 5% 310907.3 14098.88 200754.3 449473.1 66766.66 5% 339422.3 46303.82 199975 342191.6 116769.6 5% 281720.8 3.00E+09 4.00E+09 5.00E+09 3.00E+09 5% 5.00E+09 5000 6500 8000 5000 5% 8000 Outputs Net Cash Flow / Total NPV Simulation 1 Statistics / Cell $G$7 Minimum ($2,766,883,698,769,920.00) Maximum $8,148,831,232.00 Mean ($39,157,454,621,951.50) Standard Deviation $292,178,085,342,875.00 Variance 8.54E+028 Skewness-7.84 Kurtosis 64.98 Number of Errors Mode $2,836,920,384.00 5.0% ($3,531,247,872.00) 10.0% ($2,589,154,304.00) 15.0% ($2,060,067,200.00) 20.0% ($1,716,936,832.00) 25.0% ($1,440,546,944.00) 30.0% ($1,082,775,680.00) 35.0% ($717,371,328.00) 40.0% ($406,040,896.00) 45.0% ($156,345,360.00) 50.0% $171,201,008.00 55.0% $540,831,360.00 60.0% $901,182,144.00 65.0% $1,205,539,072.00 70.0% $1,618,368,128.00 75.0% $1,986,475,904.00 80.0% $2,640,264,704.00 85.0% $3,098,249,216.00 90.0% $4,043,273,472.00 95.0% $4,943,795,200.00 Filter Minimum Filter Maximum Type (1 or 2) # Values Filtered Scenario #1 >75% Scenario #2 <25%...
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.

Page1 / 18

Ch%206_P2 - Chapter 6 Problem 2 Year 1 2 3 Sales #ADDIN?...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online