Question: Please pay attention to the significant figures while solving the question. It is the difference between a right answer and a wrong answer Alfredo Auto

Please pay attention to the significant figures while solving the question. It is the difference between a right answer and a wrong answer
Alfredo Auto Parts is considering investing in a new forming line for grille assemblies. For a five-year study period, the cash flows for two separate designs are shown below. Create a spreadsheet that will calculate the present worths for each project for a variable MARR. Through trial and error, establish the MARR at which the present worths of the two projects are exactly the same. E Click the icon to view the cash flows. The MARR at which the present worths of the two projects are exactly the same is percent. (Round to one decimal place as needed.) Cash flows Year 0 1 2 3 4 5 Disbursements $1,600,000 50,000 60,000 70,000 80,000 90,000 Cash Flows for Grille Assembly Project Automated Line Receipts Net Cash Flow Disbursements $0 - $1,600,000 $1,000,000 300,000 250,000 20,000 300,000 240,000 25,000 300,000 230,000 30,000 300,000 220,000 35,000 800,000 710,000 40,000 Manual Line Receipts $0 200,000 200,000 200,000 200,000 200,000 Net Cash Flow - $1,000,000 180,000 175,000 170,000 165,000 160,000 Print Done Alfredo Auto Parts is considering investing in a new forming line for grille assemblies. For a five-year study period, the cash flows for two separate designs are shown below. Create a spreadsheet that will calculate the present worths for each project for a variable MARR. Through trial and error, establish the MARR at which the present worths of the two projects are exactly the same. E Click the icon to view the cash flows. The MARR at which the present worths of the two projects are exactly the same is percent. (Round to one decimal place as needed.) Cash flows Year 0 1 2 3 4 5 Disbursements $1,600,000 50,000 60,000 70,000 80,000 90,000 Cash Flows for Grille Assembly Project Automated Line Receipts Net Cash Flow Disbursements $0 - $1,600,000 $1,000,000 300,000 250,000 20,000 300,000 240,000 25,000 300,000 230,000 30,000 300,000 220,000 35,000 800,000 710,000 40,000 Manual Line Receipts $0 200,000 200,000 200,000 200,000 200,000 Net Cash Flow - $1,000,000 180,000 175,000 170,000 165,000 160,000 Print Done
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
