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).

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ McGraw Farm } \\ \hline \multicolumn{6}{|c|}{ Jan. 1, 2008- Dec, 31, 2008} \\ \hline \multicolumn{6}{|c|}{ Statement of Cash Flows } \\ \hline Account & Total & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 \\ \hline Beginning Cash Balance & {[1]} & 45000 & 950 & 5850 & 4850 \\ \hline \multicolumn{6}{|l|}{ Operating Receipts } \\ \hline Livestock product sales & 48000 & 12000 & 12000 & 12000 & 12000 \\ \hline \multicolumn{6}{|l|}{ Capital Receipts } \\ \hline Breeding Livestock sales & 10000 & 0 & 10000 & 0 & 0 \\ \hline \multicolumn{6}{|l|}{ Nonfarm Income } \\ \hline Off-farm salary & 40000 & 10000 & 10000 & 10000 & 10000 \\ \hline Total Cash Inflow & 143000 & {[2]} & 32950 & 27850 & 26850 \\ \hline \multicolumn{6}{|l|}{ Operating Expenses } \\ \hline Wages, Salaries, Benefits & 18000 & 4500 & 4500 & [3] & 4500 \\ \hline Feed purchases & 2500 & 2500 & 0 & 0 & 0 \\ \hline Other livestock expenses & 100 & 0 & 100 & 0 & 0 \\ \hline Supplies & 1050 & 450 & 0 & 0 & 600 \\ \hline Total operating expenses & 21650 & [4] & 4600 & 4500 & 5100 \\ \hline \multicolumn{6}{|l|}{ Capital Expenses } \\ \hline Breeding livestock & 15000 & 0 & 15000 & 0 & 0 \\ \hline \multicolumn{6}{|l|}{ Other Expenses } \\ \hline Family living expenses & {[5]} & 7500 & 7500 & 7500 & 7500 \\ \hline \multicolumn{6}{|l|}{ Scheduled Debt Payments } \\ \hline Current debt principal & 10000 & 0 & 0 & 10000 & 0 \\ \hline Current debt interest & 1000 & 0 & 0 & 1000 & 0 \\ \hline Noncurrent debt principal & 50000 & 50000 & 0 & 0 & 0 \\ \hline Noncurrent debt interest & 5000 & 5000 & 0 & 0 & 0 \\ \hline Total Cash Outflow & 132650 & 69950 & {[6]} & 23000 & 12600 \\ \hline Cash Available & 10350 & -2950 & 5850 & 4850 & [7] \\ \hline \multicolumn{6}{|l|}{ New Borrowing } \\ \hline Current & {[8]} & {[9]} & 0 & 0 & 0 \\ \hline Noncurrent & 0 & 0 & 0 & 0 & 0 \\ \hline Total New Borrowing & {[10]} & {[11]} & 0 & 0 & 0 \\ \hline \multicolumn{6}{|l|}{ Payments to New Debt } \\ \hline Principal & 0 & 0 & 0 & 0 & 0 \\ \hline Interest & 0 & 0 & 0 & 0 & 0 \\ \hline Total New Debt Payments & 0 & 0 & 0 & 0 & 0 \\ \hline Ending Cash Balance & 14250 & 950 & 5850 & {[12]} & 14250 \\ \hline \multicolumn{6}{|l|}{ Summary of Debt Outstanding } \\ \hline Current & 28900 & 28900 & 28900 & 28900 & 28900 \\ \hline Noncurrent & 100000 & 100000 & 100000 & 100000 & 100000 \\ \hline Total debt outstanding & 128900 & 128900 & 128900 & 128900 & 128900 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ McGraw Farm } \\ \hline \multicolumn{6}{|c|}{ Jan. 1, 2008- Dec, 31, 2008} \\ \hline \multicolumn{6}{|c|}{ Statement of Cash Flows } \\ \hline Account & Total & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 \\ \hline Beginning Cash Balance & {[1]} & 45000 & 950 & 5850 & 4850 \\ \hline \multicolumn{6}{|l|}{ Operating Receipts } \\ \hline Livestock product sales & 48000 & 12000 & 12000 & 12000 & 12000 \\ \hline \multicolumn{6}{|l|}{ Capital Receipts } \\ \hline Breeding Livestock sales & 10000 & 0 & 10000 & 0 & 0 \\ \hline \multicolumn{6}{|l|}{ Nonfarm Income } \\ \hline Off-farm salary & 40000 & 10000 & 10000 & 10000 & 10000 \\ \hline Total Cash Inflow & 143000 & {[2]} & 32950 & 27850 & 26850 \\ \hline \multicolumn{6}{|l|}{ Operating Expenses } \\ \hline Wages, Salaries, Benefits & 18000 & 4500 & 4500 & [3] & 4500 \\ \hline Feed purchases & 2500 & 2500 & 0 & 0 & 0 \\ \hline Other livestock expenses & 100 & 0 & 100 & 0 & 0 \\ \hline Supplies & 1050 & 450 & 0 & 0 & 600 \\ \hline Total operating expenses & 21650 & [4] & 4600 & 4500 & 5100 \\ \hline \multicolumn{6}{|l|}{ Capital Expenses } \\ \hline Breeding livestock & 15000 & 0 & 15000 & 0 & 0 \\ \hline \multicolumn{6}{|l|}{ Other Expenses } \\ \hline Family living expenses & {[5]} & 7500 & 7500 & 7500 & 7500 \\ \hline \multicolumn{6}{|l|}{ Scheduled Debt Payments } \\ \hline Current debt principal & 10000 & 0 & 0 & 10000 & 0 \\ \hline Current debt interest & 1000 & 0 & 0 & 1000 & 0 \\ \hline Noncurrent debt principal & 50000 & 50000 & 0 & 0 & 0 \\ \hline Noncurrent debt interest & 5000 & 5000 & 0 & 0 & 0 \\ \hline Total Cash Outflow & 132650 & 69950 & {[6]} & 23000 & 12600 \\ \hline Cash Available & 10350 & -2950 & 5850 & 4850 & [7] \\ \hline \multicolumn{6}{|l|}{ New Borrowing } \\ \hline Current & {[8]} & {[9]} & 0 & 0 & 0 \\ \hline Noncurrent & 0 & 0 & 0 & 0 & 0 \\ \hline Total New Borrowing & {[10]} & {[11]} & 0 & 0 & 0 \\ \hline \multicolumn{6}{|l|}{ Payments to New Debt } \\ \hline Principal & 0 & 0 & 0 & 0 & 0 \\ \hline Interest & 0 & 0 & 0 & 0 & 0 \\ \hline Total New Debt Payments & 0 & 0 & 0 & 0 & 0 \\ \hline Ending Cash Balance & 14250 & 950 & 5850 & {[12]} & 14250 \\ \hline \multicolumn{6}{|l|}{ Summary of Debt Outstanding } \\ \hline Current & 28900 & 28900 & 28900 & 28900 & 28900 \\ \hline Noncurrent & 100000 & 100000 & 100000 & 100000 & 100000 \\ \hline Total debt outstanding & 128900 & 128900 & 128900 & 128900 & 128900 \\ \hline \end{tabular}