Reference no: EM13750987
The Board of Trustees has decided that we should attempt to expand our service offering. They want you to evaluate the information below and determine if this is a project we should move forward with. If your submission is not in Excel, you will earn a zero for this assignment.
The MRI Trailer costs $600,000 and has an expected life of 5 years with an estimated salvage value of $200,000 at that time. After some extensive research, the numbers we have come up with look like this:
15 tests per day for 250 days per year for each year of the projects life
Each procedure is expected to generate $80 in cash collections during the first year of use (Net revenue for year 1 is 15*250*80=$300,000)
Labor and Maintenance costs are expected to be $100,000 during the first year
Utilities will cost $10,000 in year one and there is an incremental overhead increase of $5,000 beginning in year one
Cost for expendable supplies is expected to be $5 per procedure
Costs and revenues are expected to increase at a 5% inflation rate
Our corporate cost of capital is 10%
In the Excel spreadsheet template:
estimate the project's net cash flow over the 5 year estimated life. I want you to use the properties (formulas) in Excel here.
determine the project's NPV and IRR (Use the excel formulas to determine this as well)
Is this a project we should move forward with? (Consider NPV and strategic value here)---This can be written in text into your excel sheet.
|
MRI Trailer Purchase
|
Year
|
|
|
0
|
1
|
2
|
3
|
4
|
5
|
|
|
|
|
|
|
|
|
|
Equipment Cost
|
|
|
|
|
|
|
|
Net Revenues
|
|
|
|
|
|
|
|
Less: Labor/Maintenance Costs
|
|
|
|
|
|
|
|
Utilities Costs
|
|
|
|
|
|
|
|
Supplies
|
|
|
|
|
|
|
|
Incremental Overhead
|
|
|
|
|
|
|
|
Operating Income
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Equipment Salvage Value
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Cash Flow
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Present Value (NPV)
|
|
|
|
|
|
|
|
Internal Rate of Return (IRR)
|
|
What about for project management
: What about for project management. I have to put together a project plan for something that takes at least 5 people and 120 hpurs to complete thatscIT related
|
|
Explain why capital flows cause imbalances
: Explain why capital flows cause imbalances in the current account - Explain why purchasing, power, parity (PPP) works better in the long run than in the short run.
|
|
Apple retail store participate more in budgeting
: Would a manager at an Apple retail store participate more in budgeting than a manager at the corporate office. Explain your position.
|
|
Replace the submit button
: Replace the submit button (type="submit")with a regular button (type="button"). Once the buttonis clicked, display the user inputs in an HTML table below the form, if validations are successful
|
|
Determine the projects npv and irr
: Estimate the project's net cash flow over the 5 year estimated life - Determine the project's NPV and IRR (Use the excel formulas to determine this as well)
|
|
What causes conflict in organizations
: What causes conflict in organizations? Many of the organizational behavior topics that have been addressed in the class thus far include the opportunity for conflict to emerge. For example, conflict is a consideration if we talk about decision making..
|
|
Do you think the atomic bomb should have been used
: What were the factors that led to Truman's decision to use the atomic bomb in the war against Japan? Do you think the atomic bomb should have been used? Why, or why not?
|
|
What are some of the reasons that people file bankruptcy
: What are some of the reasons that people file bankruptcy. How does bankruptcy affect interest rates on loans. Credit cards.
|
|
Examine the american-soviet rivalry
: Examine the American-Soviet rivalry. Compare and contrast the two rivals from one of the following perspectives: technological, military, sociological, religious, cultural, or governmental.
|