Revenue Costs of Goods Sold Gross Profit Gross Profit % Operating Costs Net Income Line Item...

Transcribed Image Text:

Revenue Costs of Goods Sold Gross Profit Gross Profit % Operating Costs Net Income Line Item Month Year Amount Net Income Over Year # of Instances Year Net Income Jan 2015 2,996,108 645,365 2,350,743 1% 76,882 2,273,861 Gross Profit Jan 2015 1,000,000 2015 2015 Feb 2015 1,470,673 817,695 652,978 0% 68,078 584,900 Mar 2015 1,486,196 385,156 1,101,040 1% 65,815 1,035,225 Apr 2015 2,126,028 514,522 1,611,506 1% 65,967 1,545,539 May 2015 1,097,092 342,483 754,609 1% 89,416 665,193 This cell should change based on the 3 criteria above it This cell should change based on the 2 criteria above it This cell should change based on the 1 criteria above it Jun 2015 1,426,073 432,654 993,419 1% 67,372 926,047 Jul 2015 1,552,407 347,550 1,204,857 1% 56,091 1,148,766 Aug Sep 2015 2015 1,900,139 2,199,992 723,103 907,615 1,177,036 1,292,377 1% 93,545 1,083,491 1% 96,648 1,195,729 Oct 2015 2,058,609 497,846 1,560,763 1% 60,162 1,500,601 Nov 2015 1,824,506 970,220 854,286 0% 55,347 798,939 Dec 2015 1,328,930 501,815 827,115 1% 80,547 746,568 Jan 2016 2,338,345 820,197 1,518,148 1% 61,701 1,456,447 Revenue Costs of Goods Sold Gross Profit Gross Profit % Operating Costs Net Income Line Item Month Year Amount Net Income Over Year # of Instances Year Net Income Jan 2015 2,996,108 645,365 2,350,743 1% 76,882 2,273,861 Gross Profit Jan 2015 1,000,000 2015 2015 Feb 2015 1,470,673 817,695 652,978 0% 68,078 584,900 Mar 2015 1,486,196 385,156 1,101,040 1% 65,815 1,035,225 Apr 2015 2,126,028 514,522 1,611,506 1% 65,967 1,545,539 May 2015 1,097,092 342,483 754,609 1% 89,416 665,193 This cell should change based on the 3 criteria above it This cell should change based on the 2 criteria above it This cell should change based on the 1 criteria above it Jun 2015 1,426,073 432,654 993,419 1% 67,372 926,047 Jul 2015 1,552,407 347,550 1,204,857 1% 56,091 1,148,766 Aug Sep 2015 2015 1,900,139 2,199,992 723,103 907,615 1,177,036 1,292,377 1% 93,545 1,083,491 1% 96,648 1,195,729 Oct 2015 2,058,609 497,846 1,560,763 1% 60,162 1,500,601 Nov 2015 1,824,506 970,220 854,286 0% 55,347 798,939 Dec 2015 1,328,930 501,815 827,115 1% 80,547 746,568 Jan 2016 2,338,345 820,197 1,518,148 1% 61,701 1,456,447 Revenue Costs of Goods Sold Gross Profit Gross Profit % Operating Costs Net Income Line Item Month Year Amount Net Income Over Year # of Instances Year Net Income Jan 2015 2,996,108 645,365 2,350,743 1% 76,882 2,273,861 Gross Profit Jan 2015 1,000,000 2015 2015 Feb 2015 1,470,673 817,695 652,978 0% 68,078 584,900 Mar 2015 1,486,196 385,156 1,101,040 1% 65,815 1,035,225 Apr 2015 2,126,028 514,522 1,611,506 1% 65,967 1,545,539 May 2015 1,097,092 342,483 754,609 1% 89,416 665,193 This cell should change based on the 3 criteria above it This cell should change based on the 2 criteria above it This cell should change based on the 1 criteria above it Jun 2015 1,426,073 432,654 993,419 1% 67,372 926,047 Jul 2015 1,552,407 347,550 1,204,857 1% 56,091 1,148,766 Aug Sep 2015 2015 1,900,139 2,199,992 723,103 907,615 1,177,036 1,292,377 1% 93,545 1,083,491 1% 96,648 1,195,729 Oct 2015 2,058,609 497,846 1,560,763 1% 60,162 1,500,601 Nov 2015 1,824,506 970,220 854,286 0% 55,347 798,939 Dec 2015 1,328,930 501,815 827,115 1% 80,547 746,568 Jan 2016 2,338,345 820,197 1,518,148 1% 61,701 1,456,447

Answer rating: 100% (QA)

Based on the information provided the correct answer for t... View the full answer