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

Scenario Imagine that you are the vice president of operations

 Scenario Imagine that you are the vice president of operations at a production or service organization. You have noticed that your organization’s current operations strategy is not supporting the challenges the organization is presently facing. In order to maintain a competitive edge, you must address these challenges with your chief

As we read in Chapters 6 &7, mergers & acquisitions

As we read in Chapters 6 &7, mergers & acquisitions are a major form of corporate diversification strategy. Using the lecture slides on Chapter 7, identify and discuss the top three reasons why most (50-60%) of acquisitions fail to create shareholder value. What are the five major components of “CEMEX

The SALES Essentials section was designed to introduce you to

The SALES Essentials section was designed to introduce you to the concept of selling. To share information about the relationship between marketing and sales and to give you some insight into what’s involved in a sales career. But the most important learning is to provide opportunities for you to practice

Safety – This week you learned about safety and legal

  Safety – This week you learned about safety and legal liability.  Two VERY important concepts to keep you from getting sued and from students getting hurt/seriously injured. You also looked at cooperative skills. Use what you learned this week to complete the following questions. Copy and paste into a

Critical Incident: It’s Not Fair! Giving More and Getting Less!

  Critical Incident: It’s Not Fair! Giving More and Getting Less! Elaine Pierce had worked for the city of Metropolis in the water and sewer department for over two decades. She began working at age 17 when she was a junior in high school but she never graduated. Her 20-some years

COLLAPSE Regarding reward, what is the difference between wanting and

 COLLAPSE Regarding reward, what is the difference between wanting and liking? Describe the brain regions involved with  Complete the following readings from your textbook: Freberg, L. (2019). Discovering Behavioral Neuroscience: An Introduction to Biological Psychology (4th ed.). Boston, MA: Cengage Learning, Inc. Chapter 9: Homeostasis, Motivation, and Rewind Chapter 11: Sleep and

Consolidate the work that has been completed in the steps

Consolidate the work that has been completed in the steps along with some additional elements (scope, executive summary, etc.) to create a comprehensive migration plan that aligns to Cloud Migration Plan Template. The final document should be between eight and 10 pages. Make sure to incorporate the screenshots in your

Prompt: This discussion is an opportunity for you to share

  Prompt: This discussion is an opportunity for you to share and discuss your experience of learning about harm reduction and its use with substance use disorders. Please share the following: What harm reduction program did you learn about? What services do they offer the community? What was it like

In 500 words using APA format (remember not to exceed

In 500 words using APA format (remember not to exceed the threshold of 15% similarity score in turinitin) explain the following: Choose 1 of the companies mention in the following website : Apple https://worldsmostethicalcompanies.com/honorees/apple/ In your paper describe why/how they became one of the worlds most ethical companies. Provide supporting

Citation- PLEASE USE APA Topic- how does stress affect Polycystic

Citation-  PLEASE USE APA Topic- how does stress affect Polycystic ovary syndrome Aim: The aim is to review a substantial body of literature on a biobehavioral health topic and present a synthesis of current knowledge on the subject.   Special Considerations: The Narrative Review should not be formatted following the

Explain Variable overhead efficiency variance and how it can be

Explain Variable overhead efficiency variance and how it can be favorable and unfavorable.   For the research paper, choose one topic that is of interest to you. After choosing the topic, you will conduct outside research in order to complete the following in your research paper: Introduction of your topic

Attached Files: Analytic Summary.pptx (359.25 KB) Theory and Methods Basics.pptx

Attached Files: YOU ARE NOT CREATING A MODEL – YOU ARE COMMUNICATING HOW YOU WOULD TACKLE A PROBLEM USING THE ANALYTICS STEPS LISTED IN THE “FINAL PROJECT” DOCUMENT. THIS IS THEORY-BASED.1. Watch the video: https://365datascience.com/career-advice/expert-interviews/data-use-cases-sports-analytics/2. Watch the video to write a case study/report: https://www.youtube.com/watch?v=beGwPSAwD4o&t=2s3. Choose a case study either from

Objective of Managing International Human Resources course: · Analyze the

Objective of Managing International Human Resources course: · Analyze the major differences between the global human resources function and the domestic human resources function in various world regions, and the impact this has on the global business manager. · Organize Human Resources strategies that must be developed to support international

Assignment Content Change management is key to ensuring that an

Change management is key to ensuring that an organization remains adept in providing state-of-the-art health care. As the world changes and communities evolve, patient and personnel needs require fresh and effective ways to meet them. Operating as a reactionary wears heavily on organizations and leaders. Planning for innovation and its

The purpose of the project is to give your team

The purpose of the project is to give your team an opportunity to apply what has been learned about organizational behavior (through course lectures, readings, research, and discussions) and expand research skills to analyze the problems of an organization. Since organizational work involves working and communicating with others, you are

Q1. Excel is probably the most popular spreadsheet software for

Q1. Excel is probably the most popular spreadsheet software for PCs. Why? What can we do with this package that makes it so attractive for modeling efforts? Q2. What are the common business problems addressed by Big Data analytics?  In the era of Big Data, are we about to witness

The Difference between Developing radiopharmaceutical drugs and

Description please write a structured research paper for ” The Difference between Developing radiopharmaceutical drugs and pharmaceutical product in regulation perspective process in United States and Europe” the research paper must include – Introduction – Method: how did you gather your information? – Result: please Make at least one table