Rowan Company is considering two alternative investment projects. Each requires a $$255,000$ initial investment. Project $A$ is expected

to generate net cash flows of $$65,000$ per year over the next six years. Project $B$ is expected to generate net cash flows of $$55,000$

per year over the next seven years. Management requires an $8\%$ rate of return on its investments. $($PV of $$1,FV$ of $$1,$ PVA of $$1,$ and

FVA of $$1)($Use appropriate factor$($s$)$ from the tables provided.$)$

Required:

Compute each project's net present value.

Compute each project's profitability index.

If the company can choose only one project, which should it choose, based on profitability index?

Complete this question by entering your answers in the tabs below.

Required $1$

Required $2$

Compute each project's net present value. $($Do not round intermediate calculations. Round your present value factor to $4$

decimals and your final answers to the nearest whole dollar.$)$

please give the answer in spreadsheet format as the picture in question!