Outpatient Therapy Center Financial Proforma-Years Year Year Year Year Year 1 2 3 4 5 5...

Outpatient Therapy Center
Financial Proforma-Years
	Year	Year	Year	Year	Year
	1	2	3	4	5	5 Yr Total

# OF VISITS	2,268	2,940	3,533	3,974	4,783	17,498

Revenue
Gross Revenue	907,200	1,223,040	1,528,625	1,787,971	2,238,056	7,684,893
Contractual Allowance	(544,320)	(726,486)	(898,694)	(1,040,114)	(1,287,900)	(4,497,514)
NET REVENUE	$362,880	$496,554	$629,931	$747,857	$950,157	$3,187,379

Direct Expenses
Rent	96,000	98,000	100,000	102,000	104,000	500,000
Common Area Maintenance Charges	24,000	25,200	26,460	27,783	29,172	132,615
Start Up Costs Depreciation	7,143	14,286	14,286	14,286	14,286	64,286
Technology Depreciation	14,286	28,571	28,571	28,571	28,571	128,571
Advertising	12,000	1,500	1,500	1,500	1,500	18,000
Salary	248,976	298,954	335,884	342,884	383,631	1,610,330
Benefits	63,862	83,329	86,154	87,950	98,401	419,697
Vacation Coverage	2,160	2,246	2,336	2,430	2,527	11,699
Extended Leave	1,151	1,197	1,244	5,177	5,384	14,152
Electric	8,000	8,880	9,235	9,605	9,989	45,709
Phone	1,800	1,872	1,947	2,025	2,106	9,749
Repairs & Maintenance	500	1,000	2,000	4,000	8,000	15,500
Total Direct Expenses	479,877	565,035	609,619	628,210	687,567	2,970,308

Indirect Expenses
Supplies	454	588	707	795	957	3,500
Laundry	2,563	3,322	3,993	4,490	5,405	19,772
Total Indirect Expenses	3,016	3,910	4,699	5,285	6,361	23,272

TOTAL EXPENSES	$482,894	$568,946	$614,318	$633,495	$693,928	$2,993,580

NET INCOME/LOSS	$(120,014)	$(72,391)	$15,613	$114,362	$256,229	$193,799
Income Percentage	-33.1%	-14.6%	2.5%	15.3%	27.0%	6.1%

Physical Therapy Center Assignment

1. The operation will receive an interest free, non-amortizing loan of

$ 400,000 from the home office.

2. The pre-opening start up costs are $71,429 which will be

“capitalized” (treated as P,P,& E).

3. The investment in property, plant and equipment (AKA

technology) is $ 285,714 .

Assignment: Prepare the Cash Flow Proforma for 5 years based on

the above assumptions and Proforma Results of Operations posted on

Angel. What is the ending Cash balance?

Expert Solution

Cash Flow Proforma
	Year	Year	Year	Year	Year
	1	2	3	4	5	5 Yr Total
Receipts
Beginning balance		488,592	1,185,544	2,142,710	3,340,042	0
Revenue
Gross Revenue	907,200	1,223,040	1,528,625	1,787,971	2,238,056	7,684,893
Total cash avaialble----a	907,200	1,711,632	2,714,169	3,930,681	5,578,098	7,684,893

Less: Disbursements
Direct Expenses
Rent	96,000	98,000	100,000	102,000	104,000	500,000
Common Area Maintenance Charges	24,000	25,200	26,460	27,783	29,172	132,615
Advertising	12,000	1,500	1,500	1,500	1,500	18,000
Salary	248,976	298,954	335,884	342,884	383,631	1,610,330
Benefits	63,862	83,329	86,154	87,950	98,401	419,697
Vacation Coverage	2,160	2,246	2,336	2,430	2,527	11,699
Extended Leave	1,151	1,197	1,244	5,177	5,384	14,152
Electric	8,000	8,880	9,235	9,605	9,989	45,709
Phone	1,800	1,872	1,947	2,025	2,106	9,749
Repairs & Maintenance	500	1,000	2,000	4,000	8,000	15,500
Total Direct Expenses---1	458,449	522,178	566,760	585,354	644,710	2,777,451

Indirect Expenses
Supplies	454	588	707	795	957	3,500
Laundry	2,563	3,322	3,993	4,490	5,405	19,772
Total Indirect Expenses---2	3,016	3,910	4,699	5,285	6,361	23,272

Pre-opg. Costs-----3	71429					71429
Investment in PP&E---4	285714					285714
Total disbursements----5=(1+2+3+4)	818,608	526,088	571,459	590,639	651,071	3,157,866

Surplus/(Deficit)----6=a-5	88,592	1,185,544	2,142,710	3,340,042	4,927,027	4,527,027

Add: Loan received	400000					400000
Ending cash balance	488,592	1,185,544	2,142,710	3,340,042	4,927,027	4,927,027


NOTE: Assumed all gross revenues are received within the year

jeff jeffy answered 3 years ago

The 1-year, 2-year, 3-year and 4-year zero rates are 2%, 3%, 4% and 5% per annum...

The 1-year, 2-year, 3-year and 4-year zero rates are 2%, 3%, 4% and 5% per annum (APR) with quarterly compounding/payment. a) What are the corresponding per annum zero rates with continuous compounding? b) What is today’s forward rate for an investment initiated one year from today and maturing 3 years from today? (Give your answer per annum with continuous compounding)? c) What is today’s forward rate for a one-year investment initiated three years from today? (Give your answer per annum with continuous...

Considerations for the Child Receiving Oxygen Therapy for : infants (1st year) toddlers(1-3 years)preschool (4-6 years)...

Considerations for the Child Receiving Oxygen Therapy for : infants (1st year) toddlers(1-3 years)preschool (4-6 years) school age (7-11 years) adolescence ( 12-18 years). Thank you in advance!.

4. (a) Suppose that τσ=(1 5 2 3)(4) and στ=(1 2 4 5)(3) in S5. If...

4. (a) Suppose that τσ=(1 5 2 3)(4) and στ=(1 2 4 5)(3) in S5. If σ1 = 2, find σ and τ. (b) In Sn, show that σ = τ if and only if σ(τ)^(−1) = ε. ε is the identity permutation. Must be written as a proof. (c) Let σ=(1 2 3) and τ=(1 2) in S3. Show that S3={ε,σ,σ^2,τ,τσ,τ(σ)^2} and that σ^3=ε=τ^2 and στ=τ(σ)^2, then fill out the multiplication table for S3.

coffee tea juice 3 4 5 5 4 3 4 4 4 5 1 2 4...

coffee tea juice 3 4 5 5 4 3 4 4 4 5 1 2 4 2 2 Do a One-way ANOVA by hand (at least once in your life!) …Is there a difference in attention for those who drink coffee, tea, or juice during an 8 a.m. class? Utilize the five steps of hypothesis testing to analyze the following data (p<.01). Attention Ratings (1=no attention- 5=full attention)

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash...

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A -15000 6000 7000 6000 6000 6000 B -15000 7000 7000 7000 7000 7000 C -18000 12000 2000 2000 2000 2000 "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years...

Find the distances: A) Between ?1=〈2+2?,−1+?,−3?〉and ?2=〈4,−5−3?,1+4?〉 . B) Between the planes 2?−?+5?=0 and 2?−?+5?=5 ....

Find the distances: A) Between ?1=〈2+2?,−1+?,−3?〉and ?2=〈4,−5−3?,1+4?〉 . B) Between the planes 2?−?+5?=0 and 2?−?+5?=5 . C) From the point (1,2,3) to the line ?=〈−?,4−?,1+4?〉 .

5 + (3 * 4)^2 - 2 = 147 (5 + 3) * 4^2 -...

5 + (3 * 4)^2 - 2 = 147 (5 + 3) * 4^2 - 2 = 126 (5 + 3 )* (4^2 – 2) = 112 5 + (3 * 4^2) - 2 = 51 Which is the correct answer to using the "order of precedence" and why?

X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot...

X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot the date B: find the line of best fit C: determine ŷ AT x=3 D: Find r and r^2 E: explain r and r^2

Raysut Cement Company: Strengths: 1- 2- 3- 4- 5- Weaknesses : 1- 2- 3- 4- 5-...

Raysut Cement Company: Strengths: 1- 2- 3- 4- 5- Weaknesses : 1- 2- 3- 4- 5- Opportunities : 1- 2- 3- 4- 5- Threats: 1- 2- 3- 4- 5-

COLLAPSE Overall Rating: 1 2 3 4 5 1 2 3 4 5 " Service Positioning...

COLLAPSE Overall Rating: 1 2 3 4 5 1 2 3 4 5 " Service Positioning versus Product Process " Please respond to the following: Examine the roles of Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) in business. Determine how each system can play a critical role in managing value chains. How does LaRosa’s Pizzeria use this technology in order to improve the supply chain and value chain operations? Determine the ways this technology has helped to deliver...

Question