Cash Flow Analysis Worksheet
Unique worksheet designed for evaluating the effects of purchasing a practice. Allows for entry of over a dozen variables including purchase price, interest rate, seller involvement, practice growth assumptions, owner per diems and much more. Enter “What If” scenarios to determine maximum benefit from the purchase. Uses actual practice figures for actual/historic income & expenses to produce meaningful results.
The Worksheet allows for entering current year (or immediate past year) monthly figures for detailed income and expense and then projects annual cash flow for that year plus an additional two years. Can also be used with real time income and expenses to track cash flow on a monthly basis.
Variable Data Used for Cash Flow Analysis Worksheet
|Practice Purchase Price||Financing Rate & Term|
|Down Payment Amount||Seller or 3rd Party Loan Funding|
|Buyer Estimated Tax Rate||Annual Work Days per Doctor|
|Seller Involvement in Practice Analysis||Buyer Per Diem Payments per Year|
|Annual Revenue Growth %||Annual Expense Growth %|
|Maximum Social Security Wages||COLA %|
|Fiscal Year Ending Month||Starting Year for Cash Flow|
|Actual Income and Expense Data|
Worksheet requires Microsoft Excel version 2007 or higher.