Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show steps in excel for practice Bourque Enterprises is considering a new project. The project will generate sales of $1.9 million, $2.5 million, $2.4

image text in transcribed

Please show steps in excel for practice

Bourque Enterprises is considering a new project. The project will generate sales of $1.9 million, $2.5 million, $2.4 million, and $1.9 million over the next four years, respectively. The fixed assets required for the project will cost $2.6 million and will be eligible for 100 percent bonus depreciation. At the end of the project, the fixed assets can be sold for $165,000. Variable costs will be 30 percent of sales and fixed costs will be $525,000 per year. The project will require NWC equal to 20 percent of sales that must be accumulated in the year prior to sales. The required return on the project is 11 and the tax rate is 22 percent. What is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV

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

Finance Operations

Authors: Charles Finley

1st Edition

1491292423, 978-1491292426

More Books

Students also viewed these Finance questions