Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the financial ratio analysis (below) based on the information above.. begin{tabular}{|c|c|c|c|} hline multicolumn{4}{|l|}{ Loco Coyote, Inc. } hline multicolumn{4}{|l|}{ Balance Sheet }
I need the financial ratio analysis (below) based on the information above..
\begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ Loco Coyote, Inc. } \\ \hline \multicolumn{4}{|l|}{ Balance Sheet } \\ \hline & & & \\ \hline ASSEIS & 2021 & 2020 & 2019 \\ \hline \multicolumn{4}{|l|}{ Current Assets } \\ \hline Cash & 512,032 & 442,899 & 382,644 \\ \hline Accounts receivable & 341,977 & 308,564 & 246,599 \\ \hline Inventory & 525,477 & 515,427 & 317,103 \\ \hline Prepaid expenses & 256,911 & 235,722 & 139,116 \\ \hline Total Current Assets & 1,636,398 & 1,502,613 & 1,085,462 \\ \hline Property, Plant \& Equipment & 780,519 & 750,242 & 719,235 \\ \hline Accumulated depreciation & (222,650) & (200,779) & (178,908) \\ \hline Total Assets & 2,194,268 & 2,052,076 & 1,625,788 \\ \hline & & & \\ \hline \multicolumn{4}{|l|}{ LIABILITIES } \\ \hline \multicolumn{4}{|l|}{ Current Liabilities } \\ \hline Accounts payable & 253,464 & 374,201 & 328,599 \\ \hline Accrued liabilities & 124,636 & 220,864 & 219,783 \\ \hline Income taxes payable & 10,858 & 26,212 & 22,796 \\ \hline Current portion of long-term debt & 43,044 & 43,044 & 43,044 \\ \hline Total Current Liabilities & 432,002 & 664,321 & 614,223 \\ \hline \multicolumn{4}{|l|}{ Long-Term Liabilities } \\ \hline Long-term debt & 433,817 & 408,317 & 382,602 \\ \hline Total liabilities & 865,819 & 1,072,638 & 996,825 \\ \hline \multicolumn{4}{|l|}{ STOCKHOLDER'S EQUITY } \\ \hline Common stock & 377,526 & 363,893 & 327,258 \\ \hline Additional paid-in-captial & 30,137 & 25,379 & 22,348 \\ \hline Retained earnings & 920,786 & 590,166 & 279,358 \\ \hline Total Stockholder's Equity & 1,328,449 & 979,438 & 628,964 \\ \hline TOTAL LIABILITIES \& STOCKHOLDER'S EQUITY & 2,194,268 & 2,052,076 & 1,625,788 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|l|}{ Loco Coyote, Inc. } \\ \hline \multirow[t]{2}{*}{ Ratio Analysis } & \multirow[b]{2}{*}{2021} & \multirow[b]{2}{*}{2020} & \multirow[b]{2}{*}{2019} & \multicolumn{2}{|c|}{2019 to 2020} & \multicolumn{2}{|c|}{2020 to 2021} \\ \hline & & & & Change & % Change & Change & % Change \\ \hline \multicolumn{8}{|l|}{ Liquidity Ratios } \\ \hline \multicolumn{8}{|l|}{ Current ratio } \\ \hline \multicolumn{8}{|l|}{ Quick ratio } \\ \hline \multicolumn{8}{|l|}{ Accounts receivable turnover } \\ \hline \multicolumn{8}{|l|}{ Days' sales in accounts receivable } \\ \hline \multicolumn{8}{|l|}{ Inventory turnover } \\ \hline \multicolumn{8}{|l|}{ Profitability/Performance Ratios } \\ \hline \multicolumn{8}{|l|}{ Profit margin } \\ \hline \multicolumn{8}{|l|}{ Gross profit margin \% } \\ \hline \multicolumn{8}{|l|}{ Earnings per share } \\ \hline \multicolumn{8}{|l|}{ Sales/Total assets } \\ \hline \multicolumn{8}{|l|}{ Sales/Working capital } \\ \hline \multicolumn{8}{|l|}{ Equity Position Ratios } \\ \hline \multicolumn{8}{|l|}{ Owners' equity/Total assets } \\ \hline \multicolumn{8}{|l|}{ Current liabilities/Owner's equity } \\ \hline Total liabilities/Owner's equity & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ Loco Coyote, Inc. } \\ \hline \multicolumn{4}{|l|}{ Income Statement } \\ \hline & 2021 & 2020 & 2019 \\ \hline Sales & 1,603,577 & 1,441,853 & 1,181,585 \\ \hline Cost of good sold & 613,239 & 567,855 & 510,716 \\ \hline Gross profit & 990,337 & 873,997 & 670,869 \\ \hline & & & \\ \hline \multicolumn{4}{|l|}{ Expenses } \\ \hline Advertising & 56,256 & 51,542 & 42,993 \\ \hline Depreciation & 21,871 & 21,871 & 21,871 \\ \hline Bad debts & 20,554 & 19,313 & 18,302 \\ \hline Legal & 17,606 & 10,411 & 9,895 \\ \hline Miscellaneous & 92,834 & 31,838 & 29,686 \\ \hline Rent & 151,287 & 144,920 & 143,966 \\ \hline Repairs and maintenance & 14,601 & 13,915 & 12,171 \\ \hline Salaries and wages & 48,063 & 46,218 & 39,925 \\ \hline Utilities & 16,230 & 15,956 & 14,501 \\ \hline Total Expenses & 439,304 & 355,983 & 333,309 \\ \hline Net income before income tax & 551,034 & 518,014 & 337,560 \\ \hline Income tax expense & 220,414 & 207,206 & 135,024 \\ \hline NET INCOME & 330,620 & 310,808 & 202,536 \\ \hline Number of shares of stock outstanding & 36,272 & 27,054 & 23,949 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started