Question: ***Please Explain how to get these answers without using excel**** Quad Enterprises is considering a new 3 year expansion project that requires an initial fixed

***Please Explain how to get these answers without using excel****

Quad Enterprises is considering a new 3 year expansion project that requires an initial fixed asset investment of $2.592 million. the fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $201,600. The project requires an initial investment in net working capital of $288,000. The project is estimated to generate $2,304,000 in annual sales, with costs of $921,600. The tax rate is 23 percent and the required return on the project is 10 percent.

1) What is the projects Year 0 net cash flow?

A. $ -2,880,000

2) What is the projects Year 1 net cash flow?

A. $1,263,168

3) What is the projects Year 2 net cash flow?

A. $1,263,168

4) What is the projects Year 3 net cash flow?

A. $1,706,400

5) What is the NPV?

A. $594,319

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Quad Enterprises is considering a new three-year expansion project t initial fixed asset investment of $2.32 million. The fixed asset will straight-line to zero over its three-year tax life, after...

Q:

can u please help me without using excel Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.33 million. The fixed asset falls...

Q:

Quad Enterprises is considering a new 3-year expansion project that requi fixed asset investment of $4.644 million. The fixed asset will be depreciated to zero over its 3-year tax life, after which...

Q:

Esfandairi Enterprises is considering a new three-year expansion project that initial fixed asset investment of $2.38 million. The fixed asset qualifies for 1 bonus depreciation in the first year....

Q:

Quad Enterprises is considering a new 3-year expansion project that requi fixed asset investment of $1.7 million. The fixed asset falls into the 3-year (MACRS Table) (TIP: make sure you refer to this...

Q:

Esfandairi Enterprises is considering a new three-year expansion project that rer initial fixed asset investment of $2.41 million. The fixed asset will be depreciated line to zero over its three-year...

Q:

Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated on a three-year MACRS schedule....

Q:

All answers must be entered as a formula in excel Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset...

Q:

please show formulas for excel Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated...

Q:

please show me the formula that i would need to use to input in Excel. Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9...

Q:

Campbell Soup Co. had the following assets and liabilities (in millions) at the end of 20Y1. Assets ...... $6,862 Liabilities ... 5,774 a. Determine the stockholders equity of Campbell Soup at the...

Q:

Te oxidation of glucose to CO2 and water is a major source of energy in aerobic organisms. It is a reaction favored mainly by a large negative en-thalpy change. a. At 37C, what is the value for Go?...

Q:

Prior to Ants IPO being pulled by Chinese regulators, did Ant make a good joint venture partner for Vanguard? What are the benefits of partnering with Ant, as opposed to (a) partnering with one of...

Q:

Describe the global and international strategic alternatives that should be evaluated in theglobal strategic management process.

Q:

Instead, assume that only 50 percent of the job candidates accept a job offer. Calculate the number of job offers necessary to maintain the required staffing level of 100 employees on an annual basis.

Q:

This chapter describes HRs changing role in business. Describe each component that is involved in HRM.

Q:

How might HR technology affect the various HR functions?