Can somone let me know what is wrong with my formulas?Go to the Earnings Projections 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 D5:F5) 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 D7:F7) using a Growth Trend interpolation. D7AB1Xfx=GROWTH($D$7,$B$7:$B$9,$C$7:$C$9,B5)CEMount Moreland Hospital - Neighborhood Nurse VanFG23452Earnings Projections3IncomeMunicipal grants676Federal grants7Insurance reimbursements890∞Total Revenue2025$ 25,000 $72,0002026202720282029$ 40,00058,000#VALUE!58,00055,00055,000345 AD$442,000$ 58,000 $ 58,000 $ 55,000 $ 645,000550,000101112130123ExpensesSuppliesPayrollPharmaceuticals$ 108,000 $110,000 $112,000 $115,000 $ 118,000127,000140,000129,625132,250134,875137,5000.000 D5AB12사✓ ✓ fx =FORECAST($D$4, $B$4:$F$4, $B$5:$F$5)CEMount Moreland Hospital - Neighborhood Nurse VanEarnings ProjectionsFG3.45IncomeMunicipal grants3.7Federal grantsInsurance reimbursementsmoo-23Total Revenue2025$ 25,000 $72,0002026202720282029$ 40,00058,00058,00055,00055,000345,000$442,000 $ 58,000 $ 58,000 $ 55,000 $ 645,000550,0000Expenses1Supplies2Pharmaceuticals3Payroll$ 108,000 $110,000 $112,000 $115,000 $ 118,000137,500127,000140,000129,625132,250134,875

2. Growth Trend Interpolation for Insurance Reimbursements (Cells D7 ): For a growth trend (constant…

Answered: D7 A B 1…

12th Edition

ISBN:9781259929434

Author:William Nickels

Publisher:William Nickels

Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment

Section: Chapter Questions

Problem 1CE

Related questions

Question

Can somone let me know what is wrong with my formulas?

Go to the Earnings Projections 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 D5:F5) 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 D7:F7) using a Growth Trend interpolation.