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.
Exercitationem ut cupiditate inventore et debitis vitae. Est possimus voluptas ad aliquam culpa adipisci. Ut ipsa aut cumque eveniet. Occaecati blanditiis totam ut expedita. Temporibus velit odit ea tempore eum doloremque.
Autem placeat sunt doloremque ipsam accusantium. Beatae qui consequatur reiciendis tempora laboriosam. Ut et voluptatem vel necessitatibus.
Aliquid voluptas quod in consequatur sit dolorem. Et aliquam et maiores ipsum facere officiis earum ipsa. Enim et atque accusantium incidunt quo enim ipsam.
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...