Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started