Question: Calculate the actual growth in sales for your company over each of the past three years and the average actual growth rate over the past three years.

This is the data set, I have looked in my textbook for definitions of words in the questions and I can't find the proper formulas to answer this. Any help is appreciated.

31-Dec-18 232,887,000 17.3,18.7,000 59,704,000 31-Dec-19 280,522,000 205,760,000 74,754,000 31-Dec-20 Assumptions Inputs 386,064,000 average of IGR&SGR 291,024,000 76% 94,240,000 30.7% 489 2012 504,708,010 242,259,845 262,448,165 2013 659,813,335 316,710,401 343,102,934 2014 862,585, 155 414,040,875 448,544,281 2015 1,127,672,193 541,787,652 586,389,540 2016 1,474,224,969 707,627,985 766,596,984 28,837,000 18,150,000 35,931,000 24,081,000 12,740,000 28 876.000 71% 0% 0% 25% 3% 09 126, 177,003 15,141,740 164,953,334 19,794,400 215,646,289 75,877,555 281,918,048 32, R20,166 368,556,242 44,726,749 Period Ending Total Revenue Cost of Revenue Gross Profit Operating Expenses Rescarch Development Selling General and Administrative Non Recurring Others Eamings Before Interest And Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Non-recurring Lvents Discontinued Operations Extraordinary Items Ellect or Accounting Changes Other Items Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares Dividend RE 296,000 12,421,000 1,417,000 11,261,000 1,197,000 201,000 14,541,000 1,600,000 13,976,000 2,374,000 3.5% -75,000 22,899,000 1.847,000 Int of Debt 24,178,000 2 363 000 IVALURI AVALUE! 121,129,922 #REF! #REFI #REFI (1,009 416 158,355,200 #REF! #REF! #REFI 1,319,527) 207,020,437 #REFI #REFI #REFI (1,725,170) 270,641,326 #REF! #REF! #REFI 12,255,344) 353,813,993 #REF! #REF! #REFI 12,948,450) 35% 0% 35% 0.20% U% 0% 0X 0% n% #VALUE! #VALUE! VALUFI -0.27% -U./0% 10,064,000 -300,000 9,764,000 8,980,000 778,000 11,602,000 -300,000 11,302,000 4,790,000 6,512,000 21,315,000 -1,031,000 20,284,000 0,108,000 13,826,000 HREF! (3,532,956) #REF! MRETI FREF! #REF! 14,618,693) HREF! HRET! HREF! #REF! (6,038,096) #REF! MRE HREF! #REF! 17.893,7051 #REF! MRETI HREFI #REF! (10,319,575) HREF! HREFI #REF! 32% 49% F 75,101,000 31,750,000 9,500,000 16,677,000 17,174,000 96,334,000 38,092,000 18,929,000 20,816,000 20,497,000 132,733,000 42.122.000 42 274,000 24.542.000 23.795,000 #REFI 55,765,517 32,084,173 31,107,607 #REFI 72,749,547 41,944,183 40,667,502 #REFI 94,453,057 54,814,141 53,165,314 #REFI 122,480,082 71,685,863 69,503,916 #REFI 161,427,604 93,716,143 90,863,64/ Balance Sheet Assets Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Assel Charges Total Assets 10.91% plugil-statement 10.95% 10.95% 6.36% 6.36% 6.16% 6.16% 0.00% 0.00% 0.00% 0.00% 39,03% 39.03% 15017000 1.29% 1.29% 0.00% 0.00% 1.81% 1.81% 0.00% 0.00% 61,797,000 14,548,000 4,110,000 97,346,000 14,754,000 4,049,000 196,969,523 15017000 6,511,746 257,501,595 15017000 8,512,916 336,636,199 15017000 11,129,079 440,090,208 15017000 14,549,233 575,337,388 1.5017000 19,020,459 150 687,000 15,017,000 Carry forward 4.981.000 0 7.092.000 0 310,490,000 17.797.000 12,265,000 9,271,192 12,120,778 15,815,699 20,715,351 27,081,529 173,353,000 225,248,000 #REF! #REF! #REF! #REF! HREFI 68,391,000 38,192,000 87,812,000 47,183,000 126,385,000 72,539,000 39,787,000 17,017,000 63,205,000 12, 171,000 84,389,000 8,535,000 2,386,000 32.74% 18.79% 18.79% 0.00% If-Statement 0.00% 8,535,000 21.86% 84,389,000 2.21% #REF! 0.62% 2,386,000 0.00% 0 #VALUE! 43.48% 94,831,464 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 123,974,780 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 162,074,331 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 211,882,520 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 276,997,609 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 94,996,000 122,559,000 167,849,000 #REF! #REF! #REF! #REF! #REF! 43,549,000 62,060,000 24.19% 43 Liabilities 44 Current Liabilities 45 Accounts Payable 46 Short/Current Long Term Debt 47 Other Current Liabilities 48 Long Term Debt 49 Other Liabilities 50 Deferred Long Term Liability Charges 51 Minority Interest 52 Negative Goodwill 53 Total Liabilities 54 55 Stockholders' Equity 56 Misc Stocks Options Warrants 57 Redeemable Preferred Stock 58 Preferred Stock 59 Common Stock 60 Retained Earnings 61 Treasury Stock 62 Capital Surplus 63 Other Stockholder Equity 64 Total Stockholder Equity 65 66 Total Liabs&E 67 68 b 69 ROA 70 ROE 71 IGR 72 SGR 73 HGR 74 Industry GR 75 D/E 76 5,000 52,551,000 1,837,000 5,000 31,220,000 1,837,000 93,404,000 carryforward carryforward carryforward 5,000 carryforward 19,625,000 PriorY+NewRE 1,837,000 carryforward carryforward 9,719,000 carryforward 31,186,000 5,000 19,625,000 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 9,719,000 22,464,000 76,857,000 19,035,000 52,097,000 9,719,000 #REF! 9,719,000 #REF! 9,719,000 #REF! 9,719,000 #REF! 9,719,000 #REF! 171,853,000 174,656,000 199,035,000 #REF! #REF! #REF! #REF! #REF! 7.97% 5.63% 12.70% 0.45% 1.02% 346,227,056 #REF! #REF! 448,013,519 #REF! #REF! 581,080,688 #REF! #REF! 755,041,653 #REF! #REF! 982,463,771 #REF! #REF! 57.62% 5.02% 21.69% 2.98% 14.29% 20.45% -2.00% 68.16% Trial Assets 6.53% Trial Liabs&E 0.6504 Trial Plug 4.7% MinCash 79.6% Plug 37.6% 1.0% #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 31-Dec-18 232,887,000 17.3,18.7,000 59,704,000 31-Dec-19 280,522,000 205,760,000 74,754,000 31-Dec-20 Assumptions Inputs 386,064,000 average of IGR&SGR 291,024,000 76% 94,240,000 30.7% 489 2012 504,708,010 242,259,845 262,448,165 2013 659,813,335 316,710,401 343,102,934 2014 862,585, 155 414,040,875 448,544,281 2015 1,127,672,193 541,787,652 586,389,540 2016 1,474,224,969 707,627,985 766,596,984 28,837,000 18,150,000 35,931,000 24,081,000 12,740,000 28 876.000 71% 0% 0% 25% 3% 09 126, 177,003 15,141,740 164,953,334 19,794,400 215,646,289 75,877,555 281,918,048 32, R20,166 368,556,242 44,726,749 Period Ending Total Revenue Cost of Revenue Gross Profit Operating Expenses Rescarch Development Selling General and Administrative Non Recurring Others Eamings Before Interest And Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Non-recurring Lvents Discontinued Operations Extraordinary Items Ellect or Accounting Changes Other Items Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares Dividend RE 296,000 12,421,000 1,417,000 11,261,000 1,197,000 201,000 14,541,000 1,600,000 13,976,000 2,374,000 3.5% -75,000 22,899,000 1.847,000 Int of Debt 24,178,000 2 363 000 IVALURI AVALUE! 121,129,922 #REF! #REFI #REFI (1,009 416 158,355,200 #REF! #REF! #REFI 1,319,527) 207,020,437 #REFI #REFI #REFI (1,725,170) 270,641,326 #REF! #REF! #REFI 12,255,344) 353,813,993 #REF! #REF! #REFI 12,948,450) 35% 0% 35% 0.20% U% 0% 0X 0% n% #VALUE! #VALUE! VALUFI -0.27% -U./0% 10,064,000 -300,000 9,764,000 8,980,000 778,000 11,602,000 -300,000 11,302,000 4,790,000 6,512,000 21,315,000 -1,031,000 20,284,000 0,108,000 13,826,000 HREF! (3,532,956) #REF! MRETI FREF! #REF! 14,618,693) HREF! HRET! HREF! #REF! (6,038,096) #REF! MRE HREF! #REF! 17.893,7051 #REF! MRETI HREFI #REF! (10,319,575) HREF! HREFI #REF! 32% 49% F 75,101,000 31,750,000 9,500,000 16,677,000 17,174,000 96,334,000 38,092,000 18,929,000 20,816,000 20,497,000 132,733,000 42.122.000 42 274,000 24.542.000 23.795,000 #REFI 55,765,517 32,084,173 31,107,607 #REFI 72,749,547 41,944,183 40,667,502 #REFI 94,453,057 54,814,141 53,165,314 #REFI 122,480,082 71,685,863 69,503,916 #REFI 161,427,604 93,716,143 90,863,64/ Balance Sheet Assets Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Assel Charges Total Assets 10.91% plugil-statement 10.95% 10.95% 6.36% 6.36% 6.16% 6.16% 0.00% 0.00% 0.00% 0.00% 39,03% 39.03% 15017000 1.29% 1.29% 0.00% 0.00% 1.81% 1.81% 0.00% 0.00% 61,797,000 14,548,000 4,110,000 97,346,000 14,754,000 4,049,000 196,969,523 15017000 6,511,746 257,501,595 15017000 8,512,916 336,636,199 15017000 11,129,079 440,090,208 15017000 14,549,233 575,337,388 1.5017000 19,020,459 150 687,000 15,017,000 Carry forward 4.981.000 0 7.092.000 0 310,490,000 17.797.000 12,265,000 9,271,192 12,120,778 15,815,699 20,715,351 27,081,529 173,353,000 225,248,000 #REF! #REF! #REF! #REF! HREFI 68,391,000 38,192,000 87,812,000 47,183,000 126,385,000 72,539,000 39,787,000 17,017,000 63,205,000 12, 171,000 84,389,000 8,535,000 2,386,000 32.74% 18.79% 18.79% 0.00% If-Statement 0.00% 8,535,000 21.86% 84,389,000 2.21% #REF! 0.62% 2,386,000 0.00% 0 #VALUE! 43.48% 94,831,464 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 123,974,780 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 162,074,331 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 211,882,520 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 276,997,609 #REF! 8,535,000 84,389,000 #REF! 2,386,000 0 94,996,000 122,559,000 167,849,000 #REF! #REF! #REF! #REF! #REF! 43,549,000 62,060,000 24.19% 43 Liabilities 44 Current Liabilities 45 Accounts Payable 46 Short/Current Long Term Debt 47 Other Current Liabilities 48 Long Term Debt 49 Other Liabilities 50 Deferred Long Term Liability Charges 51 Minority Interest 52 Negative Goodwill 53 Total Liabilities 54 55 Stockholders' Equity 56 Misc Stocks Options Warrants 57 Redeemable Preferred Stock 58 Preferred Stock 59 Common Stock 60 Retained Earnings 61 Treasury Stock 62 Capital Surplus 63 Other Stockholder Equity 64 Total Stockholder Equity 65 66 Total Liabs&E 67 68 b 69 ROA 70 ROE 71 IGR 72 SGR 73 HGR 74 Industry GR 75 D/E 76 5,000 52,551,000 1,837,000 5,000 31,220,000 1,837,000 93,404,000 carryforward carryforward carryforward 5,000 carryforward 19,625,000 PriorY+NewRE 1,837,000 carryforward carryforward 9,719,000 carryforward 31,186,000 5,000 19,625,000 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 5,000 #REF! 1,837,000 9,719,000 22,464,000 76,857,000 19,035,000 52,097,000 9,719,000 #REF! 9,719,000 #REF! 9,719,000 #REF! 9,719,000 #REF! 9,719,000 #REF! 171,853,000 174,656,000 199,035,000 #REF! #REF! #REF! #REF! #REF! 7.97% 5.63% 12.70% 0.45% 1.02% 346,227,056 #REF! #REF! 448,013,519 #REF! #REF! 581,080,688 #REF! #REF! 755,041,653 #REF! #REF! 982,463,771 #REF! #REF! 57.62% 5.02% 21.69% 2.98% 14.29% 20.45% -2.00% 68.16% Trial Assets 6.53% Trial Liabs&E 0.6504 Trial Plug 4.7% MinCash 79.6% Plug 37.6% 1.0% #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF