Client says - This update is in three parts. All these parts are suppose to be presented in separate files. Part one has a raw data file and a template that needs to be populated. The part 2 is a scenario that is not restricted. The 8-10 pages is only for part 3. the entire work is suppose to be presented in three separate files? Part I Refer to attached files to complete part 1 Week 10: Capital Budgeting Confronting the limitations of a facility built many years ago, the leadership team and board at a small rural hospital must decide how and when to renovate or move into a new building. An academic medical center is considering whether to purchase an expensive piece of technology in the hope of drawing top physicians—and new patients—from throughout the nation. A small physicians’ practice is weighing whether or not to invest in a new computer system. What factors should play into these decisions? What is the best way to buy capital? How does an organization assure that it is making sound investments? This week, you explore answers to these questions as you examine capital and capital budgeting in health care organizations. As you focus on capital this week, you analyze the time value of money and conduct a net present value (NPV) analysis. You also compare financing methods for health care equipment purchases. Learning Objectives Students will: · Analyze the time value of money for a health care organization · Apply net present value (NPV) analyses for replacing capital equipment · Compare financing methods for health care equipment purchases Assignment: Capital Budgeting Note: The Instructor will post the document for this Assignment by Day 1 of Week 10. There are many options to buy capital, including cash purchases, loans, leasing, and other forms of payment. Your goal as a health care manager is to determine which method is best for your organization, given its financial and organizational structure (i.e., for-profit or not-for-profit). Time value of money and net present value are two techniques that may help you determine how and when to invest in new capital. For this Assignment, you examine these concepts as they pertain to the health care industry. To prepare for this Assignment: Review the Week 10 Assignment document provided to you by the Instructor. Reflect on concepts of time value of money, net present value, internal rate of return, and purchasing options. The Assignment: Using the “Week 10 Assignment Capital Budget Excel Template” answer the questions provided in the week 10 assignment document. To assist you with this task a Present and Future Values Excel Tutorial has been created (please check your volume settings) https://mym.cdn.laureate-media.com/2dett4d/Walden/MMHA/6400/CH/mm/excel_tutorials/pf.html Part II Does not have attached files. Solution should be derived from the scenario: Discussion: Ethics in Health Care Finance Note: This is a Post First assignment. You are required to post your original post before the discussion board opens for your review. As a health care administrator, you will undoubtedly be faced with the responsibility of making decisions that may be impacted by ethics. Sometimes, the best approach to a given situation is clear, whereas others require you to carefully consider laws, regulations, and the impact of potential outcomes. How do you ensure you will make the best decision for your health care organization? For this Discussion, you examine the following scenario and consider whether there is a breach of ethics. Scenario: An organization is developing a business plan. The intent of the organization is to provide a service for a community in need, but it appears they might have trouble obtaining financing. The board is trying to decide whether to be transparent in their financials or over-predict so they can properly finance their venture. To prepare for this Discussion: · Read the provided scenario. · Given the mission of the organization in the scenario, consider whether over-predicting financials would be a breach of ethics. Part III See attached files for this part Project: Final Project – Business Plan Business planning is a mapping of your vision for the future of an organization. As a health care administrator, it is important that you are able to create an effective business plan. For this Assignment, you examine the following scenario and develop a business plan for the organization. Scenario: A city-based community hospital is looking at adding an urgent care facility in a rural area. Urgent care is the delivery of ambulatory care in a facility dedicated to the delivery of unscheduled, walk-in care outside of a hospital emergency department. Development of the Rural Urgent Care (RUC) facility will facilitate access to care providers through extended service hours within closer geographic proximity to patients, families, and caregivers. RUC will act to alleviate demand for emergency department services by shifting lower acute patients to a less resource-intensive environment. This project is in response to the shift from volume- to value-based health care. Payers and purchasers are interested in improving economic efficiency by shifting utilization from emergency department to lower cost settings, such as RUC. Several competing hospitals have hired emergency department physicians, as part of their integration strategy to participate in accountable care organizations (ACO) contracts. The hospital needs to respond to the competitive situation by making a sound investment in the RUC facility that addresses both financial and economic situations. The facility will be staffed with physicians and will include a radiology suite, laboratory suite, and other health-related ventures to help the hospital grow. You must help the board develop a business plan for this urgent care unit. To prepare for this Final Project: · Examine the provided scenario. · Refer to the document “Executive Summary, Overview, and Financial Data for Investment in the Rural Urgent Care Center” provided here and in this week’s Learning Resources. Analyze the background and financial data for the RUC facility. Note: This Assignment will be graded using this rubric: Week 11 Project Rubric (PDF). The “Week 11 Business Plan Excel Template” will guide the financial analysis portion of this assignment. The Final Project Assignment: Using the "Week 11 Project Business Plan Template", create a business plan (8 pages) that includes the following: · Executive summary · Market analysis, including: o Macro- and microeconomic implications of market competition o ACO payment incentives to the organization o How the RUC impacts economic efficiency · Financial analysis, including: o Capital requirements o Reimbursement model o Cost per patient visit o Pro forma, including: § Patient revenue § Operating expense § Income from operations § Total expense § Net cash flow Note: You must support your business plan with financial documents in an Excel spreadsheet. The 8- to 10-page paper requirement, submitted as a Word document, does not include the title, Excel spreadsheet, or reference pages. Your Assignment must be written in standard edited English. Be sure to support your work with specific citations from this module’s Learning Resources and additional scholarly sources as appropriate. Refer to the Essential Guide to APA Style for Walden Students to ensure that your in-text citations and reference list are correct. See the rubric for additional requirements related to research and scholarly writing.