Question

Revenue Quarterly (Please show clearly what formulas were used in excel)

In excel using the correct method/formula provide the correct values for each revenue item 2018

complete the formulas in cells provided for revenues for 2019. 2019 revenues have increased by 3/4 % over 2018 values

Focused Revenue Investment (FRI)
Quarterly Schedule of Revenue
For the year December 31, 2018
	QTR1	QTR2	QTR3	QTR4	2018
Sales	280,000	310,000	320,000	500,000	1,410,000
Interest	102,500	175,000	180,000	54,000	511,500
Investment Income	13,000	9,500	10,000	12,000	44,500
Other	16,000	26,000	19,500	29,000	90,500
Total	411,500	520,500	529,500	595,000	2,056,500

Focused Revenue Investment (FRI)
COMPARITIVE INCOME STATEMENT
for years ended 31 December
			2018		2019
Revenues and gains
*Sales revenue
*Interest revenue
*Investment Income
*Other revenue
Total revenue and gains

Answer 1

Jautions Comparative Income statement for yr ended 31.12.19. Revenues & eping Note 2 1410, wwwx1.75 Sales Revenue gufterest Revenue Inpeltment gncome other Revenue 14.10,000 S,1,Suo 44,500 5,11,510 x 175 246750 18,95, 125 _77,815 158,375 qua O -05 90, 500 quswX1.95 2056500. 35,98875 Total can use this formula in Excel. votek) it is mentioned in question that 2019 Revenue have increased by 3ly to over_2018_Valueslif_ 0.75:1 increased over 2013 value - In other words it can say that 2018 Revenu's 15 times a 2018 Revenue.