Please show me how to get the right answer, I use 345000*(1+x%)^4=550000 to get the rate and calculate, but it wrong..
10. Pranjali also needs to calculate the income from insurance reimbursements in the years 2023-2025. 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 2023-2025 (cells D7:F7) using a Growth Trend interpolation. A B D E F G H K L M N O AWN - V Mount Moreland Hospital - Neighborhood Nurse Van Earnings Projections Projected Revenue Income Municipal grants Federal grants Insurance reimbursements Total Revenue 2022 2023 2024 2025 2026 $ 25,000 $ 28,750 $ 32,500 $ 36,250 $ 40,000 72,000 58,000 58,000 55,000 55,000 345,000 550,000 $ 442,000 $ 86,750 $ 90,500 $ 91,250 $ 645,000 $700,000 $600,000 $500,000 W $400,000 ncome $300,000 Expenses Supplies Pharmaceuticals Payroll Maintenance Insurance Advertising Total General Expenses $ 108,000 $ 110,000 $ 112,000 $ 115,000 $ 118,000 127,000 129,625 132,250 134,875 137,500 140,000 2,500 2,500 2,500 3,000 3,000 2,800 2,800 2,800 3,100 3,100 10,500 10,500 10,500 10,500 10,500 $ 390,800 $ 255,425 $ 260,050 $ 266,475 $ 272,100 $200,000 $100,000 $- 2022 2023 2024 2025 2026 1 2 3 4 5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Initial Earnings $ 51,200 $(168,675) $(169,550) $(175,225) $ 372,900 Revenue Trend $60,000 $50,000 $40,000 Revenue $30,000 $20,000 $10,000 $0 0 10 20 50 60 30 40 Months in Operation 10. Pranjali also needs to calculate the income from insurance reimbursements in the years 2023-2025. 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 2023-2025 (cells D7:F7) using a Growth Trend interpolation. A B D E F G H K L M N O AWN - V Mount Moreland Hospital - Neighborhood Nurse Van Earnings Projections Projected Revenue Income Municipal grants Federal grants Insurance reimbursements Total Revenue 2022 2023 2024 2025 2026 $ 25,000 $ 28,750 $ 32,500 $ 36,250 $ 40,000 72,000 58,000 58,000 55,000 55,000 345,000 550,000 $ 442,000 $ 86,750 $ 90,500 $ 91,250 $ 645,000 $700,000 $600,000 $500,000 W $400,000 ncome $300,000 Expenses Supplies Pharmaceuticals Payroll Maintenance Insurance Advertising Total General Expenses $ 108,000 $ 110,000 $ 112,000 $ 115,000 $ 118,000 127,000 129,625 132,250 134,875 137,500 140,000 2,500 2,500 2,500 3,000 3,000 2,800 2,800 2,800 3,100 3,100 10,500 10,500 10,500 10,500 10,500 $ 390,800 $ 255,425 $ 260,050 $ 266,475 $ 272,100 $200,000 $100,000 $- 2022 2023 2024 2025 2026 1 2 3 4 5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Initial Earnings $ 51,200 $(168,675) $(169,550) $(175,225) $ 372,900 Revenue Trend $60,000 $50,000 $40,000 Revenue $30,000 $20,000 $10,000 $0 0 10 20 50 60 30 40 Months in Operation
