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 u 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 increments at the end of the quarter. All components of cash COGS (DM, DL, VMOH) and cash SG\&A are paid 2/3 in the quarter incurred/purchased and 1/3 in the following quarter, Depreci COGS. Fixed Overhead and Fixed SG\&A are paid 100% in the quarter incurred. All Fixed Assets afe depreciated over 10 years ( 40 quarters). However, the new equipment purchased in Q22021 was not placed in service by 12/31/2021. for 2021 . 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 . Use the template below to prepare the Cash Budget. Cash Budget 2021 Beg Cash Collections Total Cash Collections Disbursements: DM DL VOH FOH VSGA FSGA Capital Purchases Interent Expense Miscellaneous Cash Expense Tax Expense Total Disbursements Excess (deficiency) of available Cash Trfd (To)/From Savings Loans berrowed (repaid) Ending Cash \begin{tabular}{|c|c|c|c|} \hline & & a2 & \\ \hline Q1 & Q2 & Q3 & Q4 \\ \hline$5,909 & & & \\ \hline$420,000 & $450,000 & & 78 \\ \hline \multirow{2}{*}{\multicolumn{4}{|c|}{$425,909}} \\ \hline & & & \\ \hline($27,658) & (\$29.704) & (\$39.753) & ($42,999) \\ \hline($71,400) & ($105,400) & ($146,200) & ($175,100) \\ \hline(52,280) & ($2,480) & ($3,440) & ($4,120) \\ \hline($210,000) & & 4 & \\ \hline($18,200) & (\$19,933) & ($27,733) & (\$38, 133) \\ \hline(585,000) & & & \\ \hline so & & & \\ \hline so & (\$720) & ($10,020) & ($10,020) \\ \hline($25,502) & 50 & so & so \\ \hline($6,387) & ($6,387) & 2 & \\ \hline \multicolumn{4}{|l|}{ (5446,427) } \\ \hline(520,518) & ($304,142) & & \\ \hline$2,000 & 0 & 0 & 0 \\ \hline$24,000 & $310,000 & ($67,000) & ($248,000) \\ \hline & & & \\ \hline 55,482 & $5.858 & 55,771 & $5,170 \\ \hline \end{tabular} Capital Hadzet: Other cash itrme: Tax Rute johs increnents at the end of the quarter. cocs for 2021 i. Cusk Bedgrt 2021 Ber Caul Collections Tobicuat Collections Duburnerenta DM pt. volt Foll VSOA FsaA Copual Rurctues: thiment lispenes Tas Ir vpenie Toul Destunetsoes. Trid (foi) from Sment Lases berreard (mpaid) Q1 55909 55,907 5420,000 3425009 raling Cas Q2 540000 (527,658) (529,700) (571,400)(5105,400) (32,230) (5210,000) (311200) (35000) (35000) asim is (446,4) (520310) (3)04, (a) 52000 54000 310000 Q3 (519.953) (355,753) (\$146200) (53,449) (327,739) (\$10020) 10 Q4 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 u 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 increments at the end of the quarter. All components of cash COGS (DM, DL, VMOH) and cash SG\&A are paid 2/3 in the quarter incurred/purchased and 1/3 in the following quarter, Depreci COGS. Fixed Overhead and Fixed SG\&A are paid 100% in the quarter incurred. All Fixed Assets afe depreciated over 10 years ( 40 quarters). However, the new equipment purchased in Q22021 was not placed in service by 12/31/2021. for 2021 . 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 . Use the template below to prepare the Cash Budget. Cash Budget 2021 Beg Cash Collections Total Cash Collections Disbursements: DM DL VOH FOH VSGA FSGA Capital Purchases Interent Expense Miscellaneous Cash Expense Tax Expense Total Disbursements Excess (deficiency) of available Cash Trfd (To)/From Savings Loans berrowed (repaid) Ending Cash \begin{tabular}{|c|c|c|c|} \hline & & a2 & \\ \hline Q1 & Q2 & Q3 & Q4 \\ \hline$5,909 & & & \\ \hline$420,000 & $450,000 & & 78 \\ \hline \multirow{2}{*}{\multicolumn{4}{|c|}{$425,909}} \\ \hline & & & \\ \hline($27,658) & (\$29.704) & (\$39.753) & ($42,999) \\ \hline($71,400) & ($105,400) & ($146,200) & ($175,100) \\ \hline(52,280) & ($2,480) & ($3,440) & ($4,120) \\ \hline($210,000) & & 4 & \\ \hline($18,200) & (\$19,933) & ($27,733) & (\$38, 133) \\ \hline(585,000) & & & \\ \hline so & & & \\ \hline so & (\$720) & ($10,020) & ($10,020) \\ \hline($25,502) & 50 & so & so \\ \hline($6,387) & ($6,387) & 2 & \\ \hline \multicolumn{4}{|l|}{ (5446,427) } \\ \hline(520,518) & ($304,142) & & \\ \hline$2,000 & 0 & 0 & 0 \\ \hline$24,000 & $310,000 & ($67,000) & ($248,000) \\ \hline & & & \\ \hline 55,482 & $5.858 & 55,771 & $5,170 \\ \hline \end{tabular} Capital Hadzet: Other cash itrme: Tax Rute johs increnents at the end of the quarter. cocs for 2021 i. Cusk Bedgrt 2021 Ber Caul Collections Tobicuat Collections Duburnerenta DM pt. volt Foll VSOA FsaA Copual Rurctues: thiment lispenes Tas Ir vpenie Toul Destunetsoes. Trid (foi) from Sment Lases berreard (mpaid) Q1 55909 55,907 5420,000 3425009 raling Cas Q2 540000 (527,658) (529,700) (571,400)(5105,400) (32,230) (5210,000) (311200) (35000) (35000) asim is (446,4) (520310) (3)04, (a) 52000 54000 310000 Q3 (519.953) (355,753) (\$146200) (53,449) (327,739) (\$10020) 10 Q4