1.Choose a publicly-traded company in the U.S.Go tohttp://finance.yahoo.com(you can take Apple or...

Question

1.Choose a publicly-traded company in the U.S.Go tohttp://finance.yahoo.com(you can take Apple or Walmart )2. Then, copy into Excel the last 5 years of their revenues and compute the growth rate percentages.3. Project the growth rate percentages for the next 2 years.4. use these projected growth rates to project the revenues for the next 2 years.Upload this Excel file containing the steps above.

Sumit · Accepted Answer

Sheet1
	Company Chosen:	Apple Inc.
	Particulars	2017	2018	2019	2020	2021	2022 Projected	2023 Projected
	Revenue (in Billion U.S. Dollars) 	$   229.23	$   265.60	$   260.17	$   274.52	$   365.82	$   413.92	$   465.54
	Growth Rate %		15.9%	-2.0%	5.5%	33.3%	13.1%	12.5%

1.Choose a publicly-traded company in the U.S.Go tohttp://finance.yahoo.com(you can take Apple or Walmart )2. Then, copy into Excel the last 5 years of their revenues and compute the growth rate...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment