Calculating capital cost

[imported_unknown]

Hello,

I'm a new user of Excel and new to this forum.

Can anyone help me with a formula for calculating the capital cost of an investment?

For example :
An investment of $ 100.000 will be amortisize in 5 years. We assume an intrest rate of 6 %. We want to know what the total intrest-'cost' (virtual) is.

Thx,
Monoceros
monoceros@yucom.be

 

[royUK]

there are several amortisation functions in Excel - click on functions and do a search for depreciation to check if any are suitable. There are Net Present Value functions.etc as well.You can check the PMT function
This message was edited by royUK on 2002-10-02 11:35