ÿþ<HTML> <HEAD> <TITLE>Commercial Loan Calculator</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso8859-1"> <META NAME="description" CONTENT="Financial Calculators, ©1998-2010 KJE Computer Solutions, LLC. For more information please see http://www.dinkytown.net"> <STYLE> <!-- BODY, TABLE, TD, TH, UL, OL, DD, DL, P, BR { font-family: helvetica, arial, sans-serif; font-size: 10pt; } H1 { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } DT { font-family: helvetica, arial, sans-serif; font-size: 10pt; font-weight: bold; } P.footer { font-family: helvetica, arial, sans-serif; font-size: 9pt; } DIV.large { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } --> </STYLE> </HEAD> <!-- Financial Calculators, ©1998-2008 KJE Computer Solutions, LLC. For more information please see: <A HREF="http://www.dinkytown.net">http://www.dinkytown.net</A> --> <SCRIPT LANGUAGE="JavaScript"> <!-- function doLeave() { //alert("leave the applet focus"); document.calcsubmit.btnCallCalc.focus(); } function showbuttons() { var agt = navigator.userAgent.toLowerCase(); var IEMAC = ((agt.indexOf("msie") != -1) && agt.indexOf("mac")!=-1); var N6 = (agt.indexOf("netscape6") != -1 || (agt.indexOf("netscape/6") !=-1 )); if ( N6 ) { return "Netscape 6 is unable to support our detailed reports. Please upgrade to Nescape 7 or higher.<P>"; } if ( IEMAC ) { return "<P>"; } return "<P><FORM name=calcsubmit><INPUT TYPE='button' value='Calculate' Name='btnCallCalc' onClick='document.calculator.calculate()'><INPUT TYPE='button' value='View Report' Name='btnOpenNote' onClick='openNote()'></FORM>"; } function openNote() { var agt=navigator.userAgent.toLowerCase(); var is_aol = (agt.indexOf("aol") != -1); leftpos=0; if (screen) { leftpos=screen.width/2 - 300; } if (is_aol) { var s = " "; s=document.calculator.sJavaScriptReport('HTML'); document.write(s); } else { var OpenWindow=window.open("","newwin","toolbar=yes,menubar=yes,location=no,directories=no,status=no,scrollbars=yes,resizable=yes,copyhistory=no,width=600,height="+(screen.height-120)+",left="+leftpos+",top=5"); var s = " "; s=document.calculator.sJavaScriptReport('HTML'); OpenWindow.document.write(s); OpenWindow.document.close(); OpenWindow.focus(); } } // --> </Script> <BODY bgcolor="#FFFFFF" LINK="#003399" VLINK="#666666" BGCOLOR="#FFFFFF"> <!-- \Title\ --> <P><CENTER><table border=0 bgcolor="#000000" width=468 cellspacing=1 cellpadding=0><tr><td width="100%"><table bgcolor="#FFFFDD" border=0 width=468 cellspacing=1 cellpadding=5><tr><td width="100%" align=center valign=middle><DIV class=large><a href="index.html" STYLE="text-decoration: none">100 Free Tax, Debt and Financial Calculators</a></DIV></td></tr></table></TD></TR></TABLE></CENTER> <!-- \Main Area\ --> <!-- Financial Calculators, ©1998-2008 KJE Computer Solutions, LLC. For more information please see: <A HREF="http://www.dinkytown.net">http://www.dinkytown.net</A> --> <H1>Commercial Loan Calculator</H1><P>Use this calculator to estimate your debt service coverage with a new commercial loan. If your debt service coverage is greater than 1.25, including your new loan payment, you have a good chance of being approved. <P><CENTER> <!--[if IE]><object name="calculator" classid="clsid:8AD9C840-044E-11D1-B3E9-00805F499D93" codebase="http://java.sun.com/update/1.6.0/jinstall-6-windows-i586.cab#Version=1,4,0,0" height="450" width="565"><param name="code" value="DebtService" /><param name="archive" value="dinkytown.jar" /> <P style="font-size:1px; color: #ffffff" line-height: 1px><![endif]--><![if !IE]><P style="font-size:1px; color: #ffffff" line-height: 1px><![endif]></P><![if !IE]><APPLET name="calculator" code="DebtService.class" align="baseline" WIDTH="565" HEIGHT="450" archive="dinkytown.jar"><![endif]> <PARAM name="LOAN_AMOUNT" value="0"> <PARAM name="TERM" value="0"> <PARAM name="INTEREST_RATE" value="9"> <PARAM name="VERIFIABLE_NET_INCOME" value="0"> <PARAM name="DEPRECIATION_EXPENSE" value="0"> <PARAM name="OTHER_NON_CASH_CHARGES" value="0"> <PARAM name="REAL_ESTATE_MORTGAGE" value="0"> <PARAM name="BUSINESS_LINE_OF_CREDIT" value="0"> <PARAM name="AUTO_LOANS" value="0"> <PARAM name="CREDIT_CARDS" value="0"> <PARAM name="OTHER_LOANS" value="0"> <PARAM name="MONTHLY_DEBT_PAYMENTS_ELIMINATED" value="0"> <PARAM name="DEBT_SERVICE_REQUIRED_RATIO" value="1.25"> <PARAM name="DEBT_SERVICE_SUCCESS" value="Your debt service coverage of DEBT_SERVICE_COVERAGE is more than DEBT_SERVICE_REQUIRED_RATIO and there is a good chance your loan will be approved. Please click 'View Report' below to continue the process and contact one of our loan officers."> <PARAM name="DEBT_SERVICE_FAIL" value="Unfortunately your debt service coverage of DEBT_SERVICE_COVERAGE is not more than DEBT_SERVICE_REQUIRED_RATIO. You would probably not be able to qualify for for the loan above, considering the information you have given."> <PARAM name="MSG_REPORT_SUCCESS" value="Your debt service coverage of DEBT_SERVICE_COVERAGE is more than DEBT_SERVICE_REQUIRED_RATIO and there is a good chance your loan will be approved. Please click here to contact one of our loan officers."> <PARAM name="MSG_REPORT_FAIL" value="Unfortunately, your debt service coverage of DEBT_SERVICE_COVERAGE is not more than DEBT_SERVICE_REQUIRED_RATIO. You would probably not be able to qualify for for the loan above, considering the information you have given."> <PARAM name="MSG_TITLE_SUCCESS" value="We're ready to talk business!*"> <PARAM name="MSG_TITLE_FAIL" value="You probably do not qualify.*"> <!--CUSTOM PARAMETERS--> <PARAM name="TEXT_FOR_REPORT" value="<HTML> <HEAD> <TITLE>Commercial Loan Calculator</TITLE> <META HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=iso8859-1'> <META NAME='description' CONTENT='Financial Calculators, &QCPQ;1998-2010 KJE Computer Solutions, LLC. For more information please see http://www.dinkytown.net'> <STYLE> <!-- BODY, TABLE, TD, TH, UL, OL, DD, DL, P, BR { font-family: helvetica, arial, sans-serif; font-size: 10pt; } H1 { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } DT { font-family: helvetica, arial, sans-serif; font-size: 10pt; font-weight: bold; } P.footer { font-family: helvetica, arial, sans-serif; font-size: 9pt; } DIV.large { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } --> </STYLE> </HEAD> <BODY bgcolor='#FFFFFF' LINK='#003399' VLINK='#666666' BGCOLOR='#FFFFFF'> <CENTER><table border=0 bgcolor='#000000' width=468 cellspacing=1 cellpadding=0><tr><td width='100%'><table bgcolor='#FFFFDD' border=0 width=468 cellspacing=1 cellpadding=5><tr><td width='100%' align=center valign=middle><DIV class=large>Commercial Loan Calculator</DIV></td></tr></table></TD></TR></TABLE></CENTER> <H1>MSG_TITLE</H1>**GRAPH**<P>DEBT_SERVICE_MSG <P><CENTER><table border=0 bgcolor='#000000' width=95% cellspacing=1 cellpadding=0><tr><td width='100%'><table bgcolor='#FFFFFF' border=0 width=100% cellspacing=1 cellpadding=5> <TR BGCOLOR='#CCCCCC'><TD COLSPAN=2><CENTER><B>Results Summary</B></CENTER></TD></TR> <TR><TD valign=top><b>Loan amount</b></TD><TD>LOAN_AMOUNT</TD></TR> <TR><TD valign=top><b>New monthly payment</b></TD><TD>MONTHLY_PAYMENT</TD></TR> <TR><TD valign=top><b>Interest rate</b></TD><TD>INTEREST_RATE</TD></TR> <TR><TD valign=top><b>Amortization</b></TD><TD>TERM years</TD></TR> <TR BGCOLOR='#CCCCCC'><TD COLSPAN=2><CENTER><B>Your Income</B></CENTER></TD></TR> <TR><TD valign=top><b>Annual Verifiable net income </b> </TD><TD> VERIFIABLE_NET_INCOME </TD></TR> <TR><TD valign=top><b>Annual depreciation expense</b> </TD><TD> DEPRECIATION_EXPENSE </TD></TR> <TR><TD valign=top><b>Other non-cash charges </b> </TD><TD> OTHER_NON_CASH_CHARGES </TD></TR> <TR><TD valign=top><b>Total annual net cash income </b> </TD><TD> <B>TOTAL_NET_CASH_INCOME</B> </TD></TR> <TR BGCOLOR='#CCCCCC'><TD COLSPAN=2><CENTER><B>Your Monthly Obligations</B></CENTER></TD></TR> <TR><TD valign=top><b>Real estate mortgage </b> </TD><TD> REAL_ESTATE_MORTGAGE </TD></TR> <TR><TD valign=top><b>Business line of credit </b> </TD><TD> BUSINESS_LINE_OF_CREDIT </TD></TR> <TR><TD valign=top><b>Auto loans </b> </TD><TD> AUTO_LOANS </TD></TR> <TR><TD valign=top><b>Credit cards </b> </TD><TD> CREDIT_CARDS </TD></TR> <TR><TD valign=top><b>Other loans </b> </TD><TD> OTHER_LOANS </TD></TR> <TR><TD valign=top><b>Total existing obligations </b> </TD><TD> <B>TOTAL_EXISTING_OBLIGATIONS</B> </TD></TR> <TR><TD valign=top><b>Monthly debt payments eliminated </b> </TD><TD> <B>MONTHLY_DEBT_PAYMENTS_ELIMINATED</B> </TD></TR> <TR><TD valign=top><b>Total remaining obligations </b> </TD><TD> <B>TOTAL_REMAINING_OBLIGATIONS</B> </TD></TR> <TR BGCOLOR='#CCCCCC'><TD COLSPAN=2><CENTER><B>Debt Service Coverage </B></CENTER></TD></TR> <TR><TD valign=top><b>Annual existing obligations </b> </TD><TD> + ANNUAL_EXISTING_OBLIGATIONS </TD></TR> <TR><TD valign=top><b>Annual existing obligations eliminated with new loan</b> </TD><TD> - ANNUAL_DEBT_PAYMENTS_ELIMINATED </TD></TR> <TR><TD valign=top><b>Annual remaining obligations </b> </TD><TD> = TOTAL_ANNUAL_REMAINING_OBLIGATIONS </TD></TR> <TR><TD valign=top><b>New loan annual debt service </b> </TD><TD> + ANNUAL_PAYMENT </TD></TR> <TR><TD valign=top><b>Total annual debt service </b> </TD><TD> = ANNUAL_DEBT_LOAD </TD></TR> <TR><TD valign=top><b>Debt Service Coverage (DSC) </b> </TD><TD> DEBT_SERVICE_COVERAGE </TD></TR> <TR><TD valign=top colspan=2>The DSC is determined by dividing the total annual net cash income by the total annual debt service. This would be your annual net cash income of TOTAL_NET_CASH_INCOME divided by your total annual debt service of ANNUAL_DEBT_LOAD.<P></TD></TR> <TR><TD valign=top><b>Debt service required ratio </b> </TD><TD> DEBT_SERVICE_REQUIRED_RATIO </TD></TR> <TR><TD COLSPAN='2'><b>DEBT_SERVICE_MSG</B> </TD></TR> </TABLE></TD></TR></TABLE> <P> <TABLE width=80%><TR><TD> <P class=footer>*Please note: Prequalification is not a full loan application and approval. The loan process involves a few more steps that your loan officer can handle for you. </TD></TR></TABLE> </CENTER> <P><DIV class=large>Payment schedule</DIV> <HR SIZE=1> **REPEATING GROUP** <BR> <HR SIZE=1> <CENTER><P class=footer> Information and interactive calculators are made available to you as self-help tools for your independent use and are not intended to provide investment advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues. </P></CENTER><br><br> </BODY> </HTML> "> <H1><CENTER>This Financial Calculator requires SUN's Java"! Plug-in. If you see this message you will need to download SUN's Java"! Plug-in. This can be done automatically by clicking the yellow bar at the top of your browser and choosing  Install ActiveX Control . </CENTER></H1> <OL> You can also get SUN's Java"! Plug-in here: <A href="http://www.java.com/en/download/download_the_latest.jsp" target=_blank><b>Get the Java"! Plug-in!</b></A> <P>For more information about this Plug-in please visit: <A href="http://www.dinkytown.net/money/sunjvm.html" target=_blank><b>SUN's Java"! Plug-in</b></A> <BR>For more information these financial calculators please visit: <A href="http://www.dinkytown.net" target=_blank><b>Financial Calculators from KJE Computer Solutions, LLC</b></A> </OL><!--[if IE]></OBJECT><![endif]--><![if !IE]></APPLET><![endif]> </CENTER><CENTER><SCRIPT>document.write(showbuttons())</SCRIPT> </CENTER> <H1>Definitions</H1><P><TABLE align='center' WIDTH="95%"><TR><TD><DL><!--DEFN_START--> <DT><B>Loan amount</B><DD> Total amount of your loan.<P> <DT><B>Amortization</B><DD> Payment period in years.<P> <DT><B>Interest rate</B><DD> Annual interest rate for this loan. Interest is calculated monthly on the current outstanding balance of your loan at 1/12 of the annual rate.<P> <DT><B>New monthly payment</B><DD> Monthly payment for this loan.<P> <DT><B>Annual Verifiable net income</B><DD> Your annual net income from IRS tax returns or other financial statements.<P> <DT><B>Annual depreciation expense</B><DD> Since depreciation reduces your net income, but not your cash flow, we add back depreciation in calculating your total net cash income.<P> <DT><B>Other non-cash charges</B><DD> Like depreciation, these are other non-cash charges to your net income that should be added back to calculate your total net cash income for the year.<P> <DT><B>Real estate mortgage</B><DD> Your monthly payment for any real estate mortgages.<P> <DT><B>Business line of credit</B><DD> Your monthly payment for any business lines of credit.<P> <DT><B>Auto loans</B><DD> Your monthly payment for any auto loans.<P> <DT><B>Credit cards</B><DD> Your monthly payment for any credit cards.<P> <DT><B>Other loans</B><DD> Your monthly payment for any other outstanding loans.<P> <DT><B>Monthly debt payments eliminated</B><DD> Enter the amount, if any, of the monthly obligations you entered above that will be paid off by this new loan.<P> <DT><B>Debt Service Coverage (DSC)</B><DD>The Debt Service Coverage (DSC) is determined by dividing the total annual net cash income by the total annual debt service. If you have a DSC of 1.25 or higher, there is a good chance that you will be approved for your loan. <!--DEFN_END--></DL></TD></TR></TABLE> <BR> <HR SIZE=1> <CENTER> <P class=footer> Information and interactive calculators are made available to you as self-help tools for your independent use and are not intended to provide investment advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues. </P></CENTER> <BR> </BODY> </HTML>