Question No 1: (10 Marks) Construct the following Statenient with complete information for the year 2010 ending December 31 in a spreadsheet. Particulars Sales Revenue 2018 (Amount in OMR 500,000 ?? Z? ?? Z? 25.000 ?? ?? ?? Custof goods sold (55% of Sales) Gross Profit Indirect Expenses (25% of Sales) Operating Profit Oder incomes Net Income Before Tax | Incuiue Tax (15% lax rale) Net Income After Tax for the current year Equity Share Capital Share premium Current year - 2018 Total Shareholders' funds Intangible assets Tangible assets Investments in Joint ventures Total Fixed Assets (6 times of Sales Revenue) Current Liabilities Current Assets Return on Shareholders' funds Current Ratio Return on Total Assets 1,000,000 870,000 ?? ?? 283,600 2,386,000 ?? ?? 423,750 400,000 ?? ?? Z? (10 Marks)