Hi,
New to excel, need help in developing formulas for the following
examples

1. Payments of $440,000 semi annual for 20 years or 8million dollars
now, what is the rate of interest used to arrive at 8mm?

2. Payment of 8mm now or using a rate of 7% what should the semi annual
payments be for 20 years to equal the value of $8million?

Thank you for your help


--
busterbrown885
------------------------------------------------------------------------
busterbrown885's Profile: http://www.excelforum.com/member.php...o&userid=25987
View this thread: http://www.excelforum.com/showthread...hreadid=393520