A B Acme Corp. Revenue Product 1 Sales Product 2 Sales Operating Costs Calibri Product 1 COGS Product 2 COGS SG&A Cost EBIT Interest EBT Taxes Net income Dividend Payout Cash Beginning Cash Sales A/R Collections A/P Payments Other Cash Expenses Dividend Payout Cash Ending . Eme Corp Cash Budget 11 C EOQ1 2022 $1,980,000 $1,200,000 $780,000 $656,400 $360,000 $296,400 $237,600 $1,086,000 $364,000 $722,000 $151,620 $570,380 $171,114 $1,300,450 $297,000 $1,520,478 $405,125 $514,782 $175,231 $2,022,790 BIUS D EOQ2 2022 $1,960,200 $1,188,000 $772,200 $649,836 $356,400 $293,436 $235,224 $1,075,140 $364,000 $711,140 $149,339 $561,801 $168,540 $2,022,790 $294,030 $1,683,000 $402,300 $513,339 $168,540 $2,915,640 E EOQ 3 2022 $2,038,608 $1,235,520 $803,088 $675,829 $370,656 $305,173 $244,633 $1,118,146 $364,000 $754,146 $158,371 $595,775 $178,733 F EOQ 4 2022 $2,201,697 $1,334,362 $867,335 $729,896 $400,308 $329,587 $264,204 $1,207,597 $364,000 $843,597 $177,155 $666,442 $199,933 G Full Year $8,180,505 $4,957,882 $3,222,623 $2,711,961 $1,487,364 $1,224,597 $981,661 $4,486,883 $1,456,000 $3,030,883 $636,485 $2,394,397 $718,319 hp "app.html Model Inputs CAGR Interest rate on debt Dividend payout Tax rate Cash as % of Sales A/R as % of Sales Inventories as % of Sales A/P as % Sales Product 1 COGS as % sales Product 2 COGS as % sales SG&A as % sales Debt J 8.00% 7% 30% 21% 15% 85% 0% 45% 30% 38% 12% $5,200,000 K