Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your company is considering taking on a 3-year project with the following details:The project will generate $900 in sales in year 1, but the sales

Your company is considering taking on a 3-year project with the following details:The project will generate $900 in sales in year 1, but the sales in subsequent years are uncertain. Although the sales growth rate is uncertain, it is assumed to be normally distributed with a mean of 3% and a standard deviation of 1.50%. Variable costs are assumed to be 20% percent of sales each year. Fixed costs will be $445 per year, while net working capital (NWC) is set at 10% of total sales each year (beginning in year 1). The project will require an initial investment in NWC of $75 at year 0. None of the investment in NWC will be recovered at end of the project. To operate the project, a new piece of equipment must be purchased at a cost of $575. The equipment will be depreciated to 0 using 3-year straight line depreciation. The equipment will have no salvage value at the end of the project. The tax rate is 25%. The cost of capital for the project is 9%. A. Set up a spreadsheet that calculates the NPV of the project while capturing the uncertainty in sales. B. Simulate the NPV 750 times using a data table. Find the average and standard deviation (using sample formula) of NPV.C. Graph the frequency distribution of the NPV using a bar/column chart. D. Calculate the probability that the NPV is positive. What is your recommendation regarding the project? Why?

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

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

978-0470317549, 9780470387085, 047031754X, 470387084, 978-0470533475

More Books

Students also viewed these Accounting questions