Instructions A) Calculate the total Current Assets, Total Assets, Total Liabilities and Equity, Gross profit. Operating Profit. 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 $ 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. Suggestion calculate the yellow subtotals before going on to answer [1] [2] individual questions (e.g. the current assets, etc.). These are Common size intermediate numbers used in various ratios. Balance Sheet & 2016 2017 Income Stat Big Apple Enterprises Yr 2016 Yr 2017 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 85,000 145,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 formule you used to get its numerican question has been completed as an example Note the following: - Write down the formula where it notes specify your formula sed and enter your excel formula and answer in the row highlighted in green All questions in this migment 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 2015 and 2017) Note growth rate should equal to 1P2.P1/P1 Y 2017 p] What was the company's Gross Profitin 2017? og Gross Polrev.COGS 35,000 (4) What was the company's Gross Margin ratio in 2017? Gross Marginely your formula sed Is What was the company's Operating Profit (EBIT) in 2017? EST pecity your formulad 18) What was the company's Pretax income (EBT) in 2017? EBT.... specify you formule ved How much Income Tax did they pay in 2017? Income Tax ...pely your formule used What was the company's Net Income After Tax (NAT) in 2017? NIAT..Spealy your formula used 1) What was the company's Net Operating Profit After Tax (NOPAT) in 2017? NOPTecly pour formulated 110 What was the company's Times Interest Eamed (IE) in 2017? TE ... specify your formula sed [11] What was the company Profit Margin ratio in 20177 Proft Mergin specify your formula sed 1121 What was the company's Return on Asset (ROA) in 2017? ROA...pecaly your formulated 113) What was the company's Return on Equity (ROE) in 2017? ROE...Spealy your formula used 114) What is the company's Current rutie in 2017? Current Ratispecify your formula od (15) What was the company's Quick Ratie in 2017? Quick Ratio pecly your formulased 1141 Court of 345 days per year. What was the company's Day's Sales Outstanding (DSO) in 2017? Assume a day DSC_.peally your formula used 117) What was the rate of the company's asset growth between 2016 and 2017? Asset Growth specify your formula used [18] What was the rate of the company's sales' growth between 2016 and 2017? Sales Growth...pecify your formula sed Yr 2017 119 What was the company's Debt-to-Equity ratie in 2017? Debt-to-Eaty Ratio pecly your med 120 What was the company's Earnings Per Share (EPS) in 2017? EPS ... specify your formula used 124) What was the company's Price-Earnings (PE) ratio in 2017? PE Roto...pecify your formulased 122) What was the company's Dividend Payout ratio (DPR) in 2017? DPR ... specify your formula 122) What were the Dividends Per Share paid in 2017? Dividend Per Sharewely your formulased 124) What was the Dividend Vield in 2017? Dividend Yield ... pecity your med [25] In one paragraph, please analyze the Statement of income for 2017 compared to 2018: The denominator should only include 2017 data
