Case study link: https://store.hbr.org/product/hansson-private-label-inc-evaluating-an-investment-in-expansion/4021
A manufacturer of private-label personal care products must decide whether to fund an unprecedented expansion of manufacturing capacity. The decision prompts fundamental financial analysis of the potential project, including development of cash flow projections and net present value calculations. Students will be required to compute net operating profit after tax, cash investment in working capital, and ongoing capital expenditures for a proposed investment, and to discount values to the present. The case also facilitates a systematic consideration of the company's capital planning process.
Six Hats did a comprehensive analysis of the case study and created the solution along with the excel workbook that has all the necessary calculations. Please find the link to the solution below: