The business is less than 2 years old
The real estate is special use (bowling alley, sports stadium, hotel – something that would be difficult to convert)
SBA Term:
Current SBA Interest Rate: 4.086%
Bank Term (years):
Bank Interest Rate (without the % symbol):
Total Project Cost: $
Structure
Bank Financing (50%): $NaN
SBA Financing (40%): $NaN
Equity Injection (10%): $NaN
Fees
SBA Guarantee Fee (0.5%): $NaN
Funding Fee (0.25%): $NaN
CDC Processing Fee (1.5%): $NaN
Attorney’s Fee: $2,500
Underwriter’s Fee (0.4%): $NaN
Total Fees: $NaN
Gross Debenture: $NaN
Balance to Borrower: $NaN
Third Party Lender Fee(0.5% on bank portion): $NaN
Estimated Payment
Bank: $ERROR per month
SBA: $ per month
Total Payment: $NaN per month
update_sba_int();
var fnf = document.getElementById("tpc"); fnf.addEventListener('keyup', function(evt){ var n = parseInt(this.value.replace(/\D/g,''),10); fnf.value = n.toLocaleString(); }, false);
function calculateStructure(){ var EquityInj = 0; if(document.getElementById("newy").checked == true){EquityInj = EquityInj + 5;} if(document.getElementById("suy").checked == true){EquityInj = EquityInj + 5;} var SBAPerc = 40 - EquityInj; var Equityperc = 10 + EquityInj; document.getElementById("SBAperc").innerHTML = SBAPerc; document.getElementById("Equityperc").innerHTML = Equityperc;
var tpc_unf = document.getElementById("tpc").value; var tpc = parseInt(tpc_unf.replace(/,\s?/g, "")); var bankf = (tpc*.5); var sbaf = (tpc *(SBAPerc/100)); var equif = (tpc*(Equityperc/100));
document.getElementById("bankf").innerHTML = bankf.toLocaleString(undefined, {minimumFractionDigits:2}); document.getElementById("sbaf").innerHTML = sbaf.toLocaleString(undefined, {minimumFractionDigits:2}); document.getElementById("equif").innerHTML = equif.toLocaleString(undefined, {minimumFractionDigits:2});
calculate_fees(bankf, sbaf);
}
function calculate_loan_payments(bank_principal, sba_principal){ //Calculate SBA payments var sba_interest = document.getElementById("sbaint").innerHTML/100/12; var sba_payments = document.getElementById("sbaterm").value*12;
// Now compute the monthly payment figure, using esoteric math. var x = Math.pow(1 + sba_interest, sba_payments); var sba_monthly = (sba_principal*x*sba_interest)/(x-1);
// Check that the result is a finite number. If so, display the results. if (!isNaN(sba_monthly) && (sba_monthly != Number.POSITIVE_INFINITY) && (sba_monthly != Number.NEGATIVE_INFINITY)) {
document.getElementById("sbapay").innerHTML = sba_monthly.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
} // Otherwise, the user's input was probably invalid, so don't // display anything. else { document.getElementById("sbapay").innerHTML = ""; }
//Calculate Bank Payments var bank_interest = document.getElementById("bankint").value/100/12; var bank_payments = document.getElementById("bankt").value*12;
// Now compute the monthly payment figure, using esoteric math. var x = Math.pow(1 + bank_interest, bank_payments); var bank_monthly = (bank_principal*x*bank_interest)/(x-1);
// Check that the result is a finite number. If so, display the results. if (!isNaN(bank_monthly) && (bank_monthly != Number.POSITIVE_INFINITY) && (bank_monthly != Number.NEGATIVE_INFINITY)) {
document.getElementById("bankpay").innerHTML = bank_monthly.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
} // Otherwise, the user's input was probably invalid, so don't // display anything. else { document.getElementById("bankpay").innerHTML = "ERROR"; }
var totalpay = sba_monthly+bank_monthly; document.getElementById("totalpay").innerHTML = totalpay.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2}); }
function calculate_fees(bank_principal, sba_principal){
var guar_fee = guarantee_fee * sba_principal; document.getElementById("guarfee").innerHTML = guar_fee.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
var fund_fee = funding_fee * sba_principal; document.getElementById("fundfee").innerHTML = fund_fee.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
var proc_fee = processing_fee * sba_principal; document.getElementById("procfee").innerHTML = proc_fee.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
var und_fee = underwriters_fee*(guar_fee+fund_fee+proc_fee+2500+sba_principal); document.getElementById("undfee").innerHTML = und_fee.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
var total_fees = guar_fee + fund_fee + proc_fee + und_fee + 2500; document.getElementById("total_fee").innerHTML = total_fees.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
var gdb = Math.ceil((sba_principal + total_fees)/1000)*1000; document.getElementById("grdb").innerHTML = gdb.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
var balance_to_borrower = gdb - sba_principal - total_fees; document.getElementById("btb").innerHTML = balance_to_borrower.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
var tpl_fee = third_party_lender_fee * bank_principal; document.getElementById("tplfee").innerHTML = tpl_fee.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2});
calculate_loan_payments(bank_principal, gdb);
}
function update_sba_int(){ var sbaterm = document.getElementById("sbaterm").value; if(sbaterm == 25){document.getElementById("sbaint").innerHTML = twentyfiveyear;} if(sbaterm == 20){document.getElementById("sbaint").innerHTML = twentyyear;} if(sbaterm == 10){document.getElementById("sbaint").innerHTML = tenyear;} calculateStructure(); }