LNB CAPITAL FUNDING LLC

Commercial Real Estate Deal Analyzer

Review the income, expenses, and financing of your investment property.

Property & Deal Overview

Start with the property and your financing goal. Choose renovation / lease-up if you plan to improve the property or fill vacant space.

Planning tip: Enter the property's current estimated value here. We will review expected income and value after improvements separately. For occupancy, use occupied units for multifamily or occupied rentable square feet for commercial space.

Rental Income

Enter annual amounts. Start with rent assuming all units or space are occupied, then enter a vacancy and collection loss allowance.

Current Annual Income

Effective Annual Income —

Income planning tips: Multiply monthly rent by 12 to enter an annual amount. Potential rent includes vacant units or space; do not enter rent already reduced for vacancy and deduct vacancy again. Other income may include parking, laundry, or storage. Tenant reimbursements are expected collections for expenses such as taxes, insurance, and common-area maintenance. Include each income source once and include the related property expenses in the next section. Stabilized income means a full year of expected operations after improvements and lease-up.

Operating Expenses & NOI

Enter annual property operating expenses. Replace each zero with your estimate, or leave zero when an expense does not apply. Management is entered as an annual dollar amount.

Current Annual Expenses

Total Annual Operating Expenses —
Current Annual Net Operating Income (NOI) —

Expense planning tips: Multiply monthly expenses by 12. Include the full expenses paid by the owner, even when tenants reimburse part of them; those reimbursements belong in Rental Income. Include each expense once. Keep mortgage payments, depreciation, income taxes, major renovations, leasing commissions, and replacement reserves out of this section. We will handle financing and project costs separately. NOI equals effective annual income minus annual operating expenses, before loan payments. Projected expenses should reflect a full year after improvements and lease-up, including any expected tax or insurance increases.

Financing

Enter estimated terms for the proposed loan. These inputs are planning assumptions, not a loan offer.

Lender Points Cost —
Estimated Monthly Loan Payment —
Annualized Debt Service —
Total Upfront Loan Costs —
Remaining Principal at End of Loan Term —

Loan fee examples: Origination / Lender Points: 2%. Other Loan Closing Costs: $3,000. Examples are for illustration only, not LNB pricing or entered values. Enter your quoted fees, or enter 0 when a fee does not apply; fee-dependent totals remain blank until both fields are completed. Include percentage-based origination fees in points. Other loan closing costs may include processing, underwriting, appraisal, and loan-document fees. Count each fee once and do not repeat it under Other Transaction Closing Costs.

Financing planning tips: The amortization period determines principal-and-interest payments. The loan term determines when the loan must be repaid; a shorter term may leave a balloon balance. The remaining principal shown is after the last scheduled monthly payment and excludes payoff fees and accrued interest. Interest-only payments do not reduce principal. Annualized debt service equals 12 monthly payments and excludes any balloon payoff, taxes, insurance, and reserves. Upfront loan costs include points plus other loan closing costs, not interest. This estimate assumes a fixed rate, monthly payments, and the full loan outstanding from the start. Loans with renovation draws or changing rates require a separate draw or rate schedule.

Estimated Loan Sizing

Enter the lending assumptions you want to test. These are adjustable planning inputs, not LNB program requirements or a loan approval.

Annual NOI Used —
Property Value Used —
Requested Loan LTV —
Requested Loan DSCR —
Requested Loan Debt Yield —
Annual Loan Constant —
Maximum Loan Based on LTV —
Maximum Loan Based on DSCR —
Maximum Loan Based on Debt Yield —
Estimated Supportable Loan —

Loan sizing tips: The estimate uses the lowest of the three loan limits. DSCR is annual NOI divided by annualized debt service. Debt yield is annual NOI divided by the requested loan. The annual loan constant is annualized debt service divided by the requested loan, and lets us estimate the DSCR loan limit using the same rate and payment structure. Current analysis uses your entered current property value; stabilized analysis uses your entered expected value and projected NOI. A lender may use a lower purchase-price or appraised-value basis, adjusted NOI, different underwriting payments, or additional limits. Stabilized results describe a future scenario, not funding available today. All three limits must be entered to show the combined estimate.

Investment Summary

Uses the scenario selected in Estimated Loan Sizing.

Total Project Cost & Initial Reserves —
Estimated Additional Cash Needed —
Estimated Excess Loan Proceeds After Budgeted Uses —
Investor Cash Remaining in Deal —
Annual Cash Flow After Debt Service & Reserve Contribution —
Average Monthly Cash Flow —
Cash-on-Cash Return —
Cap Rate —
Value Indicated by Assumed Market Cap Rate —
Loan to Total Budgeted Cost (Including Initial Reserves) —

Summary planning tips: Other closing costs exclude amounts already entered under Financing. Initial reserves exclude the carrying reserve already in the renovation budget. Purchase project cost includes price, renovation and lease-up budget, upfront loan costs, other closing costs, and additional initial reserves. Refinance uses include existing loan payoff instead of purchase price; this is not the property's historical cost. Cash needed and excess proceeds use the requested loan, not the estimated supportable loan, and assume all loan funds are available; draw timing and lender restrictions can change the actual cash needed. Cash flow is a full-year scenario estimate, not a renovation-period forecast, and excludes income taxes and balloon payoff. Replacement reserve contributions reduce cash flow but do not reduce NOI here. Cash-on-cash return uses investor cash remaining in the deal; for refinance, enter previously invested cash net of prior cash returned. No return percentage is shown when that cash balance is zero or negative. Current purchase cap rate uses purchase price; current refinance cap rate uses current value; stabilized cap rate uses expected stabilized value. The indicated value uses NOI divided by your assumed market cap rate and is not an appraisal. Stabilized projections use the same proposed financing terms and do not model a separate future refinance.