Assistance with loan calculation - hope someone can assist

[segran]

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