Answered step by step
Verified Expert Solution
Question
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
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
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