Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to calculate PMT function
On a 2 payment per year basis .....6 monthly
|
#2
|
|||
|
|||
One way:
If you have the following information: A1: <annual interest rate A2: <number of years A3: <Principal amount A4: =PMT(A1/2, A2*2, A3) The key is to make sure the rate and the periods are in sync - i.e., if you have 6-month periods, you need to have 6-month rates. In article , Daniel wrote: On a 2 payment per year basis .....6 monthly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions |