proforma and cost allocation
An ambulatory clinic, structured as a physicians partnership, has 7 responsibility centers: Administration, Administrational Support, Facilities Management, Environmental Support, Imaging, Clinical Services, and Surgical/Invasive Services. Last years balance sheet and income statement are shown below. Being structured as a for-profit partnership, there are some minor differences in the financial statements from the corporate formats used in class. For example, the equity section of the balance sheet is comprised primarily of 2 accounts: the capital and current accounts. Typically, each partner has their contributed capital listed in the capital account and their share of the companys accumulated profits (retained earnings) listed in their current accounts.
AMBULATORY CLINIC PARTNERSHIP
BALANCE SHEET, December 31, 2013
Cash and equivalents $ 200,000
Net accounts receivables 420,000
Pre-paid expenses 180,000
Total Current Assets $ 1,100,000
PP&E $ 2,550,000
Accumulated depreciation 550,000
Net Fixed Assets $ 2,000,000
Other Intangibles 100,000
TOTAL ASSETS $ 2,500,000
Accounts payable $ 180,000
Salaries payable 160,000
Taxes payable 30,000
Current portion of L-T debt 100,000
Notes payable 60,000
Unearned revenues 60,000
Total Current Liabilities $ 590,000
Debentures, less current portion 500,000
Mortgages, less current portion 600,000
Total Long-term Liabilities $ 1,100,000
Capital account (total) 410,000
Current account (total) 400,000
Total Equity $ 810,000
TOTAL LIABILITIES & EQUITY $ 2,500,000
AMBULATORY CLINIC PARTNERSHIP
INCOME STATEMENT, Year Ended December 31, 2013
Gross Patient Revenue $4,500,000
Deductions & Bad debt 850,000
Net Patient Revenue $3,650,000
Interest Revenue 150,000
Total Net Revenues $3,800,000
Salaries/wages expense $2,050,000
Lease expense 500,000
Supplies expense 400,000
Utilities expense 300,000
Total Operating Expenses $3,400,000
Earnings before interest,
depreciation, & amortization 400,000
Depreciation expense 153,000
Earnings before interest 247,000
Interest expense 50,000
Net Income $ 197,000
The clinic is trying to plan for next years operations. They are assuming that their sales activity will increase by 20%. They are interested in determining what, if any, will be their future additional funds needs. Currently, the fixed assets are operating at 90% capacity, meaning they have excess capacity in fixed assets. When using the percentage of sales method for forecasting funding needs, make sure you only take into consideration that accounts that would be expected to increase with sales. Some accounts will not be increasing just because sales are expected to increase. Those accounts affected by sales changes tend to be related to daily operations.
Exceptions to the spontaneous assets and liabilities criteria are the relevant funding accounts, specifically: short-term debt, long-term debt, and equity accounts. The following are specific conditions of these accounts for this practice:
1) Current portion of long-term debt is not considered short-term debt. It represents the portion of long-term debt due this year. Any changes you make to funding accounts will not affect this account, even if you were to change long-term debt accounts.
2) Notes Payable is a type of short-term debt that can be used to allocate funding needs. Interest rates on short-term debt will run at 5% per year.
3) Debentures, less current portion, represent a type of long-term debt that is sometimes referred to as line of credit. It is essentially just a bank loan. The amount listed is the amount remaining to be paid after this period.
Mortgages, less current portion, are similar to Debentures except they are obligations tied to specific assets. Both accounts can be increased or decreased and will not affect the total current portion of long-term debt until the following year.
Interest rates on all long-term debt will run at 4.27% per year.
4) In partnership organizations, Capital Accounts represent the total of each individual partners investment in the firm. It is similar to common stock plus paid-in capital for a corporation. Typically, each partners capital account is designated but here it is totaled for you.
The Current Accounts is similar to the retained earnings of a corporation, but it keeps track of the amount of profit due to each partner and their total investment.
When performing you pro forma statements, keep in mind the following requirements of the firm:
1) The partners wish to maintain a current ratio of at least 2.1026
2) The long-term debt ratio should not exceed .45
3) An ROE of at least .24 is desired
4) Next year, the partners will be withdrawing $145,000 in distributions (similar to dividends)
As noted earlier, the clinic has 7 responsibility centers. The Administration department includes the offices of top management, the functions of HR, and accounts for the debt interest paid by the organization. The Administration Support department covers the billing and coding functions as well as patient scheduling. The Facilities Management department handles the facilitys maintenance needs and accounts for the organizations depreciation. The Environmental Support group handles all housekeeping duties and any HAZMAT control needed. The Imaging department is responsible for performing all diagnostic testing for both in-house and external patients of the clinic. The Clinical Services department accounts for all the clinical staff the care for the clinics patients, including nursing, techs, and transportation. The Surgical/Invasive Services department essentially covers the surgeons and other employees and functions of surgical services.
The clinic has determined that measuring relative value units (RVUs) for patient care is a good metric for accounting for effort and cost of services. The direct cost with certain possible allocation bases are given below:
DEPARTMENT Cost FTEs Square Feet RVU%
Imaging $232,600 12 3,000 14
Clinical Services $259,100 16 4,000 16
Surgical Services $1,178,000 10 2,000 70
Administration $475,000 06 1,000 —
Admin. Support $425,000 10 1,500 —
Facilities Mgmt. $579,000 05 500 —
Environ. Support $435,000 11 500 —
Administration costs are thought to be driven by the number of employees in each department. Administration Support costs are thought to be driven by the percentage of RVUs exhibited in each department. Facilities Management is affected by a departments total physical area. Finally, Environmental Supports costs are affect by a combination measure of a departments number of employees times the square footage and then multiplied by 1 plus the RVU%.
The clinic would like to see the full costs for each revenue center for the end of the year. Please consider the affects of the Direct, Step-Down, and Double Distribution methods.
Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more