Please answer on Excel and provide with formula.
BOB Drop Boxes - X Probability o X Homework | X The Map Sur X The Map Sur X Microsoft W X Bb Week 3: Lect X Cash Flow St X + X CO File | C:/Users/DELL/Documents/ACC_1010/The%20Map%20Summer%202020.pdf G W. i Apps R Rewordify.com | Un... = CV Example | Stude... MKT Thi bang lai xe az cite aiesec apt du hoc LOB COB law vocab > > Other bookmarks #8 Cash Flow Homework Problem 18 From the following information for Declan's Doodads, prepare a Statement of Cash Flows for the year ended December 31, 20Y2. Balance Balance 12/31/Y2 12/31/Y1 Cash 95,900 38,900 Accounts Receivable 78,000 45,000 Inventory 70,000 90,000 Prepaid Insurance 3,600 2,600 Equipment 320,000 280,000 Accumulated Depreciation 80,000 20,000 Land 130,000 Security Deposits 32,000 20,000 Accounts Payable 39,000 30,000 Wages Payable 2,000 10,000 Rent Payable 12,000 4,000 Interest Payable 6,500 7,500 Taxes Payable 10,000 5,000 Note Payable 130,000 150,000 Common Stock ($1 each) 310,000 160,000 Retained Earnings 140,000 90,000 Sales 1,200,000 Cost of Goods Sold 700,000 Wage Expense 220,000 Rent Expense 48,000 Office Expenses 46,000 Type here to search O 9 ENG 6:41 PM 6/2/2020BOB Drop Boxes - X Probability o x *Homework | X The Map Sur X The Map Sur X Microsoft W X Bb Week 3: Lect X Cash Flow St X + X CO File | C:/Users/DELL/Documents/ACC_1010/The%20Map%20Summer%202020.pdf G W. h : AF MKT az cite alesec apt du hoc BOB COB law vocab > Other bookmarks Problem 29 From the following information for Brayden's Bobbles, prepare a Statement of Cash Flows for the year ended December 31, 20Y2. Balance Balance 12/31/Y2 12/31/Y1 Cash 90,000 25,000 Accounts Receivable 68,000 35,000 Inventory 70,000 90,000 Prepaid Insurance 500 3,000 Equipment 340,000 270,000 Accumulated Depreciation 80,000 20,000 Land 120,000 Security Deposits 12,000 10,000 Accounts Payable 45,000 35,000 Wages Payable 6,000 10,000 Rent Payable 7,500 Interest Payable 6,000 6,000 7,000 Taxes Payable 16,000 5,000 Note Payable 120,000 140,000 Common Stock ($1 each) 300,000 160,000 Retained Earnings 120,000 50,000 Sales 1,200,000 Cost of Goods Sold 575,000 Wage Expense 260,000 Rent Expense 24,000 Office Expenses 70,000 Depreciation Expense 60,000 Advertising Eynence 15 000 Type here to search O 9 X O ENG 6:42 PM 6/2/2020BOB Drop Boxes - X Probability o X Homework | X The Map Sur X The Map Sur X Microsoft W X Bb Week 3: Lect X Cash Flow St X + X CO File | C:/Users/DELL/Documents/ACC_1010/The%20Map%20Summer%202020.pdf G W. i Apps R Rewordify.com | Un... @ CV Example | Stude... MKT Thi bang lai xe az cite alesec apt du hoc COB law vocab > > Other bookmarks Accounts Payable 45,000 35,000 Wages Payable 6,000 10,000 Rent Payable 7,500 6,000 Interest Payable 6,000 7,000 Taxes Payable 16,000 5,000 Note Payable 120,000 140,000 Common Stock ($1 each) 300,000 160,000 Retained Earnings 120,000 50,000 Sales 1,200,000 Cost of Goods Sold 575,000 Wage Expense 260,000 Rent Expense 24,000 Office Expenses 70,000 Depreciation Expense 60,000 Advertising Expense 15,000 Insurance Expense 9,000 Interest Expense 13,000 Income Tax Expense 52,000 The equipment was acquired on September 30, 20Y2 for cash. The additional common stock was sold on June 30, 20Y2 for $1 per share. The company did not sell any equipment during the year. The land purchased during the year was purchased for cash. The retained earnings balance for both years is after all closing entries have been made. The Note Payable requires payments of $20,000 principal plus interest at 10% on June 30th of each year. Type here to search O em G O ENG 6:42 PM 6/2/2020
