Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How would I solve each ratio for 2022? I uploaded all infromation needed to solve Woofs Interest Expense Woofs BOP 3 year accrual expense Total
How would I solve each ratio for 2022? I uploaded all infromation needed to solve
Woofs Interest Expense Woofs BOP 3 year accrual expense Total Woofs Other Income/Expense Other Expense HCl Performance Bonus Total Other Expense Total Other Income Net Profit \begin{tabular}{rr} 24,420 & 17,199 \\ 563 & 13,752 \\ \hline152,597 & 48,659 \end{tabular} \begin{tabular}{rr} & 15,497 \\ \cline { 2 - 2 } & 15,497 \\ \hline152,597 & 33,162 \\ \hline 505,971 & 545,871 \end{tabular} Net Ordinary Income Other Income Woofs Other Income/Expense Woofs Other Income/Expense Woofs Depreciation Woofs Amortization Woofs Interest Expense Woofs BOP 3 year accrual expense Total Woofs Other Income/Expense Other Expense HCl Performance Bonus Total Other Expense Total Other Income Net Profit 111,350.63 121,524.32 10,451.52 37,859.27 169,835.11 1/16/2023 7:18:42 PM Balance Sheet As of 12/31/2021 Woof's Leawood LLC - Leawood ASSETS Current Asset Woofs Bank Accounts Woofs UB\&T - Leawood Woofs CrossFirst - South Overland Park Woofs Cash on Hand Total Woofs Bank Accounts 869.81 84,492.00 Woofs Inventory Woofs Retail Inventory Leawood Inventory South OP inventory Total Woofs Retail Inventory Total Woofs Inventory Woofs Accounts Receivable Balance Sheet As of 12/31/2022 Woof's Leawood LLC - Leawood ASSETS Current Asset Woofs Bank Accounts Woofs UB\&T - Leawood Woofs CrossFirst - Leawood Woofs Cash on Hand Total Woofs Bank Accounts 37373,829 Woofs Inventory Woofs Retail Inventory Woofs Retail Inventory Total Woofs Retail Inventory Total Woofs Inventory Woofs Accounts Receivable Woofs Credit Card Receivable 169,835.11 58,484.48 56,79416,66237373,829 1,7221,7221,722 1. Based on Woof's financial statements for the Leawood location, calculate the following ratios for 2021 and 2022. - Current Ratio - Days Receivable - Days Inventory - Days Payables - Cash Collection Cycle - Debt Ratio - Operating Profit Margin - Total Asset Turnover - OROA Net Profit Margin - ROE Sales Woofs Income Woofs Night Stay Income Woofs Day Play Income Woofs Grooming Income Woofs Retail Income Woofs KC Dawgz Total Woofs Income Total Sales cogs Woofs Supplies Woofs Day \& Night Stay Supplies Woofs Grooming Supplies Woofs Retail COGS Total Woofs Supplies Woofs Payroll Woofs Team Member Wages Woofs Grooming Labor Woofs Call Center Wages Woofs Salaried Manager Wages Woofs Bonus Woofs Payroll Taxes Woofs PTO accrual expense Total Woofs Payroll Total cogs Gross Profit Operating Expense Woofs - Advertising Woofs In Store POP Woofs Advertising Woofs HCl Marketing Expense Woofs Store Level Advertising Total Woofs - Advertising Woofs Misc. Operating Expense Woofs Cash Over/Short Woofs Employee Development Woofs Dues and Subscriptions Woofs Fuel Woofs Meals \& Entertainment Woofs Office Supplies Woofs Pest Control Woofs Travel Woofs Uniforms Total Woofs Misc. Operating Expense Adjusted Income Adjusted Income Woofs Repairs \& Maintenance \begin{tabular}{rr} 1,084,984 & 775,645 \\ 697,900 & 485,700 \\ 191,808 & 145,652 \\ 4,998 & 4,413 \\ 241,943 & 272,849 \\ \hline 2,221,633 & 1,684,260 \\ \hline 2,221,633 & 1,684,260 \end{tabular} Woofs Night Stay Income Woofs Day Play Income Woofs Grooming Income Woofs Retail Income Woofs KC Dawgz Total Woofs Income Total Sales cogs Woofs Supplies Woofs Day \& Night Stay Supplies Woofs Grooming Supplies Woofs Retail COGS Total Woofs Supplies Woofs Payroll Woofs Team Member Wages Woofs Grooming Labor Woofs Call Center Wages Woofs Salaried Manager Wages Woofs Bonus Woofs Payroll Taxes Woofs Employee Benefits Woofs PTO accrual expense Total Woofs Payroll Total cogs Gross Profit Operating Expense Woofs - Advertising Woofs In Store POP Woofs Advertising Woofs HCl Marketing Expense Total Woofs - Advertising Woofs Misc. Operating Expense Woofs Cash Over/Short Woofs Employee Development Woofs Dues and Subscriptions Woofs Fuel Woofs Meals \& Entertainment Woofs Office Supplies Woofs Pest Control Woofs Travel Woofs Uniforms Total Woofs Misc. Operating Expense 1,386,0231,060,968 Adjusted Income Adjusted Income Woofs Repairs \& Maintenance 2020 420,758.83 366,373.14 100,446.25 9,145.40 149,235.001,045,958.621,045,958.62 16,493.323,315.012,076.7521,885.08244,216.1941,653.4621,970.0693,549.423,293.9931,762.341,126.14437,571.60459,456.68586,501.94 161.901,907.372,055.024,124.29 10,098.96 1,472.94 2,924.03 191.58 3,955.96 556.44 \begin{tabular}{rr} 6,862 & 1,520 \\ \hline 20,652 & 11,384 \end{tabular} 1,060,968 MaintenanceStep 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