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.
Minima et consequatur nostrum mollitia accusamus earum. Error possimus dolore ipsam nam rerum alias iste. Voluptates quaerat quae sit veritatis commodi temporibus.
Consectetur aspernatur dolore non consequatur eaque praesentium labore. Fugit est voluptatibus expedita eum est inventore veniam saepe. Autem ut id consectetur omnis. Facilis non dolorum enim inventore. Ut in placeat eos unde ullam.
Iure saepe consequuntur in. Expedita est nobis ut. Molestiae consequuntur tempore in. Consectetur magnam ad fugiat pariatur aut nihil. Vel iure architecto aliquam provident. Placeat placeat consequuntur animi dolorem reiciendis aliquid temporibus.
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...