Can someone help me fill out blanks in the third photo? The first and second photos should help. Thank you.

These photos should be legible enough. I need help filling out the blanks to the fourth photo, thank you

The only additional info i was given

Q3 Sales Cost of Goods Sold Gross Profit SG&A Expenses Operating Profit Interest Expense Taxable income Income Tax Net Income Q1 $420,000 -290,509 $129,491 ($108,200) $21,291 $0 $21,291 ($6.387) $14.904 Q2 $480,000 -332,010 $147,990 ($110 800) $37,190 ($720) $36,470 ($10,941) $25,529 $720,000 -498,015 $221.985 ($121,200) $100,785 ($10,020) $90.765 ($27.229) $63.535 04 $960,000 -664020 $295,980 ($131 600) $164,380 ($18,030) $146.350 (543,905) $102 445 Annual $2,580,000 -1,784,555 $795 445 ($471.800) $323,645 ($28,770) $294.875 ($88.463) $206,413 Use the following as inputs into the Cash Budget Capital Budget: Equipment costing $300,000 will be purchased at the end of Q2. paid in cash. The equipment will not be placed into service for purposes of depreciation until after the end Other cash items: Tax Rate: 30% The beginning cash balance is $5,000 and the company intends to maintain this level of cash ($5,000 $6,000)) at the end of each quarter. If the cash balance exceeds If ending cash is insufficient, loans are taken out at the beginning of the quarter in increments of $1,000 bearing a simple interest rate of 1% per month. The interest is paid All components of cash COGS (DM, DL, VMOH) and cash SG&A are paid 23 in the quarter incurred purchased and 1/3 in the following quarter. Depreciation must be Fixed Overhead and Fixed SG&A are paid 100% in the quarter incurred. All Fixed Assets are depreciated over 10 years (40 quarters). However, the new equipment purchased in Q2 2021 was not placed in service by 12/31/2021. Therefore, no Sales are collected 50% in the quarter of sale and the balance in the following quarter. Taxes are paid in the quarter following the quarter incurred, Q1 Q2 Q3 Q4 Cash Budget 2021 Beg Cash Collections Disbursements: DM DL VOH FOH VSGA FSGA Capital Purchases Interest Expense Tax Expense Change to Cash Balance Trfd (To) From Savings Loans borrowed (repaid) Ending Cash $5,483 $5,752 $5,772 $5,170 Sales Cost of Goods Sold Gross Profit SG&A Expenses Operating Profit Interest Expense Taxable Income Income Tax Net Income Q1 $420,000 -290,509 $129,491 ($108,200) $21,291 $0 $21,291 ($6,387) $14,904 Q2 $480,000 -332,010 $147,990 ($110,800 $37,190 ($720) $36,470 ($10,941) $25,529 0 2 1 00) Q2 $480,000 -332,010 $147,990 ($110,800) $37,190 ($720) $36,470 ($10,941) $25,529 Q3 Q4 Annual $720,000 $960,000 $2,580,000 -498,015 -664,020 -1,784,555 $221,985 $295,980 $795,445 ($121,200) ($131,600) ($471,800) $100,785 $164,380 $323,645 ($10,020) ($18,030) ($28,770) $90,765 $146,350 $294,875 ($27,229) ($43,905) ($88,463) $63,535 $102,445 $206,413 ) Use the following as inputs into the Cash Budget: Capital Budget: Equipment costing 5300.000 will be purchased at the end of Q2. paid in cash. The equipment will not be placed into service for purposes of depreciation until after the end of the year due to installation and testing Other cash items: Tax Rate: 30% The beginning cash balance is 85.000 and the company intends to maintain this level of cash (55,000-36,000) at the end of each quarter. If the cash balance exceeds $6,000, the surplus in moved to Savings in $1,000 increments at the end of the quarter Trending cash is insufficient, loans are taken out at the beginning of the quarter in increments of $1.000 hearing a simple interest rate of 1% per month. The interest is paid in the quarter following any quarter where an outstanding loan balance existed. Loans are paid back at the end of the quarter whenever surplus cash exists, again in $1.000 increments Al components of cash COGS (DM, DL, VMOH) and enh SG&A are paid 23 in the quarter incurred purchased and 13 in the following quarter. Depreciation must be subtracted from the COXIS 10 derive cash COGS Fixed Overhead and Fixed SCA are paid 100% in the quarter incurred All Fixed Assets are depreciated over 10 years (40 quarters). However, the new equipment purchased in 02 2021 was not placed in service by 12/31/2021. Therefore, no depreciation was recorded on the equipment for 2021 Sales are collected 50 in the quarter of sale and the balance in the following quarter Taxes are paid in the quarter following the quarter incurred. 01 Q2 03 Q4 Use the template below to prepare the Cash Budget. Cash Budget 2021 Beg Cash Collections Disbursements: DM DL VOH FOH VSGA FSGA Capital Purchases Interest Expense Tax Expense Change to Cash Balance Tefd (Toy From Savings Loans borrowed (repaid) Ending Cash $5,483 $5,752 $5,772 $5,170 Overhead Budget Inputs: Variable overhead: $0.40 per DLH Fixed overhead: $270,000 per quarter FOH applied on the basis of budgeted DLH