[PHP] mortgage calculator

2003-03-05 Thread Karen E. Lubrecht
I'd like to add a mortgage calculator to a client's site. I've been unable
to find the formula. In searching php.net, I found a discussion from back in
2000 related to some buggy code. My web search hasn't produced anything
other than realtor and mortgage companies and a perl script site. I'm not
familiar with perl and would prefer avoiding it until my knowledge improves.
There were corrections for a java script somewhere, but I'm beginning to
think it is down. Some things seem so obvious that you just don't think you
need to bookmark! So why can't I remember...

I would just prefer not reinventing the wheel. Suggestions would be greatly
appreciated.

Karen


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] mortgage calculator

2003-03-05 Thread Mark Heintz PHP Mailing Lists

http://dave.imarc.net/ offers one.  I haven't used it yet myself, though.

mh.

On Wed, 5 Mar 2003, Karen E. Lubrecht wrote:

 I'd like to add a mortgage calculator to a client's site. I've been unable
 to find the formula. In searching php.net, I found a discussion from back in
 2000 related to some buggy code. My web search hasn't produced anything
 other than realtor and mortgage companies and a perl script site. I'm not
 familiar with perl and would prefer avoiding it until my knowledge improves.
 There were corrections for a java script somewhere, but I'm beginning to
 think it is down. Some things seem so obvious that you just don't think you
 need to bookmark! So why can't I remember...

 I would just prefer not reinventing the wheel. Suggestions would be greatly
 appreciated.

 Karen


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] mortgage calculator

2003-03-05 Thread David T-G
Karen --

...and then Karen E. Lubrecht said...
% 
...
% familiar with perl and would prefer avoiding it until my knowledge improves.

Actually, if you can read php, you can probably read perl; php is very
perl-ish.

If you *do* find it, I'd love to see a followup post :-)  Heck, I'd even
take the perl script location; I speak perl.  In fact, I'm sure I can
translate the perl script for a small fee; it shouldn't take long.


HTH  HAND

:-D
-- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!



pgp0.pgp
Description: PGP signature


Re: [PHP] mortgage calculator

2003-03-05 Thread Jonathan Pitcher
Karen,

I am currently developing a class for mortgage calculations for our 
website.  I forced one of our accounts to walk me through the 
calculations and the formula's.

The class is still in an alpha stage but I would be more then willing 
to share my code when it is completed in 3+ weeks.

Jonathan Pitcher

On Wednesday, March 5, 2003, at 10:49  AM, Karen E. Lubrecht wrote:

I'd like to add a mortgage calculator to a client's site. I've been 
unable
to find the formula. In searching php.net, I found a discussion from 
back in
2000 related to some buggy code. My web search hasn't produced anything
other than realtor and mortgage companies and a perl script site. I'm 
not
familiar with perl and would prefer avoiding it until my knowledge 
improves.
There were corrections for a java script somewhere, but I'm beginning 
to
think it is down. Some things seem so obvious that you just don't 
think you
need to bookmark! So why can't I remember...

I would just prefer not reinventing the wheel. Suggestions would be 
greatly
appreciated.

Karen

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] mortgage calculator

2003-03-05 Thread Chris Hayes
At 17:49 5-3-03, you wrote:
I'd like to add a mortgage calculator to a client's site. I've been unable
to find the formula.
Well the calculation depends on the companies policy of course.
1. Normal rent calculation would go like this:
where
 i = interest or rent over a certain the period of time (
usually between 0 and 1 (1=100%). With 3.5% interest, i is 
3.5/100=0.035
 n = the amount of timeperiods that passed
 $ = pack of money   , and $(0) is heap at start, $(n) is at end of n 
timeperiods

  $(n)= $(0) * (1+i)^n

(x raised-to-the-power-of y is sometimes written as x^y, sometimes as x**y 
(Perl))

in PHP
$startsum=$_POST['startsum'];
$interest=$_POST['interest'];
$timeperiods=$_POST['timeperiods'];
  $endsum = $startsum * pow(1+$interest/100,$timeperiods);
With a 3% year-rent  in 5 years $10 grows to
  $(n) = 10 * 1.03^5
2. Mortgage calculation
Well how do they pay back?
You can have them pay a fixed part of the loan plus the interest of the 
month, here called an annuiteiten-hypotheek
Then every month you pay
($in_this_month *interest)  + (1/$totalmonths * $startsum )

$in_this_month is probably
$n=thismonths number
so the monthly payment would look something like

((1 - $n/$totalmonths) * $startsum ) + (1/$totalmonths * $startsum )

I suppose you can simplify this if you are a mathematician.
If you are a bloody consultant you should have learned these formulas once 
up on a time.

You can loop through $n of course to make a nice list.






 In searching php.net, I found a discussion from back in
2000 related to some buggy code. My web search hasn't produced anything
other than realtor and mortgage companies and a perl script site. I'm not
familiar with perl and would prefer avoiding it until my knowledge improves.
There were corrections for a java script somewhere, but I'm beginning to
think it is down. Some things seem so obvious that you just don't think you
need to bookmark! So why can't I remember...
Perl is not that hard to translate to PHP if it is clear what every 
variable means.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP] mortgage calculator

2003-03-05 Thread Karen E. Lubrecht
Thanks, Mark! I haven't checked it in detail yet, but if nothing else it has
the formula for which I was searching.

Karen

 -Original Message-
 From: Mark Heintz PHP Mailing Lists [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, March 05, 2003 12:04 PM
 To: Karen E. Lubrecht
 Cc: [EMAIL PROTECTED]
 Subject: Re: [PHP] mortgage calculator



 http://dave.imarc.net/ offers one.  I haven't used it yet myself, though.

 mh.

 On Wed, 5 Mar 2003, Karen E. Lubrecht wrote:

  I'd like to add a mortgage calculator to a client's site. I've
 been unable
  to find the formula. In searching php.net, I found a discussion
 from back in
  2000 related to some buggy code. My web search hasn't produced anything
  other than realtor and mortgage companies and a perl script
 site. I'm not
  familiar with perl and would prefer avoiding it until my
 knowledge improves.
  There were corrections for a java script somewhere, but I'm beginning to
  think it is down. Some things seem so obvious that you just
 don't think you
  need to bookmark! So why can't I remember...
 
  I would just prefer not reinventing the wheel. Suggestions
 would be greatly
  appreciated.
 
  Karen




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] mortgage calculator

2003-03-05 Thread Karen E. Lubrecht
WOW! This list has been a wonderful resource! Thanks to all of you.
To top it off I have learned a great new technique for google search, start
in the back end of relevance! (You probably all know that, but for some
reason I never made the connection.) In addition to the site that Mark
mentioned,
http://www.karakas-online.de/myServices/showfile.php?highlight=mortgage was
included among others.

David, the link to the perl script is http://www.nohope.net/perl/ I'm not a
Perlie so I didn't check it.

Considering my many hats, I confess to have learned the formula long ago,
but couldn't get my hands on the formula when I needed it. Frustrating and I
won't even go there.

Thanks to all!

Karen

 -Original Message-
 From: David T-G [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, March 05, 2003 12:11 PM
 To: PHP General list
 Cc: Karen E. Lubrecht
 Subject: Re: [PHP] mortgage calculator


 Karen --

 ...and then Karen E. Lubrecht said...
 %
 ...
 % familiar with perl and would prefer avoiding it until my
 knowledge improves.

 Actually, if you can read php, you can probably read perl; php is very
 perl-ish.

 If you *do* find it, I'd love to see a followup post :-)  Heck, I'd even
 take the perl script location; I speak perl.  In fact, I'm sure I can
 translate the perl script for a small fee; it shouldn't take long.


 HTH  HAND

 :-D
 --
 David T-G  * There is too much animal courage in
 (play) [EMAIL PROTECTED] * society and not sufficient moral courage.
 (work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science
 and Health
 http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] mortgage calculator

2003-03-05 Thread Lowell Allen
 From: Karen E. Lubrecht [EMAIL PROTECTED]
 
 I'd like to add a mortgage calculator to a client's site. I've been unable
 to find the formula. In searching php.net, I found a discussion from back in
 2000 related to some buggy code. My web search hasn't produced anything
 other than realtor and mortgage companies and a perl script site. I'm not
 familiar with perl and would prefer avoiding it until my knowledge improves.
 There were corrections for a java script somewhere, but I'm beginning to
 think it is down. Some things seem so obvious that you just don't think you
 need to bookmark! So why can't I remember...
 
 I would just prefer not reinventing the wheel. Suggestions would be greatly
 appreciated.

There's a free PHP mortgage calculator at http://www.dreamcost.com/, which
I easily adapted for use on http://www.williamsauction.com/.

HTH

--
Lowell Allen


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php