Date: Cash Flow Budget Fertile Valley Farm Supply Store for the Fiscal Year Ending December 31, 20 QUARTER 2 Cash balance, beginning of quarter $ 2,200 $ 32,400 $ 62,200 Add: Cash inflows Feed 260,000 191,000 142.000 $236,500 Seed 30.000 60,000 10,000 68,000 Fertilizers 188.500 254,800 30,000 174,300 Chemicals 110.000 155,000 78,400 Petroleum 28.500 21,500 14,500 22,700 Miscellaneous 2.000 2,500 2.300 2.000 Supplies 24,000 21,000 16,500 16,000 Total inflows 643,000 705,800 215,300 597,900 Total cash available 645,200 738,200 277,500 597,900 Less: Cash outflows Materials 380,000 462,000 350.000 160,000 Labor 80,000 80,000 80.000 80.000 Overhead 12.000 8,000 6,000 12.000 Selling and administration 40.000 36.000 30,000 38,000 Income taxes 8,000 8,000 8,000 8,000 Equipment purchases 7.300 15,500 62,450 27,000 Debt payments 61,000 60,200 Dividends 5,500 5.500 5.500 5.500 Total outflows 532,800 676,000 541,950 390,700 Surplus (deficit) 112,400 62,200 (264,450) 207,200 Savings (to) from (80,000) 80,000 Additional borrowings 0 188,900 Repayments of borrowings 0 (188,900) Interest payments 4,450 0 Cash balance, end of quarter $ 32,400 $ 62,200 0 S 18,300 6. Use the cash flow budget above to answer the following questions: a) II teed sales in quarter 2 is 20% less than the amount given, what will be the total cash available to the firm in Q2? b) Given the information in question a) what will be the beginning balance for Q37 c) If instead of saving $80,000 in Ol and rather the firm put aside $90,000, what would be the amount of additional borrowing to secure in Q3