Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
How to solve this accounting problem on excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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