0 . . . Question 1 Scenario: A company buys a machine for $150,000 Maintenance is expected to be $10,000 per year Net income from the machine is $40,000 per year The life of the machine is expected to be 10 years At the end of 10 years, the machine should be worth no more than $50,000 The company's MARR is 15% Your assignment: Do a complete engineering analysis of this opportunity Create the cash flow for this opportunity Do the analysis using nomenclature equations and the associated tables Do the analysis using an Excel spread sheet o Show the spread sheet o Show the spread sheet macro's used What is the Present Worth of this opportunity? What is the Annual Worth of this opportunity? What is the Future Worth of this opportunity? Make a recommendation What assumptions has the company made? . . . . 0 . . . Question 1 Scenario: A company buys a machine for $150,000 Maintenance is expected to be $10,000 per year Net income from the machine is $40,000 per year The life of the machine is expected to be 10 years At the end of 10 years, the machine should be worth no more than $50,000 The company's MARR is 15% Your assignment: Do a complete engineering analysis of this opportunity Create the cash flow for this opportunity Do the analysis using nomenclature equations and the associated tables Do the analysis using an Excel spread sheet o Show the spread sheet o Show the spread sheet macro's used What is the Present Worth of this opportunity? What is the Annual Worth of this opportunity? What is the Future Worth of this opportunity? Make a recommendation What assumptions has the company made