please use Excel sheet template to solve the problem
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
please use Excel sheet template to solve the problem Economic Life 13-1 An injection-molding machine has...
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 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 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 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...