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
Click to expand...
calculate monthly installment through Goal Seek.
.
Click to expand...
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal Seeking via Excel 0
Assign a function to a Command Button 3
Inputs for Goal Seek Command 4
What regular savings, increasing every year to reach goal 11
Goal Seek returning different results 3
Excel - Wich Function should I use? 1
Goal Seek with variable Set Cell 1
Goal Seek with Complex Numbers 2

Top