| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate after making 12 payments of my mortgage
Hi, can anyone tell me which fonction should I use to calculate a loan of
100,000$ with an interest Rate of =5.15% (0.4291) for 25 years (300) and pmt = -593.36. Question: after 12 payments How much do I still own the bank? The answers is $97982.46 by using my calculator but I don't know which fonction do I need to use in Microsoft Excel . Could anyone help Me! Regards Lutrinh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate loan balances when payments are missed? | Excel Worksheet Functions | |||
| 30-yr Amortization allowing 26 payments per year/780 lines vs 360 | Excel Worksheet Functions | |||
| calculate the value of a mortgage purchased at a discount | Excel Worksheet Functions | |||
| Calculate correct interest on loan when debtor pays late | Excel Discussion (Misc queries) | |||
| Making Excel Calculate In Correct Order | Excel Discussion (Misc queries) | |||
Threaded Mode
