Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

PLEASE HELP! using the following information can you help me fill out these excel sheets? thank you!!! only the green highlighed areas need answers C

PLEASE HELP! using the following information can you help me fill out these excel sheets? thank you!!! only the green highlighed areas need answers
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
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
image text in transcribed
C Jan. Journal Entries Check worsheet: Double check Total Debits = Total Credits Check that Assets - Liabilities - Common Stock - Revenue - Expenses - Dividends \\( =0 \\) Your Company Statement of Stockholders' Equity For Period Ending February 28th 2023 Febo Journal Entries Feb. Journal Entries Your Company - Balance Sheet For Period Ending February 28th 2023 Current Assets Cash update for cash accounts ending balance Accounts Receivable Less: (Allowance for Uncollectible Accounts) Inventory Supplies Pre-Paid Rent (Feb) Total Current Assets Long-Term Assets Land Equipment Buildings Less: (Accumulated Depreciation) Patent 6 Total Long-Term Assets 1 Total Assets 2 Carrent Liabilities Accounts Payable Salaries Payable Deferred/Unearned Revenue Interest Payable Utilities Payable Income Tax Payable Total Current Liabilities Long-Term Liabilities Notes Payable - Long Term 2. Total Long-Term Liabilities 1 Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities \\& Stockholder's Equity 18 Does A-L+S/E Yes 3 January Journal Entries Your Company Income Statement For Period Ending February 28th 2023 Sales Revenue Sales Revenue (Sales Discounts) (Sales Return \\& Allowances) Net Sales Cost of Goods sold (Cost of Goods Sold) Gross Profit Service Revenue Gross Margin + Service Revenue Operating Expenses (Supplies Expense) (Salaries Expense) (Utilities Expense) (Misc. Expense) (Rent Expense) (Depreciation Expense) (Bad Debt Expense) (Research \\& Development Expense) Total Operating Expenses Operating Income Income/(Loss) from Operations (Interest Expense) (Loss) Net Income Before Tax (Income Tax Expense) 20\\% of Net Income Net Income/(Loss) 1.00 1 \\begin{tabular}{l} - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ \\hline- \\\\ \\hline \\end{tabular} \\( \\begin{array}{r}- \\\\ \\hline(3,998.00) \\\\ \\hline \\hline(3,998.00) \\\\ \\hline\\end{array} \\) You can only click on and enter data in unprotected cells Feb. Journal Entries Expenses 3) T-Accounts for Printing 4) Financial Statements 11 Expenses Continued 3) T-Accounts for Printing 4) Financial Statements C Jan. Journal Entries Check worsheet: Double check Total Debits = Total Credits Check that Assets - Liabilities - Common Stock - Revenue - Expenses - Dividends \\( =0 \\) Your Company Statement of Stockholders' Equity For Period Ending February 28th 2023 Febo Journal Entries Feb. Journal Entries Your Company - Balance Sheet For Period Ending February 28th 2023 Current Assets Cash update for cash accounts ending balance Accounts Receivable Less: (Allowance for Uncollectible Accounts) Inventory Supplies Pre-Paid Rent (Feb) Total Current Assets Long-Term Assets Land Equipment Buildings Less: (Accumulated Depreciation) Patent 6 Total Long-Term Assets 1 Total Assets 2 Carrent Liabilities Accounts Payable Salaries Payable Deferred/Unearned Revenue Interest Payable Utilities Payable Income Tax Payable Total Current Liabilities Long-Term Liabilities Notes Payable - Long Term 2. Total Long-Term Liabilities 1 Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities \\& Stockholder's Equity 18 Does A-L+S/E Yes 3 January Journal Entries Your Company Income Statement For Period Ending February 28th 2023 Sales Revenue Sales Revenue (Sales Discounts) (Sales Return \\& Allowances) Net Sales Cost of Goods sold (Cost of Goods Sold) Gross Profit Service Revenue Gross Margin + Service Revenue Operating Expenses (Supplies Expense) (Salaries Expense) (Utilities Expense) (Misc. Expense) (Rent Expense) (Depreciation Expense) (Bad Debt Expense) (Research \\& Development Expense) Total Operating Expenses Operating Income Income/(Loss) from Operations (Interest Expense) (Loss) Net Income Before Tax (Income Tax Expense) 20\\% of Net Income Net Income/(Loss) 1.00 1 \\begin{tabular}{l} - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ - \\\\ \\hline- \\\\ \\hline \\end{tabular} \\( \\begin{array}{r}- \\\\ \\hline(3,998.00) \\\\ \\hline \\hline(3,998.00) \\\\ \\hline\\end{array} \\) You can only click on and enter data in unprotected cells Feb. Journal Entries Expenses 3) T-Accounts for Printing 4) Financial Statements 11 Expenses Continued 3) T-Accounts for Printing 4) Financial Statements

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: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions