Question

Economic Life 13-1 An injection-molding machine has a first cost of $1,050,000 and a salvage value of $225,000 in any year. T

A В D E F G H 19 13-37 MARR% 21 First Cost 20% 200000 Year Market Value Lost MV Оper Cost Maint. Lost Int. Total MC Compare M

please use Excel sheet template to solve the problem

0 0
Add a comment Improve this question Transcribed image text
Answer #1

first Cost= $1,050,000

Salvage Value= $225,000

Maintenance & Operating Cost= $235,000

Maintenance & Operating Gradient= $75,000

MARR= 10%

EUAB – EAUC = $1,050,000 (A/P, 10%, n) + $225,000 (A/F, 10%, n) - $235,000 - $75,000 (A/G, 10%, n)

a) n = 4 years:

EUAB – EAUC

= $331,275 + $48,488 - $235,000 - $103,575

= -$621,362

b) n = 5 years:

EUAB – EUAC

= -$276,990 + $36,855 - $235,000 - $135,750

= -$610,885

c) n = 6 years:

EUAB – EUAC

= -$241,080 + $29,160 - $235,000 - $166,800

= -$613,720

Thus, year 5 has the minimum EUAB – EUAC, hence the most economic life is 5 years

Add a comment
Know the answer?
Add Answer to:
please use Excel sheet template to solve the problem Economic Life 13-1 An injection-molding machine has...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please show how to solve this in Excel. I posted the Excel sheet format it should...

    please show how to solve this in Excel. I posted the Excel sheet format it should look like 13-37 Big-J Construction Company, Inc. is conducting a routine periodic review of existing field equipment. They use a MARR of 20%. This includes a replace- ment evaluation of a paving machine now in use. The machine was purchased 5 years ago for $200,000, The paver's current market value is $65,000, and yearly operating and maintenance costs are as follows. Year, n Operating...

  • please show how to do problem in Excel sheet template like above Economic Life 13-1 An...

    please show how to do problem in Excel sheet template like above Economic Life 13-1 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? G JK M EUAC- P E UAC-M EUAC-S EUAC Minimum? 1 2 235000 235000 235000 235000 235000 235000 235000 235000 Maint G (AIG, 10%,...

  • Please help with graph, thank you! This is a small business started by Alex Lopez in...

    Please help with graph, thank you! This is a small business started by Alex Lopez in 1980. He was 22 years old, and had just graduated from UTSA with a degree in Business.   As a young entrepreneur, he bought a greenhouse, and started a hydroponic farm growing tomatoes. Growing various vegetables in water was a new industry at that time. Alex’s business is operating in a perfectly competitive industry, competing with other greenhouse and field producers in the U.S. and...

  • Use the graphical approach to CVP analysis to solve the following problem. Valley Peat Ltd, sells...

    Use the graphical approach to CVP analysis to solve the following problem. Valley Peat Ltd, sells peat moss for $10 per bag. Variable costs are $7.50 per bag and annual fixed costs are $100,000 a. How many bags of peat must be sold per year to break even? Number of bags bags/year b. What will be the net income for a year in which 60,000 bags of peat are sold? (Round your answer to the nearest whole number.) Net income...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT