A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next three years to plan for capital growth projects. For the first year, the hospital anticipates serving 1,300 patients, which is expected to grow by 8% per year. Based on current reimbursement formulas, each patient provides an average billing of $125,000, which will grow by 2% each year. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and are assumed to increase by 6% per year. Develop a spreadsheet model to predict the net present value of profit over the next three years. Use a discount rate of 4%. Complete the accompanving spreadsheet mode for the costs in Year 1 (Type whole numbers. D G H Collection % % Variable Cost % % Discount Rate Growth Rates Total Collected Amount Variable Patients Served Average Billing Fixed Costs Total Costs Total Profit Costs Collected Year 1 art (EBA Help me solve this View an example Get more help - Clear all Check answer

A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next three years to plan for capital growth projects. For the first year, the hospital anticipates serving 1,300 patients, which is expected to grow by 8% per year. Based on current reimbursement formulas, each patient provides an average billing of $125,000, which will grow by 2% each year. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and are assumed to increase by 6% per year. Develop a spreadsheet model to predict the net present value of profit over the next three years. Use a discount rate of 4%. Complete the accompanving spreadsheet mode for the costs in Year 1 (Type whole numbers. D G H Collection % % Variable Cost % % Discount Rate Growth Rates Total Collected Amount Variable Patients Served Average Billing Fixed Costs Total Costs Total Profit Costs Collected Year 1 art (EBA Help me solve this View an example Get more help - Clear all Check answer

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter19: Capital Investment

Section: Chapter Questions

Problem 2CE

See similar textbooks

Similar questions

A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next three years to plan for capital growth projects. For the first year, the hospital anticipates serving 1,300 patients, which is expected to grow by 9% per year. Based on current reimbursement formulas, each patient provides an average billing of $125,000, which will grow by 2% each year. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and are assumed to increase by 5% per year. Develop a spreadsheet model to predict the net present value of profit over the next three years. Use a discount rate of 4%. (Type whole numbers.) A 1 23456 7 Growth Rates Year 1 B Collection % Variable Cost% Discount Rate % Patients Served C % % % % Average Billing $ D Collected Amount E…
The hospital is considering the purchase of imaging equipment worth $25,000 to improve its visual capture results, and improve outcomes. The operating costs will be reduced by $7,000 per year. The computer has an estimated life expectancy of 5 years, and an estimated salvage value of $5,000. What is the profitability index if the discount rate is 8%. Ignore reimbursement considerations.
ABC Medical has invested RM2 million in a Health Diagnostic Support system. To maintain the system, the hospital has to pay the vendor RM10,000 monthly for monitoring and support activities. The system is projected to increase the hospital revenue by RM50,000 monthly. If the system is to be utilized by the hospital for 10 years, calculate the rate of return of the investment using ROI.
Consider a proposal to enhance the vision system used by a postal service to sort mail. The new system is estimated to cost $1.1 million and will incur an additiona $200,000 per year in maintenance costs. The system will produce annual savings of $500,000 each year (primarily by decreasing the percentage of misdirected mail and reducing the amount of mail that must be sorted manually). The MARR is 10% per year, and the study period is five years at which time the system will be technologically obsolete (worthless). The PW of this proposal is PW(10%) = −$1,100,000 + ($500,000 − $200,000)(P/A, 10%, 5) = $37,236. Determine how sensitive the decision to invest in the system is to the estimates of investment cost and annual savings.
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $16 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment outlay for the facility. Net cash inflows are expected to increase to $2.5 million in each of years 2 and 3; $2.5 million in year 4; and $3.0 million in each of years 5 through 10. The lease agreement for the facility will expire at the end of year 10, and MaxiCare expects the cost to close a facility will pretty much exhaust all cash proceeds from the disposal. Cost of capital for MaxiCare is estimated as 12%. Assume that all cash flows occur at year end. Required: 1. Compute…
A supermarket is planning on piloting a self-checkout system in one of its stores. It estimates that this requires an investment of about $50,000 to modify existing checkout lanes into self-checkout lanes. It also estimates that it will save $200,000 yearly in employee salaries by automating the checkout process. If the supermarket's MARR is at 10% per year compounded annually, determine the Conventional- payback period (in years) for this pilot.
A state department of health is considering a public awareness campaign to encourage vaccination. It determines that the cost of this campaign would be $740,000 per year for the next 6 years. It estimates that the campaign would reduce rates of illness and communicable disease. At the end of the first year of the campaign, the resulting savings would be $1,350,000; the savings would decrease by $120,000 each of the following 5 years. Assuming a discounting factor of 8%, compute the benefit cost ratio. Click here to access the TVM Factor Table calculator. Carry all interim calculations to 5 decimal places and then round your final answer to two decimal places. The tolerance is ±0.01.
An engineering firm estimates that its cost for employer sponsored health insurance will be $750,000 next year and increase at 11% per year for the next 5 years. The company CFO wants to budget a uniform amount each year to cover these costs. If the firm's rate of return is 6% per year, how much should be invested each year for employer sponsored health care? Express your answer in $ to the nearest $1,000.
ZipCar auto parts store has $88,000 to invest in a project to detect and reduce insier theft in their stores. They have considering investing in one of two alternatives, identified as Y and Z. Z is the higher first-cost alternative, and the incremental initial investment between the two is $22,000 and will exhibit a rate of return of 12% per year. Z requires an investment of $88,000. They expect a rate of return on the $88,000 investment of 49 percent. Answer the following questions; (a) what is the size of the investment required in Y?, and, (b) what is the rate of return on Y? The size of the investment required in Y is $ The rate of return on Y is %.
South Hampton University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 30,000 students are enrolled on campus. However, the university is forecasting a 5 per cent growth in student numbers in the coming year, despite an increase in fees to $3,000 per subject. The following additional information has been gathered from an examination of university records and conversations with university managers: • South Hampton is planning to award scholarships to 200 students, which will cover their fees. • The average class has 80 students, and the typical student takes 4 subjects per semester. South Hampton operates 2 semesters per year. • The average academic staff salary is $120,000 per annum including on-costs. • South Hampton's academic staff are evaluated on the basis of teaching, research, administration and professional/community service. Each of the academic staff teaches the equivalent…
Cambrian College has to choose between two investment alternatives. Alternative A (a new residence) will provide returns to the college of $30.000 after 2 years, $20,000 after 3 years and $10,000 after 4 years. Only $2000 per year is made in years five and six. Alternative B(a new gym) will bring returns of $11,000 per year for 6 years. If the college expects a return of 9% compounded annually on investments, what is the NPV of Alternative B? Select one: a. $27,034 b. $27,879 C. $50,271 d. $49,345
South Hampton University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 30,000 students are enrolled on campus. However, the university is forecasting a 5 per cent growth in student numbers in the comingyear, despite an increase in fees to $2,000 per subject. The following additional information has beengathered from an examination of university records and conversations with university managers:South Hampton is planning to award scholarships to 200 students, which will cover their fees. The average class has 80 students, and the typical student takes 4 subjects per semester. SouthHampton operates 2 semesters per year.The average academic staff salary is $220,000 per annum including on-costs. South Hampton’s academic staff are evaluated on the basis of teaching, research, administrationand professional/community service. Each of the academic staff teaches the equivalent of…