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 S values, no need to leave any decimals, e.g. Gross Profit = $34,000. E) Leave ratios and percentages in 2 decimal place, e.g. TIE = 2.81; ROA = 4.83%, etc. [1] [2] Common size Balance Sheet & Income Stat 2020 Yr 2021 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. 2020 2021 Big Apple Enterprises 2020 Yr 2021 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 9,000 18,500 26,000 62,000 70,000 100.00% 100.00% 1 LIABILITIES Current Liabilities Debt Equity TOTAL LIABILITIES & EQUITY 20,000 11,000 22,000 29,000 20,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 - SG&A 20,000 27,000 20,000 27,000 SG&A Operating Profit (EBIT) AA 2,800 3,450 Interest Expense Earnings Before Taxes (EBT) Taxes Net Income After Tax (NIAT) Other Information Tax Rate Shares Outstanding Dividends paid 2020 30% 2,000 3,000 Yr 2021 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 2021 data with the exception of question numbers 14, 17 and 18 (question 17 and 18 - is asking for the growth rate, hence, need to use the data from both years 2020 and 2021) Note - growth rate should equal to (P2 - P1)/P1 Yr 2021 [3] What was the company's Gross Profit in 2021? e.g. Gross Profit = Rev - COGS 35,000 [4] What was the company's Gross Margin ratio in 2021? Gross Margin = ... specify your formula used [5] What was the company's Operating Profit (EBIT) in 2021? EBIT = ... specify your formula used [6] What was the company's Pretax Income (EBT) Margin Ratio in 2021? EBT = ... specify your formula used [7] How much Income Tax did they pay in 2021? 8 9 [7] How much Income Tax did they pay in 2021? 0 Income Tax = ... specify your formula used 1 2 [8] What was the company's Net Income After Tax (NIAT) in 2021? 3 NIAT = ... specify your formula used 4. 5 [9] What was the company's Net Operating Profit After Tax (NOPAT) in 2021? 6 NOPAT = ... specify your formula used 7 8 [10] What was the company's Times Interest Earned (TIE) in 2021? 9 TIE = ... specify your formula used 0 1 [11] What was the company's Profit Margin ratio in 2021? 2 Profit Margin = ... specify your formula used 3 4 [12] What was the company's Return on Assets (ROA) in 202* 5 ROA = ... specify your formula used 6 7 [13] What was the company's Return on Equity (ROE) in 202* 8 ROE = ... specify your formula used 9 0 [14] What is the company's Current ratio in 2020? 1 Current Ratio = ... specify your formula used 2 3 [15] What was the company's Quick Ratio in 2021? 4. Quick Ratio = ... specify your formula used 5 [16] What was the company's Day's Sales Outstanding (DSO) in 2021? Assume 6 a day-count of 365 days per year. 7 DSO = ... specify your formula used 8 9 [17] What was the rate of the company's asset growth between 2020 and 2021? 00 Asset Growth = ... specify your formula used 1 2 [18] What was the rate of the company's sales' growth between 2020 and 2021? 3 Sales Growth = ... specify your formula used Ass. 1 G H 94 Quick Ratio = ... specify your formula used 95 What was the company's Day's Sales Outstanding (DSO) in 2021? Assume [16] 96 a day-count of 365 days per year. 97 DSO = ... specify your formula used 98 99 [17] What was the rate of the company's asset growth between 2020 and 2021? 100 Asset Growth = ... specify your formula used 101 102 [18] What was the rate of the company's sales' growth between 2020 and 2021? 103 Sales Growth = ... specify your formula used 104 105 106 [19] What was the company's Debt-to-Equity ratio in 2021? 107 Debt-to-Equity Ratio = ... specify your formula used Yr. 2021 108 109 [20] What was the company's Earnings Per Share (EPS) in 2021? 110 EPS = ... specify your formula used 111 112 [21] What was the company's Price-Earnings (P/E) ratio in 2021? 113 P/E Ratio = ... specify your formula used 114 115 [22] What was the company's Dividend Payout ratio (DPR) in 2021? 116 DPR = ... specify your formula used 117 118 [23] What were the Dividends Per Share paid in 2021? 119 Dividend Per Share = ... specify your formula used 120 121 [24] What was the Dividend Yield in 2021? 122 Dividend Yield = ... specify your formula used 123 124 125 [25] In one paragraph, please analyze the Statement of Income for 2021 as compared to 2020: 126 127 128 The denominator should only include 2020 data. 129