Accounting problem need help

Apr 9th, 2015
RockCafe
Category:
Accounting
Price: $5 USD

Question description

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.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: University of Virginia
PREMIUM TUTOR

Studypool has helped 1,244,100 students

3 Reviews


Summary
Quality
Communication
On Time
Value
BlueOcean
Nov 16th, 2016
" Awesome! Exactly what I wanted. "
ashleyisgod
Oct 24th, 2016
" Top quality work from this guy! I'll be back! "
Molly_Moon
Oct 2nd, 2016
" AMAZING as always! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors