Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100
I am trying to figure out this formula to determine Present Value for Letters
of Credit issued to borrowers |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100
You would calculate the PV of each individual cash flow, and add them up.
Ex: the PV of the first cash flow is N3*M3/100 (the payment) divided by (1+P3/1200)^1 (the one-period discount). For the second cash flow, the exponent on the discount would be 2, and so on, for all Q3 periods (presumably that's Q3 months, based on the way this is set up). "Claressa" wrote: I am trying to figure out this formula to determine Present Value for Letters of Credit issued to borrowers |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100
The interest related functions of Excel all belong to one family with one
basic equation. Some functions (invisibly) use iteration to get results. The basic equation is well described in HELP. -- Kind regards, Niek Otten "Claressa" wrote in message ... I am trying to figure out this formula to determine Present Value for Letters of Credit issued to borrowers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate a benefit amount | Excel Discussion (Misc queries) | |||
Can someone help with a formula to calculate dates? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula displays does not calculate | Excel Discussion (Misc queries) | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |