Assignment 1
In the file annuity 1 – example, do the following:
In the white boxes fill in the data for an investment loan, having the following information
| Loan amount | 500 000 | |
| Annual interest rate | 9% | |
| Loan Period | 5 | |
| Repayment initial date | 2012-12-01 | |
Assignment 2
In the file annuity 2 – example, do the following:
Insert the following overdraft drawings (client’s uses of overdraft limits). The total overdraft limit provided on 01.01.2013 is 900 000 EUR.
| Period | Loan Payment /Use of overdraft Limit/ | |
| 1 | 01.01.2013 | 100 000 |
| 2 | 01.03.2013 | 100 000 |
| 3 | 01.05.2013 | 100 000 |
| 4 | 01.07.2013 | 0 |
| 5 | 01.09.2013 | 0 |
| 6 | 01.11.2013 | 80 000 |
| 7 | 01.01.2014 | 85 000 |
| 8 | 01.03.2014 | 40 000 |
| 9 | 01.05.2014 | 150 000 |
| 10 | 01.07.2014 | 25 000 |
| 11 | 01.09.2014 | 100 000 |
| 12 | 01.11.2014 | 120 000 |
| 13 | 01.01.2015 | 0 |
| Total | 900 000 | |
Assignment 3
Prepare maturities for the two annuities above on the basis of the annuity payments, organizing the information into the following table:
| Period
Loan description |
2013
|
2014 |
2015 |
2016 |
2017 |
|
| Loan 1 – Investment | Annuity payment – principle | |||||
| Annuity payment – interest | ||||||
| Loan 2 – Overdraft | Annuity payment – principle | |||||
| Annuity payment – interest | ||||||
| Total principle | ||||||
| Total interest | ||||||
| Total annuity payments | ||||||
Calculate the total value of both loans that the client is due to repay for the five-year period. How much is the amount of the collateral needed for the overdraft?
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer Assignment 1 In the file annuity 1
Assignment 1
In the file annuity 1 – example, do the following:
In the white boxes fill in the data for an investment loan, having the following information
| Loan amount | 500 000 | |
| Annual interest rate | 9% | |
| Loan Period | 5 | |
| Repayment initial date | 2012-12-01 | |
Assignment 2
In the file annuity 2 – example, do the following:
Insert the following overdraft drawings (client’s uses of overdraft limits). The total overdraft limit provided on 01.01.2013 is 900 000 EUR.
| Period | Loan Payment /Use of overdraft Limit/ | |
| 1 | 01.01.2013 | 100 000 |
| 2 | 01.03.2013 | 100 000 |
| 3 | 01.05.2013 | 100 000 |
| 4 | 01.07.2013 | 0 |
| 5 | 01.09.2013 | 0 |
| 6 | 01.11.2013 | 80 000 |
| 7 | 01.01.2014 | 85 000 |
| 8 | 01.03.2014 | 40 000 |
| 9 | 01.05.2014 | 150 000 |
| 10 | 01.07.2014 | 25 000 |
| 11 | 01.09.2014 | 100 000 |
| 12 | 01.11.2014 | 120 000 |
| 13 | 01.01.2015 | 0 |
| Total | 900 000 | |
Assignment 3
Prepare maturities for the two annuities above on the basis of the annuity payments, organizing the information into the following table:
| Period
Loan description |
2013
|
2014 |
2015 |
2016 |
2017 |
|
| Loan 1 – Investment | Annuity payment – principle | |||||
| Annuity payment – interest | ||||||
| Loan 2 – Overdraft | Annuity payment – principle | |||||
| Annuity payment – interest | ||||||
| Total principle | ||||||
| Total interest | ||||||
| Total annuity payments | ||||||
Calculate the total value of both loans that the client is due to repay for the five-year period. How much is the amount of the collateral needed for the overdraft?
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer