You are looking at forecasts prepared by your business development unit.

You suspect that these numbers are inflated, not deflated. Your estimate of the inflation rate is $2\mathrm{.}5\%.$

a$.$ What are the deflated numbers corresponding to the above numbers?

b$.$ If the appropriate deflated discount rate is $11\%,$ what is the present value of those expected cash

flows? Use all deflated numbers for your calculations.

c$.$ Now use inflated numbers to

calculate the present value.

solve this for me with

complete explaintion and tell me how should I make an

spreadsheet in excel because I should give it to my professor as a spreadsheet excel not Ai$.$