Hello, Please how do I find NPV AND IRR for this assignment ?

-----------------------------------------------------------------------------------------------------------------------

The company bought some land three years ago for $3.9 million in anticipation of using it as a toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead.The land was appraised last week for $4.4 million on an after-tax basis.In five years, the after-tax value of the land will be $4.8 million, but the company expects to keep the land for a future project. The company wants to build its new manufacturing plant on this land; the plant will cost $37 million to build.

At the end of the project (the end of year 5), the plant can be scrapped for $5.1 million.The manufacturing plant will be depreciated using the straight line method.

The company will incur $6,700,000 in annual fixed costs excluding depreciation.The plan is to manufacture 15,300 machines per year and sell them at $11,450 per machine; the variable production costs are $9,500 per machine. Selling price and costs are expected to remain unchanged over the life of the project.

BI uses PK Global (PKG) as its lead underwriter.PKG charges BI spreads of 8% on new common stock issues, 6% on new preferred stock issues, and 4% on new debt issues.PKG has included all direct and indirect issuance costs (along with its profit) in setting these spreads.BI's tax rate is 35 percent.The project requires $1,300,000 in initial net working capital investment to get operational .Assume BI raises all equity for new projects externally (that is, BI does not use retained earnings).

The weighted average flotation cost is the sum of the weight of each source of funds in the capital structure of the company times the flotation costs, so:

f_T = 0.0682, or 6.82%

initial investment is increased by the amount of flotation costs:

(Amount raised)(1 - 0.0682) = $37,000,000(initial investment)

Amount raised = $37,000,000/(1 - 0.0682) = $39,708,092 (new inv)