Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I'm having trouble with this cash flow lab. I would appreciate it if someone could help me and tell me how they found their calculations.
I'm having trouble with this cash flow lab. I would appreciate it if someone could help me and tell me how they found their calculations. The calculations that need to be made are the blank boxes in the table.
Oakdale Farm Cash Flow Budget Cash Inflows Livestock sales Crop sales Other farm income Nonfarm income New term loans to borrow Total inflows Jan-March 37000 21000 0 6000 April-June 42000 50000 0 4000 64000 96000 Cash Outflows Crop inputs Livestock expenses Land rent Miscellaneous Family living and taxes Capital asset purchases Loan payments to make Total outflows Jan-March 0 10000 42000 14000 9000 Net Cash Flow Annual Operating Loan Beginning cash balance + Net cash flow July- Sept. 44000 0 0 2000 50000 96000 Oct.- Dec. 42000 50000 1000 6000 April-June 80000 12000 0 5000 14000 July- Sept. 2000 15000 0 3000 9000 75000 Oct.- Dec. 26000 75000 111000 104000 15000 67000 Whole Year 82000 52000 84000 23000 41000 75000 41000 357000 -11000 -15000 -8000 32000 -2000 Jan-March April-June July- Sept. 99000 0 15000 42000 1000 9000 Oct.- Dec. 5000 -11000 + Operating loan borrowing - Operating loan payment = Ending cash balance 13-1 Whole Year 165000 121000 1000 18000 50000 355000 Whole Year 5000 -15000 -8000 32000 -2000 Beginning operating loan balance 25000 Ending operating loan balance CASH FLOW BUDGETING The managers of Oakdale Farm need to find out how much operating capital they will need to borrow this year. Can you finish this cash flow budget and help them out? Calculate how much they will need to borrow each quarter and how much they can repay. Don't worry about interest on the operating loan. Budget for an ending cash balance of $1,000 each quarter. Then estimate the amount of operating loan funds they will have borrowed at the end of each quarter. 13-2 25000Step 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