80 likes | 201 Views
Personal Financial Statement . Reveals your overall net worth at the moment by illustrating the difference between what you owe and own. Personal Financial Statement . Pro Forma.
E N D
Personal Financial Statement Reveals your overall net worth at the moment by illustrating the difference between what you owe and own.
Pro Forma “Method of calculating financial results to emphasize either current or projected figures”. Revenue projections, estimated expenses and positive cash flow within a business plan. Pro Forma’s are multi year cash flow estimates.
Pro FormaHow to create a Pro Forma • Calculate the projected revenue for the business. Make realistic assumptions. Speak to people you trust in the industry to determine actual costs and revenue. • Estimate the liabilities and costs; repairs, interest, real estate taxes, insurance, utilities etc. Don’t overlook ANY projected expenses. • Estimate the future cash flow or net income.
Net Operating Income (NOI) . Net Operating Income Income Gross Rents Possible 10,200 ($850 x12) Other Income Potential Gross Income $10,200 Less Vacancy Amount $ 1,530 Effective Gross Income $8,670 Operating Expenses Hazard Insurance $850 Repairs & Maintenance $750 Management Fees Real Estate Taxes $1,000 Supplies $100 Less Operating Expenses $2,700 Net Operating Income $5,950
Debt Service Ratio (DSCR) The debt service coverage ratio (DSCR) is the ratio of net operating income to debt payments on investment real estate. Debt Service Coverage = Net Operating Income (NOI) / Debt Service 5,950 / 5,368.13 = 1.10%
. Debt Service Ratio (DSCR) In commercial real estate finance, DSCR is the main measure to determine if a property will be able to sustain its debt based on cash flow. Most banks will lend to a 1.2 DSCR, but at times with more aggressive practices you begin to see this number decreasing. A DSCR below 1.0 on a property indicates that there is not enough cash flow to even cover the loan.
. Debt Service Ratio (DSCR) Typically, most commercial banks require the ratio of 1.15 - 1.35 times (net operating income or NOI / annual debt service) to ensure cash flow sufficient to cover loan payments is available on an ongoing basis.