Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, I posted the above financial statements in order to help you complete the statement of cash flows which is the last picture on the

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

Hello, I posted the above financial statements in order to help you complete the statement of cash flows which is the last picture on the bottom. Thanks for the help I am struggling and really appreciate it.

Anal Accounting X Cut Lo Copy Format Painter 10 - AA = = = 29 Wrap Text CA E Merge Center BTU $ - % 9 Clipboard Font Alignment Number 28 f D G Worksheet For Period Ending December 31, 2020 Debit Income Statement Debit Credit Balance Sheet Debil Credit Account Unadjusted Trial Balance Number Name Credit 1110 Cash 308 201 20 1120 Accounts Receivable 11 189.00 112 Allowance for Doubtful Account 500.00 1130 Prepaid Insurance 6/360.00 1140 Prepaid Rent 2200 00 1150 Supplies 2,950.00 110 inventory 3.890.00 1211 Omce Equipment 65,600 00 1212 Accum Deprmce Equip 5800 00 1311 Computer Equipment 22.500.00 1312 Acum Depre Computer Equip 4.500.00 2101 Accounts Payable 14055 00 2102 Uneamed Revenue 7.955.00 2103 Interest Payable 2105 Salanes and Wages Payable 2106 Income Taxes Payable 2202 Notes Payable 4,050,00 2210 Bond Payable 2212 Premium on Bond Payable 12,051 18 3100 Common Stock 87 500.00 3120 Paid in Capital in Excess of Pa 31,500.00 3200 Retained Earnings 24,000.00 3300 Dividends 1.925 00 Adjunting Entries Adjusted that Balance Debit Credit Debit Credit 25.00 WWW 9.605.00 20.794 00 1039.70 1,039 70 795 00 5565 00 22300.00 78200 2,168 00 3,898.00 55,600.00 5050 11,660 35 22 500.00 4500.00 9,000,00 4,815 00 18.870.00 7,965.00 1/350.00 883799 243.00 1,350,00 8.837 99 4,29300 WWW 12,051 18 87.500.00 3150000 24,000.00 1925.00 27 600.00 4100 Sales Revenue 9,630 00 5010 Rent Expense 27 600.00 5020 Salaries and Wages Expenses 105x750.00 1.350.00 5030 Advertising Expense 481000 5040 Maintenance & Repairs Expens 14.905 00 5080 Supplies Expense 78200 5090 interest Expense 11.260.98 243 00 5100 insurance Expense 79500 5110 Depreciation Expense 103605 1 5120 Bad Debt Expense 478.00 1.039.70 5140 Telephone and internet Expens 6.020.00 5150 Income Tax Expense 8,837 99 4 5300 Cost of Boods Sold 224.5 12.00 4815:00 5 5 -7 TOTA 816,361 18 37,863.04 37 853.04 General Journal Worksheet Income Statement Ready 4.810.00 14,905,00 1782.00 11503.98 795,00 10,360,35 151770 5.020.00 8,837.99 IT 4 Stockholders Equity Balance Sheet Cash Flow Pos Type here to search EM . ace Format Painter Clipboard Font Alignment C23 fr =VLOOKUP(A23,Chart_of_Accounts,2,FALSE) A B E 2 3 C D Income Statement For Year Ending December 31, 2020 4 5 6 Revenues Sales Revenue 450,072.00 Cost of Goods Sold 229,327.00 Gross Profit $ 220,745.00 7 8 9 10 11 12 13 14 15 16 17 18 Operating Expenses 19 Rent Expense Salaries and Wages Expense Advertising Expense Maintenance & Repairs Expense Supplies Expense Interest Expense Insurance Expense Depreciation Expense Bad Debt Expense Telephone and Internet Expense $ 27 600.00 107,100.00 4,810.00 14,905.00 782.00 11,503.98 795.00 10,360.35 1,517.70 6,020.00 20 21 22 23 24 25 26 27 28 29 30 31 32 Total 185,393.05 Net Income Before Tax $ 35,351.95 Income Tax Expense Round to two decimal places) 8,837 99 Net Income After Tax General Journal Worksheet $ Income Statement 26,513.96 Stockholders Equity Balance Sheet Ready Type here to search BI B Font Alignment B C Balance Sheet As of December 31, 2020 Assets 308 226:20 5 20,794 00 1,639.70 Current Assets Cash Accounts Receivable Allowance for Doubtful Accounts Net Receivable Prepaid insurance Prepaid Rent Supplies Inventory Total 19,154 30 5,565.00 230000 2,158.00 3,898.00 341,31150 15 65.600.00 11,660.35 53,939.65 Long Term Assets Office Equipment Accum. Dept. office Equip Net Omce Equipment Computer Equipment Accum Depr Computer Equip Net Computer Equipment Total Total Assets $ 22,500.00 9,000.00 13,500.00 67.439.65 5 408,751 15 Liabilities $ 18.870.00 7,965.00 Current Liabilities Accounts Payable Uneared Revenue Interest Payable Salaries and Wages Payable Income Taxes Payable Total 1,350.00 8,83799 5 37,022.99 $ 4.293.00 S 180,000.00 12,051.18 Long-Term Liabilities Notes Payable Bond Payable Premium on Bond Payable Net Bond Payable Total Total Liabilities General Journal 192,051.18 195,344.18 233,367 17 Stockholders Equity $ Income Statement Worksheet Balance Sheet Type here to search B JX B D Total E 341 31150 65,600.00 11,660.35 Long-Term Assets Office Equipment Accum. Depr.-Office Equip Net Office Equipment Computer Equipment Accum Depr.-Computer Equip Net Computer Equipment Total Total Assets 5 53,939.65 $ 22,500.00 9,000.00 13,500.00 67 439.65 408,751.15 5 Liabilities 5 Current Liabilities Accounts Payable Uneamed Revenue Interest Payable Salaries and Wages Payable Income Taxes Payable Total 18,870.00 7 965.00 1,350.00 8.837.99 37,022.99 S 4.293.00 $ Long-Term Liabilities Notes Payable Bond Payable Premium on Bond Payable Net Bond Payable Total Total Liabilities 180.000.00 12051.18 192,051.18 196,344 18 233,367.17 $ Stockholder's Equity $ Paid in Capital Common Stock Paid-In Capital in Excess of Par Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity 87 500.00 31,500.00 56,383 98 175,383.98 408,75115 $ General Journal Worksheet Income Statement Stockholders Equity Balance Sheet O Type here to search O Ei B C D A Byte of Accounting Statement of Cash Flows - Indirect Method For Year Ending December 31, 2020 Cash Flow from Operating Activities Net Income Adjustments to reconcile net income to net cash flows from operating activities Depreciation expenses Change in accounts receivable Change in prepaid Insurance Change in prepaid rent Change in supplies Change in inventory Change in payables Change in income tax payable Net cash flows from operations Cash Flows from Investing Activities Purchase of of equipment Net cash flows from investing activities Cash Flows from Financing Activities Issuance of common stock Proceeds from issuance of bonds payable Payment of cash dividends Net cash flows from financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period Noncash Activities Purchased equipment by Issuing note payable "Change in payables General Journal Worksheet Income Statement Stockholders Equity Balance Sheet Cash ady Type here to search O Anal Accounting X Cut Lo Copy Format Painter 10 - AA = = = 29 Wrap Text CA E Merge Center BTU $ - % 9 Clipboard Font Alignment Number 28 f D G Worksheet For Period Ending December 31, 2020 Debit Income Statement Debit Credit Balance Sheet Debil Credit Account Unadjusted Trial Balance Number Name Credit 1110 Cash 308 201 20 1120 Accounts Receivable 11 189.00 112 Allowance for Doubtful Account 500.00 1130 Prepaid Insurance 6/360.00 1140 Prepaid Rent 2200 00 1150 Supplies 2,950.00 110 inventory 3.890.00 1211 Omce Equipment 65,600 00 1212 Accum Deprmce Equip 5800 00 1311 Computer Equipment 22.500.00 1312 Acum Depre Computer Equip 4.500.00 2101 Accounts Payable 14055 00 2102 Uneamed Revenue 7.955.00 2103 Interest Payable 2105 Salanes and Wages Payable 2106 Income Taxes Payable 2202 Notes Payable 4,050,00 2210 Bond Payable 2212 Premium on Bond Payable 12,051 18 3100 Common Stock 87 500.00 3120 Paid in Capital in Excess of Pa 31,500.00 3200 Retained Earnings 24,000.00 3300 Dividends 1.925 00 Adjunting Entries Adjusted that Balance Debit Credit Debit Credit 25.00 WWW 9.605.00 20.794 00 1039.70 1,039 70 795 00 5565 00 22300.00 78200 2,168 00 3,898.00 55,600.00 5050 11,660 35 22 500.00 4500.00 9,000,00 4,815 00 18.870.00 7,965.00 1/350.00 883799 243.00 1,350,00 8.837 99 4,29300 WWW 12,051 18 87.500.00 3150000 24,000.00 1925.00 27 600.00 4100 Sales Revenue 9,630 00 5010 Rent Expense 27 600.00 5020 Salaries and Wages Expenses 105x750.00 1.350.00 5030 Advertising Expense 481000 5040 Maintenance & Repairs Expens 14.905 00 5080 Supplies Expense 78200 5090 interest Expense 11.260.98 243 00 5100 insurance Expense 79500 5110 Depreciation Expense 103605 1 5120 Bad Debt Expense 478.00 1.039.70 5140 Telephone and internet Expens 6.020.00 5150 Income Tax Expense 8,837 99 4 5300 Cost of Boods Sold 224.5 12.00 4815:00 5 5 -7 TOTA 816,361 18 37,863.04 37 853.04 General Journal Worksheet Income Statement Ready 4.810.00 14,905,00 1782.00 11503.98 795,00 10,360,35 151770 5.020.00 8,837.99 IT 4 Stockholders Equity Balance Sheet Cash Flow Pos Type here to search EM . ace Format Painter Clipboard Font Alignment C23 fr =VLOOKUP(A23,Chart_of_Accounts,2,FALSE) A B E 2 3 C D Income Statement For Year Ending December 31, 2020 4 5 6 Revenues Sales Revenue 450,072.00 Cost of Goods Sold 229,327.00 Gross Profit $ 220,745.00 7 8 9 10 11 12 13 14 15 16 17 18 Operating Expenses 19 Rent Expense Salaries and Wages Expense Advertising Expense Maintenance & Repairs Expense Supplies Expense Interest Expense Insurance Expense Depreciation Expense Bad Debt Expense Telephone and Internet Expense $ 27 600.00 107,100.00 4,810.00 14,905.00 782.00 11,503.98 795.00 10,360.35 1,517.70 6,020.00 20 21 22 23 24 25 26 27 28 29 30 31 32 Total 185,393.05 Net Income Before Tax $ 35,351.95 Income Tax Expense Round to two decimal places) 8,837 99 Net Income After Tax General Journal Worksheet $ Income Statement 26,513.96 Stockholders Equity Balance Sheet Ready Type here to search BI B Font Alignment B C Balance Sheet As of December 31, 2020 Assets 308 226:20 5 20,794 00 1,639.70 Current Assets Cash Accounts Receivable Allowance for Doubtful Accounts Net Receivable Prepaid insurance Prepaid Rent Supplies Inventory Total 19,154 30 5,565.00 230000 2,158.00 3,898.00 341,31150 15 65.600.00 11,660.35 53,939.65 Long Term Assets Office Equipment Accum. Dept. office Equip Net Omce Equipment Computer Equipment Accum Depr Computer Equip Net Computer Equipment Total Total Assets $ 22,500.00 9,000.00 13,500.00 67.439.65 5 408,751 15 Liabilities $ 18.870.00 7,965.00 Current Liabilities Accounts Payable Uneared Revenue Interest Payable Salaries and Wages Payable Income Taxes Payable Total 1,350.00 8,83799 5 37,022.99 $ 4.293.00 S 180,000.00 12,051.18 Long-Term Liabilities Notes Payable Bond Payable Premium on Bond Payable Net Bond Payable Total Total Liabilities General Journal 192,051.18 195,344.18 233,367 17 Stockholders Equity $ Income Statement Worksheet Balance Sheet Type here to search B JX B D Total E 341 31150 65,600.00 11,660.35 Long-Term Assets Office Equipment Accum. Depr.-Office Equip Net Office Equipment Computer Equipment Accum Depr.-Computer Equip Net Computer Equipment Total Total Assets 5 53,939.65 $ 22,500.00 9,000.00 13,500.00 67 439.65 408,751.15 5 Liabilities 5 Current Liabilities Accounts Payable Uneamed Revenue Interest Payable Salaries and Wages Payable Income Taxes Payable Total 18,870.00 7 965.00 1,350.00 8.837.99 37,022.99 S 4.293.00 $ Long-Term Liabilities Notes Payable Bond Payable Premium on Bond Payable Net Bond Payable Total Total Liabilities 180.000.00 12051.18 192,051.18 196,344 18 233,367.17 $ Stockholder's Equity $ Paid in Capital Common Stock Paid-In Capital in Excess of Par Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity 87 500.00 31,500.00 56,383 98 175,383.98 408,75115 $ General Journal Worksheet Income Statement Stockholders Equity Balance Sheet O Type here to search O Ei B C D A Byte of Accounting Statement of Cash Flows - Indirect Method For Year Ending December 31, 2020 Cash Flow from Operating Activities Net Income Adjustments to reconcile net income to net cash flows from operating activities Depreciation expenses Change in accounts receivable Change in prepaid Insurance Change in prepaid rent Change in supplies Change in inventory Change in payables Change in income tax payable Net cash flows from operations Cash Flows from Investing Activities Purchase of of equipment Net cash flows from investing activities Cash Flows from Financing Activities Issuance of common stock Proceeds from issuance of bonds payable Payment of cash dividends Net cash flows from financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period Noncash Activities Purchased equipment by Issuing note payable "Change in payables General Journal Worksheet Income Statement Stockholders Equity Balance Sheet Cash ady Type here to search O

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

College Accounting, Chapters 1-27

Authors: James A. Heintz, Robert W. Parry

21st Edition

1285055411, 9781285055411

More Books

Students also viewed these Accounting questions

Question

6. List and explain important trends in compensation management.

Answered: 1 week ago

Question

What are our strategic aims?

Answered: 1 week ago