Answered step by step
Verified Expert Solution
Question
1 Approved Answer
- If anyone is good in accounting and doesn't mind doing mini projects, feel free to help me out this is due by midnight tonight,
- If anyone is good in accounting and doesn't mind doing mini projects, feel free to help me out this is due by midnight tonight, it would be very much appreciated if i get the help i need, this is including solving all areas of this project, if there are anyth concenrs feel free to comment , thank you so much
Wrap Tert Copy Format Painter sard Merge Center $ .. BIU A: ERR Font Alignment f Conditional Formatting Number 2 OverPriced Jeans, Inc. - Transactions Additional Information March 2021 Transactions Date Description of the Transaction S March 1 Owners of OPJ invested an additional $55,000 cash into the business. The cash is put into Big Bank As an example of how to journals and post a transaction this transaction has already been entered into the General Journal and posted to the General Ledger) D March 1 Pay off the 560,000 Note Payable owed to Little Bank. The cash to pay off the note is taken out of Big Bank Also pay to Little Bank 5450 for interest owed on the Note Payable for February The $450 cash is also taken out of Big Bank March 1 Take $5,000 cash out of Big Bank to pay for March's rent. March 2 The customer that purchased on credit on February 15 pays $88,000 cash to pay off the amount due. The cash is deposited into Big Bank March 10 Sale of inventory to a customer-selling price $73,000 - cost of the inventory sold $23,000. The customer pays cash. The cash is deposited into Little Bank March 15 Take $26,000 cash out of Little Bank to pay employees for wages they have earned March 16 Purchase $79,750 of additional inventory. OPJ will pay the manufacturer 50% of the 579,750 in 10 days. OPJ will pay the remaining 50% in 30 days March 17 Sale of inventory to a customer-selling price $113,000 - cost of the inventory sold $33,000 The customer will pay for the purchase in 30 days March 20 Sale of inventory to a customer-selling price $165,500 - cost of the inventory sold 540,750 The customer pays $35,500 cash that is deposited into Little Bank. The customer will pay the remaining amount in 30 days March 22 Purchase inventory for $42.000 cash. The cash is taken out of Big Bank March 26 Pay the manufacturer the 60% due on the March 18th purchase of inventory. The cash is taken out of Big Bank March 30 Take $30,500 cash out of Little Bank to pay employees for wages they have camed. Additional Information Note Payable Big Bank: Interest due to Big Bank on the Note Payable for the month of March is $960. As of March 31 OPJ owes Big Bank a total of $1,560 for interest (5600 for February + 5960 for March) Interest will be paid to Big Bank in June CAS OTO Trans Insert Draw File Home v 11 B Eva Arial v fx C11 Over Priced Jeans, Inc. - General Ledger CAUTION in the con by pang in the amount Do NOT copy cells from the General into the Cash - Big Bank A 100 Balance De Credit Page 2021 More 31 3-1 76 000 DO DI 131.000.000 76.000 OC 55,000.00 Beginning ance 1 AccoB 105 Cash - Little Bank 20271 Check Balance 27.000.000 Page Debat 27 000,00 Math 31 Beginning Balance Account 110 Accounts Receivable Detal Crec Banca und 158 000100 158,000.00 Di A 120 Inventory Cred 302 . 31 BA 36.000.000 Denne 36X Directions Trans Chart Accts III - Journal Calculation Mode: Automatic Workbook Statistics File Home Insert Draw Formulas Data Page Layout Arial V 11 av B C11 Account 120 Inventory Credit 2021 hey 3.1 Bearing and Der 3000 OTO 36.000,00 DI Account 150 Equipment Credit 2021 My 31 Beginning aan De 50 000.00 Balance 50.000.000 III Directions Trans Chart Accts Journal A GL Asse Calculation Mode: Automatic Workbook Statistics Overpriced Jeans, Inc. - General Ledger Enter byg the Account 200 Accounts Payable Do NOT copy of the General Jove de acco Jound Page Deba 2011 Mar 3.1 Balance Credit 0.00 0.000 Beglening balance ALB210 Note Payable - Big Bank 2021 Debit Balance Credit 65,000.00 3. Beginning Band 65,000.00 A 215 Note Payabi-Lite Bank Debit 2021 M. 3-1 Credit GOCO00.00 Balance 60,000.00 Begin Balance 220 Interest Payable - Big Bank 2001 AU Credit 1 Beginning 000 00 Bild 500.00 225 Interest Payable Little Bank Deta C Bano 45000 450.oclo Directions Trans Chart Accts Journal GL Asset Calculation Mode: Automatic Workbook Statistics Account 300 Common Stock 2021 Det CS Balance 3-1 3-1 Beginning Balance 75,000.00 55,000.00 75.000.000 130.000 DO ACON 305 Retired Eamingo Deti Cred Balance 2021 3.1 Beginning in 155,950.00 155 950 000 = III Directions Trans Chart Accts Journal GL Asset: Calculation Mode: Automatic Workbook Statistics Excel freemanchanelle-opj (1) 1 - Saved to OneDrive Search (Alt + 0) 2 Home Insert Draw Page Layout Formulas Data Review View Help V Arial V 11 BO V fo Solid Footing 14e Copyright 2021 General Ledger Over Priced Jeans, Inc. Account # 400 Sales Revenue Journal Page # Debit Credit 2021 Month-Day 3-1 Beginning Balance Balance 0.00 0.00 C Account # 500 Cost of Goods Sold Debit Joumal Page Credit Balance 2021 Month-Day 3-1 Beginning Balance 0.00 0.00 Dr Journal Chart Accts GL Assets GL Liab-Equity GL Rey Directions Trans Calculation Mode: Automatic Workbook Statistics 11 B Arial fx Cost of Goods Sold Account # 500 Journal Debit Credit Balance Pago # 2021 Month-Day 3-1 0.001 0.00 Dr Beginning Balance Rent Expense Account # 510 Balance Credit Joumal Page 3 Debit 2021 Month-Day 3-1 Beginning Balance 0.00 0.00 Dr Account # 515 Wages Expense Chat Aac - Journal GL Assets GLR GL Liab-Equity Directions Carbon Model Auto Workbook stats Data Review View Help Formulas Draw Page Layout Insert he M 11 B Eva AV Arial fx Wages Expense Account # 515 Balance Credit Journal Page Debit 0.00 Dr 2021 Month-Day 3-1 0.00 Beginning Balance Interest Expense Account #520 Journal Page # Debit Credit Balance 0.00 Dr 2021 Month-Day 3-1 0.00 Beginning Balance GL Rev- GL Assets GL Liab-Equity Directions Trans Journal Chart Act Calcutamon Mode: Automate Workbook Statistics Excel freemanchanelle-opj (1) 1 - Saved to OneDrive View Help Review Formulas Data Draw Page Layout Home Insert v 11 VB varav Arial fx Solid Footing 14e Copyright 2021 OPJ's - March 31, 2021 Pre-Closing Trial Balance Enter amounts into th Do NOT copy cells fre Debit Credit Account # Account Name 100 Cash - Big Bank 105 Cash - Little Bank 110 Accounts Receivable 120 Inventory 150 Equipment 200 Accounts Payable 210 Note Payable - Big Bank 215 Note Payable - Little Bank 220 Interest Payable - Big Bank 225 Interest Payable - Little Bank 300 Common Stock 305 Retained Earnings 400 Sales Revenue 500 Cost of Goods Sold 510 Rent Expense 515 Wages Expense 520 Interest Expense Totals 0.00 0.00 -C GL Liab-Equity Directions GL Assets Trans - Chart Accts Journal Calculation Model Automatic WorkbookStatistics 1 a Amazon Welcome to My NY My Monroe b Humble Symbol - BL Blackboard Learn Search Excel freemanchanelle-opj (1) 1 - Saved to OneDrive v View Formulas Data Review Page Layout File Home Insert Draw 11 B v av A Arial D6 fr Enter amounts into the Financial Statements by ty Do NOT copy cells from the General Ledger or Pr Income Statement for the Month Ended March 31, 2021 Sales Revenue Cost of Goods Sold Gross Profit 0.00 Expenses: Rent Expense Wages Expense Interest Expense Total Expenses 0.00 Net Income $0.00 Calculation of Retained Earnings as of March 31 for the Balance Sheet Retained Eamings Current Balance Plus March Net Income Retained Earnings as of March 31 for Balance Shoot 0.00 Directions Trans GL Liab-Equil Chart Act - Journal GL Assets Calculation Mode: Automatic Workbook Statistics M course grade X Experience a cx MSN Outlook onedrive.live.com/edit.aspx?action=edit&resid=13CA508CFC24F5C0105 a Am -) e Blackboard Learn Welcome to My NY. My My Monroe b Humble Symbol-Bi.. Se Excel freemanchanelle-opj (1) 1 - Saved to OneDrive v Vies Formulas Data Review Draw Page Layout Insert File Home 1 BA Ana 08 Overnced Jeans, Inc. Balance Sheet as of March 31, 2021 Enter amounts into the Balance Do NOT copy cells from the Ger Assets Cash - Big Bank Cash - Little Bank Accounts Receivable Inventory Equipment Total Assets $0.00 Liabilities Accounts Payable Note Payable - Big Bank Note Payable - Little Bank Interest Payable - Big Bank Interest Payable - Little Bank Total Liabilities Equity Common Stock Retained Earnings Total Equity 0.00 0.00 Total Liabilities & Equity S0.00 Directions Trans Chart Accts Journal GL Assets GLL Calculation Mode: Automatic Workbook Statistics Arial 20 E6 fx Solid Footing 14e Copyright 2021 OPJ's - March 31, 2021 Post-Closing Trial Balance - Enter Do N Debit Credit Account # Account Name 100 105 110 120 150 200 210 215 220 225 300 305 400 500 510 515 520 Cash - Big Bank Cash - Little Bank Accounts Receivable Inventory Equipment Accounts Payable Note Payable - Big Bank Note Payable - Little Bank Interest Payable - Big Bank Interest Payable - Little Bank Common Stock Retained Earnings Sales Revenue Cost of Goods Sold Rent Expense Wages Expense Interest Expense Totals 0.00 0.00 Directions Chart Accts Journal GL Assets GL Liate Calculation Mode: Automatic Workbook Statistics 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