loan repayments.xls | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |||
2 | Capital Expenditure(RM) | 0.65 | 1 | 2 | 0.85 | 3 | 4 | 6 | 7 | 5 | |||
3 | Revenue (RM) | 15 | 6 | 11 | 20 | 21 | 41 | 20 | |||||
4 | Costs (RM) | 0.65 | 0.6 | 0.8 | 0.85 | 0.85 | 0.85 | 0.85 | |||||
5 | Number of Years for Repayment | 5 | |||||||||||
6 | Interest rate | 12% | |||||||||||
7 | Interest Accrued @12% | ||||||||||||
8 | Total Loan Amount | ||||||||||||
9 | Annual Payment | ||||||||||||
10 | Interest | ||||||||||||
11 | Principle Repayment | ||||||||||||
12 | |||||||||||||
13 | |||||||||||||
14 | |||||||||||||
15 | Calculate the interest and loan amount to be paid if 50% of capital is debt? | ||||||||||||
16 | |||||||||||||
17 | |||||||||||||
18 | |||||||||||||
19 | |||||||||||||
Sheet1 |
Hi All
I am hoping someone out there, is into project evaluation, etc
I have the following problem - how does one calculate interest payable and the loan amount payable each year, if there is capital expenditure required each year. Year 0, is the beginning of year 1. And payment of loan is only payable, once revenue is received(year 2). I dont know how to include the year 3, onwards forecasted capital expenditure, into the calculation. By the way, year one, is the current year, whilst year 2 onwards are forecasted.
Hope you can assist.
Thank You