Goal Seek Application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me on application of goal seek? I want to calculate monthly installment through Goal Seek.
 
-----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
 
You must log in or register to reply here.

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

Assign a function to a Command Button 3
Calculate focal length from FOV on cameras 0
Inputs for Goal Seek Command 4
What if analysis icon is not available 2
Goal Seek returning different results 3
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL 1
Goal Seek with Complex Numbers 2
Goal-Seek Question 7

Back
Top