This is a cash budget and I cannot get the figures to equal the closing or end balance for my master budget. Ive included week 5 for a reference

[A] ACCT 5362 Master Budget Project Cash Budget TUTOR.pdf - Adobe Acrobat Pro DC (32-bit) X File Edit View E-Sign Window Help Home Tools ACCT 5362 Master... x A A X 1 /1 + 62% A MASTER BUDGET PROJECT: CASH BUDGET TEMPLATE ACCT 5362 | Accounting Principles Search tools 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 of Lo Create PDF 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 $6,000. the surplus in moved to Savings in $1,000 increments at the end of the quarter Combine Files All components of cash COGS (DM. DL, VMOH) and cash SGRA are paid 2/3 in the quarter incurred purchased and 1/3 in the following quarter. Depreciation must be subtracted from the COGS to derive cash COGS. Fixed Overhead and Fixed S/GIA are paid 100% in the quarter incurred. OF Edit PDF 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 FEATURED depreciation was recorded on the equipment for 2021. Request E-signat. Sales are collected 50% in the quarter of sale and the balance in the following quarter based on the budgeted income statement from week 5 Taxes are paid in the quarter following the quarter incurred based on the buedgeted income statement from week 5. INCOME STATEMENT WEEK 5 FOR REFERENCE LA Fill & Sign 32 Q1 02 03 04 Annual Use the template below to prepare the Cash Budget. 33 Sale: $420.000 $480,000 $720,090 $960.000 32,580,900 34 Cost of Goods Sold -290,509 -332,010 -498,015 -664,020 -1,784,53 Cash Budget 2021 2 03 04 35 Gross Profi 5129.491 $147,990 $221,985 5295,980 5795,446 Export PDF Beg Cash $5.909 $5,482 55.859 $5,771 $450,000 $585,000 $772.500 36 SG.&A Expenses ($108,200) ($110,800) ($121,200) ($131,600) ($471,800 Collections 420.000 $425.909 $455.482 $590.858 $778,271 37 Operating Profit $21,291 $37,190 $100,785 $164,380 Total Cash Collections $323,645 38 Interest Expense SO (5720) (510,020) (518,030 (328,770 Disbursements: DM ($27.658) ($29.704) ($39,753) ($42,999) 39 Taxable Income $21.291 $36,470 $90,765 5146,350 $294,STE EDOrganize Pages DL $71,400) $105.400) ($146,200) $175,100 40 Income Tax (36 387) ($10,941) ($27,230) ($43,905 (388,463 VOH ($2.280) ($2.480) ($3.440) ($4,120) 41 Net Income $14,904 $25,329 $63,536 $102,445 $206,413 FOH $210,000) DO THESE FIGURES CHANGE? VSGA ($18.200) ($19.933) ($27.733) ($38,133) La Send for Comme. FSGA ($85.000) DO THESE FIGURES CHANGE? Capital Purchases ($300,000) 30 Interest Expense ($720) ($10,020) ($18,030 Miscellaneous Cash Expense $25,502) $90,000) Comment Tax Expense $6.387) $6.387) DO THESE FIGURES CHANGE? Total Disbursements $446.427) Excess (deficiency) of available Cash $20,518) ($304.142) Tifd (To) From Savings $2.000 Scan & OCR Loans borrowed (repaid) $24.000 $310.000 ($67,000) ($248,000) Ending Cash $5.482 $5.859 $5.771 $5,170 TOTALS DO NOT ADD UP CORRECTLY Protect a 0o P X 9 5:02 PM LO O Wednesday 6/22/2022