1. 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 D5:F5) using a Linear Trend interpolation.

Mount Moreland Hospital - Neighborhood Nurse Van