Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please create the Statement of Cash Flows - indirect method (fill in the highlighted cells) and fill in debit and credit on columns for income

Please create the Statement of Cash Flows - indirect method (fill in the highlighted cells) and fill in debit and credit on columns for income statement on the Worksheet.

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

A Byte of Accounting Statement of Cash Flows - Indirect Method For Year Ending December 31, 2018 Cash Flow from Operating Activities $ 29.675.14 $ 10,586.25 (6.187.00) (2.382.00) 2.225.00 Net Income Adjustments to reconcile net income to net cash flows from operating activities: Depreciation expenses Change in accounts receivable Increase in prepaid Insurance Change in prepaid rent Increase in supplies Decrease in inventory Change in payables" Change in income tax payable Net cash flows from operations Cash Flows from Investing Activities Purchase 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 Accounts Payable Advanced Payment Interest Payable Salaries Payable A Byte of Accounting, Inc. Income Statement For Year Ending December 31, 2018 Revenues Sales Revenue $ 449,062.00 Cost of Goods Sold $ 227,077.00 Gross Profit $ 221,985.00 Operating Expenses 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 $ 31.200.00 $ 104,720.00 $ 4,610.00 $ 15,055.00 $ 118.00 $ 8,392.39! $ 289 on $ 10,586.25 $ 1,447.50 $ 6,020.00 Total $ 182.418.14 Net Income Before Tax $ 39,566.86 Income Tax Expense Mund te lwe decimal pla $9,891.72 Net Income After Tax 29,675.14 A Byte of Accounting, Inc. Trial Balance As of November 30, 2018 Unadjusted Trial Balance Debit Credit 18.175.00 26,000.00 $ 600.00 2.600.00 2,700.00 64,100.00 6.100.00 Account Number I Name 1110 Cash 1120 Accounts Receivable 1121 Allowance for Doubtful Accounts 1130 Prepaid Insurance 11401 Prepaid Rent 1150 Supplies 1160 l inventory 1211 Office Equipment 1212 Accum. Depr.-Office Equip. 1311 Computer Equipment 1312 Accum. Depr.-Computer Equip. 2101 Accounts Payable 2102 Uneamed Revenue 2103 Interest Payable 2105 Salaries and Wages Payable 2106 Income Taxes Payable 2202 Notes Payable 3100 Common Stock 3120 Paid-In Capital in Excess of Par 3200 Retained Earnings 3300 Dividends 22,000.00 4,400.00 3.665.00 28.800.00 6,400.00 24.000.00 420.000.00 28,600.00 96,800.00 3,960.00 13,640.00 4100 Sales Revenue 5010 Rent Expense 5020 Salaries and Wages Expense 5030 Advertising Expense 5040 Maintenance & Repairs Expense 5080 Supplies Expense 5090 Interest Expense 5100 linsurance Expense 5110 Depreciation Expense 5120 Bad Debt Expense 5140 Telephone and Intemet Expense 5150 Income Tax Expense 5300 Cost of Goods Sold Total 5,390.00 210,000.00 493,965.00 493,965.00 A Byte of Accounting, Inc. Worksheet For Period Ending December 31, 2018 Income Statement Debit Credit Balance Sheet Debit Credit Adiusting Entries Debit Credit 25.00 - 8,105.00 - 1.447.50 269.00 Unadiusted Trial Balance Debit Credit 258,208.20 23,662.00 5,090.00 6,456.00 2.600.00 3,400.00 2.225.00 64,100.00 6.100.00 22,000.00 4.400.00 14.276.00 8,715.00 118.00 Account Number Name 1110 Cash 1120 Accounts Receivable 1121 Allowance for Doubtful Accounts 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Supplies 1160 Inventory 1211 Office Equipment 1212 Accum. Depr.-Office Equip. 1311 Computer Equipment 1312 Accum. Depr.-Computer Equip. 2101 Accounts Payable 2102 Unearned Revenue 2103 Interest Payable 2105 Salaries and Wages Payable 2106 lincome Taxes Payable 2202 Notes Payable 2210 Bond Payable 2212 Premium on Bond Payable 3100 Common Stock 31201 Paid-In Capital in Excess of Par 3200 Retained Earnings 3300 Dividends - 6,186.25 Adiusted Trial Balance Debit Credit 258,233.20 31.767.00 3.642.50 6,187.00 2.600.00 3,282.00 2.225.00 64,100.00 12,286.25 22,000.00 8.800.00 18.34 1.00 8,715.00 22.95 1.320.00 9,891.72 4.590.00 4.400.00 4,065.00 22.95 1.320.00 9.891.72 4,590.00 192,659,64 66.600.00 14.800.00 24,000.00 192,659.64 66.600.00 14.800.00 24,000.00 2,115.00 2,115.00 440,932.00 8.130.00 449,062.00 1,320.00 31,200.00 103.400.00 4.610.00 15,055.00 4 100 | Sales Revenue 50101 Rent Expense 5020 Salaries and Wages Expense 5030 Advertising Expense 5040 Maintenance & Repairs Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Bad Debt Expense 5140 Telephone and Internet Expense 5150 lincome Tax Expense 5300 Cost of Goods Sold 8,369.44 118.00 22.95 269.00 10,586.25 1,447.50 31,200.00 104.720.00 4.610.00 15.055.00 118.00 8.392.39 269.00 10.586.25 1.447.50 6.020.00 9,891.72 227,077.00 6,020.00 223,012.00 9,891.72 4,065.00 779,297.64 779,297.64 35,850.42 35,850.42 813,313.56 813,313.56 TOTAL NET INCOME Balance A Byte of Accounting Statement of Cash Flows - Indirect Method For Year Ending December 31, 2018 Cash Flow from Operating Activities $ 29.675.14 $ 10,586.25 (6.187.00) (2.382.00) 2.225.00 Net Income Adjustments to reconcile net income to net cash flows from operating activities: Depreciation expenses Change in accounts receivable Increase in prepaid Insurance Change in prepaid rent Increase in supplies Decrease in inventory Change in payables" Change in income tax payable Net cash flows from operations Cash Flows from Investing Activities Purchase 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 Accounts Payable Advanced Payment Interest Payable Salaries Payable A Byte of Accounting, Inc. Income Statement For Year Ending December 31, 2018 Revenues Sales Revenue $ 449,062.00 Cost of Goods Sold $ 227,077.00 Gross Profit $ 221,985.00 Operating Expenses 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 $ 31.200.00 $ 104,720.00 $ 4,610.00 $ 15,055.00 $ 118.00 $ 8,392.39! $ 289 on $ 10,586.25 $ 1,447.50 $ 6,020.00 Total $ 182.418.14 Net Income Before Tax $ 39,566.86 Income Tax Expense Mund te lwe decimal pla $9,891.72 Net Income After Tax 29,675.14 A Byte of Accounting, Inc. Trial Balance As of November 30, 2018 Unadjusted Trial Balance Debit Credit 18.175.00 26,000.00 $ 600.00 2.600.00 2,700.00 64,100.00 6.100.00 Account Number I Name 1110 Cash 1120 Accounts Receivable 1121 Allowance for Doubtful Accounts 1130 Prepaid Insurance 11401 Prepaid Rent 1150 Supplies 1160 l inventory 1211 Office Equipment 1212 Accum. Depr.-Office Equip. 1311 Computer Equipment 1312 Accum. Depr.-Computer Equip. 2101 Accounts Payable 2102 Uneamed Revenue 2103 Interest Payable 2105 Salaries and Wages Payable 2106 Income Taxes Payable 2202 Notes Payable 3100 Common Stock 3120 Paid-In Capital in Excess of Par 3200 Retained Earnings 3300 Dividends 22,000.00 4,400.00 3.665.00 28.800.00 6,400.00 24.000.00 420.000.00 28,600.00 96,800.00 3,960.00 13,640.00 4100 Sales Revenue 5010 Rent Expense 5020 Salaries and Wages Expense 5030 Advertising Expense 5040 Maintenance & Repairs Expense 5080 Supplies Expense 5090 Interest Expense 5100 linsurance Expense 5110 Depreciation Expense 5120 Bad Debt Expense 5140 Telephone and Intemet Expense 5150 Income Tax Expense 5300 Cost of Goods Sold Total 5,390.00 210,000.00 493,965.00 493,965.00 A Byte of Accounting, Inc. Worksheet For Period Ending December 31, 2018 Income Statement Debit Credit Balance Sheet Debit Credit Adiusting Entries Debit Credit 25.00 - 8,105.00 - 1.447.50 269.00 Unadiusted Trial Balance Debit Credit 258,208.20 23,662.00 5,090.00 6,456.00 2.600.00 3,400.00 2.225.00 64,100.00 6.100.00 22,000.00 4.400.00 14.276.00 8,715.00 118.00 Account Number Name 1110 Cash 1120 Accounts Receivable 1121 Allowance for Doubtful Accounts 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Supplies 1160 Inventory 1211 Office Equipment 1212 Accum. Depr.-Office Equip. 1311 Computer Equipment 1312 Accum. Depr.-Computer Equip. 2101 Accounts Payable 2102 Unearned Revenue 2103 Interest Payable 2105 Salaries and Wages Payable 2106 lincome Taxes Payable 2202 Notes Payable 2210 Bond Payable 2212 Premium on Bond Payable 3100 Common Stock 31201 Paid-In Capital in Excess of Par 3200 Retained Earnings 3300 Dividends - 6,186.25 Adiusted Trial Balance Debit Credit 258,233.20 31.767.00 3.642.50 6,187.00 2.600.00 3,282.00 2.225.00 64,100.00 12,286.25 22,000.00 8.800.00 18.34 1.00 8,715.00 22.95 1.320.00 9,891.72 4.590.00 4.400.00 4,065.00 22.95 1.320.00 9.891.72 4,590.00 192,659,64 66.600.00 14.800.00 24,000.00 192,659.64 66.600.00 14.800.00 24,000.00 2,115.00 2,115.00 440,932.00 8.130.00 449,062.00 1,320.00 31,200.00 103.400.00 4.610.00 15,055.00 4 100 | Sales Revenue 50101 Rent Expense 5020 Salaries and Wages Expense 5030 Advertising Expense 5040 Maintenance & Repairs Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Bad Debt Expense 5140 Telephone and Internet Expense 5150 lincome Tax Expense 5300 Cost of Goods Sold 8,369.44 118.00 22.95 269.00 10,586.25 1,447.50 31,200.00 104.720.00 4.610.00 15.055.00 118.00 8.392.39 269.00 10.586.25 1.447.50 6.020.00 9,891.72 227,077.00 6,020.00 223,012.00 9,891.72 4,065.00 779,297.64 779,297.64 35,850.42 35,850.42 813,313.56 813,313.56 TOTAL NET INCOME Balance

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

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant Datar, Madhav Rajan

16th Global Edition

1292211547, 9781292211541

More Books

Students also viewed these Accounting questions