Ch%206_P2 - Chapter 6 Problem 2 Year Sales FC Total VC Revenues Net Cash Flow Year 1 Sales Fixed Cost Unit VC Car Price Interest rate Std of Actual

Ch%206_P2 - Chapter 6 Problem 2 Year Sales FC Total VC...

This preview shows page 1 - 4 out of 18 pages.

Chapter 6 Problem 2 Year 0 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 / To Ch 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 0 1 2 3 4 5 6 0 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 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 0 Mode $2,836,920,384.00 5.0% ($3,531,247,872.00) 10.0%

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture