Shareholder Loan calculations
- Former user (Deleted)
- Support
Inputs
- Driver
- Value
- Start
- End
- Redemption Mode
- Redemption Free Period
- Redemption Frequency
- Interest
- Method of Payment
Calculation
Profit & Loss statement | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cashflow statement |
Linear RedemptionDebt Tranches and Shareholder Loans have to be redeemed. Therefor a Redemption Frequency and a Redemption Free Period is defined. When the Redemption Free Period expires the Debt/Shareholder Loan is redeemed during the Loan Period in regular intervals according to the Redemption Frequency. When Debt with an amount of EUR 2'000'000, a Loan Period of 10 years, 24 months Redemption Free Period and a Redemption Frequency of 3 months is issued in 12 / 2015, the following Cashflow statement yields from this Debt and the connected Redemptions:
The Redemption occurs within 8 years respective 96 months. Thus a monthly Redemption of EUR 20'883 is necessary. Based on the quarterly Redemptions, an amount of EUR 62'500 has to be redeemed every third month. Annuity RedemptionWhen the debt is redeemed per annuity, the annual sum of Redemption amounts and Interest payments build a constant value. The Interest expense decline from year to year because the debt is getting less too. Therefore the Redemption amount has to increase to get an annuity Redemption. The Annuity amount can be calculated with the following formula:
When Debt with an amount of EUR 2'000'000, a Loan Period of 10 years, 24 months Redemption Free Period and a Redemption Frequency of 3 months is issued in 12 / 2015, an annuity redemption amount of annually EUR 304'86 or quarterly EUR 76'216 yields.
Bullet RedemptionWhen Bullet Redemption is selected as Redemption Mode the whole loan is redeemed at the end of the loan period. When Debt with an amount of EUR 2'000'000 and a Loan Period of 10 years is issued in 12 / 2015, the whole amount of EUR 2'000'000 is redeemed in 12 / 2025.
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Balance Sheet |
