2006-07-21 04:55:31 · 4 answers · asked by kowalskiphilip 1 in Business & Finance ➔ Other - Business & Finance
This is available in MS office Excel formulas. Try formula PMT
Example:
Data Description
8% Annual interest rate
10 Number of months of payments
10000 Amount of loan
Formula Description (Result)
=PMT(A2/12, A3, A4) Monthly payment for a loan with the above terms (-1,037.03)
=PMT(A2/12, A3, A4, 0, 1) Monthly payment for a loan with the above terms, except payments are due at the beginning of the period (-1,030.16)
2006-07-21 05:09:33 · answer #1 · answered by Anonymous · 4⤊ 0⤋
The payment would be 202.90
2006-07-21 05:00:35 · answer #2 · answered by opyankees_06 6 · 0⤊ 0⤋
$ 202.90
2006-07-21 04:59:44 · answer #3 · answered by Tom-SJ 6 · 0⤊ 0⤋
$202.90
2006-07-21 04:58:22 · answer #4 · answered by Stephen B 3 · 0⤊ 0⤋