Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need the formulas for the yellow and blue cells Column D E F G Row 2 3 4 5 Ann Growth 6 7 8

i need the formulas for the yellow and blue cells image text in transcribed
Column D E F G Row 2 3 4 5 Ann Growth 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 B LANCE Inc. Uxk Q1. Year Sales 1997 $486,854 1998 $486,432 1999 $531,274 2000 $553,421 2001 S556,759 2002 S542,810 2003 $562,781 2004 S564,734 2005 $651,437 2006 $730, 116 2007 $762,736 2008 $852,468 2009 $918,163 2010 $979,835 2011 $1,635,036 2012 $1,618,634 2013 $1.761,049 Ec6/05-1 c7/c6- c8/c7-1 =c9/c8-1 c10/c9-1 el 1/c10-1 c12/c11-1 c13/c12-1 c14/c13-1 cl5/c14-1 "c16/015-1 c17/016-1 c18/17-1 *c19/c18-1 c20/c19-1 021/c20-1 A/Ps $5,821 $9,231 $15,597 $14,718 $10.776 $11.976 $12,059 $16,346 $20,378 $18,194 $21,169 $25,939 $29.777 $39.938 $52,930 $52,753 $54,510 Sales Growth 2014 Projected A/PS Intercept Slope Sales Put Output in Cell A25. Column D E F G Row 2 3 4 5 Ann Growth 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 B LANCE Inc. Uxk Q1. Year Sales 1997 $486,854 1998 $486,432 1999 $531,274 2000 $553,421 2001 S556,759 2002 S542,810 2003 $562,781 2004 S564,734 2005 $651,437 2006 $730, 116 2007 $762,736 2008 $852,468 2009 $918,163 2010 $979,835 2011 $1,635,036 2012 $1,618,634 2013 $1.761,049 Ec6/05-1 c7/c6- c8/c7-1 =c9/c8-1 c10/c9-1 el 1/c10-1 c12/c11-1 c13/c12-1 c14/c13-1 cl5/c14-1 "c16/015-1 c17/016-1 c18/17-1 *c19/c18-1 c20/c19-1 021/c20-1 A/Ps $5,821 $9,231 $15,597 $14,718 $10.776 $11.976 $12,059 $16,346 $20,378 $18,194 $21,169 $25,939 $29.777 $39.938 $52,930 $52,753 $54,510 Sales Growth 2014 Projected A/PS Intercept Slope Sales Put Output in Cell A25

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

Quantitative Corporate Finance

Authors: John B. Guerard Jr. Anureet Saxena, Mustafa Gultekin

2nd Edition

3030435466, 978-3030435462

More Books

Students also viewed these Finance questions