Walden NURS6211 All Assignments Latest 2021 January

NURS6211 Finance and Economics in Healthcare Delivery

Week 1 Assignment  

Healthways Budget

Throughout this course, you will utilize spreadsheet software (Microsoft Excel) to perform economic and financial calculations. In this activity, you will practice some fundamental mathematical applications of spreadsheet software that enable you to use the spreadsheet as a calculator. You will also learn how to use formulas and functions, and present data in Excel.

To Prepare

Download and review the document Healthcare Budget Request Guide.

Download and review the Excel Assignment Workbook. Open the Worksheet tab titled “W1A1 HealthWays Budget”.

The Assignment

Using the Healthcare Budget Request Guide for guidance, complete the worksheet tab titled “W1A1 HealthWays Budget”.

By Day 7 of Week 1

Submit your Assignment.

Submission and Grading Information

Please save your Assignment using the naming convention “W1A1_lastname_firstname_.xlsx” as the name.

Click the Week 1 Assignment Rubric to review the Grading Criteria for the Assignment.

Click the Week 1 Assignment link. You will also be able to “View Rubric” for grading criteria from this area.

Next, from the Attach File area, click on the Browse My Computer button. Find the document you saved as “W1A1_lastname_firstname.xlsx” and click Open.

 

NURS6211 Finance and Economics in Healthcare Delivery

Week 2 Assignment  

Healthcare Budget Request and Workbook Template

Throughout this course, you will develop a comprehensive Healthcare Budget Request to promote commitment from leadership to your idea for a healthcare product or service to address gaps or provide opportunities to your organization. For this Assignment, you will begin this effort by developing an executive summary for the proposal. You will also begin work on a spreadsheet workbook that you will utilize to calculate and present financial analysis in support of your idea.

Photo Credit: Getty Images/Vetta

To Prepare

Reflect on current gaps or opportunities for enhanced services within your healthcare organization.

Select one of these gaps or opportunities that you would like to analyze and for which you would like to propose a healthcare product or service solution.

Choose your product or service carefully as it needs to meet three distinct parameters for use in this course. It must have a capital investment (start-up costs) and there must be annual cost and revenue that you can estimate for each of 5 years. An example is a capital equipment purchase that is a direct charge to the patient such as a 12-lead EKG. There would be start-up cost for the purchase of the equipment in Year 0. Then each use requires some disposable electrodes and staff to perform the procedure. Revenue is based on the patient charge.

Reflect on the impact this issue/opportunity and product/service solution have (or could have) on various stakeholders and systems across your healthcare organization.

Identify one or more individuals within your healthcare organization to act as “finance counselor” with whom you can consult on financial and budget items such as costing, estimating, and budget request processes. 

Reflect on the current costs associated with the selected issue or opportunity, including direct financial costs to the organization and financial costs to patients, healthcare providers, and other stakeholders. Also consider non-financial costs, including opportunity costs.

Consider how you would communicate a proposal to leadership that addresses the selected issue/opportunity within your organization. 

The Assignment: Healthcare Budget Request – Executive Summary:

Develop an executive summary and structure for a healthcare budget request for your new product or service idea by completing the following:

Part 1: Executive Summary

Using the Healthcare Budget Request Template, develop a 1- to 2-page executive summary that describes the issue or opportunity that you are analyzing. In your executive summary, you should: 

Describe the healthcare issue or opportunity you selected. 

Describe the stakeholder groups impacted by this issue/opportunity.

Explain which stakeholder groups would most likely be responsible for helping you address the healthcare issue or opportunity you selected and why. Be specific and provide examples.

Describe the healthcare product or service that you propose to address the identified gaps/opportunities and explain why.

Provide scholarly support for the issue or opportunity and your new product or service idea.

Part 2: Excel Assignment Workbook

As you progress through this course on the development of a Healthcare Budget Request, you will apply financial ratios and other calculations to make the business case for your idea. In this component of the assignment, you will customize a spreadsheet workbook and prepare it for use in your analysis. To do this, you will:

Review the Healthcare Budget Request Guide found in the Resources. Open the Excel Assignment Workbook; follow the instructions in the guide, which will help you:

Create a template that you will use for future analysis you will conduct in subsequent parts of your Healthcare Budget Request.

Format your spreadsheet for presentation of results.

Save and close the spreadsheet file.

Submit both Part 1 and Part 2 of your Assignment by Day 7 of Week 2.

*NOTE: You will need to submit both a Word Document and an Excel Spreadsheet for your Assignment submission. Please be sure to only submit your Assignment once you have uploaded these two components of your W2A2 Assignment.

NURS6211 Finance and Economics in Healthcare Delivery

Week 4 Assignment  

Healthcare Budget Request – Estimating Expenses

It can be tempting to think of “dreams” and “finance” as opposite ends of a spectrum. You may dream of things you want, such as new cars, vacations, or retirement. But a quick analysis of your current finances may awaken you to find that your dream is not yet financially feasible.

Dreams and finance are, in fact, not at all in opposition. If your dream is a new automobile, you soon come to realize that you’ll need a plan to make your purchase. Part of this planning is based on an understanding of your current financial position. 

Photo Credit: Getty Images

Saving money will help you, and whatever cost is not covered by savings can possibly be made up for by securing financing. You’ll likely need a personal budget that accounts for any new expenses you incur, including your new car payment.

Like you, healthcare organizations have dreams, manifested as corporate objectives. Proposals for new healthcare products or services must support these objectives, typically demonstrated via a business case. To become reality, these ideas almost always require resources. By understanding current financial position, accurately estimating revenue streams and expenses, and creating budgets, strategies can be developed that bring objectives to life.

For this Assignment you will calculate estimated expenses associated with a proposed new healthcare product or service. You will also estimate revenues and calculate a return on the proposed investment.

To Prepare

Reflect on the healthcare product or service solution you have proposed for your healthcare organization. Consider expenses (including start-up expenses and any capital expenditures) that will be required to implement your product or service.

Reflect on the estimated revenues (if any) that your proposed solution will generate. If your project does not generate a direct revenue source, consider cost avoidance, or cost savings as an alternate potential revenue source.

Reflect on the need for financing to meet the estimated expenses associated with your idea.

For each of the above, consult with your internal financial counselor as needed.

The Assignment: Estimating Expenses

Conduct an analysis of estimated expenses and revenues associated with your product or service idea by completing the following:

Part 1: Expense/Revenue/ROI Analysis:

Open your Excel Assignment Workbook and navigate to the “W4A3 Estimated Expenses” worksheet. Using the Healthcare Budget Request Guide for guidance, create a worksheet that records the following:

Each of the estimated expenses associated with your proposed idea, including startup expenses. Be sure to label each appropriately, with enough description to make it clear what the item is and what the estimated cost involves.

Each of the estimated revenues associated with your proposed idea. Be sure to label each appropriately, with enough description to make it clear what the item is and any necessary details regarding sources of revenues (including reimbursements).

Calculate the total estimated expenses and revenues for the next 5-year period.

Calculate the Return on Investment (ROI) for your proposed idea.

NOTE: You will copy your worksheet and analysis onto the Healthcare Budget Request Template (Word document) for submission.

Part 2: W4A3 Projected Expenses and Revenues (Five Year) Summary of Analysis and Interpretation of Results:

Create a brief (1- to 2-page) description of your analysis that clearly describes the estimated financial impact of your proposed idea. Interpret the results by explaining what your ROI calculation means to the organization. Place your analysis on the Healthcare Budget Request Template under the section titled W4A3 Projected Expenses and Revenues (Five Year).

 

NURS6211 Finance and Economics in Healthcare Delivery

Week 6 Assignment  

Healthcare Budget Request – Budget Development

How do you make difficult decisions? Do you carefully consider the repercussions of each choice? Perhaps you discuss possible outcomes with others. Maybe you rely on tools for help, even if the tool is a coin that can help you reach a conclusion with a simple flip.

Healthcare organizations generally don’t have an unlimited stack of coins, neither for flipping nor for spending. Therefore, they must be strategic in how they spend the resources they do have. 

Photo Credit: Getty Images

Budgeting is a process by which they can decide which projects or purchases are worth the cost involved and whether they should expand their operations, invest in new equipment or services, or pursue other projects with the potential to bring in additional profits.

For this Assignment, you examine how budgets are developed. After developing a sample budget for a product or service, you also examine how ratios can be used to analyze the budget and provide information that can guide choices.

To Prepare

Reflect on the expenses and revenues you considered in the Week 4 Assignment.

Consider any other expenses that you have yet to account for in the development, launch, and implementation of the healthcare product or service you have proposed. 

Consult with your internal finance counselor to help identify and estimate any hidden expenses that may not be obvious.

The Assignment: Budget Development

Develop and analyze a budget for your proposed healthcare product or service. To do this, complete the following:

Part 1: Develop the Budget Worksheet:

Open your Excel Assignment Workbook and navigate to the “W6A4 Budget Development” worksheet.

Using the Healthcare Budget Request Guide for guidance, create a 5-year budget for the healthcare product or service that records the projected expenses and revenues associated with the healthcare product or service you have proposed. Be sure to include startup and operating expenses in your budget. You may bring forward the work from the W4A3 Estimated Expenses assignment and add to it.

Calculate the budget ratios as directed in the Healthcare Budget Request Guide.

NOTE: You will copy your worksheet and analysis onto the Healthcare Budget Request Template (Word document) for submission.

Part 2: Summary of Analysis and Interpretation of Results:

Create a brief (1- to 2-page) description of your budget and analysis that clearly describes the budget. Be sure to address the following:

During the course of 5 years, is there an estimated surplus or deficit?

What percentages of the budget are dedicated to various categories you have defined, such as startup costs, etc.?

What does this budget mean for your organization? 

Place your analysis on the Healthcare Budget Request Template under the section titled W6A4 Projected Budget (Five Year).

 

NURS6211 Finance and Economics in Healthcare Delivery

Week 8 Assignment  

Ratio Analysis

Your personal decisions regarding purchases are likely made, in no small part, based on your financial position. You will likely consult your bank statements and checkbook before buying. But the extent that you will go beyond current resources—including loans and financing—will depend on factors such as need for the good or service and potential it has for returning value. Similarly, leaders must juggle need, financial position, and potential for return when making expenditure decisions.

Photo Credit: Getty Images/iStockphoto

For this Assignment, you consider analysis tools such as expense forecasting, break-even, cost-benefit, marginal profit and loss and cost-effectiveness that can help determine the financial and organizational impact of proposed expenditures and investments.

To Prepare

Complete the required reading in the Learning Resources.

Reflect on how these might be applied to your project.

The Assignment

Conduct a financial analysis using the three scenarios provided in the Excel Assignment Workbook. These are not based on your project but will help you learn the process.

Complete the following:

Ratio Analyses Worksheets:

Open your Excel Assignment Workbook. This assignment will be completed on 3 separate tabs named:

W8A5a Expense Forecasting

W8A5b Breakeven Analysis

W8A5c Marginal Profit and Loss

Using the Healthcare Budget Request Guide for guidance, complete the three scenarios: expense forecasting, break-even, marginal profit and loss for the scenarios provided.

 

NURS6211 Finance and Economics in Healthcare Delivery

Week 11 Assignment  

Final Healthcare Budget Request

Once an idea has matured to the point that there is a clear understanding about the organizational and financial impact, there is typically a need to request resources to bring the idea to reality. This is typically done by submitting a budget request in the hopes of getting the idea on the budget, meaning there is organizational commitment to move forward with the idea by planning to allocate necessary resources. This commitment implies that the expenditure aligns with organizational objectives and the financial position of the organization.

Photo Credit: Getty Images

In this Assignment, you will analyze financial statements to determine the financial health of an organization. You will use this assessment as part of a final healthcare budget request.

To Prepare

Reflect on the previous Healthcare Budget Request assignment submissions, including your executive summary, your Expense/Revenue/ROI Analysis, your estimated budget, and your ratio analysis.

Review the Excel Assignment Workbook, W10/11A6 HealthWays Financials tab. These are sample financial statements.

Reflect on the information conveyed by these statements.

If possible, secure copies of your healthcare organization’s income statement, balance sheet, and statement of cash flows. Consult with your internal financial counselor on this, as needed.

The Assignment

Finalize your Healthcare Budget Request by completing the following:

Part 1: Financial Statement Calculations and Analysis:

Open your Excel Assignment Workbook and navigate to the “W10/11A6 Financials” worksheet.

You have 2 Options for completing this Assignment as noted in the Excel Assignment Workbook.

Using the Healthcare Budget Request Guide for guidance, conduct analyses as directed on either your organization’s financial statements or those provided in the HealthWays Financial Statements worksheet. Your analysis will include spreadsheet calculation of financial statement ratios.

Part 2: Summary of Analyses and Interpretation of Results:

Create a brief (1- to 2-page) description of your analyses. Be sure to address the following in your summary:

Describe the results of each statement analysis. What do the results of each analysis mean?

What does your complete financial statement analysis suggest about the financial health of the organization?

If using your current organization’s data, does your analysis help describe any observed organizational behaviors or actions? Explain.

What assumptions have you made in your analyses?

What implications do these analyses have for your proposed healthcare product or service?

Part 3: Summary of Work and Final Healthcare Budget Request

Compile and summarize your work in previous assignments. Place your final work on the Healthcare Budget Request template. Your final Healthcare Budget Request should include:

A final version of your Executive Summary

A final version of your projected expenses and revenues

A product/service budget for the launch and the first 5 years

A summary of financial and SWOT analyses that you conducted, including your interpretation of the results

A 3- to 5-slide PowerPoint presentation containing the final version of your elevator speech, incorporating selling points from your analyses that you believe make the business case for nurse entrepreneurship and leadership’s commitment to your proposed healthcare product or service.