Calculate the EnV EBITDA value for the unknown company

Assignment Help Financial Management

Reference no: EM131801721

FINANCE FINAL Exam

The exam involves an unknown company. The Excel workbook shows the five-year financial history.

State everything you can about this unknown firm and WHY you believe that is the case (financial-data/analysis supported evidence, please).

Part I: Unknown Firm-related questions:

1. What type of firm do you think this is? (What kind of business are they in?)

What is your basis for that conclusion?

Use common sized values from the IS/BS and operating performance measures to guide your discussion.

2. Management and Investment:

How well do you believe the firm has been financially managed?

What is the factual basis of your conclusion?

In addition to the prior valuation discussion, use profitability indicators, operating performance measures and solvency leverage indicators as the basis for your answer.

3. Two-years forecasts for:

Income Statement:

Revenue
COGS
SG&A
EBITDA

Balance Sheet:

Gross PP&E
Working Capital

Make sure your assumptions are well-documented and supported.

ADDED for FINAL EXAM

4. Calculate the EnV: EBITDA value for the unknown company using the data provided for the period ending August 2017. What does the value mean? Do you think this value is it reasonable given your answer to question #1. Why or Why not?

Part II: Project Financial Analysis (Tornado Diagram Interpretation):

Your boss has asked you provide an analysis and recommendation for a proposed manufacturing plant expansion project. The project is highly classified within the company (information distributed on a "need to know" basis only) and has been code-named "Big Dog." Your subordinate has done lots of calculations and presented you with the Tornado Diagram (see next page). Your boss would like to know:

1. Would you recommend going forward with this project, given the base-case assumptions. Why?

2. What are the key risks of this project? How significant are these risks to the project's future success? How did you reach these conclusions?

3. What more/better information should you and your boss try to obtain before giving the "green light" to this project? Explain.

Attachment:- Assignment Files.rar

Reference no: EM131801721

Questions Cloud

Summarize the case gomillion vs lightfoot : Summarize the case Gomillion v. Lightfoot. Be sure to concisely analyze the major issues in the case, briefly list the main arguments of the majority opinions.

Identify the company mission and vision : Please visit the General Mills site, and identify the company's mission and vision, as well as their major stakeholders

About the cost of computer chips : On April 1, 2000, Betty Buyer calls Marco Manager, the sales director at Silicone Chips, Inc., to ask about the cost of computer chips

Find the optional stocking level for quantity : Sweet cider is delivered weekly to Cindy's cider bar. Demand varies uniformly between 100 liters and 200 liters per week. Cindy pays 30 cents per liter.

Calculate the EnV EBITDA value for the unknown company : FIN 522 FINAL Exam. Calculate the EnV: EBITDA value for the unknown company using the data provided for the period ending August 2017

Calculate the depreciation expense for the third year : calculate the depreciation expense for the third year of the equipments life

Describe the evolution of the global supply chain : Describe the evolution of the Global Supply Chain and the Obstacles to Global Supply Chain Management.

Sample project change control process : Research the web and locate a sample project change control process. Share the web link and discuss the most significant aspects of the process.

What is way an it department can meet users technology needs : What is the best way an IT department can meet users technology needs without an additional cost or risk to the organization.

Reviews

len1801721

1/8/2018 12:47:29 AM

This exam is an INDIVIDUAL effort. Each person is expected to turn in their own report. That report will consist of both a word document and supporting calculations (excel document). The exam will be graded on the financial-support of your arguments – do NOT take this opportunity to ramble on with a great deal of “business babble.” I am looking for conclusions you can make based on financial analysis of the information provided. Focus on the course mantra: Determine what question you are trying to answer. Determine what to Measure (and how). Do the Calculation and Explain the result in ENGLISH.

len1801721

1/8/2018 12:47:23 AM

EXAM SCORING - REPORT: 50 points - Is it readable as a stand-alone document (supported by the excel calculations)? Are the calculation approaches explained in English? Are the underlying assumptions explained in English? Are there a clearly written financial fact-based CONCLUSIONS? Any sensitivity assessment? Excel Documentation: 50 points - Clearly note how values are calculated? Is it clear what is assumed? How pro forma values calculated? Clearly noted assumptions? Calculations appropriate and accurate? Any sensitivity assessment?

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages