Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill in the twelve highlighted cells in the following statement of cash flows using the following information: Round everything to the nearest whole dollar. All

Fill in the twelve highlighted cells in the following statement of cash flows using the following information:

  • Round everything to the nearest whole dollar.
  • All new borrowing needed will be "current" borrowing. To simplify calculations, borrow and repay loans in even $100 units.
  • Interest rate is 10% per year or 2.5% per quarter on current borrowing. Repay oldest current borrowing first and pay interest only on the amount of principal repaid.
  • Maintain $1000 monthly minimum balance (anything between $950 and $1050 is okay).image text in transcribed

McGraw Farm Jan. 1, 2008-Dec, 31, 2008 Statement of Cash Flows count ginning Cash Balance erating Receipts Total [1] Quarter 1 Quarter 2 Quarter 3 Quarter 4 45000 950 5850 4850 Livestock product sales 48000 12000 12000 12000 12000 pital Receipts Breeding Livestock sales 10000 0 10000 0 0 nfarm Income Off-farm salary 40000 10000 10000 10000 10000 tal Cash Inflow 143000 [2] 32950 27850 26850 erating Expenses Wages, Salaries, Benefits 18000 4500 4500 [3] 4500 Feed purchases 2500 2500 0 0 0 Other livestock expenses 100 0 100 0 Supplies 1050 450 0 0 600 tal operating expenses 21650 [4] 4600 4500 5100 pital Expenses Breeding livestock 15000 0 15000 0 her Expenses Family living expenses [5] 7500 7500 7500 7500 heduled Debt Payments Current debt principal 10000 0 0 10000 Current debt interest 1000 0 0 1000 0 Noncurrent debt principal 50000 50000 0 0 0 Noncurrent debt interest 5000 5000 0 0 0 tal Cash Outflow 132650 69950 [6] 23000 12600 sh Available 10350 -2950 5850 4850 [7] w Borrowing Current [8] [9] 0 0 Noncurrent 0 0 0 0 tal New Borrowing |[10] |[11] 0 0 0 yments to New Debt Principal 0 0 0 0 Interest 0 0 0 0 tal New Debt Payments 0 0 0 0 0 ding Cash Balance 14250 950 5850 [12] 14250 mmary of Debt Outstanding Current 28900 28900 28900 28900 28900 Noncurrent 100000 100000 100000 100000 100000 tal debt outstanding 128900 128900 128900 128900 128900

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

Managerial Accounting Tools for business decision making

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

6th Edition

978-0470477144, 1118096894, 9781118214657, 470477148, 111821465X, 978-1118096895

More Books

Students also viewed these Accounting questions

Question

What is meant by steady state?

Answered: 1 week ago