Business Finance Homework Help

PSDT 3013 Lipscomb Find Annual Sales Revenue for Staples Walmart & Intel Excel Task

 

The file Exponentialdata.xlsx (attached below) contains the annual sales revenue for Staples, Walmart, and Intel. Use this data to work through the first five problems for this chapter.

  1. For each company, fit an exponential-trend curve to its sales data.
  2. For which company does exponential growth have the best fit with its revenue growth?
  3. For which company does exponential growth have the worst fit with its revenue growth?
  4. For each company, estimate the annual percentage growth rate for revenues.
  5. For each company, use your trend curve to predict the 2003 revenues.