Group project

Business Finance – FINA 3313

Assignment #5

Instructions: The fifth assignment is a detailed capital budgeting analysis of a clothing company

opportunity. 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:

• Form your groups (keep the same group you worked with previously unless you get approval to

change groups)

• Your group will be assigned what Business opportunity (clothing line) you are to analyze.

• 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.

• Using the provided data calculate the WACC and use this as your discount rate.

• Build a base case based on the provided data, analyze the results.

• Build an optimistic case based on the provided data, analyze the results.

• Build a pessimistic case based on the provided data, analyze the results.

• Run sensitivity analysis on the key variables to this business, analyze the results.

• Run a break-even analysis on the key variables and analyze the results.

• Determine NPV, IRR, PI, Payback Period for each case analyze the results.

• Build a PowerPoint presentation detailing your analysis and findings 6-10 slides should cover it

well. Make sure to evaluate each case, the sensitivity analysis, break even analysis and results

of opportunity on an NPV, IRR, PI, PP perspectives to determine if this is a good opportunity or

not.

• In your PowerPoint presentation include an oral presentation to corresponds to your slides and

your analysis. Each group member should be presenting a portion of the analysis. Talk about

what you did, how did you perform your analysis, what did you find out and what do you think

about the opportunity. The presentation should be about 15 minutes in total.

I look forward to reviewing your analysis and hearing your presentations.

Weighting: Assignment #5 represents 7% of your final grade

Delivery: Post your completed PowerPoint presentation and excel model in canvas

Due Date: Assignments are due in Canvas by end of day May 1