Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a projected financial statement including 5 years of projections based on the information. Create a balance sheet and income statement based. Year 1 Projected

Develop a projected financial statement including 5 years of projections based on the information. Create a balance sheet and income statement based.
image text in transcribed
image text in transcribed
Year 1 Projected Forecast Patient visits per day Expected Revenue Cost per visit/patient Variable Staff Supplies (gloves, mask, etc.) Diagnostic test/labs Year 2 Year 3 Year 4 Year 5 10 15 20 25 25 288000 432000 576000 720000 720000 $120 $120 $120 $120 $120 ($6,000) (56,200) ($6,400) (S6,600) ($6,500) ($10,000) ($15,000) ($20,000) ($25,000) ($25,000) Fixed Cost Rent Utilities Staff Salaries ($18,000) ($18,000) ($18,000) ($18,000) ($18,000) ($3,600) ($3,600) ($3,600) (53.500) ($3,600) ($252.000) (S252.000) ($252.000) (5252.000) ($252.000) Estimated total profit ($1.600) $137,200 $276,000 $414,800 $414,800 Maung Keview View Help Grammarly Picture Format YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 A B REVENUE VARIABLE COST 288000 16000 432000 21200 576000 26400 720000 31600 720000 31600 CONTRIBUTION 272000 410800 549600 688400 688400 PER UNIT/PATIENT 10 15 20 25 25 CONTRIBUTION PER UNIT 27200 27386.67 27480 27536 27536 FIXED COST 273600 273600 273600 273600 273600 BREAK EVEN POINT 10.05882 9.990263 9.956332 9.936084 9.936084

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Analysis Microsoft Excel 2010

Authors: Conrad Carlberg

1st Edition

0789747200, 9780789747204

More Books

Students also viewed these Accounting questions

Question

What are the general types of interviews? Explain each.

Answered: 1 week ago

Question

6 How can HRM contribute to ethical management and sustainability?

Answered: 1 week ago