Group project Business Finance – FINA 3313 Assignment #5 Instructions: The fifth assignment is a detailed capital budgeting analysis of a

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Homework  JWI 515: Managerial Economics Academic Submissions and Evaluation © Strayer University. All Rights Reserved. This document contains

Homework  JWI 515: Managerial Economics Academic Submissions and Evaluation © Strayer University. All Rights Reserved. This document contains Strayer University confidential and proprietary information and may not be copied, further distributed, or otherwise disclosed, in whole or in part, without the expressed written permission of Strayer University. JWI 515 –