Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Better Mousetrap's research laboratories have developed a new trap. The project requires an initial investment in plant and equipment of $ 6 million. This investment

Better Mousetrap's research laboratories have developed a new trap. The project requires an initial investment in plant and equipment of $6 million. This investment will be depreciated straight-line over four years to a value of zero, but when the project comes to an end at the end of four years, the equipment will, in fact, be sold for $500,000. The firm believes that working capital at each date must be maintained at 10% of next year's forecasted sales starting immediately. In other words, the investment in working capital in Year 0=2.5 Million x 10%=$250,000. This means that the CF from the change in working capital will be different for each year. Also, remember that the working capital is assumed to be recouped at the end of the project (working capital Year4=0). Production costs are estimated at 30% of revenues. There are no marketing expenses. Sales forecasts are given below. The firm pays tax at 21% and the required return on the project is 16%. What is the NPV?
Year 0 : sales =0 Million
Year 1: sales=2.5 Million
Year 2: sales=2.9 Million
Year 3: sales=4.0 Million
Year 4: sales=5.0 Million
$273,271
$264,382
$191,867
-$72,408
-$120,511\table[[,year 1,year 2,year 3,year 4],[Sales,2500000,2900000,4000000,5000000],[Costs,,,,],[Gross profit,,,,],[Depreciation,,,,],[Taxable income,,,,],[Tax,,,,],[Net income,,,,],[OCF,,,,]]
\table[[,year 0,year 1,year 2,year 3,year 4],[Working capital],[Change in working capital],[CF from changes in working capital],[,,,,,],[,,,,,],[,year 0,year 1,year 2,year 3,year 4],[CF from capital investment],[,,,,,],[,year 0,year 1,year 2,year 3,year 4],[OCF],[CF from changes in working capital],[CF from capital investment],[Total cash flow,,,,,]]
image text in transcribed

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Finance questions

Question

2 Should monetary policy be made by rule rather than by discretion?

Answered: 1 week ago

Question

=+informational reports, analytical reports, and proposals

Answered: 1 week ago

Question

=+3 Offer guidelines for becoming a valuable wiki contributor

Answered: 1 week ago