Please use Excel to respond to the 5 questions, below (inlcuding all bullet poin

Please use Excel to respond to the 5 questions, below (inlcuding all bullet points) for any references please use…..
Gapenski, L. (2016). Healthcare finance: An introduction to accounting and financial management (6th ed.). Health Administration Press. Chapters 5 and 14
Question 1
Assume a firm is considering the purchase of a new imagining machine. The details for the machine are as follows:
Cost: $2,500,000
Delivery: $61,000
Sales tax: 2.5%
Maintenance costs for the machine are fixed at $70,000 in year 1 and increase at a rate of 7% annually (these costs do not vary with output).
Operating labor: 2 staff members are needed ($106,000 per staff member) to operate the machine for every 2,000 scans provided per year.
The machine is expected to be usable for 7 years.
After 7 years, the machine has a scrap value of $16,000.
Each scan completed results in $34 in variable costs.
Question 2
Please calculate the annual depreciation amount for this machine.
Please calculate the total fixed costs, semifixed costs, and total variable costs for this firm for every 100 scans from 2,000 to 10,000 scans.
Please calculate the average fixed costs, average semifixed costs, average total variable costs, and average total costs for every 100 scans from 2,000 to 10,000 scans.
Please calculate the total revenue (P x Q) at price points of $106, $160, $205, $270, and $306.
Please calculate the total profits at each price point provided in question 1.3.
Please graph the organization’s AFC, ASFC, AVC, and ATC with each price point (for Q=2,000 to Q=10,000) and list a few conclusions from the illustration.
Please graph the organization’s total profits for each price point and total costs (for Q=2,000 to Q=10,000) and list a few conclusions from the illustration. Question 3
Using the information in question 1 (however, please assume the firm does not have any semifixed costs), complete the following:
Please mathematically calculate the break-even volume for the following prices:
$160
$205
$270
Please calculate the break-even price for the following volumes:
2,005
2,401
5,002
Please recalculate the break-even points in questions 2.1 and 2.2 with an economic profit of $205,000. Question 4
Using the information in question 1, as well as the information below, please complete a project cash flow analysis (7 years of revenue).
The nonprofit firm sells 7,200 scans in year one, and that volume sold increases by 3% annually.
Labor costs increase 7% annually.
The tax rate is 6.1%.
Supply cost is the same as the variable costs for the firm.
The payer information is as follows:
Payer Reimbursement Annual reimbursement increase % of scans sold % scans no-payment
Commercial $180 9% 40% 7%
Medicare $151 3% 25% 3%
Medicaid $106 -3% 30% 5%
Uninsured $421 17% 5% 34%
Question 5 part 1
Using the information from the project cash flow analysis, and assuming a cost of capital of 9%, please calculate the following and explain your answers in words
Payback period
NPV
IRR Question 5 part 2
**** Please compute the contribution margin for each price point provided in question 2.1.