Loan drawdown and repayment - how to automate

I am by no means an accountant, however I did come up with a method that yielded the values previously input in the range F10:N11. I started with column F based on the statement 2 ...From Year 1 onwards...
The driving engine behind the automation is found in the helper table, range F28:N35, with explanations listed below. I attempted to use simple formulas so that the rational could be more easily followed (I didn't want to confuse myself).
Let us know if you have any questions.

You're Welcome and thank you for the feedback. The 'Evaluate Formula' tool is often helpful in understanding what a formula is doing, however feel free to ask about any formula you don't understand.
The overall logic is to calculate the loan repayment/draw down that would be anticipated based on the previous years figures, then calculate the change in interest that will result due to potentially making that anticipated repayment/draw down and finally come up with a true repayment/draw down (I hope that makes sense).
Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

Attach a version of the workbook that illustrates the new problem.

That does change things, however I believe that the following modifications will account for the minimum cash balance now being more than the minimum draw down:
1) F30 and across: =IF(F29<0,CEILING(-F29+$R2,$R3),IF(AND($R3<$R2,F29<$R2),$R2,IF(F29<$R2,$R3,0)))
2) F34 and across: =IF(F33<0,CEILING(-F33+$R2,$R3),IF(AND(R2<R3,F33<$R2),$R2,IF(F33<$R2,$R3,0)))
Note that instead of hard coding the min balance and draw down the formulas reference cells R2 (balance) and R3 (draw down) respectively.
Let us know if you have any questions.

Thank You for the feedback and for marking the thread as 'Solved' (if problems arise you can reverse that action using the 'Thread Tools' link). A good way to see what a formula is doing is to select one of the cells using the formula then select/run the 'Evaluate Formula' tool on the 'Formulas' tab (2010 version of Excel). Let us know if you have any questions, and I hope that you have a blessed day.