An injection-molding machine has a first cost of $1,050,000 and a salvage value of $225,000 in any year. The maintenance and operating cost is $235,000 with an annual gradient of $75,000. The MARR is 10%. What is the most economic life? 13-1                         P Maint A Maint G (A/G, 10%, n) Salvage PV of S n EUAC-P EUAC-M EUAC-S EUAC Minimum?   1050000 235000 75000   225000   1             1050000 235000 75000   225000   2             1050000 235000 75000   225000   3             1050000 235000 75000   225000   4             1050000 235000 75000   225000   5             1050000 235000 75000   225000   6             1050000 235000 75000   225000   7             1050000 235000 75000   225000   8                                                                                                                                                                         Can you please teach how to calculate these number I don't know how to solve in excel I like to see the formula for each colum please. thank you

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

An injection-molding machine has a first cost of $1,050,000 and a salvage value of $225,000 in any year. The maintenance and operating cost is $235,000 with an annual gradient of $75,000. The MARR is 10%. What is the most economic life?

13-1                        
P Maint A Maint G (A/G, 10%, n) Salvage PV of S n EUAC-P EUAC-M EUAC-S EUAC Minimum?  
1050000 235000 75000   225000   1            
1050000 235000 75000   225000   2            
1050000 235000 75000   225000   3            
1050000 235000 75000   225000   4            
1050000 235000 75000   225000   5            
1050000 235000 75000   225000   6            
1050000 235000 75000   225000   7            
1050000 235000 75000   225000   8            
                         
                         
                         
                         
                         
                         

Can you please teach how to calculate these number I don't know how to solve in excel I like to see the formula for each colum please. thank you 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Present Worth
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