| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want the PMT function to calculate using 360 days not 365
I am using Excel 2002 I am trying to calculate a fixed monthly payment on a
24 month loan. The problem is the bank uses a 360 day basis when they calculate the fixed monthly payment. Excel's PMT formula has a 365 day basis. I have been on the Internet to no avail. I would greatly appreciate anyone's help in solving this problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
| Calculate # of Days from one date to another | Excel Worksheet Functions | |||
| how do I make a function to count days? | Excel Worksheet Functions | |||
Threaded Mode
