Question

Focused Revenue Investment( FRI)

Quarterly Schedule Revenue

For the year December 31, 2018

	QTR1	QTR2	QTR3	QTR4	2018
sales	280,000	310,000	320,000	500,000
interest	102,500	175,000	180,000	54,000
investment income	13,000	9500	10,000	12,000
other	16,000	26,000	19,500	29,000
total

Provide the relevant formulas to complete the worksheet.

Answer 1

Answer is given below

for formulas Excel screenshot is given

Focused Revenue Investment( FRI) Quarterly Schedule Revenue For the year December 31, 2018 | QTR1QTR2QTR3 sales 280,000 310,000 320,000 interest 102,500 175,000 180,000 investment income 13,000 9,500 10,000 other 16,000 26,000 19,500 total 411,500 520,500 529,500 QTR4 500,000 54,000 12,000 29,000 595,000 2018 1,410,000 511,500 44,500 90,500 2,056,500

A B | C D E F G C Focused Revenue Investment( FRI) Quarterly Schedule Revenue For the year December 31, 2018 sales interest investment income other total | QTR1L QTR2T 280000 310000 102500 175000 13000 9500 16000 26000 =SUM(C8:C11) =SUM(D8:011) CTR3 320000 180000 10000 19500 =SUM(E8:E11) QTR4 500000 54000 12000 29000 =SUM(F8:F11) 2018 =SUM(C8:F8) =SUM(C9:F9) =SUM(C10:F10) =SUM(C11:F11) =SUM(C12:F12)