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

Related Homework Solutions

Finance Questions
Homework Solution
$48.00
Business
Finance
Accounting
Payback
Cash Flow
Projects
Companies
Exchange Rates
Investors
Expansions
Bonds
Maturity
Tax Rate
Mortgage
Payments
Stock Prices
Investments
Capital
Supply
Demand
Regulations
Portfolio
Debt
Equity
Functio
Finance Questions
Homework Solution
$33.00
Business
Finance
Hedging
Forward Hedge
Money
Market
Interest
Spot
Rate
Malaysian
Ringgit
Cost
MNC
Debt
Risk Free
Japan
Brazil
The Shuanghui Acquisition of Smithfield Foods (440 words)
Homework Solution
$40.00
Business
Financial Management
Economics
Administration
Growth Strategy
Shuanghui Acquisition
US government
Companies
Workers
Import Balance
Export Balance
China
United Food and Commercial Workers International Union
Finance Questions
Homework Solution
$43.00
Finance
Business
Accounting
Industry
Products
Prices
Costs
Tax
Percentage
Tables
Functions
Economy
Average Values
Purchases
Machines
Inventory
Market Conditions
Projects
Correlation
Assessment
Risk
Business Questions
Homework Solution
$25.00
Accounting
Business
Financial Management
Economics
Stock Market
Prices
Payments
Companies
Facebook
Twitter
Starbucks
Shareholders
Cash
Bonds
Dividends
Financial Firm Problem
Homework Solution
$18.00
Business
Finance
Firm
Trades
Swaps
Instruments
Contracts
Pricing
Structures
Interest Rates
Discussion
Cash Flow
Payments
Get help from a qualified tutor
Live Chats