Question: Please solve using Goal Seek in Excel. Terry, an engineering technology graduate who is very entrepreneurial, wants to start an excavation and foundation business in

Please solve using Goal Seek in Excel.
Terry, an engineering technology graduate who is very entrepreneurial, wants to start an excavation and foundation business in Orlando by investing his own savings to fund part of the start-up. A primary decision is the size of a used dump truck to purchase. He knows that as the bed size increases, the net income increases, but he is uncertain whether the incremental expenditures for the larger sizes are justified. The estimated cash flows are listed below; all trucks have an 8-year useful life. Terry expects a return of at least 12% per year on this investment. Using an incremental rate-of-return analysis, determine which size truck he should purchase. Use GOAL SEEK when calculating your rate of return. (Note: You must provide screenshots to show how you used GOAL SEEK). Terry, an engineering technology graduate who is very entrepreneurial, wants to start an excavation and foundation business in Orlando by investing his own savings to fund part of the start-up. A primary decision is the size of a used dump truck to purchase. He knows that as the bed size increases, the net income increases, but he is uncertain whether the incremental expenditures for the larger sizes are justified. The estimated cash flows are listed below; all trucks have an 8-year useful life. Terry expects a return of at least 12% per year on this investment. Using an incremental rate-of-return analysis, determine which size truck he should purchase. Use GOAL SEEK when calculating your rate of return. (Note: You must provide screenshots to show how you used GOAL SEEK)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
