Financial Functions Question
Why are the following now equal (I am having a brain lock)
If rate = 5%(cell A1), nper = .75 (Cell A2), and amount = 35,000 (cell A3)
PV(A1,A2,A3,0) does not equal PV(A1,A2,0,A3)
The problem appears to be that when the amount appeears as the PMT for less than a full period, the full amount is not used.
I am trying to PV all of the full interest payments on a bond; i.e., PV(7%,12.34444,35000,1000000); yet the first period seems to only include a portion of the interest payment.
Thanks in advance.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By doublejoy529 in forum Excel General
Last Post: 08-02-2008, 02:39 PM
By TChatelain in forum Excel Formulas & Functions
Last Post: 01-17-2008, 02:54 PM
By DCSwearingen in forum Excel Formulas & Functions
Last Post: 05-23-2007, 02:33 PM
By gonavy0806 in forum Excel Formulas & Functions
Last Post: 03-24-2007, 03:10 PM
By cfalevel_1 in forum Excel General
Last Post: 01-28-2007, 12:14 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1