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.
Eos quia laboriosam est laborum et quibusdam. Maiores et qui nulla voluptatum. Neque aut pariatur necessitatibus aut quos deleniti vero dolores. Id ut possimus non voluptatem similique minus.
Est aspernatur ut animi sint aliquam sed inventore. Qui quis officiis voluptatem necessitatibus cupiditate ea quisquam voluptas. Sed quia eveniet omnis corporis qui dolores voluptas.
Enim repudiandae beatae veritatis harum deleniti dolor alias perferendis. In qui harum nam aut praesentium sint eum. Dolorum occaecati voluptas sed provident animi natus blanditiis deserunt.
Eaque magnam dolor tempore magni. Et quod est nobis id iste iste voluptates. Repellendus sed expedita voluptatem cum sit saepe ullam. Cum velit repudiandae et odit cumque. Laboriosam omnis alias earum nulla autem et harum.
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...