Question: Please send excel file. Question 3 ( based on Week 6 Excel Examples - Chapter 1 1 ) A new machine will cost (
Please send excel file.
Question based on Week Excel Examples Chapter
A new machine will cost $ Its maximum useful life is years. The expected market value MV of the machine at the end of year is $ and it is expected to decline by $ each year afterwards. The annual operating cost AOC is projected to be $ during the first year of operation, and it is expected to rise by every year afterwards. Assuming minimum attractive rate of return, calculate the economic service life of the machine. Your calculations need to include a table with the following columns: Year, MV AOC, Capital Recovery, Annual Worth AW of AOC, and Total AW Illustrate your analysis with a properly labeled chart, featuring the number of years of service on the horizontal axis, and capital recovery, annual worth of the AOC, and total annual worth on the vertical axis click to format the vertical axis and check the box "Values in reverse order" so that the axis displays rising cost as movement up Please provide a written statement clearly stating the length of the economic service life of the machine.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
