Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am having difficulties getting my statement of cash flows to reconcile to the correct number of $1,291,175. Here are the required documents. If someone

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

I am having difficulties getting my statement of cash flows to reconcile to the correct number of $1,291,175. Here are the required documents. If someone could point me in the right direction that would be great!

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Adjusted Trial Balance December 31, 2021 Acc - 1 Description DR CR 100 Cash 3,310,788.00 101 Accounts Receivable 1,756,720.00 102 Allowance for Doubtful Accounts 35,134.40 103 Short-term Investments 14,000.00 104 Fair Value Adjustment-ST 1,500 105 Inventory 933,104.10 106 Prepaid Insurance 43,750.00 107 Supplies 5,016.00 110 Available-for-sale Investments 483,800.00 111 Fair Value Adjustment-AFS 5,200.00 120 Land 1,135,000.00 121 Building 3,000,000.00 122 Accumulated Depreciation-Building 346,154.08 123 Machinery 850,000.00 124 Accumulated Depreciation Machinery 183,300.00 125 Equipment 650,000.00 126 Accumulated Depreciation Equipment 203,923.85 127 Truck 56,500.00 128 Accumulated Depreciation Truck 48,166.56 130 Right-of-use Asset 500,000.00 175 Patents 55,000.00 201 Accounts Payable 358,598.10 202 Salaries Payable 1,722,000.00 203 Utilities Payable 9,000.00 204 Payroll Taxes Payable 33,990.00 205 Interest Payable 50,750.00 206 Dividends Payable 350,000.00 207 Note Payable -short term 150,000.00 208 Income Tax Payable 190,247.00 220 Lease Liability 417,250.00 221 Note Payable -long term 454,500.00 225 Bond Payable 2,500,000.00 226 Discount on Bond Payable 128,224.00 Common Stock, $1 par, $1M shares authorized; 235,000 shares issued and 301 outstanding 295,000.00 302 APIC Common Stock 4,463,193.00 303 Retained Earnings 695,590.00 304 Unrealized Gains (Losses) Equity 5200 305 Unearned Compensation 157,777.78 306 Treasury Stock 71,500.00 307 APIC Treasury Stock 25,000.00 401 Sales 8,186,460.00 500 Cost of Goods Sold 4,550,000.00 600 Compensation Expense 2,222.22 601 Salaries Expense 2,045,000.00 602 Bad Dept Expense 23,734.40 605 Payroll Tax Expense 88,990.00 606 Advertisting Expense 125,000.00 607 Insurance Expense 121,250.00 608 Supplies Expense 22,989.00 609 Depreciation Expense 277,679.48 610 Amortization Expense 5,000.00 611 Utilities Expense 9,000.00 612 Miscellaneous Expenses 9,300.00 614 Interest Expense 126,165.00 615 Income Tax Expense 164,247.00 617 Realized Gains (Losses) 3,500.00 620 Unrealized Gains (Losses) Income 1,500.00 Totals 20,728,456.98 20,728,456.98Comparative Balance Sheet 31-Dec-21 2021 2020 ASSETS Current Assets Cash $ 3,310,788.00 $ 1,646,663 Accounts Receivable $ 1,756,720.00 879,500 Less: Allowance for Doubtful Accounts $ (35,134.40) (30,000) Short-term Investments 14,000.00 14,000 Fair Value Adjustment-ST (1,500.00) Inventory 933,104.10 2,400,000 PPD Insurance 43,750.00 50,000 Supplies 5,016.00 3,600 Total Current Assets $ 6,026,743.70 $ 4,963,763 Property, Plant, & Equipment Land $ 1,135,000.00 1,135,000 Building $ 3,000,000.00 3,000,000 Less: Accumulated Dep. Building $ (346,154.08) (269,231) Machinery 850,000.00 850,000 Less: Accumulated Dep. Machinery $ (183,300.00) (14,100) Equipment $ 650,000.00 260,000 Less: Accumulated Dep. Equip. S (203,923.42) (184,923) Del. Truck 56,500.00 56,500 Less: Accumulated Dep. Truck (48,167.00) (42,611) Property, Plant, & Equipment (Net) S 4,909,955.51 $ 4,790,635.00 Long-term Investments Available for Sale Investments 483,800.00 100,000 Fair Value Adjustment-AFS in in in 5,200.00 15,000 489,000.00 115,000 Intangible Assets Patents $ 55,000.00 60,000 Other Non-current Assets Right of use Asset $ 500,000.00 Total Assets $ 11,980,699.21 $ 9,929,398.00 Current Liabilities A/P $ 358,598.10 1,141,754 Salaries Payable $ 1,722,000.00 1,177,000 Utilities Payable 9,000.00 11,000 Payroll Taxes Payable 33,990.00 73,000 Interest Payable 50,750.00 13,000 Dividends Payable 350,000.00 400,000 Note Payable-Short Term 150,000.00 50,000 Income Tax Payable 190,247.28 126,000 Total Current Liabilities $ 2,864,585.38 2,991,754 Long Term Liabilities Lease Liability $ 417,250.00 Note Payable-Long Term S 454,500.00 500,000 Bond Payable $ 2,500,000.00 2,500,000 Discount on Bond Payable S (128,224.00) $ (146,139) Total Long Term Liabilities $ 3,243,526.00 2,853,861 Total Liabilities $ 6,108,111.38 $ 5,845,615 Stockholders' Equity Common Stock, $1 par, $1M Shares Authorized; 295,000 Shares Issued and 279,500 shares Outstanding 295,000.00 200,000 Additional Paid in Capital - Common Stock $ 4,463,193.00 2,823,193 RE $ 1,313,472.61 1,045,590 Unrealized gain(loss) Available for Sale Securities 5,200.00 15,000 Less: Unearned Compensation 157,777.78 Less: Treasury Stock (net) 46,500.00 Total Stockholders' Equity $ 5,872,587.83 4,083,783 Total Liabilities and Stockholders' Equity $ 11,980,699.21 $ 9,929,398.00Multiple-Step Income Statement For the Year Ended December 31, 2021 Sales 8,186,460.00 Cost of Goods Sold 4,550,000.00 Gross Profit 3,636,460.00 Less Operating Expenses Selling & Distribution Expense Advertisting Expense S 125,000.00 General and Administrative Expenses Compensation Expense 2,222.22 Salaries Expense $ 2,045,000.00 Bad Dept Expense 23,734.40 Payroll Tax Expense 88,990.00 Insurance Expense 121,250.00 Supplies Expense 22,989.00 Depreciation Expense 277,679.48 Amortization Expense 5,000.00 Utilities Expense 9,000.00 Miscellaneous Expenses 9,300.00 Total General & Administrative Expenses 2,730,165.11 Operating Income (Loss) 306,294.89 Realized Gains (Losses) 3,500.00 Unrealized Gains (Losses) Income 1,500.00 2,000.00 Earnings Before Interest and Taxes 908,294.89 Interest Expense 126,165.00 Earnings Before Taxes 782,129.89 Income Tax Expense 164,247.00 Net Income 617,882.89Statement of Cash Flows For the Year Ended December 31, 2021 Operating Activities Net Income 617,882.89 Adjustments to reconcile net income to net cash provided by operating activities Depreciation Expense 277,679.48 Gain on Sale of Equipment (3,500.00) Changes in Current Accounts Compensation Expense (2,222.22) Increase in Accounts Receivable (877,220.00) Allowance for Doubtful Accounts (5,134.40) Fair Value Adjustment-ST 1,500.00 Decrease in Inventory $1,466,895.90 Decrease in prepaid expenses (6,250.00) Supplies (1,416.00) Decrease in accounts payable (783,155.90) Salaries Payable 545,000.00 Utilities Payable (2,000.00) Payroll Taxes Payable (39,010.00) Interest Payable 37,750.00 Dividends Payable (50,000.00) Note Payable-Short Term 100,000.00 Income Tax Payable 64,247.28 Net cash provided by operating activities $ 1,341,047.03 Investing Activities Available for sale investments 383,800.00 Fair Value Adjustment-AFS 9,800.00 Purchase of Equipment S (390,000.00) Net cash provided by investing activities $ 3,600.00 Financing Activities Lease Liability 417,250.00 Common Stock Issued 95,000.00 Note Payable - Long Term 45,500.00 Discount on Bond Payable (17,915.00) Retained Earnings (350,000.00) Treasury Stock 71,500.00 Net Cash Provided by Financing Activities $ 189,835.00 Net Increase in Cash $ 1,664,125.00 Beginning Cash $ 1,646,663.00 Ending Cash $ 3,310,788.00

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

Financial Accounting

Authors: Jeffrey Waybright, Robert Kemp, Sherif Elbarrad

2nd Canadian edition

133375536, 9780133845396, 133845397, 978-0133375534

More Books

Students also viewed these Accounting questions

Question

=+b) Find the predicted value for the year 2012. Is it realistic?

Answered: 1 week ago