Question

DCF analysis - Comparing two machines (possibly replacing one):

Machine 1:

3 years old
original cost 800,000 (3 years ago)
Straight line depreciation
15 year life
zero salvage value

Machine 2:

cost 900,000
pre-tax labor savings of 100K per year
save $2000 in space per year
Can cell Machine 1 at $400,000 immediately
12 year life
Straight line depreciation


10% discount rate
35% tax rate

Please show excel spreadsheet work.

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

DCF Analysis

This is only a preview of the solution. Please use the purchase button to see the entire solution

$10.00

or free if you
register a new account!

Related Homework Solutions

Get help from a qualified tutor
Live Chats