Cyber Text

A D 1 ] K 1 E F G H 1 Sue The Light Projected Income Statement For the Period Ending December 31, 20x1 $1,125,000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $30.00 Gross Profit Selling Expenses: Fixed Variable (Commission per unit) $3.00 Administrative Expenses Fixed Variable @ $2.00 Total Selling and Administrative Expenses: Net Profit $23,000.00 75,000.00 $ 98,000.00 $42,000.00 50,000.00 92.000.00 190,000.00 185,000.00 I See The Light Projected Balance Sheet As of December 31, 20x1 22 ggggggggggggg o go on on untu $ 34,710.00 67,500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 8,000.00 500 @ $16.00 0 3000 @ $30.00 90,000.00 $ 200,210.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assels $ 20,000.00 6,800.00 104 105 13.200.00 $ 213,410.00 54,000.00 $ 54,000.00 106 107 108 118 119 120 121 122 132 133 134 135 136 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Relained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147.410.00 159,410.00 $ 213,410.00 A1 82 A 3 A4 A5 A = Introduction FAQ Calculation Mode: Automatic Workbook Statistics