ÿþ<html> <head><title>Calc4WebCenter.xls</title><meta name="GENERATOR" content="ExcelEverywhere for HTML version 2.4.9" /> <!-- ExcelEverywhere Header start --> <!-- Parts of this page Copyright (C) 2002 Framtidsforum I&M AB, Sweden --> <style> /* Styles needed by ExcelEverywhere */ *.ee127 { font-size : 10.00pt; font-family : "Arial", Sans-serif; border-bottom : 3px solid #000000; border-right : 3px solid #000000; border-left : 3px solid #000000 } *.ee126 { font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : center; border-left : 3px solid #000000 } *.ee125 { } *.ee124 { border-bottom : 3px solid #000000 } *.ee123 { font-size : 10.00pt; font-family : "Arial", Sans-serif; border-bottom : 3px solid #000000 } *.ee122 { font-size : 14.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center } *.ee121 { font-size : 14.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center; border-bottom : 3px solid #000000; border-right : 3px solid #000000; border-left : 3px solid #000000 } *.ee120 { font-size : 12.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center } *.ee119 { font-size : 12.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center; border-right : 3px solid #000000; border-left : 3px solid #000000 } *.ee118 { font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : center; border-bottom : 3px solid #000000; border-right : 3px solid #000000 } *.ee117 { font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : right; border-bottom : 3px solid #000000; border-left : 3px solid #000000 } *.ee116 { font-size : 9.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center } *.ee115 { font-size : 9.00pt; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center; border-bottom : 3px solid #000000; border-right : 3px solid #000000 } *.ee114 { background-color : #c0c0c0; font-size : 10.00pt; font-family : "Arial", Sans-serif } *.ee113 { background-color : #c0c0c0; font-size : 10.00pt; font-family : "Arial", Sans-serif; border-bottom : 3px solid #000000; border-right : 3px solid #000000 } *.ee112 { font-size : 10.00pt; font-family : "Arial", Sans-serif; border-bottom : 3px solid #000000; border-left : 3px solid #000000 } *.ee111 { font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : right; border-right : 3px solid #000000 } *.ee110 { font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : center } *.ee109 { font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : center; border-right : 3px solid #000000 } *.ee108 { font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : right } *.ee107 { background-color : #c0c0c0; font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : right } *.ee106 { background-color : #c0c0c0; font-size : 10.00pt; font-family : "Arial", Sans-serif; text-align : right; border-right : 3px solid #000000 } *.ee105 { font-size : 10.00pt; font-family : "Arial", Sans-serif; border-left : 3px solid #000000 } *.ee104 { text-decoration : underline; font-size : 12.00pt; color : #0000ff; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center } *.ee103 { text-decoration : underline; font-size : 12.00pt; color : #0000ff; font-weight : bold; font-family : "Arial", Sans-serif; text-align : center; border-bottom : 3px solid #000000 } *.ee102 { text-decoration : underline; font-size : 13.20pt; color : #0000ff; font-family : "Arial", Sans-serif; text-align : center } *.ee101 { font-size : 10.00pt; font-family : "Arial", Sans-serif } *.ee100 { font-size : 24.00pt; font-family : "Arial", Sans-serif; text-align : center } </style> <script language="javascript"> var co = new Object; function recalc_onclick(ctl) { if (true) { co.p1B5=eeparseFloatTh(document.formc.p1B5.value);co.p1B6=eeparsePercent(document.formc.p1B6.value);co.p1B8=eeparsePercentV(document.formc.p1B8[document.formc.p1B8.selectedIndex].value);calc(co);document.formc.p1D5.value=eedisplayFloatNDTh(co.p1D5,2);document.formc.p1D6.value=eedisplayFloatNDTh(co.p1D6,2);document.formc.p1D7.value=eedisplayFloatNDTh(co.p1D7,2);document.formc.p1D9.value=eedisplayPercentND(co.p1D9,3);document.formc.p1A14.value=eedisplayFloat(co.p1A14);document.formc.p1B14.value=eedisplayFloatNDTh(co.p1B14,2);document.formc.p1C14.value=eedisplayFloatNDTh(co.p1C14,2);document.formc.p1D14.value=eedisplayFloatNDTh(co.p1D14,2);document.formc.p1A15.value=eedisplayFloat(co.p1A15);document.formc.p1B15.value=eedisplayFloatNDTh(co.p1B15,2);document.formc.p1C15.value=eedisplayFloatNDTh(co.p1C15,2);document.formc.p1D15.value=eedisplayFloatNDTh(co.p1D15,2);document.formc.p1A16.value=eedisplayFloat(co.p1A16);document.formc.p1B16.value=eedisplayFloatNDTh(co.p1B16,2);document.formc.p1C16.value=eedisplayFloatNDTh(co.p1C16,2);document.formc.p1D16.value=eedisplayFloatNDTh(co.p1D16,2);document.formc.p1A17.value=eedisplayFloat(co.p1A17);document.formc.p1B17.value=eedisplayFloatNDTh(co.p1B17,2);document.formc.p1C17.value=eedisplayFloatNDTh(co.p1C17,2);document.formc.p1D17.value=eedisplayFloatNDTh(co.p1D17,2);document.formc.p1A18.value=eedisplayFloat(co.p1A18);document.formc.p1B18.value=eedisplayFloatNDTh(co.p1B18,2);document.formc.p1C18.value=eedisplayFloatNDTh(co.p1C18,2);document.formc.p1D18.value=eedisplayFloatNDTh(co.p1D18,2);document.formc.p1A19.value=eedisplayFloat(co.p1A19);document.formc.p1B19.value=eedisplayFloatNDTh(co.p1B19,2);document.formc.p1C19.value=eedisplayFloatNDTh(co.p1C19,2);document.formc.p1D19.value=eedisplayFloatNDTh(co.p1D19,2);document.formc.p1A20.value=eedisplayFloat(co.p1A20);document.formc.p1B20.value=eedisplayFloatNDTh(co.p1B20,2);document.formc.p1C20.value=eedisplayFloatNDTh(co.p1C20,2);document.formc.p1D20.value=eedisplayFloatNDTh(co.p1D20,2);document.formc.p1A21.value=eedisplayFloat(co.p1A21);document.formc.p1B21.value=eedisplayFloatNDTh(co.p1B21,2);document.formc.p1C21.value=eedisplayFloatNDTh(co.p1C21,2);document.formc.p1D21.value=eedisplayFloatNDTh(co.p1D21,2);document.formc.p1A22.value=eedisplayFloat(co.p1A22);document.formc.p1B22.value=eedisplayFloatNDTh(co.p1B22,2);document.formc.p1C22.value=eedisplayFloatNDTh(co.p1C22,2);document.formc.p1D22.value=eedisplayFloatNDTh(co.p1D22,2);document.formc.p1A23.value=eedisplayFloat(co.p1A23);document.formc.p1B23.value=eedisplayFloatNDTh(co.p1B23,2);document.formc.p1C23.value=eedisplayFloatNDTh(co.p1C23,2);document.formc.p1D23.value=eedisplayFloatNDTh(co.p1D23,2);document.formc.p1A24.value=eedisplayFloat(co.p1A24);document.formc.p1B24.value=eedisplayFloatNDTh(co.p1B24,2);document.formc.p1C24.value=eedisplayFloatNDTh(co.p1C24,2);document.formc.p1D24.value=eedisplayFloatNDTh(co.p1D24,2);document.formc.p1A25.value=eedisplayFloat(co.p1A25);document.formc.p1B25.value=eedisplayFloatNDTh(co.p1B25,2);document.formc.p1C25.value=eedisplayFloatNDTh(co.p1C25,2);document.formc.p1D25.value=eedisplayFloatNDTh(co.p1D25,2);document.formc.p1A26.value=eedisplayFloat(co.p1A26);document.formc.p1B26.value=eedisplayFloatNDTh(co.p1B26,2);document.formc.p1C26.value=eedisplayFloatNDTh(co.p1C26,2);document.formc.p1D26.value=eedisplayFloatNDTh(co.p1D26,2);document.formc.p1A27.value=eedisplayFloat(co.p1A27);document.formc.p1B27.value=eedisplayFloatNDTh(co.p1B27,2);document.formc.p1C27.value=eedisplayFloatNDTh(co.p1C27,2);document.formc.p1D27.value=eedisplayFloatNDTh(co.p1D27,2);document.formc.p1A28.value=eedisplayFloat(co.p1A28);document.formc.p1B28.value=eedisplayFloatNDTh(co.p1B28,2);document.formc.p1C28.value=eedisplayFloatNDTh(co.p1C28,2);document.formc.p1D28.value=eedisplayFloatNDTh(co.p1D28,2);document.formc.p1A29.value=eedisplayFloat(co.p1A29);document.formc.p1B29.value=eedisplayFloatNDTh(co.p1B29,2);document.formc.p1C29.value=eedisplayFloatNDTh(co.p1C29,2);document.formc.p1D29.value=eedisplayFloatNDTh(co.p1D29,2);document.formc.p1A30.value=eedisplayFloat(co.p1A30);document.formc.p1B30.value=eedisplayFloatNDTh(co.p1B30,2);document.formc.p1C30.value=eedisplayFloatNDTh(co.p1C30,2);document.formc.p1D30.value=eedisplayFloatNDTh(co.p1D30,2);document.formc.p1A31.value=eedisplayFloat(co.p1A31);document.formc.p1B31.value=eedisplayFloatNDTh(co.p1B31,2);document.formc.p1C31.value=eedisplayFloatNDTh(co.p1C31,2);document.formc.p1D31.value=eedisplayFloatNDTh(co.p1D31,2); };}; var eeisus=1;var eetrue="TRUE";var eefalse="FALSE";var eedec=".";var eeth=",";var eedecreg=new RegExp("[.]","g");var eethreg=new RegExp(",","g"); var arr2xA28A32=new Array(5);for(var ii=0;ii<5;ii++){arr2xA28A32[ii]=new Array(1);for(var jj=0;jj<1;jj++){arr2xA28A32[ii][jj]=0}};var arr2xC28C32=new Array(5);for(var ii=0;ii<5;ii++){arr2xC28C32[ii]=new Array(1);for(var jj=0;jj<1;jj++){arr2xC28C32[ii][jj]=0}};var arr2xA44A48=new Array(5);for(var ii=0;ii<5;ii++){arr2xA44A48[ii]=new Array(1);for(var jj=0;jj<1;jj++){arr2xA44A48[ii][jj]=0}};var arr2xC44C48=new Array(5);for(var ii=0;ii<5;ii++){arr2xC44C48[ii]=new Array(1);for(var jj=0;jj<1;jj++){arr2xC44C48[ii][jj]=0}};var arr4xA22A24=new Array(3);for(var ii=0;ii<3;ii++){arr4xA22A24[ii]=new Array(1);for(var jj=0;jj<1;jj++){arr4xA22A24[ii][jj]=0}};var arr4xC22C24=new Array(3);for(var ii=0;ii<3;ii++){arr4xC22C24[ii]=new Array(1);for(var jj=0;jj<1;jj++){arr4xC22C24[ii][jj]=0}};function calc(data){var c1B5=data.p1B5;var c1B6=data.p1B6;var c1B8=data.p1B8;var c1B7=(360);var c1D5=(pmt((((c1B6)/(12))),(c1B7),(((c1B5)*(-1))),(0),(0)));var c1A14=(((((c1B7)-(c1B7)))+(1)));var c1B14=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A14)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A14)))*(12)))))-(c1B5)));var c1C14=(((((((c1B14)*(v2n(c1B8))))>(2000)))?(2000):(((c1B14)*(v2n(c1B8))))));var c1D6=(((c1C14)/(12)));var c1D7=(((c1D5)-(c1D6)));var c1D9=(((rate((c1B7),(((c1D7)*(-1))),(c1B5),(0),(0),(0.1)))*(12)));var c1D14=(((0)+(c1C14)));var c1A15=(((c1A14)+(1)));var c1B15=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A15)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A15)))*(12)))))-(c1B5)));var c1C15=(((((((((c1B15)-(c1B14)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B15)-(c1B14)))*(v2n(c1B8))))));var c1D15=(((c1D14)+(c1C15)));var c1A16=(((c1A15)+(1)));var c1B16=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A16)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A16)))*(12)))))-(c1B5)));var c1C16=(((((((((c1B16)-(c1B15)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B16)-(c1B15)))*(v2n(c1B8))))));var c1D16=(((c1D15)+(c1C16)));var c1A17=(((c1A16)+(1)));var c1B17=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A17)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A17)))*(12)))))-(c1B5)));var c1C17=(((((((((c1B17)-(c1B16)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B17)-(c1B16)))*(v2n(c1B8))))));var c1D17=(((c1D16)+(c1C17)));var c1A18=(((c1A17)+(1)));var c1B18=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A18)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A18)))*(12)))))-(c1B5)));var c1C18=(((((((((c1B18)-(c1B17)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B18)-(c1B17)))*(v2n(c1B8))))));var c1D18=(((c1D17)+(c1C18)));var c1A19=(((c1A18)+(1)));var c1B19=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A19)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A19)))*(12)))))-(c1B5)));var c1C19=(((((((((c1B19)-(c1B18)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B19)-(c1B18)))*(v2n(c1B8))))));var c1D19=(((c1D18)+(c1C19)));var c1A20=(((c1A19)+(1)));var c1B20=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A20)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A20)))*(12)))))-(c1B5)));var c1C20=(((((((((c1B20)-(c1B19)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B20)-(c1B19)))*(v2n(c1B8))))));var c1D20=(((c1D19)+(c1C20)));var c1A21=(((c1A20)+(1)));var c1B21=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A21)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A21)))*(12)))))-(c1B5)));var c1C21=(((((((((c1B21)-(c1B20)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B21)-(c1B20)))*(v2n(c1B8))))));var c1D21=(((c1D20)+(c1C21)));var c1A22=(((c1A21)+(1)));var c1B22=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A22)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A22)))*(12)))))-(c1B5)));var c1C22=(((((((((c1B22)-(c1B21)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B22)-(c1B21)))*(v2n(c1B8))))));var c1D22=(((c1D21)+(c1C22)));var c1A23=(((c1A22)+(1)));var c1B23=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A23)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A23)))*(12)))))-(c1B5)));var c1C23=(((((((((c1B23)-(c1B22)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B23)-(c1B22)))*(v2n(c1B8))))));var c1D23=(((c1D22)+(c1C23)));var c1A24=(((c1A23)+(1)));var c1B24=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A24)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A24)))*(12)))))-(c1B5)));var c1C24=(((((((((c1B24)-(c1B23)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B24)-(c1B23)))*(v2n(c1B8))))));var c1D24=(((c1D23)+(c1C24)));var c1A25=(((c1A24)+(1)));var c1B25=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A25)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A25)))*(12)))))-(c1B5)));var c1C25=(((((((((c1B25)-(c1B24)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B25)-(c1B24)))*(v2n(c1B8))))));var c1D25=(((c1D24)+(c1C25)));var c1A26=(((c1A25)+(1)));var c1B26=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A26)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A26)))*(12)))))-(c1B5)));var c1C26=(((((((((c1B26)-(c1B25)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B26)-(c1B25)))*(v2n(c1B8))))));var c1D26=(((c1D25)+(c1C26)));var c1A27=(((c1A26)+(1)));var c1B27=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A27)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A27)))*(12)))))-(c1B5)));var c1C27=(((((((((c1B27)-(c1B26)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B27)-(c1B26)))*(v2n(c1B8))))));var c1D27=(((c1D26)+(c1C27)));var c1A28=(((c1A27)+(1)));var c1B28=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A28)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A28)))*(12)))))-(c1B5)));var c1C28=(((((((((c1B28)-(c1B27)))*(v2n(c1B8))))>(2000)))?(2000):(((((c1B28)-(c1B27)))*(v2n(c1B8))))));var c1D28=(((c1D27)+(c1C28)));var c1A29=(((c1A28)+(5)));var c1B29=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A29)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A29)))*(12)))))-(c1B5)));var c1C29=(((((((((c1B29)-(c1B28)))*(v2n(c1B8))))>(10000)))?(10000):(((((c1B29)-(c1B28)))*(v2n(c1B8))))));var c1D29=(((c1D28)+(c1C29)));var c1A30=(((c1A29)+(5)));var c1B30=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A30)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A30)))*(12)))))-(c1B5)));var c1C30=(((((((((c1B30)-(c1B29)))*(v2n(c1B8))))>(10000)))?(10000):(((((c1B30)-(c1B29)))*(v2n(c1B8))))));var c1D30=(((c1D29)+(c1C30)));var c1A31=(((c1A30)+(5)));var c1B31=(((((((pv((((c1B6)/(12))),(((c1B7)-(((c1A31)*(12))))),(c1D5),(0),(0)))*(-1)))+(((((c1D5)*(c1A31)))*(12)))))-(c1B5)));var c1C31=(((((((((c1B31)-(c1B30)))*(v2n(c1B8))))>(10000)))?(10000):(((((c1B31)-(c1B30)))*(v2n(c1B8))))));var c1D31=(((c1D30)+(c1C31)));data.p1D5=c1D5;data.p1D6=c1D6;data.p1D7=c1D7;data.p1D9=c1D9;data.p1A14=c1A14;data.p1B14=c1B14;data.p1C14=c1C14;data.p1D14=c1D14;data.p1A15=c1A15;data.p1B15=c1B15;data.p1C15=c1C15;data.p1D15=c1D15;data.p1A16=c1A16;data.p1B16=c1B16;data.p1C16=c1C16;data.p1D16=c1D16;data.p1A17=c1A17;data.p1B17=c1B17;data.p1C17=c1C17;data.p1D17=c1D17;data.p1A18=c1A18;data.p1B18=c1B18;data.p1C18=c1C18;data.p1D18=c1D18;data.p1A19=c1A19;data.p1B19=c1B19;data.p1C19=c1C19;data.p1D19=c1D19;data.p1A20=c1A20;data.p1B20=c1B20;data.p1C20=c1C20;data.p1D20=c1D20;data.p1A21=c1A21;data.p1B21=c1B21;data.p1C21=c1C21;data.p1D21=c1D21;data.p1A22=c1A22;data.p1B22=c1B22;data.p1C22=c1C22;data.p1D22=c1D22;data.p1A23=c1A23;data.p1B23=c1B23;data.p1C23=c1C23;data.p1D23=c1D23;data.p1A24=c1A24;data.p1B24=c1B24;data.p1C24=c1C24;data.p1D24=c1D24;data.p1A25=c1A25;data.p1B25=c1B25;data.p1C25=c1C25;data.p1D25=c1D25;data.p1A26=c1A26;data.p1B26=c1B26;data.p1C26=c1C26;data.p1D26=c1D26;data.p1A27=c1A27;data.p1B27=c1B27;data.p1C27=c1C27;data.p1D27=c1D27;data.p1A28=c1A28;data.p1B28=c1B28;data.p1C28=c1C28;data.p1D28=c1D28;data.p1A29=c1A29;data.p1B29=c1B29;data.p1C29=c1C29;data.p1D29=c1D29;data.p1A30=c1A30;data.p1B30=c1B30;data.p1C30=c1C30;data.p1D30=c1D30;data.p1A31=c1A31;data.p1B31=c1B31;data.p1C31=c1C31;data.p1D31=c1D31;}; function myIsNaN(x){return(isNaN(x)||(typeof x=='number'&&!isFinite(x)));};function round(n,nd){if(isFinite(n)&&isFinite(nd)){var sign_n=(n<0)?-1:1;var abs_n=Math.abs(n);var factor=Math.pow(10,nd);return sign_n*Math.round(abs_n*factor)/factor;}else{return NaN;}};function s2n(str){str=String(str).replace(eedecreg,".");return parseFloat(str);}function v2n(v){switch(typeof v){case "number":return v;case "string":return s2n(v);case "boolean":return v?1:0;case "object":if(v.constructor==Number){return v;};if(v.constructor==String){return s2n(v);};if(v.constructor==Boolean){return v?1:0;};return Number.NaN;default:return Number.NaN;}};function eeparsePercent(str){var parts=String(str).split('%');var tmp=String(parts[0]).replace(eedecreg,".");var res=parseFloat(tmp)/100;if(isNaN(res)){return 0;}else{return res;}};function eedisplayFloat(x){if(myIsNaN(x)){return Number.NaN;}else{return String(x).replace(/\./g,eedec);}};function eedisplayFloatND(x,nd){if(myIsNaN(x)){return Number.NaN;}else{var res=round(x,nd);if(nd>0){var str=String(res);if(str.indexOf('e')!=-1)return str;if(str.indexOf('E')!=-1)return str;var parts=str.split('.');if(parts.length<2){var decimals=('00000000000000').substring(0,nd);return(parts[0]).toString()+eedec+decimals;}else{var decimals=((parts[1]).toString()+'00000000000000').substring(0,nd);return(parts[0]).toString()+eedec+decimals;}}else{return res;}}};function eedisplayPercentND(x,nd){if(myIsNaN(x)){return Number.NaN;}else{return eedisplayFloatND(x*100,nd)+'%';}}function eeparseFloatTh(str){str=String(str).replace(eethreg,"");str=String(str).replace(eedecreg,".");var res=parseFloat(str);if(isNaN(res)){return 0;}else{return res;}};function eedisplayFloatNDTh(x,nd){if(myIsNaN(x)){return Number.NaN;}else{var res=round(x,nd);if(nd>0){var str=String(res);if(str.indexOf('e')!=-1)return str;if(str.indexOf('E')!=-1)return str;var parts=str.split('.');var res2=eeinsertThousand(parts[0].toString());if(parts.length<2){var decimals=('00000000000000').substring(0,nd);return(res2+eedec+decimals);}else{var decimals=((parts[1]).toString()+'00000000000000').substring(0,nd);return(res2+eedec+decimals);}}else{return(eeinsertThousand(res.toString()));}}};var eeparseFloatVreg=new RegExp("^ *-?[0-9.]+ *$");function eeparseFloatV(str){if(str=="")return str;str=String(str).replace(eedecreg,".");if(!eeparseFloatVreg.test(str)){return str;};var res=parseFloat(str);if(isNaN(res)){return str;}else{return res;}};var eeparsePercentVreg=new RegExp("^ *-?[0-9.]+$");function eeparsePercentV(str){if(str=="")return str;var parts=String(str).split('%');var tmp=String(parts[0]).replace(eedecreg,".");if(!eeparsePercentVreg.test(tmp)){return str;};var res=parseFloat(tmp)/100;if(isNaN(res)){return str;}else{return res;}};function eeinsertThousand(whole){if(whole==""||whole.indexOf("e")>=0){return whole;}else{var minus_sign="";if(whole.charAt(0)=="-"){minus_sign="-";whole=whole.substring(1);};var res="";var str_length=whole.length-1;for(var ii=0;ii<=str_length;ii++){if(ii>0&&ii%3==0){res=eeth+res;};res=whole.charAt(str_length-ii)+res;};return minus_sign+res;}};function pmt(rate,nper,pv,fv,type){var pvif=Math.pow(1+rate,nper);var fvifa=(Math.pow(1+rate,nper)-1)/rate;var type1=(type!=0)?1:0;return((-pv*pvif-fv)/((1+rate*type1)*fvifa));};function pv(rate,nper,pmt,fv,type){if(!isFinite(type)||!isFinite(fv)||!isFinite(pmt)||!isFinite(nper)||!isFinite(rate))return Number.NaN;if(rate==0)return-(fv+nper*pmt);var type1=(type!=0)?1:0;var pvif=Math.pow(1+rate,nper);var fvifa=(Math.pow(1+rate,nper)-1)/rate;if(pvif==0)return Number.NaN;return((-fv-pmt*(1+rate*type)*fvifa)/pvif);};function rate(nper,pmt,pv,fv,type,guess){if(!isFinite(guess)||!isFinite(type)||!isFinite(fv)||!isFinite(pv)||!isFinite(pmt)||!isFinite(nper))return Number.NaN;var type2=(type)?1:0;var wanted_precision=0.00000001;var current_diff=Number.MAX_VALUE;var x,next_x,y,z;if(guess==0)x=0.1;else x=guess;var max_iterations=100;var iterations_done=0;while(current_diff>wanted_precision&&iterations_done<max_iterations){if(x==0)next_x=x-(pv+pmt*nper+fv)/(pv*nper+pmt*(nper*(nper-1)+2*type2*nper)/2);else{y=Math.pow(1+x,nper-1);z=y*(1+x);next_x=x*(1-(x*pv*z+pmt*(1+x*type2)*(z-1)+x*fv)/(x*x*nper*pv*y-pmt*(z-1)+x*pmt*(1+x*type2)*nper*y));}iterations_done++;current_diff=Math.abs(next_x-x);x=next_x;}if(guess==0&&Math.abs(x)<wanted_precision)x=0;if(current_diff>=wanted_precision){return Number.NaN;}else{return x;};}; </script> <!-- ExcelEverywhere Header end --> </head><body onload="document.formc.p1B5.focus();"> <!-- ExcelEverywhere Body start --> <form id="formc" name="formc" method="post" action=""> <table width="519" style='border-collapse:collapse;width:390pt' border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF"> <tr> <td height="39" style='height:30pt;' align=center class=ee100 colspan=4 > OHIO MCC Tax Credit Calculator </td> </tr> <tr> <td height="69" style='height:53pt;' class=ee101 colspan=4 > The purpose of this calculator is to compute the MCC (Mortgage Credit Certificate) Tax credit on a Home Purchase. The table below shows the credit each period as well as the Cumulative Credits assuming only the standard Principle and Interest payments are being made. Any extra payments would reduce the amount of the MCC Tax Credit. </td> </tr> <tr> <td height="23" style='height:17pt;' align=center class=ee102 colspan=4 > <a href="https://www.ohiohome.org/mcc/default.aspx" target="_blank" class=ee102> Additional Details on www.OhioHome.org website </a> </td> </tr> <tr> <td height="22" style='height:17pt;' align=center class=ee103 colspan=4 > <a href="http://www.irs.gov/pub/irs-pdf/f8396.pdf" target="_blank" class=ee104> 2010 IRS Form to take MCC Tax Credit </a> </td> </tr> <tr> <td height="18" width="121" style='height:14pt;width:91pt;' class=ee105 > Loan Amount </td> <td width="149" style='width:112pt;' align=right class=ee106 > <input name="p1B5" id="p1B5" type="text" value="125,000.00" onblur="this.value=eedisplayFloatNDTh(eeparseFloatTh(this.value),2);recalc_onclick('p1B5')" tabindex="1" style='width:112pt' size="21" class=ee107 > </td> <td width="141" style='width:106pt;' align=right class=ee108 > Monthly Payment </td> <td width="120" style='width:90pt;' align=center class=ee109 > <input name="p1D5" id="p1D5" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' class=ee105 > Rate of Interest </td> <td align=right class=ee106 > <input name="p1B6" id="p1B6" type="text" value="5.00%" onblur="this.value=eedisplayPercentND(eeparsePercent(this.value),2);recalc_onclick('p1B6')" tabindex="2" style='width:112pt' size="21" class=ee107 > </td> <td align=right class=ee108 > Year 1- AVG Credit </td> <td align=center class=ee109 > <input name="p1D6" id="p1D6" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' class=ee105 > Loan Term(Months) </td> <td align=right class=ee111 > 360 </td> <td align=right class=ee108 > Cost after Tax Credit </td> <td align=center class=ee109 > <input name="p1D7" id="p1D7" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="18" style='height:14pt;' class=ee112 > Tax Credit Rate *** </td> <td class=ee113 > <select name="p1B8" id="p1B8" size="1" onchange="recalc_onclick('p1B8')" tabindex="3" class=ee114 style='width:112pt'> <option value="30%" >30%</option> <option value="25%" >25%</option> <option value="20%" >20%</option> </select> </td> <td align=center class=ee115 colspan=2 > Tax Credit Received when Taxes are Filed </td> </tr> <tr> <td height="19" style='height:14pt;' align=right class=ee117 colspan=3 > Comparable Rate if Tax Credit was given Monthly ---> </td> <td align=center class=ee118 > <input name="p1D9" id="p1D9" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="22" style='height:17pt;' align=center class=ee119 colspan=4 > ***( 30% for REO&#39;s -- 25% Target Areas -- 20% All Other ) </td> </tr> <tr> <td height="25" style='height:19pt;' align=center class=ee121 colspan=4 > MCC Credit is Limited to $2,000 per Year </td> </tr> <tr> <td height="19" style='height:14pt;' class=ee123 > &nbsp; </td> <td class=ee124 > &nbsp; </td> <td class=ee124 > &nbsp; </td> <td class=ee124 > &nbsp; </td> </tr> <tr> <td height="18" style='height:14pt;' align=center class=ee126 > Year </td> <td align=center class=ee110 > Cumulative Interest Paid </td> <td align=center class=ee110 > Possible Tax Credits**** </td> <td align=center class=ee109 > Cumulative Credits </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A14" id="p1A14" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B14" id="p1B14" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C14" id="p1C14" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D14" id="p1D14" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A15" id="p1A15" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B15" id="p1B15" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C15" id="p1C15" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D15" id="p1D15" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A16" id="p1A16" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B16" id="p1B16" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C16" id="p1C16" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D16" id="p1D16" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A17" id="p1A17" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B17" id="p1B17" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C17" id="p1C17" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D17" id="p1D17" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A18" id="p1A18" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B18" id="p1B18" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C18" id="p1C18" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D18" id="p1D18" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A19" id="p1A19" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B19" id="p1B19" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C19" id="p1C19" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D19" id="p1D19" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A20" id="p1A20" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B20" id="p1B20" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C20" id="p1C20" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D20" id="p1D20" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A21" id="p1A21" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B21" id="p1B21" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C21" id="p1C21" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D21" id="p1D21" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A22" id="p1A22" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B22" id="p1B22" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C22" id="p1C22" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D22" id="p1D22" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A23" id="p1A23" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B23" id="p1B23" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C23" id="p1C23" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D23" id="p1D23" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A24" id="p1A24" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B24" id="p1B24" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C24" id="p1C24" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D24" id="p1D24" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A25" id="p1A25" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B25" id="p1B25" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C25" id="p1C25" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D25" id="p1D25" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A26" id="p1A26" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B26" id="p1B26" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C26" id="p1C26" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D26" id="p1D26" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A27" id="p1A27" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B27" id="p1B27" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C27" id="p1C27" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D27" id="p1D27" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A28" id="p1A28" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B28" id="p1B28" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C28" id="p1C28" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D28" id="p1D28" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A29" id="p1A29" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B29" id="p1B29" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C29" id="p1C29" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D29" id="p1D29" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A30" id="p1A30" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B30" id="p1B30" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C30" id="p1C30" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D30" id="p1D30" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="17" style='height:13pt;' align=center class=ee126 > <input name="p1A31" id="p1A31" type="text" value="0" readonly="true" style='border:0px solid #000000;width:91pt' size="17" class=ee110 > </td> <td align=center class=ee110 > <input name="p1B31" id="p1B31" type="text" value="0" readonly="true" style='border:0px solid #000000;width:112pt' size="21" class=ee110 > </td> <td align=center class=ee110 > <input name="p1C31" id="p1C31" type="text" value="0" readonly="true" style='border:0px solid #000000;width:106pt' size="20" class=ee110 > </td> <td align=center class=ee109 > <input name="p1D31" id="p1D31" type="text" value="0" readonly="true" style='border:0px solid #000000;width:90pt' size="17" class=ee110 > </td> </tr> <tr> <td height="55" style='height:42pt;' class=ee127 colspan=4 > These number are believed to be correct based upon the information presented, however they are not guaranteed and you should consult your tax preparer to verify your eligibility under these programs. </td> </tr> </table> <p> </form> <script language="javascript"> recalc_onclick(''); </script> <!-- ExcelEverywhere Body end --> <noscript>The browser does not support JavaScript. The calculations created using <a href="http://www.exceleverywhere.com">ExcelEverywhere</a> will not work. Please access the web page using another browser.<p></noscript> </body> </html>