Based on the following information, create a balance sheet (in excel or sheets) at the end...

  

Transcribed Image Text:

Based on the following information, create a balance sheet (in excel or sheets) at the end of each Quarter. Create an annual income statement (in excel or sheets) (i.e. after Q4). Q1 1. Investor puts $1,500 cash into business for 50% equity 2. Buy $200 of inventory 3. Pay utilities of $250 4. Buy equipment for $150. Will pay in Q2. T1 Assets Cash; Accounts Receivable Inventory: Current/short-term Scooter; 1300 200 1500 Equipment! Goodwill: Total Long-Term 1500 1500 Total Assets 3000 Liabilities Payables Current Liabilities Loan! Long-Term Liabilities Total Liabilities 100 25 75 2000 3000 Revenue Expenses Retained Earnings! Owners Equity Equity Based on the following information, create a balance sheet (in excel or sheets) at the end of each Quarter. Create an annual income statement (in excel or sheets) (i.e. after Q4). Q1 1. Investor puts $1,500 cash into business for 50% equity 2. Buy $200 of inventory 3. Pay utilities of $250 4. Buy equipment for $150. Will pay in Q2. T1 Assets Cash; Accounts Receivable Inventory: Current/short-term Scooter; 1300 200 1500 Equipment! Goodwill: Total Long-Term 1500 1500 Total Assets 3000 Liabilities Payables Current Liabilities Loan! Long-Term Liabilities Total Liabilities 100 25 75 2000 3000 Revenue Expenses Retained Earnings! Owners Equity Equity

Answer rating: 100% (QA)

Balance sheet as on quarter Assets Cash Account Receivable Inventory Current Short t... View the full answer