Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you PLEASE help me with this? I DO NOT have a financial background. :-( Create a 3- to 5-year financial plan to implement the

Can you PLEASE help me with this? I DO NOT have a financial background. :-(

Create a 3- to 5-year financial plan to implement the goals and objectives created in Part II of your strategic plan (see below). The deliverables for the financial plan include a projected budget created in Microsoft Excel and a report in Microsoft Word that clarifies and explains the financial plan.

Section One: Projected Budget

Create a projected budget. The projected budget should be a Microsoft Excel spreadsheet that contains a 3- to 5-year financial projection that includes detailed expenditures, income, contingency, gain or loss, capital outlay, and ROI (if applicable). Include budget strategies to increase volume and budget assumptions.

Section Two: Financial Plan Explanation

Write a 1,050- to 1,400-word narrative discussing the fiscal details of the plan and the assumptions that were used in developing the projected budget. Include all the elements required in the projected budget. Include capital expenditure planning and contingency plans for unexpected events. Budget summary: When explaining your budget: Describe the organization's current business model. Evaluate the impact of internal resources and financial capabilities on the business model implementation. Determine how the organization's internal resources and financial capabilities affect your financial plan. Determine how they will affect implementation of the plan. Explain the details of the budget assumptions and the strategies to increase volume.

Cite at least 4 peer-reviewed, scholarly, or similar resources to support your information.

Here's a sample

Sample Strategic Planning Spreadsheet

Diagnostic Imaging

Purchase &

Hire & Train

Strategies to Increase Volume

Install

Staff

Purchase and install a new MRI.

MRI

Train or hire additional staff to operate new MRI.

Revenue

Year 1

Year 2

Year 3

Increase marketing to physicians.

CT

$2,000,000

$2,200,000

$2,420,000

Assumptions

MRIs

$8,000,000

$8,800,000

$9,680,000

Increase in revenue/year

10.00%

General diagnostic

$6,000,000

$6,600,000

$7,260,000

Increase in salaries/year

4.00%

Interventional

$12,000,000

$13,200,000

$14,520,000

Increase in supply expense/year

5.00%

Travel as a % of revenue

0.50%

Total revenue

$28,000,000

$30,800,000

$33,880,000

Maintenace as a % revenue

1.00%

Contracts as a % of revenue

2.00%

Expenses

Marketing as a % of revenue

0.50%

Misc as a % of revenue

1.00%

Salaries

$18,200,000

$20,020,000

$22,022,000

Salaries as a % of revenue

65.00%

Supplies

$4,200,000

$4,410,000

$4,630,500

Travel

$140,000

$154,000

$169,400

Maintenance

$280,000

$308,000

$338,800

Contracts

$560,000

$616,000

$677,600

Marketing

$140,000

$154,000

$169,400

Miscellaneous

$280,000

$308,000

$338,800

Total expenses

$23,800,000

$25,970,000

$28,346,500

Net profit

$4,200,000

$4,830,000

$5,533,500

Capital outlay

$2,500,000

$0

$0

Goals and Objectives (3-5 year period)

The focus is on development of our organization in the first year, internal consolidation with value addition as a focus for the second year, and customer focus for growth in the third year. A development plan with target goals and objectives for next three years have been prepared (see illustration below).

2017

Goals and Objectives

Appoint Directors & Heads of various departments. Each Director shall head one or two technical divisions.

Appoint each director as members of Board.

The directors shall prepare and set goals for one year for their departments.

Set personal goals for their team members

Directors shall create a vision and look ahead plan for their respective departments and agree with the Board for implementation plans.

Board of Directors to approve a look ahead plan for next three years.

CEO to prepare a strategic plan for development of the organization for next three years.

The key development areas shall be to add two additional Medicare departments.

Set a business goal for each year for the organization

Plan some strategic alliance and growth plan.

Create own website

An organization website to be operational by the end of 2017.

Shall provide all possible information to the Medicare providers and customers.

Shall ensure at least three corporate donations through this website.

2018

Goals and Objectives

Prepare an organization structure with clear line of responsibilities and roles.

Develop a responsibility matrix for all staff, accepted by the board of directors.

Provide training to all team members on mission & vision, their roles and reporting structures.

Each department shall have their clear goals and means to achieve.

IT system to be fully functional.

Plan and implement an internal data and information sharing system, with communication facilities.

HR to ensure a merger with an IT company to set up and manage the internal and external communication system.

Ensure on line trainings and ERP system is operative.

Ensure travel budget is reduced to half.

Value for money for customers, Internal efficiency and Improvement Areas.

The directors shall set service improvement plans.

Ensure reduction of customer complaints by 50%.

Reduce the patient time spent in hospital by 10 minutes.

Add two new services to the hospital portfolio.

Contract ambulance service providers Minimum 5 ambulances to be on board.

Start Orthopedic department as it is seen as a potential growth area.

Set performance measurement systems to ensure efficiency and cost reduction by 5%.

Add new wing for emergency and trauma care center.

2019

Goals and Objectives

Customer Meet

Plan and hold a 2-day meet the customer seminar.

Marketing with HR to develop a plan and hold a 2 day seminar with Insurance providers, corporate donation providers, Government Agencies and other corporate alliance hospitals

Plan regular video conferences and personal meetings with Insurance agencies and corporate donation providers, one per month to ensure donations double in this year.

An internal one week conference to review the performance in last two years.

HR to organize a one week seminar on company performance.

Complete board to attend this conference.

Take out five clear business and corporate governance related strategies for implementation in next two years.

Prepare a marketing plan with targets and budget requirement

Prepare two year look ahead plan for their respective departments.

.

Marketing team shall present their plan in two parts (1). Three monthly plans for one year. (2). A yearly plan for three years.

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

Middle Market M And A Handbook For Advisors Investors And Business Owners

Authors: Kenneth H. Marks, Christian W. Blees, Michael R. Nall, Thomas A. Stewart

2nd Edition

1119828104, 978-1119828105

Students also viewed these Finance questions