Session 2 Student Worksheet

xlsx

School

Westcliff University *

*We aren’t endorsed by this school

Course

300

Subject

Accounting

Date

Feb 20, 2024

Type

xlsx

Pages

31

Uploaded by MasterSnow9813

Report
March 2024 ASSETS Supplies Equipment 20,000 -500 500 6,300 1,300 -150 -200 -6,000 6,000 3,000 -1,200 -1,000 Balance 12,250 3,000 500 6,000 6,300 Proof TOTAL ASSETS: 28,050 Bartok Consulting Income Statement March 1 - 31, 2024 REVENUES service fee income 4,300 TOTAL REVENUE EXPENSES telephone expenses 200 advertising expenses 1,200 office expenses 0 utilities expenses 150 rent expenses 0 TOTAL EXPENSES NET INCOME/(LOSS) First Bank Checking Account Accounts Receivable Prepaid Rent
Bartok Consulting Statement of Equity March 1 - 31, 2024 Beginning Balance Cristina, Capital, March 1 Plus: Additional contributions from owner 20,000 Less: Owner personal draws 1,000 Plus: Net Income/(Loss) 2,750 Ending Balance Cristina, Capital, Mar 31 April Transactions: 1st Receive cash payments in the amount of $2,300 from clients who 3rd Purchase $150 in Supplies on account payable in 30 days 5th Make a $500 payment on the loan (assume 0% interest) 10th Provide $6,000 in consulting services for customers who pay imm 15th The autopay of $200 comes out of the checking account for the t 20th Write a check for the electricity bill in the amount of $175 30th Make the adjusting entry to "use" one month of the prepaid rent 30th Make the adjusting entry to "use" $200 of Supplies (expense as O ASSETS Supplies Equipment Balances 12,250 3,000 500 6,000 6,300 1st 2,300 -2,300 3rd 150 5th -500 10th 6,000 15th -200 20th -175 30th -1,000 30th -200 Balance 19,675 700 450 5,000 6,300 Proof TOTAL ASSETS: 32,125 Bartok Consulting First Bank Checking Account Accounts Receivable Prepaid Rent
Income Statement April 1 - 30, 2024 REVENUES Service Fee Income 6,000 TOTAL REVENUE EXPENSES Telephone Expense 200 Advertising Expense 0 Office Expense 200 Utilities Expense 175 Rent Expense 1000 TOTAL EXPENSES NET INCOME/(LOSS) Bartok Consulting Statement of Equity April 1 - 30, 2024 Beginning Balance Cristina, Capital, April 1 Plus: Additional contributions from owner 0 Less: Owner personal draws 0 Plus: Net Income/(Loss) 4,425 Ending Balance Cristina, Capital, April 30
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
LIABILITIES EQUITY REVENUE 20,000 6,300 1,300 200 3,000 1,000 0 6,300 20,000 1,000 4,300 200 TOTAL LIABILITIES TOTAL E 6,300 21,7 Bartok Consultin Balance Sheet March 31, 202 ASSETS first bank checking account 4,300 account receivable supplies prepaid rent equipment TOTAL ASSETS LIABILITIES accounts payable first bank loan payable 1550 TOTAL LIABILITIES 2,750 EQUITIES bartok, C capital Accounts Payable First Bank Loan Payable Bartok, C., Capital Bartok, C., Drawing Service Fee Income Telephone Expense
TOTAL LIABILITIES & EQUITIES 0 21,750 o previously promised to pay mediately (money is deposited into the checking acc telephone bill (we prepaid 6 months of rent) Office Expense) LIABILITIES EQUITY REVENUE 0 6,300 21,750 150 -500 6,000 200 150 5,800 21,750 0 6,000 200 TOTAL LIABILITIES TOTAL E 5,950 26,1 Bartok Consultin Accounts Payable First Bank Loan Payable Bartok, C., Capital Bartok, C., Drawing Service Fee Income Telephone Expense
Balance Sheet April 1 - 30, 202 ASSETS First Bank Checking Account 6,000 Accounts Receivable Supplies Prepaid Rent Equipment TOTAL ASSETS LIABILITIES Accounts Payable 1,575 First Bank Loan Payable TOTAL LIABILITIES 4,425 EQUITIES Bartok, C Capital TOTAL LIABILITIES & EQUITIES 21,750 26,175
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
EXPENSES 150 1,200 1,200 0 150 0 EQUITY 750 ng t 24 12,250 3,000 500 6,000 6,300 28,050 0 6,300 6,300 21,750 Advertising Expense Office Expense Utilities Expense Rent Expense
28,050 EXPENSES 175 1,000 200 0 200 175 1,000 EQUITY 175 ng Advertising Expense Office Expense Utilities Expense Rent Expense
t 24 19,675 700 450 5,000 6,300 32,125 150 5,800 5,950 26,175 32,125
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Use this Chart of Accounts for your account names CHART OF ACCOUNTS Assets Revenue + Debit Credit - - Debit First Bank Checking Account Service Fee Income Accounts Receivable Expenses Supplies + Debit Prepaid Rent Telephone Expense Equipment Advertising Expense Liabiliies Office Expense - Debit Credit + Utilities Expense Accounts Payable Rent Expense First Bank Loan Payable Equity - Debit Credit + + Debit Bartok, C. Capital Bartok, C. Drawing Analyze each of the following transactions using the T Accounts March 2, 2024 first bank checking bartok, C CAPITAL 20000 20000 March 5, 2024 Cristina uses the company debit card to purchase $500 FIRST BANK CHECKING supplies 500 500 March 11, 2024 Cristina purchases $6,300 of equipment by taking out equipment first bank loan 6300 6300 March 13, 2024 first bank checking service fee income 1300 1300 March 17, 2024 Cristina deposits $20,000 from her personal savings business checking account Cristina provides $1,300 of consulting work to custome in cash (she deposits to the bank) Cristina pays the $150 electricity bill online using the account
first abnk checking utilities bill 150 150 March 20, 2024 first bank checking telephone expenses 200 200 March 25, 2024 first bank checking prepaid rent 6000 6000 March 26, 2024 accounts receivable service fee income 3000 3000 March 27, 2024 first bank checking advertising expenses 1200 1200 March 31, 2024 first bank checking Bartok C drawing 1000 1000 Analyze each of the following transactions using the T Accounts April 5, 2024 first bank checking accounts receivable 2300 2300 April 10, 2024 Purchase $150 in Supplies on account payable in 3 Cristina sets the company cell phone up on autopay by $200 bill from the checking account Cristina writes a check to prepay the next six months $1,000 per month Cristina provides $3,000 in consulting services to clients who days Cristina uses the company debit card to purchase advertisin media for $1,200 Cristina takes $1,000 in cash out of the Checking Account expenses Receive cash payments in the amount of $2,300 from previously promised to pay
supplies account payable 150 150 April 15, 2024 Make a $500 payment on the loan (assume 0% in first bank checking first bank loan 500 500 April 20, 2024 first bank checking service fee income 6000 6000 April 21, 2024 first bank checking telephone expenses 200 200 April 25, 2024 Write a check for the electricity bill in the amount first bank checking utilities expenses 175 175 April 30, 2024 prepaid rent rent expenses 1000 1000 April 30, 2024 supplies office expenses 200 200 Provide $6,000 in consulting services for customers immediately (money is deposited into the checking The autopay of $200 comes out of the checking acco telephone bill Make the adjusting entry to "use" one month of the p (we prepaid 6 months of rent) Make the adjusting entry to "use" $200 of Supplies (expens Expense)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Credit + First Bank Checking Account Accounts 20000 500 1300 150 Credit - 200 6000 1200 First Bank Lo 1000 balance 12250 Credit - Bartok, C Accounts Receivable 3000 Bartok, C. 1000 Supplies Service Fe 500 0 in supplies Prepaid Rent 6000 a bank loan Equipment 6300 Bartok Consulting Income Statement March 1 - 31, 2024 REVENUES TOTAL REVENUE EXPENSES Post the transactions for March to the T Accounts accoun s into the ers who pay e checking
TOTAL EXPENSES NET INCOME/(LOSS) Bartok Consulting Statement of Equity March 1 - 31, 2024 Beginning Balance Cristina, Capital, March 1 Plus: Additional contributions from owner Less: Owner personal draws Plus: Net Income/(Loss) Ending Balance Cristina, Capital, Mar 31 First Bank Checking Account Accounts 30 days First Bank Lo y paying the s of rent for will pay in 30 ng on social t for personal Post the transactions for April to the T Accounts accoun clients who
nterest) Bartok, C Accounts Receivable Bartok, C. Supplies Service Fe Prepaid Rent of $175 Equipment Bartok Consulting Income Statement April 1 - 30, 2024 REVENUES TOTAL REVENUE EXPENSES TOTAL EXPENSES NET INCOME/(LOSS) Bartok Consulting Statement of Equity s who pay account) ount for the prepaid rent se as Office
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
April 1 - 30, 2024 Beginning Balance Cristina, Capital, March 1 Plus: Additional contributions from owner Less: Owner personal draws Plus: Net Income/(Loss) Ending Balance Cristina, Capital, Mar 31
s Payable Telephone Expense 200 oan Payable 6300 Advertising Expense 1200 C. Capital Office Expense 20000 . Drawing Utilities Expense 150 ee Income 1300 3000 Rent Expense 4300 Ba t B 4 M ASSETS TOTAL ASSETS s below and determine the balance of each nt
LIABILITIES TOTAL LIABILITIES EQUITIES Bartok, C. Capital TOTAL LIABILITIES & EQUITIES y 4 0 s Payable Telephone Expense oan Payable Advertising Expense below and determine the balance of each nt
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
C. Capital Office Expense . Drawing Utilities Expense ee Income Rent Expense Ba B A t ASSETS TOTAL ASSETS LIABILITIES TOTAL LIABILITIES EQUITIES Bartok, C. Capital TOTAL LIABILITIES & EQUITIES y
0
artok Consulting Balance Sheet March 31, 2024
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
artok Consulting Balance Sheet April 30, 2024 0 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Check Your Understanding Problem 1 Create an Income Statement from the following information: Sales Revenue 62,500 Rental Revenue 15,300 Product Expense 52,200 Wages Expense 18,900 Owenr Investment 12,000 Equipment purchases 56,000 Utilities Expense 1,800 Income Taxes Expense 400 DL Enterprises Income Statement July 1 - July 31, 2024 Revenues Total Revenue Expenses Total Expenses Net Income/(Loss) Check Your Understanding Problem 2 Calculate net income or net loss for each month given the following: Revenues Jan 22,500 Gains Feb 1,200 Losses Mar 3,700 Expeneses Feb 21,620 Gains Jan - Revenues March 42,800
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Losses Feb 1,600 Expenses Mar 45,100 Losses Jan - Revenues Feb 37,550 Expenses Jan 20,760 Gains Mar 5,600 January February March Revenues Expenses Gains Losses Net Income/(Loss) Check Your Understanding Problem 3 Calculate the cash balance on Dec 31st given the following transactions Cash Sales 3250 Payments for inventory 1760 Investments of cash by owners 3000 Supplies used 175 Cash withdrawals 260 Inventory received 2500 Wages paid 2390 Cash balance on Dec 1 4250 Cash Balance Dec 31st Check Your Understanding Problem 4 List of Account Balance in Alphabetical Order JD Corporation Month ended June 30, 20xx Account Debit Credit Accounts Payable 2,300 Accounts Receivable 3,500 Advertising Expense 1,200 Cash 14,250 10,000 Dividends Paid 8,000 Common Stock ($1 par, 10,000 shares issued and outstanding)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Equipment 18,900 Fees Income 37,900 Insurance Expense 650 Interest Expense 1,400 Inventory 8,500 Land 35,000 Mortgage Payable 121,000 Notes Payable 8,600 Office Building 87,000 Office Expense 1,150 Retained Earnings, June 1 15,100 Utilities Expense 800 Visa Card Payable 1,750 Wages Expense 16,300 Totals 196,650 196,650 JD Corporation Income Statement June 1 - June 30, 20xx Revenue Total Revenue Expenses Total Expenses Net Income/(Loss) JD Corporation Statement of Equity June 1 - June 30, 20xx Beginning Retained Earnings, June 1 Changes in Retained Earnings Dividends Paid +/- Net Income/(Loss) Total Change in Retained Earnings Ending Retained Earnings, June 30
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
JD Corporation Balance Sheet June 30, 20xx Assets Current Assets Total Current Assets Total Fixed Assets Total Fixed Assets Total Assets Liabilities Current Liabilities Total Current Liabilities Long-term Liabilities Total Long-term Liabilities Total Liabilities Equity Retained Earnings Total Liabilities & Equity Common Stock ($1 par, 10,000 shares issued and outstanding)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Check Your Understanding Problem 5 JD Corporation Comparative Balance Sheet 2023 2022 Change Assets Cash 66,700 83,250 Accounts Receivable 55,400 54,220 Prepaid Insurance 2,400 3,600 Investments 95,000 75,000 Property, Plant & Equipment 35,600 290,000 Accumulated Depreciation (65,700) (36,700) Total Assets 189,400 469,370 Liabilities & Equity Liabilities Accounts Payable 48,100 47,300 Notes Payable 160,000 185,000 Total Liabilities 208,100 232,300 Equity Common Stock 130,000 100,000 Retained Earnings 171,700 137,070 Total Equity 301,700 237,070 Total Liabilities & Equity 509,800 469,370 JD Corporation Income Statement July 1, 2023 - June 30, 2023 Sales Revenue 433,000 Cost of Goods Sold 289,000 Gross Profit 144,000 Operating Expenses Depreciation Expense 29,000 Insurance Expense 14,400 Other Operating Expenses 57,200 Total Operating Expenses 100,600
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Operating Income 43,400 Other Revenue (and Expenses) Gain on Sale of Land 17,500 Total Other Revenue and Expenses 17,500 Income Before Income Tax 60,900 Income Tax Expense 18,270 Net Income 42,630
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Other Relevant Info: Investments that originally cost $30,000 were sold Investments were purchased for $50,000 cash. Plant assets were purchased for $66,000 cash. Cash dividends were declared and paid to shareho JD Corporation Statement of Cash Flows (Indirect Method) Year Ended June 30, 2023 Cash Flow from Operating Activities Net Income Adjustments to Reconcile Net Income to Net Cash Flow from Operating Activities: Depreciation Gain on Sale of Plant Assets Accounts Receivable Prepaid Insurance Accounts Payable Net Cash Flow: Operating Activities Cash Flow from Investing Activities Proceeds from Sale of Investments Cost of Investments Purchased Cost of New Plant Assets Net Cash Flow: Investing Activities Cash Flow from Financing Activities: Payment of Notes Payable Issuance of Common Stock Payment of Notes Payable Net Cash Flow: Financing Activities Total Cash Flow increase/(decrease) Cash Balance June 30, 2022 Cash Balance June 30, 2023
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
d for $47,500 cash. olders in the amount of $8,000.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help