Question: estion 3 Using relevant data provided about the Antibacterial Soap Project below, prepare a cash flow table, using the Excel formulas as explained in 6
estion Using relevant data provided about the Antibacterial Soap Project below, prepare a cash flow table, using the Excel formulas as explained in Asset replacement and calculate the NPV IRR, PVI, and discounted payback period. ABCLEAN Ltd is planning to invest in a new antibacterial soap AB project that requires equipment with a purchase price of $ The installation cost of $ for the soapproducing equipment would be paid by the supplier. The transportation cost for the equipment would be $ The machine will have an economic life of six years and would be depreciated at percent straight line for the tax purpose. The salvage value of the equipment is estimated to be $ at the end of the project life. Starting production with this machine requires an additional investment of $ in inventory and $ in accounts receivable. Whereas, there would be additional accounts payable of $ In order to analyse the effectiveness of the AB soap to kill germs, the management has spent $ for clinical tests. The tests revealed that the AB soap uses harmful chemicals triclosoan and triclorcarbon as the main ingredients and these can be linked to health hazards and environmental damage. Despite the adverse outcomes of the tests, the management has decided to go for production. Expected sales in the first year would be $ Sales are expected to grow at in each year until the th year. Costs have been estimated to be percent of sales revenue. In addition, there would be an annual fixed overhead cost of $ If the project is started, the regular annual net earnings of $ of the company from the same production facility would be stopped. This new project will increase the annual interest expense from $ to $ Whereas, due to the start of the project, annual sales of the company's body wash will increase by $ in the first year and that increased sales will further grow by percent in each year until the th year. The cost of sale for the body wash products is percent. The applicable corporate tax rate would be percent. The cost of capital is estimated to be either percent or percent. The management has targeted a discounted payback period of four years. What would be your decision about this project at and percent costs of capital? What would be your comment in recommending this project considering qualitative factors?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
