Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

My T-Account numbers are not matching up with the figures given. I had to delete almost everything to start afresh where I am making mistake?

My T-Account numbers are not matching up with the figures given. I had to delete almost everything to start afresh where I am making mistake? If any more info is needed please let me know... I think Journal entries might be fine I am just not able to put them in T-Account as I should

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

*100% Activities LibreOffice Calc May 21 22:08:35 48.9'F Summer 2019 Mod 3 Excel Workbook Assignment 1.xlsx - LibreOffice Colc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help P12 Common Stock amount was still listed as receivable 18,000 34 514 The total cost of the goods sold during 2019 was $1,689,756 36 15 Supplies inventory of $4,729 was purchased with cash during 2019. Total supplies 3 nventory of $726 was still on hand at year end 2019 10 Furniture and Equipment 63,000 63,000 Bank 38 Total Salaries Expense for the year was $135,422 and total interest expense was L6 $24,012. Salaries of $7,580 and interest of $24,012 are still payable at year end 2019 11 Inventory 1,764,640 39 40 17 Bank 41 Depreciation expense needs to be recorded on ALL buildings, furniture and 42 equipment, and the new computer system at year end 2019. All items are 3 depreciated on a monthly basis using straight line depreciation. The building has a useful life of 40 years and the furniture and equipment is depreciated over 6 years--there is no salvage value on the buildings or the furniture and equipment. As noted above, the new sales system has a useful life of 3 years and has a salvage 12 Computer System 81,440 Cash 81,440 13 Bank 2,512,952 45 46 value of $8,000 Accounts Receivable 51,278 47 18 Sales The Prepaid Insurance and the Supplies Inventory need to be adjusted at year end 2019 so that the proper amount for insurance expense and supplies expense is recorded. See items 6 and 15 for details. (If you adjusted the supplies in #15, do not do it again) 48 14 Cost of Goods Sold 1,689,756 49 I 51 19 Estimated income tax payable amounts for 2019 equaling $86,500 were paid 52during the year as they became due 53 20 The company paid out cash dividends totaling $2,050 to its shareholders. Expenses for the Supplies Supplies Inventory 4,729 15 756 Cash 3,973 The company determined that a customer account was not collectible, and wrote s5 off $378 on December 31 56 22 16 Salary Expense 135,422 The company believes that 2% of ending Accounts Receivable is a reasonable estimate of its Allowance for Doubtful Accounts balance. The Company uses the allowance method to record bad debts. Bank 127,842 7,580 57 Salary Payable 58 59 | 23 Tax expense is 21% of Income before Income Tax. Intereet Evnence 1 01 + Part A JEs & Background Info Part i. ' Accts & Acct Equster Part C . I nal 531 & los ng JE Part U, Mut ple-stes rc Str Pyt E St t r Het Ear Ps-F. Comparattee ial Sheet Part G tern ngs er s are at H rc Stmt atics t ngs Sheelof 8 Engish (USA Peeag: Sum D Activities LibreOffice Calc *100% May 21 22:08:51 48.9'F Summer 2019 Mod 3 Excel Workbook Assignment 1.xlsx - LibreOffice Colc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help P12 62Background Information: The Balance Sheet for December 31, 2018 for beginning 3 balances needed for T-Accounts. 17 BuildingDepreciation Accumulated Depreciation 17 F&E-Depreciation Candy Earth, Co Accumulated Depreciation Balance Sheet 17 Sales Sys Depreciation 14,280 December 31, 2018 Accumulated Depreciation 14,280 Assets 69 18 Insurance Expense 0 Current Assets 2,850 346,890 31,878 (405) Prepaid Insurance 2,850 71 Accounts Receivable Allowance for Doubtful Accounts 18 Supplies Expense 3,973 73 74 Supplies Inventory Merchandise Inventory 76 Prepaid Insurance 970 3,973 1,118,695 75 754 Current tax expense 19 86,500 Total Current Assets 1,498,782 Bank 86,500 78 20 Dividends Property, Plant, and Equipment 2,050 Land 120,000 Bank 2,050 Buildings 525,000 82 Accumulated Depreciation--Buildings Furniture and Equipment (52,500) 21 Bad Debts 378 18,000 Accounts Receivable 378 84 Accumulated Depreciation--Furniture and Equipment Net Property, Plant, and Equipment (12,000 22 Bad Debts Expense 598,500 1,396 85 Allowance for Doubtful Accounts 1,396 86 Total Assets 2,097,282 iahilities and Storkholders Fo Part A JEs & Background Info Part i, ' Accts & Acct Equster Part C . I nal 531 & los ng JE Part U, Mur: ple-stes rc Str Pat E St t r Het Ear Ps-F. Comparattee ial Sheet Part G tern ngs er s are at H rc Stmt atics t ngs Enush (USA Peeag: Sum D Activities LibreOffice Calc *100% May 21 22:08:59 48.9'F Summer 2019 Mod 3 Excel Workbook Assignment 1.xlsx - LibreOffice Colc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help P12 1,396 Allowance for Doubtful Accounts 86 Total Assets 2,097,282 Liabilities and Stockholders' Equity Current Liabilities Accounts Payable 92 Salaries Payable Interest Payable Taxes Payable 303,656 9,510 28,000 93 46,878 388,044 Total Current Liabilities 97 Long-ter iabilities Note Payable Mortgage Note Payable Total Long-term Liabilities 260,000 300,000 60,000 Total Liabilities 948,044 104 Stockholders' Equity 10 Common Stock, 10,000 shares issued and outstanding, $10 pa Retained Earnings Total Stockholders' Equity 100,000 1,049,238 106 1,149,238 07 Total Liabilities and Stockholders' Equity 2,097,282 110 Part A JEs & Background Info Part i, ' Accts & Acct Equster Part C . I nal 531 & los ng JE Part U, Mur: ple-stes rc Str Pat E St t r Het Ear Ps-F. Comparattee ial Sheet Part G tern ngs er s are at H rc Stmt atics t ngs Engish (USA Peeag: Sum D Activities LibreOffice Calc May 21 22:10:14 48.9'F Summer 2019 Mod 3 Excel Workbook Assignment 1.xlsx - LibreOffice Colc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help M N is Ending Cash $696,205; Total Ending Assets- $2,646,497 ts your Total Credits in the T-Accounts! r Total Debit e your 1 olution: Liabilities Equity Assets 19 21 Cash Prepaid Insurance Accounts Payable Common Stock 346,890 303,656 BB Land Salaries Payable Retained Earnings 120,000 Building 32 25,000 Interest Payable 35 Furniture & Equipment Sales Revenue 38 Taxes Payable Shec: 2 of3 FageSle Purt B.T Accts & Noct Equation Engish (USA Peeag: Sum D Activities LibreOffice Calc May 21 22:10:23 48.9'F Summer 2019 Mod 3 Excel Workbook Assignment 1.xlsx - LibreOffice Colc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help M N VX AC AD 15 ts $2,646,497. 6 the T-Accounts! 19 Liabilities Equity 19 21 Prepaid Insurance Accounts Payable Common Stock alaries & Wages Exp 303,656 BB Supplies Expense Land Salaries Payable Retained Earnings 120,000 Insurance Expense Building 32 525,000 Interest Payable Bad Debt Expense 35 Furniture & Equipment Sales Revenue Depreciation Expense 38 Taxes Payable + Pa t A Ls s u2ck ground i to Part B. T Accts & Acct Equation Part C. ' nal 531 & los ng JE Part U, Mul ple-stes rc St Pat E St t r Het Ear Ps-F. Comparattee ial Sheet Part G ter ngs er s are at H rc Stmt atics t ngs Shec: 2 of3 FageSle Purt B.T Accts & Noct Equation Engish (USA Peeag: Sum D Activities LibreOffice Calc *100% May 21 22:10:37 48.9'F Summer 2019 Mod 3 Excel Workbook Assignment 1.xlsx - LibreOffice Colc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help M N AR Building 32 S25,000 Interest Payable Bad Debt Expense Furniture & Equipment Sales Revenue Depreciation Expense 38 Taxes Payable 40 Computerized Sales Systen Interest Expense Cost of Goods Sold 45 Accum Depr-Building Mortgage Note Payable Tax Expense 47 Note Pavable Accum Depr-Furn&Equi Shec: 2 of3 FageSle Purt B.T Accts & Noct Equation Enush (USA Peeag: Sum D *100% Activities LibreOffice Calc May 21 22:10:46 48.9'F Summer 2019 Mod 3 Excel Workbook Assignment 1.xlsx - LibreOffice Colc File Fdit View Insert Farmat Styles Sheet Data Tacls Wincow Help M N Taxes Payable Accounts Receivable Computerized Sales System Cost of Goods Sold 45 Accum Mortgage Note Payable r-Buildin 16 Allowance for Doubtful Accts 18 19 Note Payable Accum Depr-Furn&Equip 52 Merchandise Inventory Accum Depr:Sales System Supplies Invento 60 Shec: 2 of3 FageSle Purt B.T Accts & Noct Equation Engish (USA Peeag: Sum D

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions