ENGINEERING ECONOMY DIGITAL ACCESS
ENGINEERING ECONOMY DIGITAL ACCESS
8th Edition
ISBN: 2810022611683
Author: Blank
Publisher: MCG
Question
Book Icon
Chapter 5, Problem 25P

(a):

To determine

Compare the projects based on the present worth.

(a):

Expert Solution
Check Mark

Explanation of Solution

Plan A: The initial cost (C) is $1,000,000 per year.

Plan B: It is a two-year contract. The cost (C) is $600,000 per semiannual starts with immediate. No payment required in the second year.

Plan C: It is a three-year contract. The cost (C) is $1,500,000 now and the second payment (C1) is $500,000 after two years.

To compare the projects, all projects’ life time should be equal. Thus, all the projects’ cash flow converts to 6 years.

Interest rate (i) is 6% per year that is compounded semiannually. Interest calculated time period (Ci) is 2. The effective interest rate per year (Ei) can be calculated as follows:

Ei=(1+iCi)Ci1=(1+0.062)21=1.06091=0.0609

The effective interest rate is 6.09%.

Plan A cash flow is each year pays $1,000,000. Since the payment is made at the beginning of each year, the time period (n) is five. The present worth of plan A (PWA) can be calculated as follows:

PWA=CC((1+Ei)n1Ei(1+Ei)n)=1,000,0001,000,000((1+0.0609)510.0609(1+0.0609)5)=1,000,0001,000,000(1.34391610.0609(1.343916))=1,000,0001,000,000(0.3439160.081844)=1,000,0001,000,000(4.202092)=1,000,0004,202,092=5,202,092

The present worth of the plan A is -$5,202,092.

Plan B cash flow is each semiannual pays $600,000. Since the payment is made at the beginning of each semiannual for the first year, the time period (n1) is two, time period 2 (n2) is three, and time period 3 (n3) is seven. Since the interest is compounded semiannually, the semiannual interest (i1) is 3%(62). The present worth of plan B (PWB) can be calculated as follows:

PWB=C(1+((1+i1)n11i1(1+i1)n1)+((1+i1)n21i1(1+i1)n2)(1+i1)n2+((1+i1)n31i1(1+i1)n3)(1+i1)n3)

=600,000(1+((1+0.03)210.03(1+0.03)2)+((1+0.03)310.03(1+0.03)3)(1+0.03)3+((1+0.03)310.03(1+0.03)3)(1+0.03)7)=600,000(1+(1.060910.03(1.0609))+(1.09272710.03(1.092727))1.092727+(1.09272710.03(1.092727))1.229873)=600,000(1+(0.06090.031827)+(0.0927270.032782)1.092727+(0.0927270.032782)1.229873)=600,000(1+(1.91347)+(2.828595)1.092727+(2.828595)1.229873)=600,000(1+(1.91347)+2.588565+2.299991)=600,000(7.802026)=4,681,215.6

The present worth of plan B is -$4,681,215.6.

Plan C’s cash flow is $1,500,000 at the beginning of the year and pays $500,000 at the end of the second year. Thus, the time period (n1) is four, time period 2 (n2) is six, and time period 3 (n3) is 10. Since the interest is compounded semiannually, the semiannual interest (i1) is 3%(62). The present worth of plan C (PWC) can be calculated as follows:

PWC=CC1(1+i1)n1C(1+i1)n2C1(1+i1)n3=1,500,000500,000(1+0.03)41,500,000(1+0.03)6500,000(1+0.03)10=1,500,000500,0001.0927271,500,0001.194052500,0001.3463916=1,500,000457,570.82971,256,226.1497371,362.872=3,555159.85

The present worth of plan C is -$3,555,159.85. Since the present worth of plan C is greater than other two plans, select plan C.

(b):

To determine

Spreadsheet function for calculating the present worth.

(b):

Expert Solution
Check Mark

Explanation of Solution

The interest rate is filled in B2, cash flows are filled in B5 to B10. The spreadsheet function for plan A is given below:

=NPV($B2,B6:B10)+B5

The above function gives the value of -$5,202,070.

The interest rate is filled in D2, cash flows are filled in D5 to D15. The spreadsheet function for plan A is given below:

= NPV($D2,D6:D15)+D5

The above function gives the value of -$4,681,182.

The interest rate is filled in E2, and cash flows are filled in E5 to E15. The spreadsheet function for plan A is given below:

= NPV($E2,E6:E15)+E5

The above function gives the value of -$3,572,517.

Since the present worth of plan C is greater than other two plans, select plan C.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Describe the various measures used to assess poverty and economic inequality. Analyze the causes and consequences of poverty and inequality, and discuss potential policies and programs aimed at reducing them, assess the adequacy of current environmental regulations in addressing negative externalities. analyze the role of labor unions in labor markets. What is one benefit, and one challenge associated with labor unions.
Evaluate the effectiveness of supply and demand models in predicting labor market outcomes. Justify your assessment with specific examples from real-world labor markets.
Explain the difference between Microeconomics and Macroeconomics?  2.) Explain what fiscal policy is and then explain what Monetary Policy is? 3.) Why is opportunity cost and give one example from your own of opportunity cost. 4.) What are models and what model did we already discuss in class? 5.) What is meant by scarcity of resources?
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:9780190931919
Author:NEWNAN
Publisher:Oxford University Press
Text book image
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Text book image
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Text book image
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education