I ONLY NEED #$2$ answered but information from #$1$ is required for #$2$:

$1.$ Bulldog Memorabilia, a small screen printing firm, is considering investing in new technology that allows customers to design their own products online, then they are automatically printed and shipped with only minimal labor costs. The firm has projected the following cash flows

Time $0$ Time $1$ Time $2$ Time $3$ Time $4$ Time $5$

$-2,000,000450,000550,000625,000600,000400,000$

The firm anticipates selling the equipment for $300,000($its salvage value$)$ at time $5$ and estimates the project cost of capital to be $10\%.$ The firm estimates the IRR on the project to be $13\mathrm{.}19\%$

a$.$ Calculate the Net Present Value of the project $(5$ points$)$

NPV$=(450,000/1\mathrm{.}1)+(550,000/1\mathrm{.}21)+(625,000/1\mathrm{.}331)+(600,000/1\mathrm{.}464)+(400,00/1\mathrm{.}611)+300,000-2,000,000$

NPV$=1,777,661\mathrm{.}1$

b$.$ Calculate the Payback Period and Discounted Payback period $(5$ points$)$

Payback period$=$ year before payback $+($unrecovered cash$/$cash flow$)$

$=3+(375,000/600,000)$

Payback period$=3\mathrm{.}63$ years

Discounted payback period$=$ year before payback$+($unrecovered discount cost$/$cash flow$)$

$=4+(256,983\mathrm{.}81/434,645\mathrm{.}92)$

Discounted payback period$=4\mathrm{.}6$ years

c$.$ Calculate the Profitability Index for the project $(5$ points$)$

Profitability index$=($NPV$+$Investment$/$Investment$)$

$=(177,661\mathrm{.}1+2,000,000/2,000,000)$

Profitability index$=1\mathrm{.}09$

d$.$ Will the NPV and IRR always provide the same accept $/$ reject decision $($is it possible for you to accept a project using NPV and reject it using IRR$).$ Explain in detail $($show why they will always agree or provide an example where they don$$t$)(5$ points$)$

When considering a project by itself, the NPV and IRR will generally always lead to the same accept$/$reject decision assuming conventional cash flow, but I don$$t believe that is the case with this project. If you are comparing a project to another project, on the other hand, trying to decide which to pursue, the NPV and IRR will not always agree, and you should utilize NPV$.$ There are limitations to IRR in cases of unconventional cash flows, IRR not taking into account size and scale of the investment, and IRR assuming reinvestment at the same rate. NPV will provide a clear indication of if a project will or will not increase the firm$$s overall value, taking size and scale of investment into consideration. Because of this, and the limitations of IRR, sometimes the NPV and IRR will not provide the same accept$/$reject decision when comparing projects. In the case of this project, the project$$s IRR would suggest that the project is acceptable since it is higher than the cost of capital, however, the NPV of this project points towards a decrease in overall value of the firm, hence showing a disagreement in the accept$/$reject decision between NPV and IRR.

e$.$ If you were comparing this project to another project and could only accept one of them, would it matter if you ranked the projects based upon their NPV or IRR? Explain in detail. $(5$ points$)$

I kind of touched on this in the previous question, but yes it would matter. When comparing this project to another project, you should prioritize NPV$.$ The NPV will provide you with a more absolute value of the projects for the firm, compared to IRR. It$$s not that the IRR is not valuable to consider when comparing projects, just that the NPV is the better whole$-$scope option to consider that doesn$$t carry the same limitations as IRR that I previously mentioned.

$2.$ The CFO of Bulldog is not sure that she is accurate in her estimates of the future cash flows and decides to conduct a scenario analysis.

a$.$ She has asked you to recalculate the NPV assuming that each future cash flow and the salvage value are $10\%$ higher than her initial estimate or $10\%$ lower. How is the estimate of NPV changed in each case $($case$1$all future cash flows and the salvage value increase by $10\%,$ case $2$ all cash future flows and the salvage value decrease by $10\%)?$ Assume that there is a $25\%$ probability of the increased cash flows, a $25\%$ probability of the decreased cash flows and a $50\%$ probability of the original estimate in problem $1.$ What is the expected NPV of the project? $(10$ points$)$

b$.$ Does the range of outcomes and expected NPV change how you would view the riskiness project and the likelihood that you would accept the project? Explain in detail and relate your answer to the issues associated with using NPV to evaluate a project $($how accurate are the projected future cash flows? What types of assumptions must be made to forecast the future cash flows used in the analysis? Does the basic NPV or the expected NPV provide better information upon which to base a decision? $(5$ points$)$