Using relevant data provided about the Chemical Fertilizer Project below, create a cash flow table, using the Excel formulas and calculate the NPV, IRR, PVI, and discounted payback period.

GROWMORE Ltd is planning to invest in a farm-grade chemical fertilizer project that requires equipment with a purchase price of $92,000. The installation cost for the equipment would be $21,000. The transportation cost of $7,000 for the fertilizer-producing equipment would be paid by the supplier.

Starting production with this equipment requires an additional investment of $29,000 in inventory and $14,000 in accounts receivable. Whereas, there would be additional accounts payable of $24,000.

The equipment will have an economic life of seven years and would be depreciated at 12 percent straight line for the tax purpose. The salvage value of the equipment is estimated to be $17,000 at the end of the project life.

In order to analyse the effectiveness of the fertilizer to boost production, the management has spent $13,000 on clinical tests. The tests revealed that the fertilizer would have some detrimental effects on the soil for multiple uses on any farmland. It requires further research for reducing the side effects of this fertilizer. Despite the adverse outcomes of the tests, the management has decided to go for the production. Expected sales in the first year would be $95,000. Sales are expected to grow at 17% in each year until the 7th year. Costs have been estimated to be 46 percent of sales revenue. In addition, there would be an annual fixed overhead cost of $6,524.

This new project will increase the annual interest expense from $8,000 to $9,800. If the project is started, annual sales of the company's insecticide products will increase by $25,000 in the first year and that increased sales will further grow by 13 percent in each year until the 7th year. The cost of sale for the insecticide products is 80 percent. Whereas, due to the start of the project, the company's regular net earnings of $8,000 from the same production facility would be discontinued.

The cost of capital is estimated to be either 10.99 percent or 14.85 percent. The management has targeted a discounted payback period of four years. Applicable corporate tax rate would be 34 percent.

What would be your decision about this project at 10.99 and 14.85 percent costs of capital?

What would be your comment in recommending this project considering qualitative factors as discussed in the recorded lectures of weeks 5 and 6?

(Create Excel table like this)

L3 fx 0.6 G H K L ($m) $15.00 $0.60 B D E F 1 ABC Company 2 Statement of Future Cash Flows for HOT ICECREAM Project ($M) 3 YO Y1 Y2 Y3 Y4 4 New PPE ($15.00) $0.60 5 Net WC ($0.60) $0.60 6 Incremental Revenue $14.00 $12.00 $10.00 $4.00 7 (-) Cost 50% of Rev ($7.00) ($6.00) ($5.00) ($2.00) 8 (-) Tax on NR at 30% ($2.10) ($1.80) ($1.50) ($0.60) 9 Depr tax shield on Inc Depr $0.87 $0.87 $0.87 $0.87 10 SV of Old PPE $1.40 11 Tax on Gain/Loss on SV of PPE ($0.30) $0.72 12 (-) Opportunity cost (lost rent) ($0.50) ($0.50) ($0.50) ($0.50) 13 Tax benefit for Opp. Cost $0.15 $0.15 $0.15 $0.15 14 TOTAL CASH FLOWS ($14.50) $5.42 $4.72 $4.02 $3.84+ 15 16 NET PRESENT VALUE (NPV) ($0.60) >0 Reject 17 Internal Rate Return(IRR) 9.90% >12% Reject 18 NPV at IRR $0.00 IRR verified 19 Benefit Cost Ratio (BCR) 0.96 >1 Reject 20 21 22 Basic Data: New PPE Net WC Incremental Revenue Y1 Y2 Y3 Y4 Cost (as % of Rev) Tax rate New PPE SV at Y4 Tax Depr pa Old PPE BV at now Tax Depr pa SV at now $14 $12 $10 $4 50% 30% $0.60 20% $0.40 $0.10 $1.40 Annual Depr for New PPE BV of New PPE after 4 years $3.00 $3.00 Loss of Rent for New PPE $0.50 RRR 12%