G Guest Apr 28, 2004 #1 Can anyone help me on application of goal seek? I want to calculate monthly installment through Goal Seek.
Can anyone help me on application of goal seek? I want to calculate monthly installment through Goal Seek.
P Peter Atherton Apr 28, 2004 #2 -----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
-----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
