Module $9$ Exploring Financial Tools and Functions $|$ ExcelEX $9619.$ Project future income statements under this new business plan. In the Profit and Loss worksheet,in the range C$8$:E$8,$ project the company$$s revenue for the next five years by interpolating theYear $2$ through Year $4$ revenue assuming a growth trend. The costs of marketing and R&D as wellas gross profit will be calculated for you$\mathrm{.}10.$ In the range C$14$:F$14,$ extrapolate the Year $2$ through Year $5$ payroll expenses by assuming thepayroll will grow by $12\%$ per year. In C$15$:F$17,$ extrapolate the other expenses by assumingthey grow by $5\%$ per year from the initial Year $1$ values. The range C$18$:F$18$ automaticallycalculates the total expenses for Year $2$ through Year $5\mathrm{.}11.$ Calculate depreciation of the company$$s tangible assets. In the Startup Plan worksheet, in cellB$12,$ enter $350,000$ as current value of the long$-$term tangible assets$\mathrm{.}12.$ Asli estimates that the long$-$term tangible assets will depreciate to a salvage value of $$50,000$ in$15$ years. In the Depreciation worksheet, in the range B$10$:F$10,$ calculate the yearly straight$-$linedepreciation of the long$-$term assets using the SLN function with absolute references to the Cost,Salvage, and Life values in the range B$4$:B$6\mathrm{.}13.$ In the range B$16$:F$16,$ use the DB function to calculate the yearly declining balance of the assetsusing absolute references to the Cost, Salvage, and Life values in the range B$4$:B$6$ and relativereferences to the Period values in the cells B$15$ through F$15\mathrm{.}14.$ In the Profit and Loss worksheet, in the range B$22$:F$22,$ enter formulas to reference the decliningbalance depreciation values in the range B$16$:F$16$ of the Depreciation worksheet$\mathrm{.}15.$ In the range B$25$:F$25,$ enter formulas to reference the cumulative interest payments in the rangeB$56$:F$56$ of the Amortization Schedule worksheet. Enter the interest expenses as positive valuesby changing the sign of the interest value$\mathrm{.}16.$ In the range B$28$:F$28,$ use an IF function to calculate the company$$s taxes for each year. If thecompany$$s pretax profit in row $26$ is negative, set the tax to $0$; otherwise, multiply the assumedtax rate in cell F$5$ by the pretax profit$\mathrm{.}17.$ Calculate the value of the company to potential investors. In the Startup Plan worksheet, in cellB$30,$ enter $$250,000$ as the amount the company hopes to attract from investors$\mathrm{.}18.$ Calculate the rate of return if the investor group is paid $$55,000$ per year for the next five yearson the $$250,000$ investment. In the Investment worksheet, in cell B$9,$ use the RATE function tocalculate the interest of the proposed repayment schedule using the corresponding values in therange B$6$:B$8\mathrm{.}19.$ The company will also offer investors dividends on their investment. In cell B$13,$ enter $$0$ for theYear $1$ dividend. In cells C$13$ and D$13,$ enter $$6,000$ as the Year $2$ and Year $3$ dividends. In cellsE$13$ and F$13,$ enter $$25,000$ for the Year $4$ and Year $5$ dividends$\mathrm{.}20.$ In the range C$18$:C$23,$ calculate the payback period of the investment by calculating a runningtotal of the values in the range B$18$:B$23\mathrm{.}21.$ Determine the profitability of the investment to the investors:a$.$ In cell C$25,$ enter $12\%$ as the desired rate of return for the investors.b$.$ In cell C$26,$ use the NPV function to calculate the present value of the investment using thedesired rate of return in cell C$25$ and the payments in the range B$19$:B$23.$c$.$ In cell C$27,$ calculate the net present value by adding to the cost of the initial investment incell B$18$ to the present value in cell C$26.$d$.$ In cell C$28,$ use the IRR function to calculate the internal rate of return for this investmentusing the cash flow values in the range B$18$:B$23\mathrm{.}22.$ In the Profit and Loss worksheet, in the range B$31$:F$31,$ enter formulas to reference the yearlydividend values paid to the shareholders in the range B$13$:F$13$ of the Investment worksheet$\mathrm{.}23.$ An error is somewhere in the workbook. Starting with cell F$18$ in the Balance sheet, trace the#REF error in the workbook back to its source, and correct it