Question
1 Florida Home Health is a small home care agency owned by a group practice of nurses and physical therapists in Tampa, Florida. During the
1 Florida Home Health is a small home care agency owned by a group practice of nurses and physical therapists in Tampa, Florida. During the past few years, the company reported the following revenues:
Year | Revenue (thousands) |
1 | $2058 |
2 | $2534 |
3 | $2472 |
4 | $2850 |
5 | $3000 |
6 | ? |
Use Excel's FORECAST function to predict Florida Home Health's Year 6 revenue: 3,243
=FORECAST(Forecast year,cells containing known revenue,cells containing respective know years)
2. Continuing with the previous problem, forecast Florida Home Health's Year 6 revenue using the average annual growth rate.
r=(FV/PV)1/t -1
Answer to the nearest dollar. Do not include the dollar sign in your answer.
**Need help with question number 2 only please.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started