D7 A B 1 Xfx=GROWTH($D$7,$B$7:$B$9,$C$7:$C$9,B5) C E Mount Moreland Hospital - Neighborhood Nurse Van F G 2345 2 Earnings Projections 3 Income Municipal grants 67 6 Federal grants 7 Insurance reimbursements 8 9 0∞ Total Revenue 2025 $ 25,000 $ 72,000 2026 2027 2028 2029 $ 40,000 58,000 #VALUE! 58,000 55,000 55,000 345 AD $442,000 $ 58,000 $ 58,000 $ 55,000 $ 645,000 550,000 10 11 12 13 0123 Expenses Supplies Payroll Pharmaceuticals $ 108,000 $110,000 $112,000 $115,000 $ 118,000 127,000 140,000 129,625 132,250 134,875 137,500 0.000 D5 A B 1 2 사 ✓ ✓ fx =FORECAST($D$4, $B$4:$F$4, $B$5:$F$5) C E Mount Moreland Hospital - Neighborhood Nurse Van Earnings Projections F G 3. 4 5 Income Municipal grants 3. 7 Federal grants Insurance reimbursements moo-23 Total Revenue 2025 $ 25,000 $ 72,000 2026 2027 2028 2029 $ 40,000 58,000 58,000 55,000 55,000 345,000 $442,000 $ 58,000 $ 58,000 $ 55,000 $ 645,000 550,000 0 Expenses 1 Supplies 2 Pharmaceuticals 3 Payroll $ 108,000 $110,000 $112,000 $115,000 $ 118,000 137,500 127,000 140,000 129,625 132,250 134,875
D7 A B 1 Xfx=GROWTH($D$7,$B$7:$B$9,$C$7:$C$9,B5) C E Mount Moreland Hospital - Neighborhood Nurse Van F G 2345 2 Earnings Projections 3 Income Municipal grants 67 6 Federal grants 7 Insurance reimbursements 8 9 0∞ Total Revenue 2025 $ 25,000 $ 72,000 2026 2027 2028 2029 $ 40,000 58,000 #VALUE! 58,000 55,000 55,000 345 AD $442,000 $ 58,000 $ 58,000 $ 55,000 $ 645,000 550,000 10 11 12 13 0123 Expenses Supplies Payroll Pharmaceuticals $ 108,000 $110,000 $112,000 $115,000 $ 118,000 127,000 140,000 129,625 132,250 134,875 137,500 0.000 D5 A B 1 2 사 ✓ ✓ fx =FORECAST($D$4, $B$4:$F$4, $B$5:$F$5) C E Mount Moreland Hospital - Neighborhood Nurse Van Earnings Projections F G 3. 4 5 Income Municipal grants 3. 7 Federal grants Insurance reimbursements moo-23 Total Revenue 2025 $ 25,000 $ 72,000 2026 2027 2028 2029 $ 40,000 58,000 58,000 55,000 55,000 345,000 $442,000 $ 58,000 $ 58,000 $ 55,000 $ 645,000 550,000 0 Expenses 1 Supplies 2 Pharmaceuticals 3 Payroll $ 108,000 $110,000 $112,000 $115,000 $ 118,000 137,500 127,000 140,000 129,625 132,250 134,875
Chapter19: Pricing Concepts
Section: Chapter Questions
Problem 6DRQ
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.
Transcribed Image Text:D7
A
B
1
Xfx=GROWTH($D$7,$B$7:$B$9,$C$7:$C$9,B5)
C
E
Mount Moreland Hospital - Neighborhood Nurse Van
F
G
2345
2
Earnings Projections
3
Income
Municipal grants
67
6
Federal grants
7
Insurance reimbursements
8
9
0∞
Total Revenue
2025
$ 25,000 $
72,000
2026
2027
2028
2029
$ 40,000
58,000
#VALUE!
58,000
55,000
55,000
345 AD
$442,000
$ 58,000 $ 58,000 $ 55,000 $ 645,000
550,000
10
11
12
13
0123
Expenses
Supplies
Payroll
Pharmaceuticals
$ 108,000 $110,000 $112,000 $115,000 $ 118,000
127,000
140,000
129,625
132,250
134,875
137,500
0.000
Transcribed Image Text:D5
A
B
1
2
사
✓ ✓ fx =FORECAST($D$4, $B$4:$F$4, $B$5:$F$5)
C
E
Mount Moreland Hospital - Neighborhood Nurse Van
Earnings Projections
F
G
3.
4
5
Income
Municipal grants
3.
7
Federal grants
Insurance reimbursements
moo-23
Total Revenue
2025
$ 25,000 $
72,000
2026
2027
2028
2029
$ 40,000
58,000
58,000
55,000
55,000
345,000
$442,000 $ 58,000 $ 58,000 $ 55,000 $ 645,000
550,000
0
Expenses
1
Supplies
2
Pharmaceuticals
3
Payroll
$ 108,000 $110,000 $112,000 $115,000 $ 118,000
137,500
127,000
140,000
129,625
132,250
134,875
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Foundations of Business - Standalone book (MindTa…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning