Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 05, 07:10 PM posted to microsoft.public.excel.worksheet.functions
Claressa
 
Posts: n/a
Default 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   Report Post  
Old December 9th 05, 07:21 PM posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default 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   Report Post  
Old December 9th 05, 07:27 PM posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to calculate a benefit amount pgruening Excel Discussion (Misc queries) 6 August 9th 05 06:51 PM
Can someone help with a formula to calculate dates? SharonP. Excel Discussion (Misc queries) 11 August 9th 05 01:47 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula displays does not calculate Neil Bhandar Excel Discussion (Misc queries) 4 January 10th 05 11:55 PM
Excel - formula to calculate colored fill cells within a range wi. MA Excel Worksheet Functions 1 January 7th 05 05:06 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017