By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

Looking for some financial formulas

P: n/a
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.
Dec 10 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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!

Dec 10 '05 #2

P: n/a
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
Dec 10 '05 #3

P: n/a

"Ewoud Dronkert" <fi*******@lastname.net.invalid> schreef in bericht
news:o6********************************@4ax.com...
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.
Dec 10 '05 #4

P: n/a
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

Dec 10 '05 #5

P: n/a
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/
Dec 19 '05 #6

P: n/a
>
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.
Dec 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.