Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Theory Perspectives From China

Authors: Xingyun Peng

1st Edition

1938134311, 1938134338, 9781938134319, 9781938134333

More Books

Students also viewed these Finance questions