Lab-4 Lab-5 Lab-5 (Question 4) Name: Chalaya Simon Date: 2023-12-10 Official Time: 19:10:47 Year 1 2 3 4 5 Total NPV Question 4 [13 points] Project R cost $10,100 and will generate net cash inflows of $1,200 in year one, $2,100 in year two, $3,500 in year three, $3,700 in year four and $1,900 in year five. Spreadsheet Print Preferences Help Complete the following table and find the NPV using 7% as the discount rate. Please make sure your final answers for the present value factor are accurate to 3 decimal places and the ones for the present value are accurate to the nearest whole number. Cash Flow Amount Present Value Factor Present Value $1,200 2,100 3,500 3,700 1,900

Transcribed Image Text:

Preferences Help Lab-4 Lab-5 Lab-5 (Question 4) Name: Chalaya Simon Date 2023-12-10 Official Time: 19:10:47 Question 4 [13 points] Project R cost $10,100 and will generate net cash inflows of $1,200 in year one, $2,100 in year two, $3,500 in year three, $3,700 in year four and $1,900 in year five. Complete the following table and find the NPV using 7% as the discount rate: Please make sure your final answers for the present value factor are accurate to 3 decimal places and the ones for the present value are accurate to the gearest whole number Year | Cash Flow Amount Present Value Factor Present Value 1 $1,200 2 2,100 3,500 3,700 1,900 Total NPV Preferences Help Lab-4 Lab-5 Lab-5 (Question 4) Name: Chalaya Simon Date 2023-12-10 Official Time: 19:10:47 Question 4 [13 points] Project R cost $10,100 and will generate net cash inflows of $1,200 in year one, $2,100 in year two, $3,500 in year three, $3,700 in year four and $1,900 in year five. Complete the following table and find the NPV using 7% as the discount rate: Please make sure your final answers for the present value factor are accurate to 3 decimal places and the ones for the present value are accurate to the gearest whole number Year | Cash Flow Amount Present Value Factor Present Value 1 $1,200 2 2,100 3,500 3,700 1,900 Total NPV