The case The financial pathway to green manifests itself as a dichotomous and mutually-exclusive choice between a hybrid car which entails fossil fuel directly and an all-electric car which doesn't. This exercise frames the decision-making process into a typical mutually exclusive capital budgeting analysis. We choose Toyota Prius as the hybrid and the Nissan Leaf as the all-electric car. In August 2015, a Toyota Prius lists at $26,985 as its manufacturer suggested retail price. The corresponding retail price for the Nissan Leaf lists at $29,010. The Prius has a city-highway combined efficiency of 50 miles per gallon. For the base-case analysis, let's assume a gas price at $3.00 per gallon. This will result in a mileage efficiency of 6 mile. The Leaf has an efficiency of 5.4 miles/kWh. For base-case analysis, let's assume electricity supply at a price of 12/kWh. This will result in a mileage efficiency of 2.2222 mile. For simplicity of analysis, let's assume the a driver who needs to drive 12,000 miles a year or 1,000 miles a month for work, school, and other transportation needs. Let's further assume the driver faces an auto loan's interest rate of 3% per year or 25% per month. To de: We first perform a base-case analysis using the data provided or assumed so far. QI: Calculate the monthly cash flows for purchasing and operating the Prius for 10 years. (10%) Q2: Calculate the monthly cash flows for purchasing and operating the Leaf for 10 years. (109) 03: From the monthly cash flows in the previous two questions, derive the incremental cash flows of purchasing the more expensive Leaf over the less-expensive Prius for 10 years. (10%) 04: From the incremental cash flows established in Q3 above, find the following capital- budgeting measures. i undiscounted payback in years (5%) Hi, discounted payback in years; (5%) iii. net present value, NPV, in S: (109) iv. internal rate of return, IRR, in % (10%) w profitability index (practitioner's version) (10%) vi. modified internal rate of return, MIRR, in %. Use reinvestment rate of 1% per annum or .08333% per month. (10%) Next, we perform 2-variable sensitivity analyses over ranges of plausible values for the two variables by calculating the discount payback which is simply the number of years it entails to breakeven the extra $2,025 upfront payment for the all-electric Nissan Leaf. For the Prius, we choose gas price as the variable for a range of 2.00 S/gallon to 6.00 S/gallon over a 50-4 increment. For the Leal, we choose three variables, namely the interest rate from 0% to 6% per year, electric supply rate from 8 kWh to 16 g/kWh, and tax credit for buying the electric car from SO (the base-case analysis above) to $2,000 at S500 increment. Beware of the #NUMI output when applying the Excel's Data, What if Analysis, Data Table mode. They are not spurious output but do have their own significant economie interpretation. Those who need help with the Data Table function in Excel, please refer to the Appendix where a similar numerical example was presented as an illustration. We expect three output tables as follow: Gas price, Spallon 112.00 2.50 3.00 3.50 4.00 4.50 5.00 5.506,00 The case The financial pathway to green manifests itself as a dichotomous and mutually-exclusive choice between a hybrid car which entails fossil fuel directly and an all-electric car which doesn't. This exercise frames the decision-making process into a typical mutually exclusive capital budgeting analysis. We choose Toyota Prius as the hybrid and the Nissan Leaf as the all-electric car. In August 2015, a Toyota Prius lists at $26,985 as its manufacturer suggested retail price. The corresponding retail price for the Nissan Leaf lists at $29,010. The Prius has a city-highway combined efficiency of 50 miles per gallon. For the base-case analysis, let's assume a gas price at $3.00 per gallon. This will result in a mileage efficiency of 6 mile. The Leaf has an efficiency of 5.4 miles/kWh. For base-case analysis, let's assume electricity supply at a price of 12/kWh. This will result in a mileage efficiency of 2.2222 mile. For simplicity of analysis, let's assume the a driver who needs to drive 12,000 miles a year or 1,000 miles a month for work, school, and other transportation needs. Let's further assume the driver faces an auto loan's interest rate of 3% per year or 25% per month. To de: We first perform a base-case analysis using the data provided or assumed so far. QI: Calculate the monthly cash flows for purchasing and operating the Prius for 10 years. (10%) Q2: Calculate the monthly cash flows for purchasing and operating the Leaf for 10 years. (109) 03: From the monthly cash flows in the previous two questions, derive the incremental cash flows of purchasing the more expensive Leaf over the less-expensive Prius for 10 years. (10%) 04: From the incremental cash flows established in Q3 above, find the following capital- budgeting measures. i undiscounted payback in years (5%) Hi, discounted payback in years; (5%) iii. net present value, NPV, in S: (109) iv. internal rate of return, IRR, in % (10%) w profitability index (practitioner's version) (10%) vi. modified internal rate of return, MIRR, in %. Use reinvestment rate of 1% per annum or .08333% per month. (10%) Next, we perform 2-variable sensitivity analyses over ranges of plausible values for the two variables by calculating the discount payback which is simply the number of years it entails to breakeven the extra $2,025 upfront payment for the all-electric Nissan Leaf. For the Prius, we choose gas price as the variable for a range of 2.00 S/gallon to 6.00 S/gallon over a 50-4 increment. For the Leal, we choose three variables, namely the interest rate from 0% to 6% per year, electric supply rate from 8 kWh to 16 g/kWh, and tax credit for buying the electric car from SO (the base-case analysis above) to $2,000 at S500 increment. Beware of the #NUMI output when applying the Excel's Data, What if Analysis, Data Table mode. They are not spurious output but do have their own significant economie interpretation. Those who need help with the Data Table function in Excel, please refer to the Appendix where a similar numerical example was presented as an illustration. We expect three output tables as follow: Gas price, Spallon 112.00 2.50 3.00 3.50 4.00 4.50 5.00 5.506,00