Dave Taylor answers free tech support questions about a wide variety of business and technical topics, including blogging, iphone help, ipod help, AdSense, MySpace, Sony PSP help, Mp3 players, Windows XP, Windows Vista, Linux, SEO, Mac OS X, Facebook, Twitter and LinkedIn.

Interesting JavaScript code example: finance calculator

I've been building a financial calculator that lets you enter a monthly payment, an interest rate level and an overall debt level, then tells you how long it'll take to pay off the loan and how much interest you'll end up paying. It's fairly self-explanatory, I think, and interesting to read.

First off, here's the JavaScript:

<script type="text/javascript">
<!--
// Script written by Dave Taylor based on some math suggested by
// Bennett Haselton @ Peacefire.org. Thanks Bennett!

function centNotation(value)
{
  // return the value in normalized dollars.cents notation

  dollars = Math.floor(value);  // chop floating point portion
  cents   = Math.floor((value % 1) * 100);              // and chop everything else
  if (cents < 10) cents = "" + cents + "0";

  return(dollars + "." + cents);
}

Dave's Answer:

function validInt(value)
{
  // return true if it's digits or decimal point-only, false otherwise.

  for (var i=0; i < value.length; i++) {
    var c = value.charAt(i);
    if ((c < '0' || c > '9') && c != '.') {
      alert("There's a problem: all values herein must " +
        "be numbers only, and " + value + " has an unacceptable character " +
        "'" + c + "'");
      return(false);
    }
  }
  return(true);
}

function myPaymentCalc()
{
  // calculate the number of payments and total payments for a simple loan given
  // the interest, monthly payment and principal of the loan.
  
  var interestRate = document.debtcalc.interest.value,
      monthlyPayment = document.debtcalc.monthlypayment.value,
      principal = document.debtcalc.principal.value,
      accumulatingInterest = 1;
  
  if (! validInt(interestRate) || ! validInt(monthlyPayment) ||
      ! validInt(principal))
    return(false);
    
  if (interestRate == 0 || monthlyPayment == 0 || principal == 0) {
    alert("You need to specify your monthly payment, credit card " +
        "interest rate and current debt amount before I can calculate " +
        "how long it'll take for you to pay off your debt.");
    return(false);
  }
  
  interestRate = (interestRate > 1)? interestRate / 100.0 : interestRate;

  monthlyInterestRate = interestRate / 12;

  if (principal * monthlyInterestRate > monthlyPayment) {
    monthlyrate = "$" + centNotation(principal * monthlyInterestRate);
    permonthPayment = "$" + centNotation(monthlyPayment);
    alert("You've got a fundamental problem: your monthly payment of " +
        permonthPayment + " is less than the interest added each month " +
        "(which is " + monthlyrate + ") and you will never " +
        "pay off this debt. It might be a good time to call your creditors.");
    return(false);
  }
   
  interimVal1 = monthlyPayment - (monthlyInterestRate * principal)
  
  numberOfPayments = (Math.log(monthlyPayment) - Math.log(interimVal1)) /
        Math.log(1+monthlyInterestRate);
  
  numberOfPayments = Math.ceil(numberOfPayments);
      
  interimVal2 = Math.pow((monthlyInterestRate+1), (numberOfPayments-1));
  
  remaining = (principal * interimVal2) -
    (monthlyPayment/monthlyInterestRate) * (interimVal2 - 1);
    
  totalPayment = monthlyPayment *(numberOfPayments-1) + remaining;
  
  // clean up the display format to make it attractive...
        
  payments = numberOfPayments;
  totalpayment = "$" + centNotation(totalPayment);
  interestPaid = "$" + centNotation(totalPayment-principal);
  
  alert("Given these figures, you'll end up having " + payments +
        " payments and pay a total of " + totalpayment + ", of which " +
        interestPaid + " is interest.");

} 
// -->
</script>
Did I mention that it's a lot of JavaScript? :-)

The other part of this is the form itself, which actually ends up being fairly short by comparison:

<form id="debtcalc" name="debtcalc" action="#">
<div style="border:1px solid #669; padding:3px;font-size:85%;">
<div style="font-size:110%;font-weight:bold;">How long will it
take for you to pay off those holiday bills?</div>
Monthly payment:
<input type="text" size="6" name="monthlypayment" />
interest rate (APR):
<input type="text" name="interest" size="5" />
and amount owed:
<input type="text" name="principal" size="9" />
then
<input type="button" value=" solve " onclick="myPaymentCalc()"
 style="font-size: 80%;background-color: #CFC" />
</div>
</form>
So, want to see it in use? Go to RealLifeDebt.com and you'll find it on the home page.


Help others find this article at Del.icio.us, Digg, Netscape, Reddit, and Stumble Upon    

Subscribe!

Never miss another useful Q&A article again! Subscribe to AskDaveTaylor with Google Reader.

Comments

OMG, I can't believe you call yourself a 'guru'. centNotation() has an error in the line:

if (cents < 10) cents = "" + cents + "0";

Remind me not to get you to do my tax.

Posted by: Dave at May 23, 2007 9:12 PM

The script has no effect in my browser when I go to RealLifeDebt.com because it was included as follows (this should be in the head rather than the body, by the way):

[script src="calculator.js" type="text/css"][/script]

After replacing "text/css" with "text/javascript" it worked fine.

Posted by: Jason Boyle at July 13, 2007 1:27 AM

This line is missing from my comment above:

<script src="calculator.js" type="text/css"></script>

Posted by: Jason Boyle at July 13, 2007 1:30 AM


I have a lot to say, but ...
Starbucks coffee cup I have a lot to say, and questions of my own for that matter, but most of all I'd like to say thank you for all your efforts on this Web site by buying you a chai!

I do have a comment, now that you mention it!









Remember personal info?


Please note that I will never send you any unsolicited commercial email. Ever.

While I'm at it, please note that by submitting a question or comment you're agreeing to my terms of service, which are: you relinquish any subsequent rights of ownership to your material by submitting it on this site.









Uniblue: Free Virus Scan

Search
Find just the answers you seek from among our 1700+ free tech support articles by using our Lijit search engine.


Member of the B5Media Network

Help!





Subscribe to
Ask Dave Taylor!

Add to Google Reader
Add to My Yahoo!
Subscribe in NewsGator Online

RDF   XML

Free Updates!
Sign up and get free weekly updates and special offers on books, seminars, workshops and more.


Recent Entries
Join the List!
Join my author info mailing list, where you'll learn about my upcoming books, speaking gigs, and more!


Book Links
© 2002 - 2008 by Dave Taylor. All Rights Reserved.

Note: This web site is for the purpose of disseminating information for educational purposes, free of charge, for the benefit of all visitors. We take great care to provide quality information. However, we do not guarantee, and accept no legal liability whatsoever arising from or connected to, the accuracy, reliability, currency or completeness of any material contained on this web site or on any linked site.

[whiteboard marker tray]