80 likes | 209 Vues
A Personal Financial Statement (PFS) reveals your net worth by showing the difference between what you owe and own. Pro Forma statements help project financial results, emphasizing estimated revenue, expenses, and cash flow over multiple years. To create a Pro Forma, estimate projected revenue, consider realistic assumptions, and account for all liabilities and expenses. Key measures like Net Operating Income (NOI) and Debt Service Coverage Ratio (DSCR) assess a property's capacity to sustain debt, guiding investment decisions and financing.
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.