Laserfiche WebLink
NewB_(119)_9%_MixedIncome <br />Year 1 Year 15 <br />Net Operating Income Income Inflator 2.00% 800,994 909,916 <br />Expense Inflator 3.00% <br />Income Available for Debt Service 800,994 909,916 <br />Lender/Loan <br />Total Subordinated Debt Payments <br />Income Available after Subordinated Debt 800,994 909,916 <br />Minimum Debt Coverage Ratio 1.1500 1.0000 <br />Net Income Available for Debt Service 696,517 909,916 <br />Lowest Income Available for Debt Service 696,517 <br />Term (Years)40 <br />Amortization (Years)40 <br />Interest Rate 4.650% <br />Mortgage Insurance Premium (MIP)0.250% <br />Debt Service Constant (including MIP)0.057610014 <br />Maximum Calculated Mortgage 12,090,199 <br />Maximum NOI Supported Mortgage (rounded) 12,090,000 <br />Actual Mortgage if not Maximum Supported <br />Annual TIF Payment 81,753 <br />Minimum Debt Coverage Ratio 1.0000 <br />Available TIF for Debt Service 81,753 <br />Amortization (Years)25 <br />Total Permanent Note Rate 4.650% <br />Mortgage Insurance Premium (MIP)0.250% <br />Debt Service Constant (including MIP)0.070225686 <br />Maximum Calculated TIF Mortgage 1,164,147 <br />Maximum TIF Supported Mortgage (rounded) 1,164,000 <br />Actual TIF Mortgage if not Maximum Supported 1,907,500 <br />FIRST MORTGAGE CALCULATION <br />TIF MORTGAGE CALCULATION <br />Debt Service <br />Year 1 <br />Debt Service <br />Year 15 <br />MHFA <br />Check if  <br />MN Hsg Principal Rate <br />Term  <br />(Years) <br />Amort  <br />(Years) <br />MORTGAGE CALCULATION <br />INCOME AVAILABLE FOR DEBT SERVICE <br />Change on the Cash Flow tab: <br />Temporary Income (excluding TIF) <br />SUBORDINATED DEBT PAYMENTS <br />Workbook Mortgage Calc ‐ Page 12 of 32 3/26/2018 5:25 PM