$9.$ Go to the Earnings Projections worksheet. Pranjali has entered most of the income and expense data on the worksheet. She knows the income from municipal grants will be $$25,000$ in $2022,$ and estimates it will be $$40,000$ in $2026.$ She needs to calculate the income from municipal grants in the years $20232025.$ The grants should increase at a constant amount from year to year.

Project the income from Municipal grants for $20232025($cells D$5$:F$5)$ using a Linear Trend interpolation.

$10.$ Pranjali also needs to calculate the income from insurance reimbursements in the years $20232025.$ She knows the starting amount and has estimated the amount in $2026.$ She thinks this income will increase by a constant percentage.

Project the income from Insurance reimbursements for $20232025($cells D$7$:F$7)$ using a Growth Trend interpolation.

$11.$ Pranjali needs to calculate the payroll expenses in the years $20232026.$ She knows the payroll will be $$140,000$ in $2022$ and will increase by at least five percent per year.

Project the payroll expenses as follows:

a$.$ Project the expenses for Payroll for $2023-2026($cells D$13$:G$13)$ using a Growth Trend extrapolation.

b$.$ Use $1\mathrm{.}05($a $5$ percent increase$)$ as the step value.

$12.$ The Projected Revenue line chart in the range H$4$:Q$19$ shows the revenue Pranjali estimates in the years $20222026.$ She wants to extend the projection into $2027.$

Modify the Projected Revenue line chart as follows to forecast the future trend:

a$.$ Add a Linear Trendline to the Projected Revenue line chart.

b$.$ Format the trendline to forecast $1$ period forward.

$13.$ The Revenue Trend scatter chart in the range A$21$:G$40$ is based on monthly revenue estimates listed on the Monthly Revenue Projections worksheet. Pranjali wants to include a trendline for this chart that shows how revenues increase quickly at first and then level off in later months.

Modify the Revenue Trend scatter chart as follows to include a logarithmic trendline:

a$.$ Add a Trendline to the Revenue Trend scatter chart.

b$.$ Format the trendline to use the Logarithmic option.

$14.$ Go to the Investment worksheet. This worksheet should show the returns potential investors could realize if they invested $$165,000$ in the Neighborhood Nurse program. Pranjali figures a desirable rate of return would be $7\mathrm{.}3$ percent. She estimates the investment would pay different amounts each year $($range C$7$:C$12)$ and wants to calculate the present value of the investment.

Calculate the present value of the investment as follows:

a$.$ In cell C$15,$ enter a formula that uses the NPV function to calculate the present value of the investment in a medical van for the Neighborhood Nurse program.

b$.$ Use the desired rate of return value $($cell C$14)$ as the rate argument.

c$.$ Use the payments in Years $16($range C$7$:C$12)$ as the returns paid to investors. $($Hint: If a Formula Omits Adjacent Cell error warning appears, ignore it$.)$

$15.$ Pranjali also wants to calculate the internal rate of return on the investment. If it is $7$ percent or higher, she is confident she can attract investors.

Calculate the internal rate of return on the investment as follows:

a$.$ In cell C$17,$ enter a formula that uses the IRR function to calculate the internal rate of return for investing in a medical van for the Neighborhood Nurse program.

b$.$ Use the payments for startup and Years $16($range C$6$:C$12)$ as the returns paid to investors.