4 Chapter Five: Spreadsheets Applications in Financial Statements Analysis 2 3 14 5 Student Name Student ID EX4 Amman Company Statement of Profit or Loss For the Year Ended December 31, 2018 7 Sales 8 Sales Returns 9 Sales Discounts Net Sales 10 11 Beginning Inventory 12 Purchases 13 Purchases Returns 14 Purchases Discounts 15 Purchases Expenses 16 17 Ending Inventory 18 Cost of Net Purchases Cost of Goods Sold 19 Grass Profit / Loss 20 Advertising Expenses 21 Salaries Expenses A Sumasative Expenses 23 Total Operating Expenses 24 Profit/Loss Before Tax 25 Tax (40%) 26 BANG Profit/Loss 100000 ??? ??? ??? 10000 ??? ??? ??? ??? ??? ITE 10000 ??? ??? ??? 4500 1200 ??? ??? ??? ??? (Figure 5-23) Financial Ratio Gross Profil Marjan 164 Operating Income Margin Income (Profit) Margin Any entory Turnover of the following financial ratios: a Gross Profit Margin. 277 b. Operating Income Margin. e Income (Profit) Margin. & Inventory Turnover. 169 777 Required: 1. Create a new worksheet "Chapter5 EX4", and enter the previous EX4", data in it. ??? 2. Insert necessary equations or functions in the related cells to calculate sales returns (2% of sales), sales discounts (5% of sales), net sales, purchases (50% of sales), purchases returns (2% of purchases), purchases discounts (6% of purchases), purchases expenses (1% of purchases), cost of net purchases, cost of goods sold, gross profit/loss, advertising expenses (3% of sales), total operating expenses, profit/loss before tax, tax (40%), and profit/loss. 3. Insert necessary equations in the related cells to calculate each 227