G H A Calculate the total Current Assets, Total Asseto, Total Libes and Equity. Gross proft, Operating profit. Eaming before Taxos, TAXOS 7 Net Income after Ter on the Balance Sheet and Income statement below (rows highlighted in yellow) B) Calculate the percentage of each line item under Assets to the Total Assels, each in ltem under Liabilities and Equity to the total Liabilith Band Equity, and Cost of Goods Sold, SG&A and Interest Expense to Revenue (blue baxua) c) Calculate the value of the ratio of the questions isted below - Show your work by specifying the formula you used for each of these 9 cakulations 10 D) For 5 values, no need to leave any decimals, e.g. Gross Profit-$34,000. 11 E) Leave ratios and percentages in 2 decimal place, ... TIE - 2.81: ROA - 4.83%;ote. 12 13. Sugestion calculate the yellow subtotals before going on to 10) 121 14 answer individual questions (eg the current assets, etc.). These Common size 15 are intermediate numbers used in various ratios. Balance Sheet & 16 2016 2017 Income Stat 17 Big Apple Enterprises Yr 2016 Yr 2017 Yr 2016 Yr 2017 ASSETS 19 Cash 4.500 6,000 20 Accounts Receivable 21,000 21.000 21 Inventos 7,500 8.000 22 Current Assets 23 24 Other Non-current Assets 10,500 9,000 25 Net Foxed Assets 18.500 26.000 28 TOTAL ASSETS 62.000 70,000 100.00% 100.00% 27 LIABILITIES 29 Current Liabilities 20,000 11,000 30 Debt 22.000 29,000 31 Equity 20,000 30,000 32 TOTAL LIABILITES & EQUITY 100.00% 100.00% 34 INCOME STATEMENT 35 Revenue 125,000 145,000 100.00% 100.00% 30 Cost of Goods Sold COGS 85 000 10 000 Gross Pront 38 SGSA 20.000 27000 Operating Profit (EBIT) 41 42 Interest Expense 2 800 3.450 Earnings Before Taxes (EBT) 4 Taxes Net Income After Tax (NIAT 45 47 Other Information Yr 2016 Yr 2017 48 Tax Rate 30% 30% 49 Shares Outstanding 2.000 30 2.000 Dividends paid 3.000 3.000 51 52 Share Price 58.00 SS DO 53 37 40 4 For each of the calculations of abos below, show work by specifying the you to get shumeric answer question has been completed as an example) Note the following: - Write down the formula where the specify your formula sed ad enter your excelfonderin the row highlighted green Aquestions this assignment are related to 2017 datath the exception of best humber 17 and 18 (question 17 and 18 - I asking for the growth rate besco need to use the data from both years 2016 and 2017 Ass. 1 Rono TE A) Calculate the total Current Assets, Total Assets, Total Liabilities and Equity, Gross profit, Operating Proft, Earning before Taxes Taxes and Net Income after Tax on the Balance Sheet and Income statement below (rows highlighted in yellow) B) Calculate the percentage of each line item under Assets to the Total Assets, each line item under Liabilities and Equity to the total Liabilities and Equity, and Cost of Goods Sold, SG&A and Interest Expense to Revenue (blue boxes) C) Calculate the value of the ratio of the questions listed below - Show your work by specifying the formula you used for each of these calculations D) For S values, no need to leave any decimals, e.g. Gross Profit = $34,000 E) Leave ratios and percentages in 2 decimal place, e... TIE = 2.81; ROA = 4.83%, etc. (1) [2] Common size Balance Sheet & Income Stat Yr 2016 Yr 2017 Suggestion calculate the yellow subtotals before going on to answer individual questions (e.g. the current assets, etc.). These are intermediate numbers used in various ratios. 2016 2017 Big Apple Enterprises Yr 2016 Yr 2017 ASSETS Cash 4,500 6,000 Accounts Receivable 21,000 21,000 Inventory 7.500 8,000 Current Assets Other Non-current Assets Net Fixed Assets TOTAL ASSETS 10,500 18.500 62,000 9,000 26.000 70,000 100.00% 100.00% LIABILITIES Current Liabilities Debt Equity TOTAL LIABILITIES & EQUITY 20,000 22.000 20,000 11,000 29,000 30,000 100.00% 100.00% 100.00% 100.00% INCOME STATEMENT Revenue Cost of Goods Sold (COGS) Gross Profit 125.000 145,000 85,000 110,000 20.000 27.000 SG&A Operating Profit (EBIT) 2,800 3.450 Interest Expense Earnings Before Taxes (EBT) Taxes Net Income After Tax (NIAT) Other Information Tax Rate Shares Outstanding Dividends paid Yr 2016 30% 2.000 3,000 Yr 2017 30% 2,000 3,000 Share Price $8.00 $6.00 For each of the calculations or ratios below, show work by specifying the formula you used to get its numeric answer (question #3 has been completed as an example):- Note the following: - Write down the formula where it notes "specify your formula used" and enter your excel formula and answer in the row highlighted in green - All questions in this assignment are related to 2017 data with the exception of question number 17 and 18 (question 17 and 18 - is asking for the growth rate, hence need to use the data from both years 2016 and 2017) Note - growth rate should equal to (P2-P1)/P1