50.1K

Verified Solution

Link Copied!

How to solve this accounting problem on excel

Calculate each item as a percentage of total revenue for both 2022 and 2021 2022%amt.2021%amt 27 Sales and other revenue: \begin{tabular}{|l|l|r|r|} \hline 28 & Net sales & $3,600 & 97.96% \\ \hline 29 & Other revenue & 75 & 2.04% \\ \hline 30 & Total & 3675 & 100.00% \\ \hline 31 & Costs and other charges: & & \\ \hline 32 & Cost of Goods Sold & 1000 & \\ \hline 33 & Depreciation and amortization & 150 & \\ \hline 34 & Selling and administrative exp.s & 225 & \\ \hline 35 & Interest expense & 50 & \\ \hline 36 & Income taxes & 100 & \\ \hline 37 & Total & 1525 & \\ \hline 38 & Net income for the year & 2150 & \\ \hline 39 & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline$1,350 & \\ \hline 50 & \\ \hline 1400 & \\ \hline \end{tabular} 49 Balance Sheet Items: Surfboard Souls Inc. \begin{tabular}{|c|l} \hline 41 & \\ \hline 42 & \\ \hline 43 & \\ \hline 44 & Current Assets \\ \hline 45 & \end{tabular} Partial Balance. Sheet Accounts (000,000 omitted) 2022 \begin{tabular}{r|l|r|} \hline 45 & Cash and Cash Equivalents & 200 \\ \hline 46 & Accounts Receivable, net & 1450 \\ \hline 47 & Inventories & 125 \\ \hline \end{tabular} Ratio Analysis: Please find the "Ratio Formula Sheet" in your "Resources" section in Laulima then using the 2022 Income Statement and the 2022 Balance Sheet, calculate the following ratios. After doing this analysis, answer this question: Is the company Surfboard Souls, Inc. doing well? Give three reasons why or why not you believe your decision based upon the work you did above. Yes or No

Answer & Explanation Solved by verified expert

See Answer