Pranjali needs to calculate the payroll expenses in the years $2023-2026.$ 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.

The Projected Revenue line chart in the range H$4$:Q$19$ shows the revenue Pranjali

estimates in the years $2022-2026.$ 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.

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