" + "%s |
| " + "%s |
Back";
function EmitRow1(s1)
{
Emit(shBeginRow1);
Emit1(shCell1, s1);
Emit(shEndRow);
}
function Execute(oForm)
{
var iError = 0;
var nMinP, nMaxP, nMinI, nMaxI, iYears;
if ( (nMinP = Validate(oForm.appq0001.value, 0)) == nErrorNumber)
iError = 100;
else if ( (nMaxP = Validate(oForm.appq0002.value, 0)) == nErrorNumber)
iError = 100;
else if ( (nMinI = Validate(oForm.appq0003.value, 0)) == nErrorNumber)
iError = 100;
else if ( (nMaxI = Validate(oForm.appq0004.value, 0)) == nErrorNumber)
iError = 100;
else if ( (iYears = Validate(oForm.appq0005.value, 1)) == nErrorNumber)
iError = 140;
var iPpy = 12;
var iMonths = 12 * iYears;
var iPeriods = iPpy * iYears;
if (!iError)
{
var sMessage = "";
if (nMinP == 0)
sMessage = "Please enter a minimum principal amount";
else if (nMinP < 0)
sMessage = "Minimum principal amount must be positive";
else if (nMaxP == 0)
sMessage = "Please enter a maximum principal amount";
else if (nMaxP < 0)
sMessage = "Maximum principal amount must be positive";
else if (nMinP >= nMaxP)
sMessage = "Minimum principal amount must be smaller "
+ "than maximum principal amount";
else if (nMinP + 100 > nMaxP)
sMessage = "Minimum principal amount must be at least"
+ " $100 smaller "
+ "than maximum principal amount";
else if (nMinI == 0)
sMessage = "Please enter a minimum interest rate";
else if (nMinI < 0)
sMessage = "Minimum interest rate must be positive";
else if (nMaxI == 0)
sMessage = "Please enter a maximum interest rate";
else if (nMaxI < 0)
sMessage = "Maximum interest rate must be positive";
else if (nMinI >= nMaxI)
sMessage = "Minimum interest rate must be smaller "
+ "than maximum interest rate";
else if (nMinI + .01 > nMaxI)
sMessage = "Minimum interest rate must be at least"
+ " 0.01% smaller "
+ "than maximum interest rate";
else if (iYears == 0)
sMessage = "Please enter length of loan (in years)";
else if (iYears < 0)
sMessage = "Length of loan (in years) must be positive";
if (sMessage != "")
{
iError = 170;
alert(sMessage);
}
}
if (!iError)
{
var iR, iC;
var nInterests = new Array(iColumns);
var nPrincipals = new Array(iRows);
// bRoundedHeadings = 0; // ***** temp
if (bRoundedHeadings)
{
Heads(nMinI, nMaxI, nInterests);
Heads(nMinP, nMaxP, nPrincipals);
}
else
{
for (iR = 0; iR < iRows; ++iR)
nPrincipals[iR] = Round(nMinP + iR * (nMaxP - nMinP)
/ (iRows - 1), 0);
for (iC = 0; iC < iColumns; ++iC)
nInterests[iC] = Round(nMinI + iC * (nMaxI - nMinI)
/ (iColumns - 1), 3);
}
Emit1(shStart, "Mortgage Payment Table Results<\/span>");
// Emit1(shHeadGif, "gifs/mort_table_results.gif");
Emit1(shHeading2, "Mortgage Payment Table Results<\/span>");
Emit(shBeginTable1);
EmitRow1("Monthly Payment Comparison Table");
EmitRow1("Based on " + iYears + " Year Fixed Rate Mortgage");
EmitRow1("Interest Rate Range: " + nMinI + " % to "
+ nMaxI + " %");
EmitRow1("Principal Amount Range: $" + nMinP + " to $"
+ nMaxP);
Emit(shEndTable);
Emit(shBeginTable2);
Emit(shBeginRow1);
Emit1(shCell2, " ");
for (iC = 0; iC < iColumns; ++iC)
Emit1(shCell2, Format(nInterests[iC], 0, 3));
Emit(shEndRow);
for (iR = 0; iR < iRows; ++iR)
{
Emit(shBeginRow1);
Emit1(shCell3, Format(nPrincipals[iR], 0, 0));
for (iC = 0; iC < iColumns; ++iC)
{
nPayment = nPrincipals[iR] / PresentValue(1,
nInterests[iC]/1200, iMonths);
nPayment = Round(nPayment + .005, 2);
Emit1(shCell4, Format(nPayment, 0, 2));
}
Emit(shEndRow);
}
Emit(shEndTable);
Emit(shEndPage);
}
if (!iError)
{
if (bDebug && sDump != "")
sOut += sNl + "" + sDump + "
";
// document.open();
document.write(sOut);
document.close();
}
}
function Heads(nMin, nMax, nHeads)
{
var iCount = nHeads.length;
var nDiff = nMax - nMin, nInterval, nLower, nUpper;
var iPow = -Math.floor(Math.log(nDiff)/Math.log(10)) - 2;
var bIterate = true;
var iSlots, iMinSlot, iK, iValues;
while (bIterate)
{
nInterval = ExpN(10, -iPow);
iSlots = iCount;
iMinSlot = 0;
nLower = Round2(nMin-ExpN(10, -iPow-5), iPow, 1);
nUpper = Round2(nMax+ExpN(10, -iPow-5), iPow, -1);
if (nLower != Round2(nMin, iPow + 5, 0))
--iSlots, ++iMinSlot, nHeads[0] = nMin;
if (nUpper != Round2(nMax, iPow + 5, 0))
--iSlots, nHeads[iCount-1] = nMax;
iValues = Math.round((nUpper - nLower)/nInterval) + 1;
if (iValues < iSlots)
++iPow;
else
{
for (iK = 0; iK < iSlots; ++iK)
nHeads[iK+iMinSlot] = nLower + nInterval
* Math.round((iValues-1) * iK / (iSlots-1));
bIterate = false;
}
}
}
function Dump(sStr) { if (bDebug) sDump += sStr + sNl; }
function Emit(sStr) { sOut += sStr + sNl; }
function Emit1(sStr, s1)
{
var iK;
if ( (iK = sStr.indexOf(sSub)) >= 0)
sStr = sStr.substring(0, iK) + s1
+ sStr.substring(iK + sSub.length);
Emit(sStr);
}
function Emitx(sStr, sSubs)
{
var iK, iL, iPos1 = 0, iPos2 = 0;
while ( (iK = sStr.indexOf(iPos1, sSub)) >= 0)
{
if ( (iL = eSubs.indexOf(iPos2, sSep)) < 0)
iL = eSubs.length();
sStr = sStr.substring(0, iK)
+ sSubs.substring(iPos1, iL)
+ sStr.substring(iK + sSub.length());
iPos1 = iK + sSub.length();
if ( (iPos2 = iL + eSep.length()) > sSubs.length())
iPos2 = sSubs.length();
}
Emit(sStr);
}
var sBlanks = " "
+ " ";
var sDashes = "---------------------------------------------"
+ "-----------------------------------------";
var nPowers = [
0.0000000000000001,
0.000000000000001,
0.00000000000001,
0.0000000000001,
0.000000000001,
0.00000000001,
0.0000000001,
0.000000001,
0.00000001,
0.0000001,
0.000001,
0.00001,
0.0001,
0.001,
0.01,
0.1,
1.,
10.,
100.,
1000.,
10000.,
100000.,
1000000.,
10000000.,
100000000.,
1000000000.,
10000000000.];
function Power(n)
{
return nPowers[n+16];
}
var sMonths = ["January", "February", "March", "April", "May",
"June", "July", "August", "September", "October",
"November", "December"];
function Mmm(iK) { if (!(iK >= 1 && iK <= 12)) return "MMM" + iK;
return sMonths[iK-1].substring(0, 3); }
function ExpN(nX, iN) // compute x ** n, where n is integral
{
var nResult = 1;
var bSign = 0;
if (iN < 0)
{
bSign = 1;
iN = -iN;
}
while (iN > 0)
{
if (iN & 1)
nResult *= nX;
nX *= nX;
iN >>= 1;
}
if (bSign)
nResult = 1 / nResult;
return nResult;
}
function PresentValue(nPayment, nPercent, iNumPeriods)
{
var nAmount = (Math.abs(nPercent) > 1e-20)
? nPayment * (1 - ExpN(1 + nPercent, -iNumPeriods))
/ nPercent
: nPayment * iNumPeriods;
return nAmount;
}
function SparsePresentValue(nPayment, nPercent, iInterval, iNumPeriods)
{
var nAmount = (Math.abs(nPercent) > 1e-20)
? nPayment * (1 - ExpN(1 + nPercent, -iNumPeriods))
/ (ExpN(1 + nPercent, iInterval) - 1)
: nPayment * iNumPeriods;
return nAmount;
}
function Round(nVal, iD)
{
var iSign = 1;
if (nVal < 0)
{
nVal = - nVal;
iSign = -1;
}
var iInt = Math.round(nVal);
if (iD > 0)
iInt = Math.floor(nVal);
var nFp = nVal - iInt;
// alert ('iInt, nFp = ' + iInt + ", " + nFp);
if (iD > 0)
nFp = Math.round(nFp * Power(iD)) / Power(iD);
nVal = iSign * (iInt + nFp);
return nVal;
}
function Round2(nVal, iD, iType)
// iType: -1 = floor, 0 = round, +1 = ceil
{
var nPow = Power(iD);
nVal = Math.round(nVal * nPow + iType * .5) / nPow;
// alert(nVal + "/" + iD + "/" + iType + "/" + nPow + "/" + nVal);
return nVal;
}
function Validate(sVal, bInt)
{
var sMessage = "";
var bDot = 0, bE = 0, iState = 0;
var sCh, iK;
var bInvalid = 0;
var nValue = bInt ? parseInt(sVal) : parseFloat(sVal);
for (iK = 0; sMessage == "" && iK < sVal.length; ++iK)
{
sCh = sVal.charAt(iK);
if (sCh == " ")
{
if (iState > 0)
iState = 9;
}
else
{
if (iState == 9)
sMessage = "Number '" + sVal + "' has an embedded blank";
else if (sCh == '.' && !bInt)
{
if (bDot || bE)
bInvalid = 1;
else
bDot = 1;
}
else if ((sCh == 'e' || sCh == 'E') && !bInt)
{
if (bE)
bInvalid = 1;
else
{
bE = 1;
iState = 6;
}
}
else if (sCh == '+' || sCh == '-')
{
if (iState == 0 || iState == 6)
++iState;
else
sMessage = "Number '" + sVal + "' contains a sign "
+ "in an illegal position"
}
else if (sCh >= '0' && sCh <= '9')
{
if (iState == 1 || iState == 7)
++iState;
else if (iState == 0 || iState == 6)
iState += 2;
}
else
bInvalid = 1;
}
if (bInvalid)
sMessage = "Number '" + sVal + "' contains"
+ " invalid non-numeric character(s)";
}
if (sMessage == "")
if (iState == 1 || iState == 6 || iState == 7)
sMessage = "Illegal number: " + sVal;
else if (iState == 0)
nValue = 0;
if (sMessage != "")
{
alert(sMessage);
nValue = nErrorNumber;
}
return nValue
}
// DollarFormat -- could be jazzed up to produce "CR" or "DB"
function DollarFormat(nVal, iW, iD)
{
return GenFmt(nVal, iW, iD, 1);
}
function Format(nVal, iW, iD)
{
return GenFmt(nVal, iW, iD, 0);
}
function GenFmt(nVal, iW, iD, bDollar) // format val into w chars,
// d digs after decimal point
{
var sOut = "";
var iSign = 0;
nVal = Round(nVal, iD);
if (nVal < 0)
{
nVal = - nVal;
iSign = 1;
}
var iInt = Math.round(nVal);
if (iD > 0)
iInt = Math.floor(nVal);
var nFp = nVal - iInt;
var iDigs = 1;
if (iInt > 9)
iDigs = Math.floor(Math.log(iInt+.1)/Math.log(10)) + 1;
var iLeft = iW - iSign - (bDollar ? 1 : 0);
if (iD > 0)
iLeft -= iD + 1;
if (iLeft > iDigs)
sOut += sBlanks.substring(0, iLeft - iDigs);
if (iSign)
sOut += '-';
if (bDollar)
sOut += '$';
sOut += iInt;
if (iD > 0)
{
nFp = Math.round((1 + nFp) * Power(iD));
sOut += '.' + String(nFp).substring(1);
}
return sOut;
}
function PrepadString(sStr, iW)
{
if (sStr.length < iW)
sStr = sBlanks.substring(0, iW - sStr.length) + sStr;
return sStr;
}
function CenterString(sStr, iW)
{
var iBlanks = iW - sStr.length;
if (iBlanks > 0)
sStr = sBlanks.substring(0, Math.floor(iBlanks/2)) + sStr
+ sBlanks.substring(0, iBlanks - Math.floor(iBlanks/2));
return sStr;
}