Project NPV

Given the provided $5$ year cash inflows $($see Excel$)$ calculate the project NPV$.$ The discount rate will be $8\%$ for the project. Show the project NPV with and without overhead $($i$.$e$.$ you need to calculate NPV using WBS costs first, then recalculate NPV after you add$-$in overhead$).$

However, your recommendation should be based on total project cost $($WBS activity cost $+$overhead$).$ Provide a recommendation to approve $/$ reject the project $...$ include your rationale

Include screenshots of your NPV calculations.

Remember that the initial investment $($outflow$)$ for NPV calculation is total WBS costs then recalculate NPV using total WBS costs $+$ Overhead

$-$the total project cost without overhead costs is $1703200\mathrm{.}00$

and the total project cost with overhead costs is $2129000\mathrm{.}00$

CASH FLOWS FOR NPV

YEAR $1$: $575,000$

YEAR $2$: $575,000$

YEAR $3$: $575,000$

YEAR $4$: $575,000$

YEAR $5$: $575,000$

DISCOUNT RATE: $8\%$

WHAT IS NPV WITH AND WITHOUT OVERHEAD? SHOULD PROJECT BE APPROVED OR REJECTED AND WHY?