Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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.

image text in transcribed 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 25000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Finance and Investments

Authors: William Brueggeman, Jeffrey Fisher

14th edition

73377333, 73377339, 978-0073377339

More Books

Students also viewed these Finance questions

Question

=+1. What are the four determinants of a market-specific strategy?

Answered: 1 week ago