question 2, A company is considering a $150,000 investment in machinery with the following net cash flows. The company requires a 10% return on its investments. Net cash flows Initial investment Required rate of return Year 1 $10,000 $150,000 10% Year $25,000 Year 3 $50,000 Year 4 $37,500 Year 5 $100,000

A company is considering a $150,000 investment in machinery with the following net cash flows. The company requires a 10% return on its investments. Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the bottom of this worksheet). Use cells A2 to F9 from the given information to complete this question. Table 1 Present Value of 1 31 Present Value of $1 Future Value of $1 Present Value of Annuity of $1 Future Value of Table 2 Future Value of 1 > Present Value of $1 Future Value of $1 Present Value of Annuity of $1 Future Value of Ar Calculation Mode: Automatic Workbook Statistics 2 Table 4 Present Value of an Annuity of 1 Present Value of $1 Future Value of $1A Present Value of Annuity of $1 Future Value of Calculation Mode: Automatic Workbook Statistics 2. Table B.3 Future value of an Annuity of 1 s Present Value of $1 Future Value of $1B Present Value of Annuity of $1B Future Value of Annuity of $1 Gra Calculation Mode Automatic Workbook Statistics