Q2 5. Sell $100 in coffee mugs (COGS is 20% of revenue). Customer (Tim) will pay in Q3. 6. Obtain bank loan for $750 7. Pay bill for equipment of $150 8. Buy $75 in advertising from Facebook Assets 900 1400 700 1650 100 150 175 200 0 200 1075 12 Assets Cash Accounts Receivable inventory Current/short-term Scooter Equipment Goodwill Total Long-Term Total Assets 1900 1600 900 Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Auto Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Auets 300 1000 300 1000 2000 300 1000 1000 1000 1300 1300 3300 2075 1200 2900 4200 2 Assets Cash 4 Accounts Receivable Inventory 6 Current/short-term 7 Scooter Equipment Goodwill 10 Total Long Term 11 Total Assets 12 13 abilities | 14 Parables 15 Current Utilities 16 Loan 17 Long Term Labilities 18 Total abilities 19 20 Revenue tenses Hetained ternings 23 Owners Equity 24 pity 300 0 0 0 300 0 0 Liabilities Payables Current Utilities LOM Long Term Liabilities Total abilities Liabilities Payables Current sites Loan Long Term Uabilities Total abilities 750 750 750 Liabilities Payables Current abilities Loan Long Term Usbilities To Uobilis 2200 200 U 750 o 1050 750 2200 100 25 75 2000 2075 Revenue bxpenses Metained ning Owners County Equity 200 50 150 2000 2150 Revenue Expenses Hetained turning Owners Equity Equity 200 50 150 2000 2150 Reven penses Metained terning Owners Equity Equity 200 200 O 2000 2000 + 27 26 19 Credit Debit Credit Debit 500 100 2000 Cash Revenue mentory Expenses 100 25 Cash Scooter Inventory Expenses 25 16 Basic Premium Cost $ $ Price 0.155 0.20 $ 3.00 3.50 Units Sold 25000 25000 Net Profit margin Break Even 499 $ 69,333.33 2 Basic S 3 Premium $ 4 Sales S 5 COGS-Basic S 6 COGS-Premium $ 7 Total COGS S 8 Gross Profit 5 9 Gross Profit Margin 10 Rent 11 Marketing 12 Manager Salaries 13 Utilities 14 Total Operating $ 15 EBITDAS 16 Depreciation 17 EBITS 18 Taxes 19 Net Profit 20 21 22 23 24 75,000.00 87,500.00 162,500.00 3,750.00 5,000.00 8,750.00 153,750.00 95% 12,000.00 10,000.00 40,000.00 3,600.00 65,600.00 88,150.00 500.00 87,650.00 8,765.00 78,885.00 Q2 5. Sell $100 in coffee mugs (COGS is 20% of revenue). Customer (Tim) will pay in Q3. 6. Obtain bank loan for $750 7. Pay bill for equipment of $150 8. Buy $75 in advertising from Facebook Assets 900 1400 700 1650 100 150 175 200 0 200 1075 12 Assets Cash Accounts Receivable inventory Current/short-term Scooter Equipment Goodwill Total Long-Term Total Assets 1900 1600 900 Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Auto Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Auets 300 1000 300 1000 2000 300 1000 1000 1000 1300 1300 3300 2075 1200 2900 4200 2 Assets Cash 4 Accounts Receivable Inventory 6 Current/short-term 7 Scooter Equipment Goodwill 10 Total Long Term 11 Total Assets 12 13 abilities | 14 Parables 15 Current Utilities 16 Loan 17 Long Term Labilities 18 Total abilities 19 20 Revenue tenses Hetained ternings 23 Owners Equity 24 pity 300 0 0 0 300 0 0 Liabilities Payables Current Utilities LOM Long Term Liabilities Total abilities Liabilities Payables Current sites Loan Long Term Uabilities Total abilities 750 750 750 Liabilities Payables Current abilities Loan Long Term Usbilities To Uobilis 2200 200 U 750 o 1050 750 2200 100 25 75 2000 2075 Revenue bxpenses Metained ning Owners County Equity 200 50 150 2000 2150 Revenue Expenses Hetained turning Owners Equity Equity 200 50 150 2000 2150 Reven penses Metained terning Owners Equity Equity 200 200 O 2000 2000 + 27 26 19 Credit Debit Credit Debit 500 100 2000 Cash Revenue mentory Expenses 100 25 Cash Scooter Inventory Expenses 25 16 Basic Premium Cost $ $ Price 0.155 0.20 $ 3.00 3.50 Units Sold 25000 25000 Net Profit margin Break Even 499 $ 69,333.33 2 Basic S 3 Premium $ 4 Sales S 5 COGS-Basic S 6 COGS-Premium $ 7 Total COGS S 8 Gross Profit 5 9 Gross Profit Margin 10 Rent 11 Marketing 12 Manager Salaries 13 Utilities 14 Total Operating $ 15 EBITDAS 16 Depreciation 17 EBITS 18 Taxes 19 Net Profit 20 21 22 23 24 75,000.00 87,500.00 162,500.00 3,750.00 5,000.00 8,750.00 153,750.00 95% 12,000.00 10,000.00 40,000.00 3,600.00 65,600.00 88,150.00 500.00 87,650.00 8,765.00 78,885.00
