Goal Seek Application

A

Adn

Can anyone help me on application of goal seek? I want to calculate monthly installment through Goal Seek.
 
P

Peter Atherton

-----Original Message-----
Can anyone help me on application of goal seek? I want to
calculate monthly installment through Goal Seek.
You would be better using Excel's Financial formuals.
PMT and PPMT calulate repayments see below for PMT
Loan of 100 over 24 months at 5% interest per an (5%/12)
with payment at the beginning of each period.

Loan 1000
Periods 24
Interest .004166667

Payments -£43.69

Regards
Peter
 
Top