{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

IP-1 - PROBLEM 2-5 Given Initial Investment in software...

This preview shows pages 1–4. Sign up to view the full content.

PROBLEM 2-5 Given Solu Initial Investment in software \$(55,000) = Value given i Technician training cost \$(10,000) = Formula/Calc Hourly Rate 25 = Qualitative an Tax Rate 30% = Goal Seek or Discount Rate 9% = Crystal Ball I \$15,000 = Crystal Ball O 25% Total hours of installation per year 6,000 Solution Year Year 0 1 2 3 Rev \$37,500 \$37,500 \$37,500 Upgrade Expense (15,000) (15,000) (15,000) EBIT \$22,500 \$22,500 \$22,500 Less: Taxes (6,750) (6,750) (6,750) NOPAT \$15,750 \$15,750 \$15,750 Plus: DEP - - - Less: CAPEX (65,000) - - - Project Free Cash Flows (PFCF) \$(65,000) \$15,750 \$15,750 \$15,750 NPV \$(3,738) IRR 7% Payback Period 4.13 Additional Investment per year for software upgrades % Reduction in hours of technician time for installation

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
ution Legend in problem culation/Analysis required nalysis or Short answer required r Solver cell Input Output 4 5 \$37,500 \$37,500 (15,000) (15,000) \$22,500 \$22,500 (6,750) (6,750) \$15,750 \$15,750 - - - - \$15,750 \$15,750
PROBLEM 2-6 Given Investment (CAPEX in year 0) \$(600,000) = Value give Depreciable life 5 years = Formula/C Initial units for year 1 100,000 = Qualitative Revenue per unit 1.50 = Goal Seek Growth Rate per year in units rec 25% = Crystal Ba Tax Rate 30% = Crystal Ba Required Return 15% Solution Year 0 1 2 3 4 Units recycled 100,000 125,000 156,250 195,313 Revenues \$150,000 \$187,500 \$234,375 \$292,969 Depreciation Expense (120,000) (120,000)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

IP-1 - PROBLEM 2-5 Given Initial Investment in software...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online