Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all work on excel A company is considering a new 4-year expansion project that requires an investment of $200,000 for new equipment, plus

Please show all work on excel

A company is considering a new 4-year expansion project that requires an investment of $200,000 for new equipment, plus an extra $10,000 for shipping and $30,000 for installation. The fixed assets will be depreciated straight line to zero over 4 years, after which, it will have a salvage value of $96,000. The project requires an initial investment of $30,000 in NOWC, 80% of which will be recovered at the end of the project. Expected annual unit sales are 1,250 with sale price and cost per unit of $200 and $100, respectively. The tax rate is 40% and the required return (i.e. the WACC) is 10%. The project data are summarized below.

Baseline:
WACC 10%
Tax Rate 40%
Equipment Cost $200,000
Shipping $10,000
Installation $30,000
Salvage Value $96,000
Project Life (Years) 4
NOWC Investment $30,000
NOWC Recovery Rate 80%
Units Sold / Year 1250
Unit Price $200
Cost per Unit $100
  1. What will be the initial cash flow for the project (FCF0)?
  2. Compute the projects OCF.
  3. Determine the after-tax salvage value of the equipment.
  4. Find the projects net present value and indicate whether or not the project should be accepted based on NPV.
  5. Determine the sensitivity of NPV to the cost per unit, i.e. NPV / Cost per Unit.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: E. Thomas Garman, Raymond Forgue

9th Edition

0618938737, 978-0618938735

More Books

Students also viewed these Finance questions

Question

What does count_if() do?

Answered: 1 week ago

Question

What are your current research studies?

Answered: 1 week ago