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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1
You are the financial manager of the firm LAB.inc which does research in the medical field, your company needs an estimate of a financing plan for a research project. The research project according to the evaluation of the experts will be spread over a period of 4 years. The annual funding required to conduct this research is $100,000 at the beginning of each year. The firm has set a term of 7 years to raise the necessary funds to finance this research, the nominal interest rate is 8% capitalized quarterly. 1. How much does the company need to save at the end of each month to fund this research in 7 years? 2. Draw the timeline for this financing plan by presenting all the relevant elements. If the firm wants to start financing the research project today t=0, by taking out a bank loan equal to the VA of all the financing needs of the research project (for the 4 years). 3. Calculate the amount of monthly payments that the firm must pay to repay this bank loan for a period of 5 years?
A state highway department is considering a bypass loop that is expected to save motorists $821,000 per year in gasoline and other automobile-related expenses. However, local businesses will experience revenue losses estimated to be $131,000 each year. The cost of the loop will be $8,900,000. Calculate the conventional B/C ratio using an interest rate of 7% per year and a 10-year project period.
1. A consulting firm is considering the purchase of a new computer system for their enterprise management needs. A vendor has quoted a purchase price of $240,000. The consulting firm plans to borrow one-fourth of the purchase price from a bank at 8% compounded annually. The loan is to be repaid in equal annual payments over a six year period. The remainder of the purchase price is available through other funding sources (e.g. not a loan or money that must be repaid). The time. computer system is expected to last eight years and has a salvage value of $8,000 at that During the 8-year period, the consultant firm also expects to pay a technician $25,000 per year to maintain the system but will also save an estimated $55,000 per year through increased efficiencies in operations. The consulting firm project manager has determined that a MARR of 12%/year should be used to evaluate this investment project. What is the external rate of return for the investment project? Should the new computer…
You need to prepare for three large, upcoming project expenditures which will begin 3 years from now. The first required cash flow will be $56,000, the next year will require $94,000, and then $132,000. If you begin setting aside funds from your current budget next month, how much do you need to save each month in order to have enough to cover all three cash flows the day the first cash flow comes due? Assume you can invest these funds at 8.4 percent APR, compounded monthly. Please demonstrate how to calculate using a financial calculator, when possible.
Goergen Corporation is considering a capital budgeting project that would require an initial investment of $700,000. The investment would generate annual cash inflows of $267,000 for the life of the project, which is 4 years. The company's discount rate is 10%. The net present value of the project is closest to: Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using the tables provided. Multiple Choice $368,000 $700,000 $846,123 $146,123
The general city population is set to benefit in travel-time savings from a municipal road project amounting to $80,000. The local government will incur an initial spending of $2,500,000 and an operating and maintenance cost of $30,000 per year. This new road will reduce accidents, representing medical savings of $135,000. Consider a 15- year period and an interest rate of 5%. What is the modified benefit-cost ratio of this project?
Please answer with a complete step
How do I solve this by hand and what is the equation?
Calculate the NPV based upon the following facts: Bob has just completed the development of a better face shield for health workers. The new product is expected to produce annual revenues of $230,000. Bob requires an investment in an advanced 3D Printer costing $30,000. The project has an expected life of 5 years. The 3D printer will have a $20,000 salvage value at the end of 5 years. Working capital is expected to increase by $80,000 which Bob will recover at the end of the products life cycle. Annual operating expenses are estimated at $200,000. The required rate of return is 4%.
Cohen Brothers Fixers R Us is a small company specializing in emergency home repairs. They are considering expanding into a domestic emergency consultation business. Doing so will involve investing $1 million in licensing, recruiting, training, advertising, and a phone call answering center. A staff of 20 licensed clinical social workers will be hired to perform emergency counseling. If the service is well-received (probability 60%) then cash flows will be $500,000 per year for 3 years. If the service is not well-received (probability 40%) then the cash flows will be $210,000 per year for 3 years. Calculate the expected NPV of the project. Cohen's discount rate is 10% -$40,953 -$45,049 -$49,554 -$54,509…
Terra Landscape is evaluating a capital budgeting project that is expected to generate $80, 100 per year during its eight-year life. If its required rate of return is 14 percent, what is the value of the project to Terra Landscape?