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 ? Use Excel's FORECAST function to predict Florida Home Health's Year 6 revenue: =FORECAST(Forecast year cells containing known revenue.cells containing respective know years) Answer to the nearest dollar. Do not include the dollar sign in your answer. (Note: the FORECAST functions is a linear regression solution to the problem.) Problem 1b: Continuing with the previous problem, forecast Florida Home Health's Year 6 revenue using the average annual growth rate. r=(FV/PV)¹/t -1 Answer to the nearest dollar. Do not include the dollar sign in your answer.

Q&A Education