At its simplest, this ought to be:
balance brought forward +drawdown -repayment +interest = ending bal
The concept of repayment is that you never model more repayment more than the amount of loan that is accrued in that period. So if you have capability to repay $1m, but the loan /drawdown during the period is $100, you repay $100. But where is the remainder of this 'pot' in the corkscrew calculation (i.e. $1m - $100) and why is it not carried forward onto the next period? Surely the fact that you have cash in the bank should be taken into consideration in your repayment capability for the period immediately after?
Thanks.
Minus consequatur facere explicabo assumenda et atque. Esse ducimus et quaerat eligendi. Repudiandae soluta quasi occaecati.
Et dolorum fuga adipisci repellat minus vero. Doloribus et sit ratione eos iusto. Iusto dolorem dolorum exercitationem esse.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...