Hello,

I need to identify what is the common stock, additional paid-in-capital, treasury stock, and retained earnings for year end 20x2.

The year end balance sheet for 20x1 included below:

Assets Current assets Cash and equivalents Short term investments Net receivables Inventories Other current assets Total current Non-current assets Long term investments Net property, plant and equipment Other assets Total noncurrent Total assets 48,230,500 45,050,000 11,455,000 11,250,000 6,843,000 I 64,257,000 .| 45,124,000 7,935,000 ABC Company Balance Sheet Year end 12/31/20X1 Liabilities 8: Shareholders Equity Current liabilities Accounts payable Warranties Accrued expenses Other current liabilities Total current 122,329,500 Non-current liabilities Long term debt Total non-current Total liabilities 118,366,000 Shareholders equity 241,195,500 Common stock Additional Paid-In Capital Treasury stock Retained earnings Total shareholders equity Total liabilities & shareholders equity 30,000,000 2,754,000 2,210,000 1,348,000 70,000,000 70,000,000 9,255,000 9,957,000 (15,219,000) 130,859,500 36,322,000 106,322,000 134,873,500 241,195,500 ABC Company Budgeted Income Statement Year ending 12/31/20X2 Sales 282,393,500 Cost of goods sold Gross margin 58,643,500 Administrative expenses Operating income (46,413,500) Interest expense (7,980,000) Other income 5,849,490 Income before taxes (48,544,010) Income taxes - Net income (48,544,010) ABC Company Budgeted Cost of Goods Sold Schedule Year ending 12/31/20X2 Beginning Inventory 15 Add Purchases 315 Cost of goods available for sale 235,000,000 Less ending inventory 30 Cost of goods sold (223,750,000) (105,057,000) 212,500,000 IF, THEN FORMULA PROVIDED ABC Company Budgeted Statement of Retained Earnings Year ending 12/31/20X2 Beginning balance of retained earnings 130,859,500 +/ Net income/loss (48,544,010) - Dividends - Ending balance of retained earnings 82,315,490 129,921,990 Intermediate Budgets and Schedules ALL CELLS WILL LINK TO OTHER TABS 0R WILL HAVE FORMULASI Sales Budget Model A Model B Model C Total Inventory Purchases Budget Sales units + Target ending inventory Total units required - Beginning inventory Number of units to purchase Unit Cost Cost of Purchases Cost of goods available for sale Cost of goods sold Units Selling Price Total Revenues 50 $1,500,000 $75,000,000 150 $1,125,000 $168,750,000 100 $750,000 $75,000,000 $318,750,000 Model A Model B Model C 50 150 100 5 5 5 55 155 105 5 5 5 55 155 105 $1,000,000 $750,000 $500,000 $55,000,000 $60,000,000 $50,000,000 $116,250,000 $120,000,000 $112,500,000 Total 300 15 315 15 315 $2,250,000 $52,500,000 $223,750,000 $55,000,000 $235,000,000 $50,000,000 $212,500,000 Selling, General and Administrative Expense Budget Utilities, maintenance, and facilities Executive and administrative salaries Depreciation Marketing and promotions Bad debt expense Sales commission Warranties Shipping and handling costs Insurance Total $681.3. expenses Budgeted Interest Expense Beginning longterm debt balance Payments on longterm debt Ending longterm debt balance Interest expense on ending balance Schedule of Cash Receipts from Sales Beginning accounts receivable Cash receipts from current year sales Total cash receipts on sales Schedule of Cash Receipts from Investments Interest received from shortterm investments Interest received from longterm investments Total cash collections on investments $850,000 $9,000,000 $2,432,000 $31,875,000 $31,875,000 $9,562,500 $9,562,500l $3,187,500 $6,712,500 $105,057,000 $70,000,000 $3,500,000 $66,500,000 $7,980,000 $11,456,000 $270,937,500 $282,393,500 $1,351,500 $4,497,990 $5,849,490 Schedule of Cash Payments for Warranties Cash payments for warranties previous year's estimate Total cash payments for warranties Cash Budget Beginning cash balance Add cash receipts Collections from customers Collections from investments Total cash available Deduct disbursements Cash payments for inventory Utilities, maintenance, and facilities Executive and administrative salaries Marketing and promotions Sales commissions Warranties Shipping and handling costs Insurance Accrued expenses and other Longterm debt Dividends Income tax Total cash payments Budgeted ending cash balance $2,764,000 $2,764,000 $48,230,500 $282,393,500 $5,849,490 $336,473,490 $220,187,500 $850,000 $9,000,000 $31,875,000 $9,562,500 $2,764,000 $3,187,500 $6,712,500 $3,558,000 $3,500,000 $0.00 $0.00 $291,197,000 $45,276,490 IF, THEN FORMULA PROVIDED IF, THEN FORMULA PROVIDED