Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cash Flow Budget Fertile Valley Farm Supply Store for the Fiscal Year Ending December 31, 20 QUARTER Cash balance, beginning of Quarter $ 2.200 $
Cash Flow Budget Fertile Valley Farm Supply Store for the Fiscal Year Ending December 31, 20 QUARTER 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 0 60,200 Dividends 5.500 5.500 5,500 Total outflows 532,800 676,000 541,950 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 (188,900) Interest payments 4.450 Cash balance, end of quarter $ 32,400 $ 62,200 0 $ 18,300 6. Use the cash flow budget above to answer the following questions a) If feed 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 Q3? OO c) If instead of saving $80,000 in Q1 and rather the firm put aside $90,000, what would be the amount of additional borrowing to secure in Q3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started