Build a 10-year discounted cash flow model based on the provided data to analyze the opportunity (build the cash flow model in spreadsheet and label it as Question 1: 20 points)

The company wants to launch a new clothing product line by investing approximately $9 million into the product line with homes of selling millions of items over the next decade. It wants your team to evaluate whether this is a wise business decision or not based on a thorough 10-year projection discounted cash flow analysis. Here is what you need to do:

• Your group will be assigned what Business opportunity (clothing line) you are to analyze: Your group has to work on the assignment clothing line tab in the assignment 5 data file.

• Find the tab for your assigned business opportunity (clothing line) with the required data that you need in the file Assignmnet_5_data.xls.

• Build a 10-year discounted cash flow model based on the provided data to analyze the opportunity (build the cash flow model in spreadsheet and label it as Question 1: 20 points).

• Using the provided data calculate the WACC and use this as your discount rate (show your WACC calculations in spreadsheet and label it asQuestion 2: 10 points)

Last Completed Projects