G H M N 5 Question No 1: (10 Marks) Construct the following Statement with complete information for the year 2018 ending December 31 in a spreadsheet Particulars 2018 (Amount in OMR) 500,000 7? 72 ?? 72 25,000 7? Sales Reveme Cost of goods sold (55% of Sales) Gross Profit Indirect Expenses (25% of Sales) Operating Profit Other incomes Net Income Belore Tax Income Tax (15% tax rate) Net Income Alter Tax for the current year EquityShare Capital Share prenium Current year 2018 Total Shareholders' funds Intangible assets Tangible assets Investments in Joint ventures Total Dixed Assets (6 times of Sales Revenue) Current Liabilities Current Assets 7? 77 1,000,000 870,000 22 ?? 283,600 2,386,000 ?? ?? 423,750 100,000 Return on Surelsolders lands Eu rrent Ratio 72 ?? 727 Return On Totad Asses (10 Marks)