Valuation Spreadsheet for Johnson and Johnson
Please submit the valuation Excel spreadsheet for Johnson and Johnson. The attached valuation spreadsheet (ValuationModels.xls) has yellow highlighted cells on two worksheets (FCFF Valuation and Earnings Growth Models) which need to be filled with the Johnson and Johnson data.
Attached is a sample valuation worksheet (ValuationModels.xls), document on how to compute the Weighted Average Cost of Capital (WACC.pdf) and the class textbook for reference (businessanalysis-valuation3rd-ed-62402.pdf).