Instructions A) Calculate the total Current Assets, Total Assets, Total Liabilities and Equity, Gross proft, Operating Profit, Earning before Taxes, Taves 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, 6.9. TIE281; ROA = 4.83%; etc. [0] [21 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 33,000 35,000 7.26% 33.87% 12.10% 53.23% 8.57% 30.00% 11.43% 50.00% Other Non-current Assets Net Fixed Assets TOTAL ASSETS 10,500 18.500 62,000 9,000 26.000 70,000 16.94% 29.84% 100.00% 12.86% 37.14% 100.00% LIABILITIES Current Liabilities Debt Equity TOTAL LIABILITIES & EQUITY 20.000 22.000 20.000 62,000 11,000 29,000 30.000 70,000 32.26% 35.48% 32.26% 100.00% 15.71% 41.43% 42.86% 100.00% INCOME STATEMENT Revenue Cost of Goods Sold (COGS) Gross Profit 125,000 145,000 85,000 110,000 40,000 35,000 100.00% 68.00% 100.00% 75.86% 16.00% 18.62% SG&A Operating Profit (EBIT) 20,000 20,000 27,000 8,000 2.24% 2.38% Interest Expense Earnings Before Taxes (EBT) Taxes Net Income After Tax (NIAT) 2.800 17,200 5,160 12,040 3,450 4,550 1.365 3,185 Other Information Tax Rate Shares Outstanding Dividends paid Yr 2016 Yr 2017 30% 30% 2,000 2,000 3,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 Yr 2017 35,000 [3] What was the company's Gross Profit in 2017? eg. Gross Profit = Rev - COGS [4] What was the company's Gross Margin ratio in 2017? Gross Margin = ... specify your formula used [5] What was the company's Operating Profit (EBIT) in 2017? EBIT = ... specify your formula used [6] What was the company's Pretax Income (EBT) in 2017? EBT = ... specify your formula used [7] How much Income Tax did they pay in 2017? Income Tax = ... specify your formula used [8] What was the company's Net Income After Tax (NIAT) in 2017? NIAT = ... specify your formula used [9] What was the company's Net Operating Profit After Tax (NOPAT) in 2017? NOPAT = ... specify your formula used [10] What was the company's Times Interest Earned (TIE) in 2017? TIE = ... specify your formula used [11] What was the company's Profit Margin ratio in 2017? Profit Margin=... specify your formula used [12] What was the company's Return on Assets (ROA) in 2017? ROA -... specify your formula used [13] What was the company's Return on Equity (ROE) in 2017? ROE - ... specify your formula used [14] What is the company's Current ratio in 2017? Current Ratio = ... specify your formula used [15] What was the company's Quick Ratio in 2017? Quick Ratio = ... specify your formula used What was the company's Day's Sales Outstanding (DSO) in 2017? [16] Assume a day- count of 365 days per year. DSO = ... specify your formula used [17] 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 ... specify your formula used Yr. 2017 [19] What was the company's Debt-to-Equity ratio in 2017? Debt-to-Equity Ratio = ... specify your formula used [20] What was the company's Earnings Per Share (EPS) in 2017? EPS = ... specify your formula used [21] What was the company's Price-Earnings (P/E) ratio in 2017? P/E Ratio = ... specify your formula used [22] What was the company's Dividend Payout ratio (DPR) in 2017? DPR = ... specify your formula used [23] What were the Dividends Per Share paid in 2017? Dividend Per Share = ... specify your formula used [24] What was the Dividend Yield in 2017? Dividend Yield = ... specify your formula used [25] In one paragraph, please analyze the Statement of Income for 2017 as compared to 2016: The denominator should only include 2017 data
