8:13 Back A17 Cash flow.xlsx Apment Pipo Telp you understand how to come and five. Use the g talent aspurtaiyait tuter Q= we will Follow the found in The 2. Capsules con 00106 Livestock sales-375.000 4. Livetid purchase/100004 Cap-559.000 Code 10.00002.5.000.000 poche 520.000 Depreciation mod. 200 mm Iedereen quite 400 12. There is 40,00 www.ced on the other by the end of try, we had to Irinare puree l you do me thonjwyment on that will be 10% of the game payment will start the quarter er heller inte CASH FLOW OL 03 03 Canhadows Finish CH . Cattom ENTRE kes Capture mily ng po er der man New best om 93 G 181 Dashboard Calendar To Do Notifications Inbo Assignment Purpose: To help you understand how to contruct a cash flow. Use the following information to prepare a quarterly cash flow budget. Qx indicates the quarter in which the cash inflow or outflow will occur. Follow the example format found in cashflow handout. There is more than one correct way to do the cash flow since ending balances may exceed the desired $4,000. 1. Beginning cash balance - $8,000. 2. Crops sales - $44,000 (Q1) and $91,000 (04). 3. Livestock sales - $75,000 (Q2). 4. Livestock purchases - $30,000 (Q4). 5. Cash crop expenses - $52,000 (Q2). 6. Cash livestock expenses - $5,000 (Q1), $5,000 (Q2), $5,000 (03), $10,000 (04). 7. Equipment purchase - $30,000 (Q2). 8. Depreciation - $5,000 each quarter. 9. Farm mortgage principal payment - $23,000 (Q1) Ignore interest on this loan. 10. Family living expense - $7,000 cach quarter. 11 Minimum ending cash balance desired each quarter - $4,000. 12. There is $40,000 borrowed on an operating loan carried over from the previous year. The bank would like it paid off by the end of the year. Ignore any interest that is due on this loan. 13. Intermediate loan funds are available to purchase the equipment. If you borrow these funds, assume that loan payment on this debt will be 10% of the original amount borrowed and that payments will start the quarter after the loan is taken out. Ignore interest on this loan. CASH FLOW 01 03 04 payments will start the quarter after the loan is taken out. Ignore interest on this loan. Q1 Q2 Q3 Q4 CASH FLOW Cash Inflows Beginning cash balance Crop sales Livestock sales Total cash inflow Cash outflows Livestock purchases Crop expenses Livestock expenses Capital purchase Family living expense Intermediate loan principal payment Mortgage principal payment Total outflow Cash flow summary Inflows minus outflows New borrowing equipment loan Operating loan principal payments Ending cash balance