Only Balance sheet is needed
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. 12 900 1400 1650 100 150 700 0 200 175 200 1075 1900 1600 900 Ansets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Assets Assets 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 Assets 300 1000 300 1000 2000 300 1000 3000 1000 1300 2075 1200 2900 4200 1 2 Assets Cash 4 Accounts Receivable 5 Inventory 6. Current/short-term 7 Scooter 8 Equipment Goodwill 10 Total Long Term 11 Total Arts 12 13 tiabilities | 14 Parables 15 Current Utilities 16 Loan 17 Long Term Labilities 18 Total abilities 19 20 Reverse 21 thepenses 22 Hetained ternings 23 Owners Equity 24 Fully Liabilities Payables Current Utilities 300 0 0 0 300 0 O Liabilities Payables Current Unities Loan Long Term Ubilities Total abilities Lo 750 750 750 750 Liabilities Payables Current Liabilities Loan Long Term Ubilities Total Webilitas 2200 200 0 Long Term Liabilities Total Liabilities o 1050 750 2200 100 25 75 2000 2075 Revenue bendes Hetained turnings Owners Equity Equity 200 50 150 2000 2150 Revenue Expenses Hetained turning Owners Equity Futy 200 50 150 2000 2150 Revenue penses Metained tarnings Owners Equity Equity 200 200 0 2000 2000 + = E F & S & & Credit Debit Credit Debit 500 100 2000 Cash Revenue mentory Expenses 100 25 Cash Scor Inventory Expenses 25 11 900 1650 100 150 175 1075 12 Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipruent Good Total Long Term Total Assets Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Assets 1900 900 1000 2000 1000 1300 2075 3200 Liabilities Payables Current abilities 300 300 Liabilities Payables Current abilities Loan Long Term Liabilities Total abilities Loan 750 750 0 Long Term Liabilities Total Usbilities 1050 1 2. Revenue Expenses Metained Earnings Owners Equity Equity 100 25 75 2000 2075 Revenue Expenses retained ning Owners Equity Equity 200 50 150 2000 2150 5 Credit Debit 100 100 Cash Revenue Inventory Expenses 25 25 14 13 1000 0 200 200 0 200 1600 900 Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long-Term Total Assets Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Assets 300 1000 2000 300 1000 1300 3300 2900 4200 0 . Liabilities Payables Current Liabilities Loan Long Term Liabilities Total Liabilities 750 750 Liabilities Payables Current Liabilities Loan Long-Term Liabilities Total abilities 2200 2200 750 2200 200 200 Revenge Expenses Retained Earnings Owners Equity Equity 200 50 150 2000 2250 Revenue Expenses Retained Earnings Owners Equity Epily + b000 2000 Credit Debit 500 2000 Cash Scooter Inventory Expenses 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. 12 900 1400 1650 100 150 700 0 200 175 200 1075 1900 1600 900 Ansets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Assets Assets 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 Assets 300 1000 300 1000 2000 300 1000 3000 1000 1300 2075 1200 2900 4200 1 2 Assets Cash 4 Accounts Receivable 5 Inventory 6. Current/short-term 7 Scooter 8 Equipment Goodwill 10 Total Long Term 11 Total Arts 12 13 tiabilities | 14 Parables 15 Current Utilities 16 Loan 17 Long Term Labilities 18 Total abilities 19 20 Reverse 21 thepenses 22 Hetained ternings 23 Owners Equity 24 Fully Liabilities Payables Current Utilities 300 0 0 0 300 0 O Liabilities Payables Current Unities Loan Long Term Ubilities Total abilities Lo 750 750 750 750 Liabilities Payables Current Liabilities Loan Long Term Ubilities Total Webilitas 2200 200 0 Long Term Liabilities Total Liabilities o 1050 750 2200 100 25 75 2000 2075 Revenue bendes Hetained turnings Owners Equity Equity 200 50 150 2000 2150 Revenue Expenses Hetained turning Owners Equity Futy 200 50 150 2000 2150 Revenue penses Metained tarnings Owners Equity Equity 200 200 0 2000 2000 + = E F & S & & Credit Debit Credit Debit 500 100 2000 Cash Revenue mentory Expenses 100 25 Cash Scor Inventory Expenses 25 11 900 1650 100 150 175 1075 12 Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipruent Good Total Long Term Total Assets Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Assets 1900 900 1000 2000 1000 1300 2075 3200 Liabilities Payables Current abilities 300 300 Liabilities Payables Current abilities Loan Long Term Liabilities Total abilities Loan 750 750 0 Long Term Liabilities Total Usbilities 1050 1 2. Revenue Expenses Metained Earnings Owners Equity Equity 100 25 75 2000 2075 Revenue Expenses retained ning Owners Equity Equity 200 50 150 2000 2150 5 Credit Debit 100 100 Cash Revenue Inventory Expenses 25 25 14 13 1000 0 200 200 0 200 1600 900 Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long-Term Total Assets Assets Cash Accounts Receivable Inventory Current/short-term Scooter Equipment Goodwill Total Long Term Total Assets 300 1000 2000 300 1000 1300 3300 2900 4200 0 . Liabilities Payables Current Liabilities Loan Long Term Liabilities Total Liabilities 750 750 Liabilities Payables Current Liabilities Loan Long-Term Liabilities Total abilities 2200 2200 750 2200 200 200 Revenge Expenses Retained Earnings Owners Equity Equity 200 50 150 2000 2250 Revenue Expenses Retained Earnings Owners Equity Epily + b000 2000 Credit Debit 500 2000 Cash Scooter Inventory Expenses
