Can I have the following?

• Operating margins for all years and companies. Each value should be to 2 decimal places.
• Net income margins for all years and companies. Each value should be to 2 decimal places.
• CAGR for total revenue from 2012-2014. Each value should be to 2 decimal places.

Thank you! Can you show formula in cell!

Statement A Company Financials - Evaluating Industry Source: Financial Earning Reports Company A Period Ending 2013 2014 2015 Total Revenue Cost of Revenue Gross Profit $ $ $ 12,917,000 $ 8,288,000 $ 4,629,000 $ 14,194,000 $ 9,150,000 $ 5,044,000 $ 15,389,000 9,973,000 5,416,000 Operating Expenses Research & Development Selling General and Administrative $ 3,746,000 $ 4,110,000 $ 4,555,000 Operating Income or Loss $ 883,000 $ 934,000 $ 861,000 Total Other Income/Expenses Net Earnings Before Interest And Taxes $ $ 11,000 $ 894,000 $ 12,000 $ 946,000 $ 17,000 878,000 Interest Expense Income Before Tax Income Tax Expense $ $ $ $ 894,000 $ 343,000 $ $ 946,000 $ 367,000 $ 878,000 342,000 Net Income $ 551,000 $ 579,000 $ 536,000 Statement B Company Financials - Evaluating Industry Source: Financial Earning Reports Company B. Period Ending 2012 2013 2014 Total Revenue Cost of Revenue Gross Profit $ $ $ 14,072,000 $ 4,216,000 $ 9,856,000 $ 16,047,000 $ 5,036,000 $ 11,011,000 $ 17,902,000 5,732,000 12,170,000 Operating Expenses Research & Development Selling General and Administrative $ $ 1,573,000 $ 5,395,000 $ 1,768,000 $ 5,872,000 $ 2,000,000 6,656,000 Operating Income or Loss $ 2,888,000 $ 3,371,000 $ 3,514,000 Total Other Income/Expenses Net Earnings Before Interest And Taxes $ $ 196,000 $ 3,084,000 $ 95,000 $ 3,466,000 $ 17,000 3,531,000 Interest Expense Income Before Tax Income Tax Expense $ $ $ $ 3,084,000 $ 475,000 $ $ 3,466,000 $ 610,000 $ 3,531,000 3,485,000 Net Income $ 2,609,000 $ 2,856,000 $ 46,000 Statement C Company Financials - Evaluating Industry Source: Financial Earning Reports Company C Period Ending 2012 2013 2014 $ Total Revenue Cost of Revenue Gross Profit $ $ 182,795,000 $ 112,258,000 $ 70,537,000 $ 170,910,000 $ 106,606,000 $ 64,304,000 $ 156,508,000 87,846,000 68,662,000 Operating Expenses Research & Development Selling General and Administrative $ $ 6,041,000 $ 11,993,000 $ 4,475,000 $ 10,830,000 $ 3,381,000 10,040,000 Operating Income or Loss $ 52,503,000 $ 48,999,000 $ 55,241,000 Total Other Income/Expenses Net Earnings Before Interest And Taxes $ $ 980,000 $ 53,483,000 $ 1,156,000 $ 50,155,000 $ 522,000 55,763,000 Interest Expense Income Before Tax Income Tax Expense $ $ $ $ 53,483,000 $ 13,973,000 $ $ 50,155,000 $ 13,118,000 $ 55,763,000 14,030,000 Net Income $ 39,510,000 $ 37,037,000 $ 41,733,000