Fill out the following statement . Beginning Balances as of Dec 31, Year 1

$ 1,757,000.00

Excel File Edit View Insert Format Tools Data Window Help Mon Apr 25 1:19 PM AutoSave OFF bu ... End of Semester Assignment - Student Template Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments X Century Gothic Insert v V 14 V Ai ab ab Wrap Textv Accounting V TIL MITI EM 7. D o V Delete v V Paste to v Av V V Merge & Center v $ v % 9 .00 0 Sensitivity Conditional Format Formatting as Table Cell Styles Sort & Filter Format v Find & Select Analyze Data 30 fx A D F G H L M 0 P a R U w Events Truck Equipment Notes Payable Revenue Net Income Cash 1,757,000.00 $ Acct Rec 17,500.00 $ Inventory 328,000.00 $ Expense Land 50,000.00 $ Building 250,000.00 APIC - CS Preferred Stock 600,000.00 $ 400,000.00 $ Accum Depr Acct Payable Div Payable $ 8,333.00 $ 418,000.00 $ 42,000.00 (42,000.00) Wages Payable Common Stock $ 215,000.00 $ 200,000.00 $ $ $ APIC - PS Retained Earnings 100,000.00 $ 419, 167.00 $ (42,000.00) $ 150,000.00 Beginning Balances as of Dec 31, Year 1 Paid a $42,000 cash dividend previously declared for stockholders Paid wages payable accrued in previous month Acquired $150,000 by signing a note payable with a local bank Sold 5,000 shares of $5 par Common Stock for $110,000 s Sold 2,000 shares of $40 par, 3% cumulative preferred stock for $120,000 Purchased a truck and piece of Equipment for $128,000. The truck has a market value of 6 65,000 and the equipment has a market value of 95,000. 7 Purchased 25,000 Units of Inventory on Account for $8.15 per unit 8 Sold 45,000 units at $24.50 on Account - Revenue 9 COGS on sale of 45000 units Lo Collect $570,000 on Account Paid $540,250 of Accounts Payable Purchased 70,000 units of Inventory on Account for $8.50 per unit Sold 75,000 units at $24.50 on Account 4 Record COGS for Sales of 75,000 units on Account 5 Collect $1,472,500 on Account 6 Paid $438,500 of Accounts Payable Purchased 115,000 Units of Inventory on Account for $9.35 per unit & Sold 102,000 units at $24.50 Record COGS for Sale of 102,000 units Collect $735,000 on Account 1 Paid $883, 150 of Accounts Payable Purchased 175,000 units of Inventory on Account for $8.75 per unit Paid Advertising and Marketing Expenses of $130,000 4 Paid Fixed Operating Expenses of $275,708 Paid Wages of $1,235,000 6 Record Wages Payable of $215,000 7 Paid Product Line Research & Development Expenses of $450,000 8 Principle & Interest on Note Payable 9 Year 1 Depreciation on Truck 0 Year 1 Depreciation on Equipment Year 2 Depreciation on Building Common Stock Dividend Declaration Preferred Stock Dividend Declaration Balance at December 31, Yr 2 NE Total Assets Total Liabilities & Equity Accounting Equation Inventory Tracking Budget Template Income Statement Balance Sheet Stockholders' Equity Cash Flow + Ready . + 46% 16 APR 2 162 Up S ty 25 ALUTZVUD UVEY ORAL AMUS ragua VEEKIDSUUWIOL A A X O W 280