SHOW IN EXCEL SHOW EACH PROCESS IN EXCEL Gasoline EV Purchase Cost $50,000 $80,000 Annual - Maintenance $5,000 $2,500 Annual Fuel $7,500 $3,000 Service Life Probability Service Life Probability 55% 52% 6 10% 65% 7 25% 7 10% 8 35 % 8 25% 9 20% 9 50 % 10 5 % 10 8% a) (5 Points) What is the expected value of the present worth and expected value of the standard deviation of each option? b) (5 Points) Which option should be chosen, and why? c) (5 Points) If the company' s MARR is 20%, which option would they choose and why? d) (5 Points) What value of the MARR makes the company indifferent between choosing gasoline or electric vehicles?

Essentials of Economics (MindTap Course List)
8th Edition
ISBN:9781337091992
Author:N. Gregory Mankiw
Publisher:N. Gregory Mankiw
Chapter19: The Basic Tools Of Finance
Section: Chapter Questions
Problem 3CQQ
icon
Related questions
Question
SHOW IN EXCEL SHOW EACH PROCESS IN EXCEL Gasoline EV Purchase Cost $50,000 $80,000 Annual
-
Maintenance $5,000 $2,500 Annual Fuel $7,500 $3,000 Service Life Probability Service Life Probability
55% 52% 6 10% 65% 7 25% 7 10% 8 35 % 8 25% 9 20% 9 50 % 10 5 % 10 8% a) (5 Points) What is the
expected value of the present worth and expected value of the standard deviation of each option? b) (5 Points) Which
option should be chosen, and why? c) (5 Points) If the company' s MARR is 20%, which option would they choose
and why? d) (5 Points) What value of the MARR makes the company indifferent between choosing gasoline or electric
vehicles?
Transcribed Image Text:SHOW IN EXCEL SHOW EACH PROCESS IN EXCEL Gasoline EV Purchase Cost $50,000 $80,000 Annual - Maintenance $5,000 $2,500 Annual Fuel $7,500 $3,000 Service Life Probability Service Life Probability 55% 52% 6 10% 65% 7 25% 7 10% 8 35 % 8 25% 9 20% 9 50 % 10 5 % 10 8% a) (5 Points) What is the expected value of the present worth and expected value of the standard deviation of each option? b) (5 Points) Which option should be chosen, and why? c) (5 Points) If the company' s MARR is 20%, which option would they choose and why? d) (5 Points) What value of the MARR makes the company indifferent between choosing gasoline or electric vehicles?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Essentials of Economics (MindTap Course List)
Essentials of Economics (MindTap Course List)
Economics
ISBN:
9781337091992
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Brief Principles of Macroeconomics (MindTap Cours…
Brief Principles of Macroeconomics (MindTap Cours…
Economics
ISBN:
9781337091985
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Principles of Economics 2e
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax
Economics Today and Tomorrow, Student Edition
Economics Today and Tomorrow, Student Edition
Economics
ISBN:
9780078747663
Author:
McGraw-Hill
Publisher:
Glencoe/McGraw-Hill School Pub Co
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning