Hybrid vs. Gas Which is the best option?AssumptionsScenarioHonda Civic Sedan DX (Hybrid)Honda Civic Sedan ExAnnual Cash Flow Analysis ResultsSensitivity: Avg. Cost of FuelSensitivity: Miles Driven/YrSensitivity: Civic Hybrid Maintenance Cost/YrSensitivity ResultsResourcesHybrid vs. GasHybrid vs. GasWhich is the best option?Which is the best option?Team 10Team 10Daniel Cerna Daniel Cerna Juan Gaspar Juan Gaspar Duane San Juan Duane San Juan Sadia Tarannum Sadia TarannumAssumptionsAssumptionsAnalysis Period of 5 YearsAnalysis Period of 5 Years5 Year Loan at 6.50% APR5 Year Loan at 6.50% APRNo Down PaymentNo Down PaymentConstant Maintenance Cost for 5 YearsConstant Maintenance Cost for 5 Years15,000 Miles Driven/Yr15,000 Miles Driven/YrMiles Driven are 50% City & 50% HighwayMiles Driven are 50% City & 50% HighwayStandard Driving ConditionsStandard Driving ConditionsNot Reselling Car After 5 YearsNot Reselling Car After 5 YearsScenarioScenarioFor personal transportation is it best For personal transportation is it best to purchase a vehicle that runs on :to purchase a vehicle that runs on :Hybrid – 2005 Honda Civic HybridHybrid – 2005 Honda Civic HybridGasoline – 2005 Honda CivicGasoline – 2005 Honda CivicHonda Civic Sedan DX (Hybrid)Honda Civic Sedan DX (Hybrid)Purchase Price: $21,450Purchase Price: $21,450Variable Speed Variable Speed AutomaticAutomaticMPG (City): 48MPG (City): 48MPG (Highway): 47MPG (Highway): 47Honda Civic Sedan Ex Honda Civic Sedan Ex Purchase Price: Purchase Price: $19,310$19,3104 Speed Automatic4 Speed AutomaticMPG (City): 31MPG (City): 31MPG (Highway): 38MPG (Highway): 38Annual Cash Flow Analysis ResultsAnnual Cash Flow Analysis ResultsEUAC of Civic Hybrid = $7,901.80EUAC of Civic Hybrid = $7,901.80EUAC of Civic EX (Gas) = $7,737.29EUAC of Civic EX (Gas) = $7,737.29EUAC of Civic Hybrid is greater than EUAC of Civic Hybrid is greater than EUAC of Civic EX (Gas)EUAC of Civic EX (Gas)Therefore, Choose Civic EX (Gas)Therefore, Choose Civic EX (Gas)Sensitivity: Avg. Cost of FuelSensitivity: Avg. Cost of Fuel$3.98Sensitivity: Miles Driven/YrSensitivity: Miles Driven/Yr22,541 MilesSensitivity: Civic Hybrid Maintenance Cost/YrSensitivity: Civic Hybrid Maintenance Cost/Yr$365.11Sensitivity ResultsSensitivity ResultsLowest EUAC – Honda Civic ExLowest EUAC – Honda Civic ExHybrid fuel savings does not offset higher Hybrid fuel savings does not offset higher purchase pricepurchase priceCases where Civic Hybrid costs less:Cases where Civic Hybrid costs less:Avg. Cost of Fuel Over $3.98Avg. Cost of Fuel Over $3.98Miles Driven/Yr Over 22,541 MilesMiles Driven/Yr Over 22,541 MilesCivic Hybrid Maintenance Cost/Yr Below Civic Hybrid Maintenance Cost/Yr Below $365.11$365.11ResourcesResourcesHybrid Vehicle Cost Calculator Tool: Hybrid Vehicle Cost Calculator Tool: http://fcvt.nrel.gov/cleancities/hev/calculator/singhttp://fcvt.nrel.gov/cleancities/hev/calculator/single.phple.phpCalculates Present Value of Annuity with Calculates Present Value of Annuity with Interpretation:Interpretation:Investopedia.com Investopedia.com Mortgage Payment Calculator:Mortgage Payment Calculator:Connel.netConnel.netLoan Payment Calculator:Loan Payment
View Full Document