| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the annual payment for a $4,000 loan, 3%, 3 years,
I have a simple need. We are about to make a loan of $4,000 to be paid back
in 3 annual payments (starting in Aril of 2011) at 3% interest. What is the payment amount. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate the annual payment for a $4,000 loan, 3%, 3 years,
=PMT(3%,3,-4000)
-- Kind regards, Niek Otten Microsoft MVP - Excel "snevitt" wrote in message ... I have a simple need. We are about to make a loan of $4,000 to be paid back in 3 annual payments (starting in Aril of 2011) at 3% interest. What is the payment amount. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate the annual payment for a $4,000 loan, 3%, 3 years,
Hi,
=PMT(0.03,3,4000) "snevitt" wrote: I have a simple need. We are about to make a loan of $4,000 to be paid back in 3 annual payments (starting in Aril of 2011) at 3% interest. What is the payment amount. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
| Can excel calculate a loan payment with a balloon at the end? | Excel Discussion (Misc queries) | |||
| Annual Benefit Payment Tracker | Excel Discussion (Misc queries) | |||
| Calculate Loan Payment Dates | Excel Worksheet Functions | |||
| loan amortization template with loan start date AND first payment | Excel Discussion (Misc queries) | |||
Linear Mode
