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 $2025,$ and estimates it will be $$40,000$ in $2029.$ She needs to calculate the

income from municipal grants in the years $2026-2028.$ The grants should increase at a

constant amount from year to year.

Project the income from Municipal grants for $2026-2028($cells D$5$:F$5)$ using a Linear

Trend interpolation.

Pranjali also needs to calculate the income from insurance reimbursements in the years

$2026-2028.$ She knows the starting amount and has estimated the amount in $2029.$ She

thinks this income will increase by a constant percentage.

Project the income from Insurance reimbursements for $2026-2028($cells D$7$:F$7)$ using a

Growth Trend interpolation.

Pranjali needs to calculate the payroll expenses in the years $2026-2029.$ She knows the

payroll will be $$140,000$ in $2025$ and will increase by at least five percent per year.

Project the payroll expenses as follows:

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

Trend extrapolation.

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