Question
Help, I need step by step solution. Thanks A hospital is considering the purchase of an MRI machine which costs $1,500,000 and has an estimated
Help, I need step by step solution. Thanks
A hospital is considering the purchase of an MRI machine which costs $1,500,000 and has an estimated salvage value of $250,000. The estimated average charge per MRI is $175. The machine is expected to operate 25 times per day for 200 days per year for each year of the projects life, and each scan is expected to cost the hospital $50 in supplies.Labor and maintenance costs are expected to be $150,000 during the first year of operations. Utilities will cost another $15,000 and overhead will increase by $6,000 in year 1. All costs and revenues are expected to increase at a 5% inflation rate after the first year.The corporate cost of capital is 12%.Complete the following table with the data given above. IRR Must be done on excel
Year | |||||||
0 | 1 | 2 | 3 | 4 | 5 |
| |
Equipment Cost |
|
|
|
|
|
|
|
Net Revenues |
|
|
|
|
|
|
|
Fixed Operating Costs |
|
|
|
|
|
|
|
Variable Operating Costs |
|
|
|
|
|
|
|
Net Operating Income |
|
|
|
|
|
|
|
Equipment Salvage Value |
|
|
|
|
|
|
|
Net Cash Flow |
|
|
|
|
|
| |
Corporate Cost of Capital | 12% |
|
|
|
| ||
NPV |
|
|
| ||||
IRR (Optional) |
|
|
| ||||
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started