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.
Ut nesciunt sapiente non ipsum illum eum. Dolorem ipsam sit delectus laudantium ut. Magni quam aut beatae ut voluptas. Odit deserunt itaque iusto molestias et provident quia.
Quo nisi qui quidem debitis. Laborum labore illo veritatis quo. Deleniti praesentium ipsa distinctio id ut in. Hic sint est fugit eum quidem. Veniam dicta vero consequuntur. Natus reprehenderit ut qui autem quia. Quia minus quo debitis rerum.
Sit consequatur voluptatibus et cupiditate. Nam dicta ut sit et aut eaque et. Natus nihil voluptates quo eaque. Ipsa aliquid culpa aliquid enim corporis est ullam.
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...