473,325 Members | 2,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Looking for some financial formulas

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
6 2981
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
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

"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
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
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
>
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: BlackHawke | last post by:
Hello! My name is Nick Soutter, I am the owner of a small game company in San Diego, CA called Aepox Games (www.aepoxgames.net). Our first product, Andromeda Online...
4
by: Nick Palmer | last post by:
Hi all, I'm looking for some third party libraries that provide mathematic (financial) functions, and date functions to include in a VC project. Anybody out there have anything that they can...
4
by: Sehri | last post by:
Hi all, I have just started developing a math companion tool with VS2005 and I just ran into a problem when trying to add the description of a formula. Doed anyone know how can I add math...
9
by: sr | last post by:
There is a System.Math class that is very helpful I couldn't imagine any next generation framework or language without one a Math class! What is the issue with having a System.Financial class for...
2
by: IntraRELY | last post by:
I know this isnt really a VB question per say, but is what I am developing in VB.NET and Excel is the only place that has provided direction. I wanted to ask the public if perhaps you could lend me...
1
by: boarderchic15 | last post by:
Hi- I have the following XML structure: <?xml version="1.0" encoding="UTF-8"?> <content> <type content_type="Listing"/> <faq_listing> <heading>Benefits</heading>...
5
by: mastro78 | last post by:
I'm working on Input Validation using the JS Header in my Notes app. I originally had formulas in Notes that was doing this, but now I've taken it to the web. So, after redoing the majority of the...
4
by: John Brock | last post by:
I have a .NET application that, among other things, creates Excel workbooks, and I have run into a very strange problem involving formulas on one worksheet that reference values on another...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.