Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete 3 key financial ratio calculations based on your latest financial statements from the Biz Caf simulation: Return on Assets; Inventory Turnover Ratio; and, Current
Complete 3 key financial ratio calculations based on your latest financial statements from the Biz Caf simulation: Return on Assets; Inventory Turnover Ratio; and, Current Ratio. Provide commentary understanding of what the ratio measures, reflection on your figures, trends, future impact, etc. How do your figures compare with Starbucks or another publicly traded caf?
Checkbook ? = Date Account Payment Deposit Balance COGS Adv./Promo. COGS $770.00 $1,400.00 $561.00 $1,200.00 $900.00 Description Beginning Balance 110 lb. Bulk Coffee Online Ad Baked Goods 20000 Small Cups w/Logo 10000 Large Cups w/Logo Monday Receipts Tuesday Receipts Wednesday Receipts Utilities Thursday Receipts Manager Pay Staff Pay Friday Receipts Purchase 5 lb. Coffee Saturday Receipts Sunday Receipts Feb 5 Feb 5 Feb 5 Feb 5 Feb 5 Feb 6 Feb 7 Feb 8 Feb 8 Feb 9 Feb 9 Feb 9 Feb 10 Feb 11 Feb 12 Feb 12 $3,066.75 $3,035.25 $3,146.00 Inventory Inventory Revenue Revenue Revenue Utilities Revenue Management Staff Revenue $22,478.79 $21,708.79 $20,308.79 $19,747.79 $18,547.79 $17,647.79 $20,714.54 $23,749.79 $26,895.79 $26,345.79 $29,379.04 $27,235.69 $24,348.19 $27,477.94 $27,437.94 $30,008.94 $32,274.69 $550.00 $3,033.25 $2,143.35 $2,887.50 $3,129.75 $40.00 COGS Revenue $2,571.00 $2,265.75 Revenue Daily Receipts and Customer Traffic ? E Date Cups Served Daily Capacity 688 Avg. Price $4.68 $4.69 688 688 Feb 5 Feb 6 Feb 7 Feb 8 Feb 9 Feb 10 Feb 11 Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday 581 573 598 573 Receipts $3,066.75 $3,035.25 $3,146.00 $3,033.25 $3,129.75 $2,571.00 $2,265.75 688 688 $4.67 $4.69 $4.68 $4.68 $4.69 593 688 486 439 688 Total 4,816 3,843 $4.68 $20,247.75 Units Unit Price Weekly Totals Small Coffee Medium Coffee Large Coffee Baked Goods 1,377 1,590 876 1,122 $4.25 $4.75 $5.25 $2.00 Receipts $5,852.25 $7,552.50 $4,599.00 $2,244.00 Total $20,247.75 Income Statement for February, Month to Date Previous Month ? = February to Date $33,285.15 $1,963.79 $31,321.36 % of Rev. 100% 6% Revenue COGS Gross Margin Year to Date $90,881.75 $6,685,46 $84,196.29 % of Rev. 100% 7% 93% 94% 17% 23% 16% 20% 23% 4% Management Staff Adv./Promo. Rent Utilities Depreciation Expense Interest on Loan Other Total Expenses $5,583.67 $7,500.81 $1,400.00 $2,000.00 $550.00 $0.00 $0.00 $(0.00) $17,034.48 $14,717.42 $17,982.71 $21,000.00 $4,000.00 $550.00 $233.33 $208.33 $1,141.00 $59,832.79 4% 1% 6% 2% 0% 0% -0% 51% 0% 0% 1% 66% Net Income $14,286.88 43% $24,363.50 27% Balance Sheet for February, Month to Date Previous Month ? = Assets Cash Liabilities Taxes Payable Loans Total Liabilities $3,042.90 $25,000.00 $28,042.90 Deposits Equipment Accumulated Depreciation Inventory Prepaid Exp. $32,274.69 $2,500.00 $14,000.00 $(233.33) $2,306.04 $1,559.00 Equity Retained Earnings Total Equity Total Liab. & Eq. $24,363.50 $24,363.50 Total Assets $52,406.40 $52,406.40 Cash Flow Statement for February, Month to Date Previous Month ? = Cash Flow From Operations Net Income Depreciation Increase (Decrease) in Payables Decrease (Increase) in Inventory Decrease (Increase) in Deposits Decrease (Increase) in Prepaid Expenses Net Cash From Operations $14,286.88 $0.00 $3,042.90 $(1.587.21). $0.00 $0.00 $15,742.57 Investment Activities Furniture and Equipment Net Investment $0.00 $0.00 Financing Activities Increase (Decrease) in Short-Term Debt Net Financing $0.00 $0.00 Net Increase (Decrease) in Cash $15,742.57 Weekly Purchases Save Undo ? E Perishable Wasted Sold Emergency Next Week's Purchases Coffee O lb. 115 lb. 5 lb. 115 lb. Organic ($7.00/lb.) Non-Perishable Inventory Sold Emergency Next Week's Purchases Small Cups 18,623 cups 1,377 cups 0 cups None Medium Cups 1,590 cups 0 cups None 5,250 cups 9,124 cups Large Cups 876 cups 0 cups None Coffee Calculator Estimated Cup Sales Coffee per Cup Coffee Required Small 1,377
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