Question

K A B C D E F. G H . J 209 210 Below is Challenge Homework 211 212 A Financial Statement Example of Formulas 213 Below is data from an Income Statement. 214 We have highlighted cells for you to calculate totals, ratios, and growth rates using the formulas and definitions you have been taught. 215 Format the results as specified. 216 217 2018 2019 Format 218 Revenues 10,251 10,529 219 Year Over Year Revenues Growth Percent one decimal points 220 Cost of Revenues 7,325 7,563 221 Gross Profit (Revenues - Cost of Revenues) Comma after thousands, no decimal point 222 Gross Margin (Gross Profit / Revenues) Percent no decimal points 223 Remember to force the calculation for the reformatting to change incorrect cells to red.

Please write answers using an Excel Formula

Answer must be an Excel Formula

Thank You

Answer 1

Solution:
	Calculation of Revenue Growth, Gross Profit & Gross Margin
		2018	2019	Remarks
	Revenues	10,251	10,529
	Year over year Revenue Growth		102.7%	(10,529/10,251) X 100
	Cost of Revenue	7,325	7,563
	Gross Profit (Revenues - Cost of Revenue)	2,926	2,966
	Gross Margin (Gross Profit / Revenue )	29%	28%