90.2K

Verified Solution

Link Copied!

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.g. TIE=2.81;ROA=4.83%; etc. 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. \begin{tabular}{|l|r|r|} \hline Big Apple Enterprises & 2020 & \multicolumn{1}{c|}{2021} \\ \hline ASSETS & 2020 & Yr 2021 \\ \hline Cash & 4,500 & 6,500 \\ \hline Accounts Receivable & 21,000 & 21,500 \\ \hline Inventory & 7,500 & 8,000 \\ \hline Current Assets & & \\ \hline \hline & 10,500 & 8,000 \\ \hline Other Non-current Assets & 18,500 & 26,000 \\ \hline Net Fixed Assets & 62,000 & 70,000 \\ \hline TOTAL ASSETS & & \\ \hline & & \\ \hline LIABILITIES & 20,000 & 12,000 \\ \hline Current Liabilities & 22,000 & 28,000 \\ \hline Debt & 20,000 & 30,000 \\ \hline Equity & & \\ \hline TOTAL LIABILITIES \& EQUITY & & \\ \hline & 125,000 & 155,000 \\ \hline INCOME STATEMENT & 85,000 & 110,000 \\ \hline Revenue & & \\ \hline Cost of Goods Sold (COGS) & & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{1}{|c|}{[1]} & {[2]} \\ \hline \multicolumn{2}{|c|}{ Common size } \\ Balance Sheet \& \\ \hline \multicolumn{2}{|c|}{ Income Stat } \\ \hline 2020 & Yr 2021 \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline 100.00% & 100.00% \\ \hline & \\ \hline & \\ \hline & \\ \hline 100.00% & 100.00% \\ \hline & \\ \hline 100.00% & 100.00% \\ \hline \end{tabular} 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 he row highlighted in green - All questions in this assignment are related to 2021 data with the exception of question numbers 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 [3] What was the company's Gross Profit in 2021? e.g.GrossProfit=RevCOGS Yr 2021 [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=specifyyourformulaused [6] What was the company's Pretax Income (EBT) Margin Ratio in 2021? EBT=specifyyourformulaused [7] How much Income Tax did they pay in 2021? Income Tax= specify your formula used [8] What was the company's Net Income After Tax (NIAT) in 2021? NIAT=...specifyyourformulaused [9] What was the company's Net Operating Profit After Tax (NOPAT) in 2021? NOPAT=...specifyyourformulaused [10] What was the company's Times Interest Earned (TIE) in 2021? TIE=specifyyourformulaused [11] What was the company's Profit Margin ratio in 2021? ProfitMargin=specifyyourformulaused [12] What was the company's Return on Assets (ROA) in 2021? ROA=specifyyourformulaused [13] What was the company's Return on Equity (ROE) in 2021? ROE=specifyyourformulaused [13] What was the company's Return on Equity (ROE) in 2021? ROE=specifyyourformulaused [14] What is the company's Current ratio in 2021? Current Ratio = specify your formula used [15] What was the company's Quick Ratio in 2021? Quick Ratio = specify your formula used [16] What was the company's Day's Sales Outstanding (DSO) in 2021? Assume a daycount of 365 days per year. DSO=specifyyourformulaused [17] What was the rate of the company's asset growth between 2020 and 2021? AssetGrowth=specifyyourformulaused [18] What was the rate of the company's sales' growth between 2020 and 2021? SalesGrowth=specifyyourformulaused [19] What was the company's Debt-to-Equity ratio in 2021? Debt-to-EquityRatio=specifyyourformulaused [20] What was the company's Earnings Per Share (EPS) in 2021? EPS=specifyyourformulaused [21] What was the company's Price-Earnings (P/E) ratio in 2021? P/ERatio=specifyyourformulaused [22] What was the company's Dividend Payout ratio (DPR) in 2021? DPR=specifyyourformulaused [23] What were the Dividends Per Share paid in 2021? Dividend Per Share = specify your formula used [16] What was the company's Day's Sales Outstanding (DSO) in 2021? Assume a daycount of 365 days per year. DSO=specifyyourformulaused [17] What was the rate of the company's asset growth between 2020 and 2021 ? Asset Growth =... specify your formula used [18] What was the rate of the company's sales' growth between 2020 and 2021 ? Sales Growth =... specify your formula used [19] What was the company's Debt-to-Equity ratio in 2021? Yr. 2021 Debt-to-Equity Ratio = ... specify your formula used [20] What was the company's Earnings Per Share (EPS) in 2021? EPS=specifyyourformulaused [21] What was the company's Price-Earnings (P/E) ratio in 2021? P/ERatio=specifyyourformulaused [22] What was the company's Dividend Payout ratio (DPR) in 2021? DPR=specifyyourformulaused [23] What were the Dividends Per Share paid in 2021? DividendPerShare=...specifyyourformulaused [24] What was the Dividend Yield in 2021? DividendYield=...specifyyourformulaused [25] In one paragraph, please analyze the Statement of Income for 2021 as compared to 2020

Answer & Explanation Solved by verified expert

See Answer