Practice Purchase / Sale Cash Flow Analysis Worksheet


Detailed Excel Worksheet to analyze the financial aspects of purchasing a practice.


Practice Purchase
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.

Related Products