Looking for some financial formulas

[Martien van Wanrooij]

Hi all,

I have been looking in some forums etc. but cannot find what I would like. I
need some financial formulas for a site related to some mortgage issues.
Unfortunately the specifications have been supplied to me be an excel sheet
so it is quite tricky to find out how the formulas that are used have been
made. To give some examples: I would need a formula for the future value of
savings after x years when you have already an amount of money on the bank,
and you decide to add every month a fixed quantity of money to that savings
account. Another is: how much money should you set aside every month to
reach amount x after y years?
I have enough knowledge of basic math functions in php, unfortunately not
for the way how to use them in this situation so even a page with the
formulas themselves, without their translations to php, will be welcome :)

Martien.

[Darkstar 3D]

You have the formulas already in Excel just display or print them. On
the Tools menu, point to Formula Auditing, and then click Formula
Auditing Mode to display the formulas. Helps out big time on converting
a monsterish workbook!

[Ewoud Dronkert]

Martien van Wanrooij wrote:

need some financial formulas for a site related to some mortgage issues.
Unfortunately the specifications have been supplied to me be an excel sheet

So why ask in a php group?

http://support.microsoft.com/?kbid=213939
A download for MacOS, stuffit self extracting archive inside hqx:
http://www.microsoft.com/downloads/d...displaylang=en

--
E. Dronkert

[Martien van Wanrooij]

"Ewoud Dronkert" <fi*******@last name.net.invali d> schreef in bericht
news:o6******** *************** *********@4ax.c om...

So why ask in a php group? Because it will be a site with php functions, maybe there is already some
info available although I couldn't find it. http://support.microsoft.com/?kbid=213939
A download for MacOS, stuffit self extracting archive inside hqx:
http://www.microsoft.com/downloads/d...displaylang=en

But these links are also very helpful, thanks :)

Martien.

[Mara Guida]

Martien van Wanrooij wrote:

[...] I need some financial formulas [...].
[...] the specifications have been supplied to me be an excel sheet [...]

As Darkstar pointed out you can see the formulas in Excel.

Or try Wikipedia -- http://en.wikipedia.org/wiki/Time_value_of_money

[Manuel Lemos]

Hello,

on 12/10/2005 06:14 PM Martien van Wanrooij said the following:

Hi all,

I have been looking in some forums etc. but cannot find what I would like. I
need some financial formulas for a site related to some mortgage issues.
Unfortunately the specifications have been supplied to me be an excel sheet
so it is quite tricky to find out how the formulas that are used have been
made. To give some examples: I would need a formula for the future value of
savings after x years when you have already an amount of money on the bank,
and you decide to add every month a fixed quantity of money to that savings
account. Another is: how much money should you set aside every month to
reach amount x after y years?
I have enough knowledge of basic math functions in php, unfortunately not
for the way how to use them in this situation so even a page with the
formulas themselves, without their translations to php, will be welcome :)

This seems to be what you are looking for:

http://www.phpclasses.org/financial_class

This also has to do with mortgage:

http://www.phpclasses.org/amort
--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

[Dana Cartwright]

>

on 12/10/2005 06:14 PM Martien van Wanrooij said the following:

Hi all,

I have been looking in some forums etc. but cannot find what I would
like. I need some financial formulas for a site related to some mortgage
issues.

Burington's Handbook of Mathematics, Page 6, "Interest, Sinking Funds,
Annuities". Published in 1933 and just as relevant today as then.
Mathematics condensed into 100 pages. I could not write software without
it. I'm sure there are others that are just as useful. Probably it's on
the Web someplace.