ALTERNATIVE A: A solar panel costs 25,000. 7 solar panels are needed in a company. The installation fee is 10,000 and will have a useful 25 years with no salvage value. The maintenance per year is 5,000. The annual interest rate for solar panel is 1.5%. ALTERNATIVE B: A new power line will cost 20,000, with power costs expected to be 1,950.90 per month. The annual increase rate of electric bill is about 3.5%. Which alternative should be selected on the basis of a future worth analysis? Illustrate the cash flow diagram. USE MS EXCEL IN COMPUTATION and SHOW THE SOLUTION PROPERLY.

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
FIRST COST
ANNUAL COST
SALVAGE VALUE
ANNUAL INTEREST RATE
STUDY PERIOD
Power Line
20,000
1,950.90/month × 12= 23,410.8/year
Solar
25,000 X 7= 125,000+10,000= 135,000
3,000/year
0
3.5%
25
ALTERNATIVE A: A solar panel costs 25,000. 7 solar panels are needed in a company. The installation fee
is 10,000 and will have a useful 25 years with no salvage value. The maintenance per year is 5,000. The
annual interest rate for solar panel is 1.5%.
0
1.5%
25
ALTERNATIVE B: A new power line will cost 20,000, with power costs expected to be 1,950.90 per
month. The annual increase rate of electric bill is about 3.5%.
Which alternative should be selected on the basis of a future worth analysis? Illustrate the cash
flow diagram. USE MS EXCEL IN COMPUTATION and SHOW THE SOLUTION PROPERLY.
Transcribed Image Text:FIRST COST ANNUAL COST SALVAGE VALUE ANNUAL INTEREST RATE STUDY PERIOD Power Line 20,000 1,950.90/month × 12= 23,410.8/year Solar 25,000 X 7= 125,000+10,000= 135,000 3,000/year 0 3.5% 25 ALTERNATIVE A: A solar panel costs 25,000. 7 solar panels are needed in a company. The installation fee is 10,000 and will have a useful 25 years with no salvage value. The maintenance per year is 5,000. The annual interest rate for solar panel is 1.5%. 0 1.5% 25 ALTERNATIVE B: A new power line will cost 20,000, with power costs expected to be 1,950.90 per month. The annual increase rate of electric bill is about 3.5%. Which alternative should be selected on the basis of a future worth analysis? Illustrate the cash flow diagram. USE MS EXCEL IN COMPUTATION and SHOW THE SOLUTION PROPERLY.
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Equivalent Uniform Annual Benefit and Cost
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
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
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education