austenr
11-04-2005, 01:39 PM
I am trying to determine the following using the PV function.
20,000,000 distributed in 10 installments
How much was it worth assuming a long term interest rate of 5%.
What is the effect on the answer if payments are received at the beginning of the year (Jan 1) vs. the end of the year(Dec 31st)
BTW, I thought I posted this on MrExcel but went to look for the link and could not find the post, thus, I am posting here. Thanks
20,000,000 distributed in 10 installments
How much was it worth assuming a long term interest rate of 5%.
What is the effect on the answer if payments are received at the beginning of the year (Jan 1) vs. the end of the year(Dec 31st)
BTW, I thought I posted this on MrExcel but went to look for the link and could not find the post, thus, I am posting here. Thanks