The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
In this tutorial you will practice constructing a spreadsheet-based break-even analysis.
This exercise requires that you calculate the profitability of implementing a new information system, specifically an electronic medical records system installed in a group of physician’s offices. Use Microsoft Excel and the following facts to conduct a break-even analysis to determine system costs, system benefits, net annual benefits, break even totals, net present value, and internal rate of return for the system. The following links explain NPV, http://www.investopedia.com/terms/n/npv.asp, and IRR, http://www.investopedia.com/terms/i/irr.asp.
Costs
· The physician’s group consists of 10 offices and the plan is to install the system in 2 offices in 2018, 3 offices in 2019, and the remaining offices in 2020.
· There is a one-time installation cost of $95,000 per office in the year of installation.
· The annual operating costs will be $22,000 for each office with a system installed.
Benefits
· Each office has 2 physicians
· The system will improve efficiencies in assessing and treating patients so that each physician will be able to see one more patient each day.
· Each additional patient will increase revenue by an average of $136.
· Each physician sees patients 220 days per year.
Calculations
The break-even analysis will cover a 4 year period from 2018-2021. For each year:
· Calculate the system costs and benefits.
· Calculate the net benefits of the system and the break-even totals for the system. Break even totals are simply the accumulated net benefits. The project breaks even when the accumulated net benefits value is positive.
For the total time period:
· Calculate the net present value (NPV) of the investment using a rate of 10%.
· Calculate the internal rate of return (IRR).
Answer the four questions at the bottom of the spreadsheet.
Deliverables
· Use the provided spreadsheet template to construct and compute the specified calculations.
· Use formulas in cells for the calculations. Do not just use a calculator and enter output values.
· Use a list of variables that can be changed to see their effects on the calculated totals. This will require the use of absolute cell referencing.
· Use conditional formatting for the net annual benefits, break-even calculations, and NPV so that positive numbers are highlighted in green and negative numbers are highlighted in red.
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more