LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 921
Default Inputed Interest / Present Value

Hello,

I have the following variable payment schedule, and associated dollar
amounts. What is the best way to determine the present value, using 5%?

November 1, 2007 100
November 1, 2008 100
May 1, 2009 100
November 1, 2009 100
May 1, 2010 100
November 1, 2010 100
May 1, 2011 100
November 1, 2011 100
May 1, 2012 100


TIA!



 
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
only allow one cell inputed for a range of cells Brian Excel Discussion (Misc queries) 8 October 30th 07 11:30 PM
how to have result of excell formula remian as if inputed jim miller Excel Discussion (Misc queries) 1 May 27th 07 12:07 AM
to compute interest rate from principal and interest amount PVJ Excel Discussion (Misc queries) 3 December 28th 05 05:01 PM
When I open up excel a worksheet that has been inputed opens up w. EL GUAPO Excel Discussion (Misc queries) 3 April 17th 05 08:52 PM
VBA: Return Searched Value Inputed by End-User Mcasteel Excel Worksheet Functions 1 October 28th 04 03:09 PM


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

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

About Us

"It's about Microsoft Excel"