Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Now, Assume that you start out on January 1 of 2 0 2 4 with $ 3 5 , 0 0 0 . 0 0

Now, Assume that you start out on January 1 of 2024 with $35,000.00 cash in the bank, and a 0 operating loan balance and you plant 1000 acres of No-Till soybeans (all on cash rented land). Assume your enterprise budget projections are correct. Develop a monthly cash flow budget from January of 2024 through December of 2024 to track the timing of cash inflows and outflows, and the resulting required operating loan balances at the end of each month. Use the "OSU Cash Flow Blank Template available on the class website for this exercise. Assume that you need to maintain a $5,000.00 balance in your cash account. Also assume that you have other sources of income to fund family living, so you do not actually take the operator labor charge out of the wheat enterprise. Assume 8.0% interest on your operating loan. The template will calculate your operating loan balance for you every month, and will pay it off when you have excess cash above your $5,000.00 minimum, and will pay the accrued interest on the operating loan when there are enough excess funds to pay off the operating loan and the interest (all of those calculations are done for you). So, to start, scroll down the "B" column to the appropriate yellow input cells and put in the $35,000.00 beginning cash balance, the $5,000.00 minimum cash balance, and the 8.0% interest rate on the operating loan (enter as a whole number 8, not decimal form).
6. Develop your cash flow in the Excel template (OSU Cash Flow Blank Template).
7. If you divide your total operating loan interest cost that the cash flow spreadsheet calculated for you (Hint, it is automatically assumed to be paid in October in the cash flow template) by 1000 acres, why do you get a number that is different than the $17.00 per acre estimated in the enterprise budget?
8. What would be the beginning cash balance this farm would start the following season with if this projection turns out to be accurate?
image text in transcribed

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

The Development Of The American Public Accounting Profession

Authors: T.A. Lee

1st Edition

0415403944, 9780415403948

More Books

Students also viewed these Accounting questions