hello ive been having trouble with a project specifically the "cash budget" & "balance sheet for upcoming year". i was hoping to see answers and willing to pay more if it was too difficult to do. if interested @yeaaaa.ight on Instagram (:

Units Unit selling price Sales $ $ TBA Inc., Sales Budget For the Year Ended Decemeber 31, 20x1 Q1 Q2 Q3 2,000,000 6,000,000 6,000,000 0.70 $ 0.70 $ 0.80 $ 1,400,000 $ 4,200,000 $ 4,800,000 $ Q4 Year 2,000,000 16,000,000 0.80 1,600,000 $ 12,000,000 Budgeted unit sales Desired Ending Inventory Total units needed Less: Est. Beginning Inventory Total Units to be Produced TBA, Inc. Production Budget For the Year Ended 20x1 Q2 6,000,000 500,000 6,500,000 500,000 6,000,000 Q1 2,000,000 500,000 2,500,000 100,000 2,400,000 Q3 6,000,000 100,000 6,100,000 500,000 5,600,000 Q4 2,000,000 100,000 2,100,000 100,000 2,000,000 Year 16,000,000 17,200,000 16,000,000 Unit produced Direct material per unit Production needs Desired ending inventory Total needed Less: beginning inventory Units produced Cost per pound Total purchase cost TBA Inc. Direct Material Purchases Budget For the year ended 20X1 Q2 Q3 6,000,000 5,600,000 26 26 156,000,000 145,600,000 8,000,000 5,000,000 164,000,000 150,600,000 8,000,000 8,000,000 156,000,000 142,600,000 $0.01 $0.01 $1,560,000.00 $1,426,000.00 Q1 2,400,000 26 62,400,000 8,000,000 70,400,000 5,000,000 65,400,000 $0.01 $654,000.00 Q4 2,000,000 26 52,000,000 5,000,000 57,000,000 5,000,000 52,000,000 $0.01 $520,000.00 Total 16,000,000 26 416,000,000 5,000,000 421,000,000 5,000,000 416,000,000 $0.01 $4,160,000.00 Units Produced Direct labor per unit Direct labor hrs. required for production: Cost per direct labor hour Total Direct Labor Cost: Q1 $ $ TBA, Inc. Direct Labor Cost Budget For the Year Ended 20X1 Q2 6,000,000 0 90,000 2,400,000 0 36,000 Q3 5,600,000 0 84,000 14.00 $ 14.00 $ 14.00 $ 504,000 $ 1,260,000 $ 1,176,000 $ Q4 2,000,000 0 30,000 14.00 $ 420,000 $ Year 16,000,000 0 240,000 14.00 3,360,000 Variable Factory OH: Budgeted DL hours Variable OH rate Total Variable Factory OH Fixed Factory OH: Supervision Depreciation Rent Total Fixed Factory OH Total Factory Overhead Factory Overhead Budget For the Year Ended 20x1 Q1 Q2 Q3 Q4 Year Total 36,000 90,000 84,000 30,000 240,000 $8 $8 $8 $8 $8 $288,000 $720,000 $672,000 $240,000 $ 1,920,000 $ 100,000 $ 100,000 $100,000 $100,000 $400,000 $ 20,000 $ 20,000 $ 200,000 $ 200,000 $200,000 $200,000 $ 800,000 $20,000 $20,000 $ 80,000 $ 320,000 $ 320,000 $320,000 $320,000 $1,280,000 $ 608,000 $1,040,000 $992,000 $560,000 $3,200,000 TBA, Inc. Cost of Goods Sold Budget For the Year Ending December 31, 20x1 $ 50,000 4,160,000 4,210,000 (50,000) 4,160,000 3,360,000 3,200,000 Finished Goods Inventory, January 20x1 Work in Process Inventory, January 20x1 Direct Materials: Direct Materials Inventory January 1, 20x1 Direct Material Purchases Cost of direct Materials available for use Less: Direct Materials Inventory (12/31/20X1) Cost of Direct Materials Placed in production Direct Labor Factor Overhead Total Manufacturing Costs Total Work in Process during period Less: Work in Process inventory, December 31, 20x1 Cost of Goods Manufactured Cost of finished Goods available for sale Finished Goods Inventory, December 31, 20x1 (Note a) Cost of Goods Sold (Note a) Finished Goods Inventory. 12/31/20x1: Unit costs Direct materials Direct labor (.015 x $14) Overhead: Budgeted variable overhead Budgeted fixed overhead ($1,280,000/16,000,000) Total manufacturing cost per unit Total ending inventory cost (100,000 x $.67) FA $ $ $ $ $ $ $ 0.26 0.21 0.12 0.08 0.67 67,000 $ $ $ 10,720,000 10,720,000 $ $ $ $ $ 55,000 10,775,000 10,775,000 67,000 10,708,000 TBA, Inc. Marketing Budget For the Year Ended December 31, 20x1 Q1 Q2 6,000,000 Q3 6,000,000 2,000,000 $ 0.05 $ 0.05 $ 0.05 $ 100,000.00 $ 300,000.00 $ 300,000.00 $ 20,000 $ 20,000 $ 20,000 $ $ 5,000 $ 5,000 $ 5,000 $ $ 3,000 $ 3,000 $ 3,000 $ $ 10,000 $ 15,000 $ 10,000 $ $ 43,000 $ 38,000 $ 38,000 $ $ $ 343,000 $ 338,000 $ Budgeted Unit Sales Unit variable marketing expense (commission) Total variable marketing expenses Fixed Marketing Expenses: Salaries Depreciation Travel Advertising Total fixed Marketing Expenses Total Marketing Expenses 138,000 Q4 2,000,000 Year 16,000,000 $ 0.05 $ 0.05 $100,000.00 $ 800,000.00 20,000 $ 80,000 5,000 $ 20,000 3,000 $ 12,000 10,000 $ 45,000 38,000 $ 157,000 957,000 138,000 $ Fixed Administrative Expenses: Salaries Expense Insurance Expense Depreciation Expense Travel Expense Total Administrative Expenses: TBA, Inc. Administrative Expense Budget For the Year Ended December 31, 20x1 Q1 Q2 $ 35,000 $ 35,000 $ $ 4,000 $ 4,000 $ $ 12,000 $ 12,000 $ $ 2,000 $ 2,000 $ $ 53,000 $ 53,000 $ Q3 35,000 $ 4,000 $ 12,000 $ 2,000 $ 53,000 $ Q4 35,000 $ 4,000 $ 12,000 $ 2,000 $ 53,000 $ Total 140,000 16,000 48,000 8,000 212,000 TBA, Inc. Budgeted Income Statement For the Year Ending December 31, 20x1 Revenue from sales Cost of goods sold Gross profit Selling and administrative expenses: Selling expenses Administrative expenses Operating Income Other revenue and expense: Interest revenue Interest expense (From Cash Budget) Income before income tax Income tax (30% of net income) Net Income $ $ $ $ $ $ $ 12,000,000 5,758,000 6,242,000 137,000 212,000 5,893,000 Cash Sales 30% of prior quarter's sales on account 70% of current quarter's sales on account Total Cash Receipts Q4 20x0 Sales Q1 20X1 Sales Q2 20X1 Sales Q3 20X1 Sales Q4 20X1 Sales 1 $ $ $ $ Cash Reciept Budget For the Year Ended December 31, 20x1 Q1 700,000 $ Q2 2,100,000 $ 210,000 $ 300,000 $ 490,000 $ 1,470,000 $ 1,490,000 $ 3,780,000 $ Total Sales Cash Sales (50%) 2,000,000 $ $ 1,400,000 $ $ 4,200,000 $ $ 4,800,000 $ $ 1,600,000 $ Q3 2,400,000 $ 630,000 $ 1,680,000 $ 4,710,000 $ Credit Sale (50%) 1,000,000 700,000 2,100,000 2,400,000 800,000 1,000,000 $ 700,000 $ 2,100,000 $ 2,400,000 $ 800,000 $ Q4 800,000 $ 720,000 $ 560,000 $ 2,080,000 $ Total 6,000,000 1,860,000 4,200,000 12,060,000 TBA, Inc. Cash Payment Budget For the Year Ended December 31, 20x1 Q1 Q2 Q3 Q4 Total $654,000 $1,560,000 $1,426,000 $520,000 $ 100,000 $ 130,800 $ 312,000 $285,200 $ 523,200 $1,248,000 $1,140,800 $ 416,000 $ 623,200 $1,378,800 $1,452,800 $701,200 $4,156,000 DM Purchases on Account Payments of Accounts Payable: 20% prior quarter's DM Purchases 80% current quarter's DM Purchases Total Cash Payments Begir ning Cash Balance Estinated Cash Receipts from: Cash Sales Feceived from Accounts Receivalbe Total Cash Available Cash Payments: TBA, Inc. Cash Budget For the Year Ended December 31, 20x1 Q1 Q2 Q3 Q4 $ 120,000 $ 100,000 $ 100,000 $ 100,000 $ 700,000 $2,100,000 $2,400,000 $800,000 $ 300,000 $ 210,000 $630,000 $ 720,000 $ 490,000 $1,470,000 $1,680,000 $ 560,000 $ 1,610,000 $3,880,000 $4,810,000 $2,180,000 $ $ $ $ 100,000 $ 130,800 $ 312,000 $285,200 523,200 $ 1,248,000 $ 1,140,800 $ 416,000 504,000 $1,260,000 $1,176,000 $ 420,000 408,000 $ 840,000 $ 792,000 $360,000 133,000 $ 338,000 $333,000 $133,000 41,000 $ 41,000 $ 41,000 $ 41,000 447,000 $1,134,000 $1,413,000 $ 644,700 600,000 $ $ $ $ $ 2,756,200 $ 4,991,800 $5,207,800 $2,299,900 $ 100,000 $ 100,000 $100,000 $100,000 $ 2,856,200 $ 5,091,800 $5,307,800 $2,399,900 $ (1,246,200) $ (1,211,800) $ (497,800) $ (219,900) $ 1,300,000 $1,300,000 $500,000 $300,000 $ (1.300,000) S (1,300,000) $ (500,000) $ (300.000) $ 39,000 $ 39,000 $ 15,000 $ 9,000 $ 1,300,000 $1,339,000 $ 515,000 $309,000 $ 100,000 $100,000 $100,000 $100,000 100,000 S 100,000 $ 100,000 $100,000 $ 30% of prior quarter's credit sales 70% of current quarter's credit sales Payments for puruchases: 20% of prior quarter purchases 80% of current quarter purchases Direct Labor Overhead (excluding depreciation exp.) Marketing expense (exclude depreciation exp.) Administrative expense (exclude depreciation exp) Income Tax Capital investment (equipment) Total cash payments Minimum cash balance To al cash needs Excess (Deficiency) Financing: Borrowings Repayments Interest To al financing Acd: minimum cash balance Er ding cash balance Year 420,000 $ $ 6,000,000 $ 1,860,000 $4,200,000 $12,480,000 $ 828,000 $ 3,328,000 $ 3,360,000 $ 2,400,000 $ 937,000 $ 164,000 $ 3,638,700 $ 600,000 $ 15,255,700 Balance Sheet For upcoming year For the Year Ended December 31, 20x1 Current Assets: Cash (note a) Accounts Receivables (note b) $ 480,000 Material inventory (note c) $ 50,000 Finisihed Goods Inventory (note d) $ 67,000 Total Current Assets Property, Plant, & Equipment: Land (note e) $ 2,500,000 Buildings & Equipment (note f) $ 9,000,000 (5,368,000) Accumulated Depreciation (note g) $ Total PP&E $ 6,132,000 $ 6,132,000 Total Assets $ 7.646,100 ??? Alaura's number - not sure where she got it. Liabilies & Stockolders' Equity: Current Liabilities: Accounts Payable (note h) $ 104,000,000 Stockholders' Equity: Common Stock $ 600,000 Retained Earning (note i) Total Stockholders' Equity Total Liabilities & Stockholders' Equity Mates: ending cash balance from cash budget Q4 Sales x 30% Desired ending inventory of 5,000,000 x $0.01 COGS Budget (no) Balance Sheet, 12/31/200 Balance Sheet, 12/031/200 Accumulated depreciation (12/31/20X0) Depreciation expenses (Overhead Marketing Administration) ($6,825,000+800.000 $20,000-$48,000) $6,873.300 20% of Q4 Direct Material Purchases