Please show all work in Excel- thanks

7. The NPV and payback period

What information does the payback period provide?

Suppose Omni Consumer Productss CFO is evaluating a project with the following cash inflows. She does not know the projects initial cost; however, she does know that the projects regular payback period is 2.5 years.

Year	Cash Flow
Year 1	$300,000
Year 2	$400,000
Year 3	$425,000
Year 4	$475,000

If the projects weighted average cost of capital (WACC) is 9%, what is its NPV?

$309,469

$418,693

$400,489

$364,081

Which of the following statements indicate a disadvantage of using the discounted payback period for capital budgeting decisions? Check all that apply.

The discounted payback period does not take the time value of money into account.

The discounted payback period is calculated using net income instead of cash flows.

The discounted payback period does not take the projects entire life into account