Construct a cash flow budget given the following information Item Timing Beginning Cash Balance $105,200.00 Seed $1,500.00 March Fertilizer $750.00 Monthly April-August Pesticides $500.00 Monthly April-August Machinery costs $500.00 Monthly March-October Livestock expenses $550.00 Monthly Repairs to machinery $300.00 March and November Supplies $1,650.00 Monthly Property tax $5,000.00 May & November Insurance $850.00 Monthly Replacement breeding stock $8,000.00 August Forest Service leased land $350.00 Monthly June-August Family living expenses $2,800.00 Monthly Income Tax & Social Security $1,500.00 March, June, Sept, Dec Loan payments (current) #1 $2,500.00 March Loan interest (current) #1 $225.00 March Loan payments (non-current) $2,500.00 Monthly Loan interest (non-current) $250.00 Monthly Beginning Current Debt Balance $220,000.00 Beginning Beginning Non-Current Debt Balance $150,000.00 Beginning Spouse's off-farm income $3,200.00 Monthly Farmer's off-farm income $650 Monthly Sale of 20 breeding heifers $5,000.00 April Sale of crops $250,000.00 October Sale of extra native hay from stores $18,000.00 March 13. Cash Flow Budget Jan Feb Mar Apr May Jun $105,200 Jul Aug Sep Oct Nov Total $105,200 Dec Beginning Balance Operating Receipts Capital Receipts Scheduled Debt Payments Current Loan Debt Payments Current Loan Interest Payments Non-Current Loan Payments Non-Current Interest Payments TOTAL CASH OUTFLOW Cash Available New Borrowing Payments on New Borrowing Interest on New Borrowing Total New Borrowing Debt Ending Cash Balance Summary of Debt Outstanding Current Non-current Total Outstanding Debt $0 $34,525 $2,417 -$34,525 -$36.942 Non Farm.Income TOTAL CASH INFLOW $60,000 $325,000 Operating Expenses Total Operating Expenses Capital Expenditures Other Expenditure