Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template Ramel T 241 File Home Insert Page Layout Formulas Data Review View Help Share

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template Ramel T 241 File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 13 ~ A A = ab Wrap Text General Heading 1 Heading 2 Heading 3 Heading 4 TIX _ AutoSum ~ AY O Paste [ Copy Fill nsert Delete Format Sort & Find & Analyze E E Merge & Center $ ~ % 9 00 20 Conditional Format as Title Total 20% - Accent1 20% - Accent2 Format Painter Formatting Table ~ Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A9 X V fx E Ending Balances, December 31: C D E F G H I K L M N P Q R S T U V W X A Company Statement of Stockholder's Equity For Qtr. Ending 12/31/20xx UI A W I Common Stock Retained Earnings Total Beginning Balances, September 30 6 Issued Common Stock 7 Net Income 8 Dividends 9 Ending Balances, December 31: 10 11 12 13 18 ... Statement of Stockholder Equity Balance Sheet Closing Entries Post-Closing Trial Balance Ready D - 100% 2:39 PM Type here to search O 84'F Partly sunny ~ g (6 () 7 7/4/2021H 9 ACC 201 Company Accounting Workbook Template Ramel T at AutoSave . Off Review View Share Comments File Home Insert Page Layout Formulas Data Help 2 AutoSum ~ & Cut Calibri 11 ~ A A = ab Wrap Text General 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 TIX AY O Fill [ Copy nsert Delete Format Sort & Find & Analyze Paste E E Merge & Center $ ~ % 9 00 20 Conditional Format as 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 Clear Formatting Table Filter ~ Select Data Format Painter Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A6 X V B C D E F G H K L M N o P Q R S T U V W X A Company Income Statement For Qtr. Ending 12/31/20XX Revenues 40 00 01 UI A W N . Total Revenues 10 Gross Profit 11 12 Operating Expenses: w 14 16 18 so Total Operating Expenses: 32 Net Income U w 35 ... Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet Closing Entries ... : " - 100% Ready 2:39 PM Type here to search O ? 84'F Partly sunny ~ g (7() 7/4/2021AutoSave . Off HY ACC 201 Company Accounting Workbook Template Ramel T at File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ A A = ab Wrap Text Date 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 TIX 2 AutoSum ~ AY O [ Copy Fill Paste BIULA E E Merge & Center $ ~ % 9 00 20 Conditional Format as 60% - Accent3 60% - Accent4 60% - Accent5 60% - Accent6 nsert Delete Format Sort & Find & Analyze Format Painter Formatting Table Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A6 X V 12/31/2020 C D E F G H K L M N P Q R S T U V W X Z A Company Adjusting Journal Entries W I 20XX Date Accounts Debit Credit 31-Dec Depreciation Expense Accumulated Depreciation P OneDrive Screenshot saved The screenshot was added to your ... Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet Closing Entries ... : OneDrive. Ready Type here to search O 0 84'F Partly sunny ~ 9: (7 () 2:39 PM 7/4/2021AutoSave . Off HY ACC 201 Company Accounting Workbook Template Ramel T at File Home Data Help Share Comments Insert Page Layout Formulas Review View _ AutoSum ~ & Cut Calibri 11 ~ A A ab Wrap Text Accounting Normal Bad Good Neutral AY O 1 Fill useit Delete Format Analyze Paste [ Copy E $ ~ % 2 00 20 Conditional Format as Calculation Check Cell Explanatory ... Input Sort & Find & Clear Format Painter BIULA E Merge & Center Formatting Table Filter ~ Select Data Editing Clipboard Alignment Number Analysis Font Styles Cells GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more E10 X V ='Adjusting Entries'!D11 U A B C D E F G H K L M N P Q R S T A Company Trial Balance N N 20xx Unadjusted trial balance Adjusting entries Adjusted trial balance UI AL Account Debit Credit Debit Credit Debit Credit 6 7 Baking Supplies 8 Merchandise Inventory 9 Prepaid Rent 10 Prepaid Insurance 11 Baking Equipment 12 Accumulated Depreciation 13 Office Supplies 14 Accounts Receivable 15 Notes Payable 16 Interest Payable 17 Accounts Payable 18 Wages Payable 19 Common Stock 20 Dividends 21 Bakery Sales 22 Merchandise Sales 23 Baking Supplies Expense 24 Rent Expense 25 Interest Expense 26 Insurance Expense 27 Depreciation Expense 28 Misc. Expense 29 Office Supplies Expense 30 Business License Expense 31 Advertising Expense 32 Wages Expense P OneDrive 33 Telephone Expense 34 COGS Screenshot saved 35 The screenshot was added to your OneDrive. ... Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet Closing Entries ... Ready 2:39 PM Type here to search O 84'F Partly sunny ~ 9 (7() 7/4/2021AutoSave . Off HY ACC 201 Company Accounting Workbook Template Ramel T at File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ A A = = E ab Wrap Text General Normal Bad Good Neutral _ AutoSum ~ AY O [ Copy 1 Fill Paste =E Merge & Center v $ ~ % 9 00 20 Conditional Format as Calculation Check Cell Explanatory ... Input useit Delete Format Sort & Find & Analyze Format Painter Formatting Table Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis iGET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more R7 X V fax Sales - selling price, $8.50 a box B C D E G H K L M N O P Q R S T U V 1 IN FIFO 3 Purchases Sales Ending Inventory Purchases No. of No. of No. of Date Items Unit Price Total Price Items Unit Price Total Price |Items Unit Price Total Price Date 12/7: 10 boxes purchased at $6 D Cr 7-Dec 10 $ 6.00 $ 60.00 10 $ 6.00 $ 60.00 7-Dec Merchandise Inventory (10 x $6) 60.00 12/20: 20 boxes purchased at $6.10 Cash 60.00 12/30: 25 boxes purchased at $6.05 15-Dec 8 $ 6.00 $ 48.00 2 $ 6.00 $ 12.00 Purchased inventory Sales - selling price, $8.50 a box Co 12/15: 8 boxes 20-Dec 20 $ 6.10 $ 122.00 2 $ 6.00 $ 12.00 15-Dec Cash (8 x $8.50) 68.00 12/24: 18 boxes 20 $ 6.10 $ 122.00 Merchandise Sales Revenue 68.00 22 $ 134.00 ale of inventory 24-Dec 2 $ 6.00 $ 12.00 15-Dec Cost of Goods Sold (8 X $6) 48.00 16 $ 6.10 $ 97.60 4 $ 6.10 $ 24.40 Merchandise Inventory 48.00 18 $ 109.60 Recorded the cost of goods sold 30-Dec 25 $ 6.05 $ 151.25 4 $ 6.10 $ 24.40 20-Dec Merchandise Inventory (20 x $6.10 ) 122.00 25 $ 6.05 $ 151.25 Cash 122.00 29 $ 175.65 Net Inventor 55 $ 333.25 26 $ 157.60 29 $ 175.65 24-Dec Cash (18 x 8.50) 153.00 Merchandise Sales Revenue 153.00 Record sale of inventory 24-Dec Cost of Goods Sold (2 x $6)+(16 x $6.10) 109.60 Merchandise Inventory 109.60 Recorded the cost of goods sold 30-Dec Merchandise Inventory (25 x $6.05) 151.25 Cash 151.25 OneDrive Screenshot saved The screenshot was added to your ... Inventory Valuation Trial Balance |Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet Closing Entries ... OneDrive. Ready Type here to search O 84'F Partly sunny ~ 9: (7 () 2:39 PM 7/4/2021Ramel T at AutoSave . Off HY ACC 201 Company Accounting Workbook Template Share Comments File Home Insert Page Layout Formulas Data Review View Help Normal Bad Good Neutral _ AutoSum ~ AY O LOT & Cut Calibri 11 ~ A A = ab Wrap Text Custom 1 Fill [ Copy Analyze $ ~ % 9 00 20 Conditional Format as Calculation Check Cell Explanatory ... Input useit Delete Format Sort & Find & Paste E E Merge & Center Clear Filter ~ Select Data Format Painter Formatting Table Styles Cells Editing Analysis Clipboard Font Alignment Number GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A3 X V 10/1/2020 AA AB B D E F G H K M N O P Q R S T U V W X Y Z Cash date Common Stock date date Notes Payable date Business License exp UN 1-Oct| $ 3-Oct 10-Oct S 1-Oct 0 13-Oct n A 3-Oct 7-Oct 0 10-Oct 11-Oct 13-Oc 14-Oc 10 31-Oct 31-Oct 5-Nov 8-Nov 14 10-Nov 15 18-Nov 16 15-Nov 17 20-Nov Accounts Rec. Insurance expense 18 20-Nov 31-Oct 19 22-Nov 8-Nov 30-Nov 18-Nov 1-Dec 30-Nov 5-Dec 8-Dec 7-Dec 31-Dec 8-Dec 10-Dec o 0 26 13-De 27 15-Dec 28 15-Dec 29 20-Dec 30 31 20-Dec 24-Dec 30-Dec OneDrive 34 31-Dec 35 Screenshot saved 36 The screenshot was added to your 37 OneDrive. ... T-Accounts - autofill Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet ... + : Ready Type here to search X 84'F Partly sunny ~ 9 (7 () 2:39 PM O 7/4/2021AutoSave . Off HY ACC 201 Company Accounting Workbook Template Ramel T at File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ A A = ab Wrap Text Date 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 TIX 2 AutoSum ~ AY O Fill Paste [ Copy Conditional Format as 60% - Accent3 60% - Accent4 60% - Accent5 60% - Accent6 nsert Delete Format E Sort & Find & Analyze Format Painter BIULA E Merge & Center $ ~ % 9 00 20 Formatting Table Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A6 X V D G H J K L M N P Q R S T U V W X Y Z AA AB AC Debit Credit OneDrive Screenshot saved The screenshot was added to your December Journal Entries T-Accounts - autofill Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockh ... + OneDrive. Ready O 2:40 PM Type here to search O ? 84'F Partly sunny ~ 9 (2 4) 7/4/2021AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template Ramel T 241 File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ A A = ab Wrap Text Date 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 TIX 2 AutoSum ~ AY O [ Copy Fill Paste E E Merge & Center $ ~ % 9 00 20 Conditional Format as 60% - Accent3 60% - Accent4 60% - Accent5 60% - Accent6 nsert Delete Format Sort & Find & Analyze Format Painter Formatting Table Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A6 X v fx C D E F G H 1 K L M N 0 P Q R S T U V W X A Company General Journal Entries November, 20xx Date Accounts Debit Credit P OneDrive Screenshot saved The screenshot was added to your ... November Journal Entries December Journal Entries T-Accounts - autofill Inventory Valuation Trial Balance Adjusting Entries Income Stat ... + : OneDrive. Ready Type here to search O 2:40 PM 84'F Partly sunny ~ 9: ( 4)) 7/4/2021AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template Ramel T 241 File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ A A = ab Wrap Text General TH 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 TIX 2 AutoSum ~ AY O [ Copy Fill Paste E E Merge & Center $ ~ % 2 00 20 Conditional Format as 60% - Accent3 60% - Accent4 60% - Accent5 60% - Accent6 nsert Delete Format Sort & Find & Analyze Format Painter Formatting Table Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more B6 X V C D E F G H K L M N P Q R S T U V W X A Company General Journal Entries October, 20xx IG UI A Date Accounts Debit Credit 1-Oct $ 1-Oct 12 3-Oct 14 7-Oct 16 18 10-Oct 11-Oct 24 25 13-Oct 13-Oct 14-Oc P OneDrive Screenshot saved 23 The screenshot was added to your Chart of Accounts October Journal Entries November Journal Entries December Journal Entries T-Accounts - autofill Inventory Valuation ... + OneDrive. Ready O 2:40 PM Type here to search X 84'F Partly sunny ~ : ( 4)) 7/4/2021AutoSave . Off HY ACC 201 Company Accounting Workbook Template Ramel T at File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Bad Good Neutral TIX _ AutoSum ~ Calibri 11 ~ A A E ab Wrap Text General Normal APO Fill Paste [ Copy E FEE Merge & Center $ ~ % 2 00 20 Conditional Format as Calculation Check Cell Explanatory ... Input usert Delete Format Sort & Find & Analyze Formatting Table v Clear Format Painter Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A1 X V fx This chart of accounts should help you identify the appropriate accounts to record to as you are analyzing and journaling transactions for this workbook. There is nothing to complete on this page; this is simply a resource for you. D G H M O P Q R S This chart of accounts should help you identify the appropriate accounts to record to as you are analyzing and journaling transactions for this workbook. There is nothing to complete on this page; this is simply a resource for you. w Asset Accounts Liability Accounts Equity Accounts Acct # Acct # Acct # 5 Cash 101 Notes Payable 201 Common Stock 301 6 Baking Supplies 102 Accounts Payable 202 Dividends 302 7 Prepaid Rent 103 Wages Payable 203 Cost of Goods Sold 303 8 Prepaid Insurance 104 Interest Payable 204 9 Baking Equipment 105 10 Office Supplies 106 11 Accounts Receivable 107 12 Accumulated Depreciation 108 13 Merchandise Inventory 109 Revenue Accounts 14 Acct # 15 Bakery Sales 401 16 Merchandise Sales 402 17 18 Expense Account Acct # Baking Supplies Expense 501 Rent Expense 502 Insurance Expense 503 Misc. Expense 504 Business License Expense 505 Advertising Expense 506 Wages Expense 507 Telephone Expense 508 OneDrive Interest Expense 509 Depreciation Expense 510 Screenshot saved Office Supplies Expense 511 The screenshot was added to your Chart of Accounts October Journal Entries November Journal Entries December Journal Entries T-Accounts - autofill Inventory Valuation OneDrive. Ready 2:40 PM Type here to search O 84'F Partly sunny ~ 9 (6 4) 7/4/2021AutoSave . Off) - GA ACC 201 Accounting Data Appendix 1 (1) - Word Ramel Takes File Home Insert Draw Design Layout References Mailings Review View Help Share Comments X Cut 12 ~ A" A Aa Ap Find ~ Calibri AaBbCcDc AaBbCcDc AaBbCcD AaBbCcD( AaBbCCD) 7/4/2021 2:44 PMAutoSave . Off) H 9 ACC 201 Company Accounting Workbook Template Ramel T at Share Comments File Home Insert Page Layout Formulas Data Review View Help _ AutoSum ~ & Cut Calibri 11 ~ A A = ab Wrap Text General Normal Bad Good Neutral AY O I Fill Paste [B Copy BIULA E E Merge & Center $ ~ % 9 00 20 Conditional Format as Calculation Check Cell Explanatory ... Input useit Delete Format Sort & Find & Analyze Clear Format Painter Formatting Table Filter ~ Select Data Cells Analysis Clipboard Font Alignment Number Styles Editing GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A22 X V Total B C D E F G H 1 J K L M N O P Q R S T U V W X A Company Post-Closing Trial Balance W I Qtr. Ending 12/31/20xx Unadjusted Trial Balance Account Debit Credit 6 7 Baking Supplies 8 Merchandise Inventory 9 Prepaid Rent 10 Prepaid Insurance 11 Baking Equipment 12 Accumulated Depreciation 13 Office Supplies 14 Accounts Receivable 15 Accounts Payab 16 Wages Payable 17 Interest Payable 18 Notes Payable 19 Common Stock 20 Retained Earnings 21 Total 23 24 25 26 28 ... Statement of Stockholder Equity Balance Sheet Closing Entries Post-Closing Trial Balance + " - 100% Ready O ? 2:39 PM Type here to search 84'F Partly sunny ~ g (76 () 7 7/4/2021AutoSave . Off HY ACC 201 Company Accounting Workbook Template Ramel T at File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut 2 AutoSum ~ Calibri 11 ~ A A = ab Wrap Text General 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 TIX AY O Paste [ Copy Fill E E Merge & Center $ ~ % 9 00 20 Conditional Format as |40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 nsert Delete Format Sort & Find & Analyze Format Painter Formatting Table Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more B7 X V fx Bakery Sales C D E F G H K L M N P Q R S T U V w X A Company Closing Entries UI A W I Qtr ending 12/31/20xx Date Accounts Debit Credit 31-Dec Bakery Sales Merchandise Sales Retained Earnings 10 31-Dec Retained Earnings 12 Baking Supplies Expense wi Rent Expense Wages Expense Office Supplies Expense Business License Expense Office Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense COGS 31-Dec Retained Earnings Dividends 29 30 31 P OneDrive Screenshot saved The screenshot was added to your Statement of Stockholder Equity Balance Sheet Closing Entries Post-Closing Trial Balance OneDrive. Ready Type here to search O ? 84'F Partly sunny ~ 9 (7 () 2:39 PM 7/4/2021AutoSave . Off) H 9 ACC 201 Company Accounting Workbook Template Ramel T 241 File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 13 ~ A" A ab Wrap Text General Heading 1 Heading 2 Heading 3 Heading 4 TIX _ AutoSum ~ AY O [ Copy Fill Paste Conditional Format as Title nsert Delete Format E Total 20% - Accent1 20% - Accent2 Sort & Find & Analyze $ ~ % 2 00 20 Format Painter BIULA E Merge & Center Formatting Table v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more E26 X V Total Liabilities & Equity C D E F G H K L M N P Q R S T U V A Company Balance Sheet A W N As of December 31, 20XX Assets Liabilities and Owners' Equity Current Assets: Current Liabilities: Total Current Liabilities 12 Long Term Liabilities: 13 14 Total Current Assets Total Long Term Liabilities: 15 16 Total Liabilities: 17 18 19 Shareholder's Equity: 20 21 Non-Current Assets: 22 23 Total Equity 4 Baking Equipment (Net) 25 6 Total Assets: Total Liabilities & Equity 27 29 30 31 OneDrive Screenshot saved The screenshot was added to your ... Statement of Stockholder Equity Balance Sheet Closing Entries Post-Closing Trial Balance OneDrive. Ready 2:39 PM Type here to search O 84'F Partly sunny ~ 9 (7 () 7/4/2021

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

Recommended Textbook for

Advanced Accounting

Authors: Gail Fayerman

1st Canadian Edition

978-1118037911

Students also viewed these Accounting questions