i TRIED MANUALLY AND WITH EXCEL BUT I DO NOT GET THE CORRECT ANSWER. CAN YOU PLEASE PROVIDE THE ANSWERS AND HOW WOULD ENTER THIS ON EXCEL I tHINK I PUT =RATE, VALUES FOR EACH YEAR? PLEASE PROVIDE ANSWERS TO ALL. THANK YOU IN ADVANCE

Suppose you are evaluating a project with the expected future cash inflows shown in the following table. Your boss has asked you to calculate the projects net present value (NPV). You dont know the projects initial cost, but you do know the projects regular, or conventional, payback period is 2.50 years.

Year	Cash Flow
Year 1	$375,000
Year 2	$500,000
Year 3	$450,000
Year 4	$475,000

A. If the projects weighted average cost of capital (WACC) is 7%, the projects NPV (rounded to the nearest dollar) is:

$500,275

$416,896

$333,517

$354,362

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

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

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

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