steffenhvid
New Member
- Joined
- Oct 14, 2009
- Messages
- 4
Hi there,
I am needing to do some calculations on a loan, the tricky part is that the interest and the payment is not the same.
Lets see how to explain
PV = 200.000
PMT = ?? (added monthly)
Interest = 10% pro anno (but added quaterly)
FV = 0
Can excel with out making a tabel calculate the yearly interest and the payment..??
I hope it makes sense.. or else i will try to explain it furter..
I am needing to do some calculations on a loan, the tricky part is that the interest and the payment is not the same.
Lets see how to explain
PV = 200.000
PMT = ?? (added monthly)
Interest = 10% pro anno (but added quaterly)
FV = 0
Can excel with out making a tabel calculate the yearly interest and the payment..??
I hope it makes sense.. or else i will try to explain it furter..
