What are the companys enterprise value

Assignment Help Financial Management

Reference no: EM131157490

Write solution of given Problems.

here is data for part A:
https://www.sec.gov/Archives/edgar/data/1011006/000119312516483790/d12894d10k.htm

PROBLEM 1

This exercise asks you to forecast Square (SQ) free cash flow and discuss risks the company is facing. You may use and modify if necessary the template below or you may create your own template.

a) download 2013-2015 historical financial data for the company, using one of the sources listed in Course Content (you may enter numbers in the template below or create your own). I recommend using 424B4 (prospectus) filing with the SEC

b) Based on historical financial data calculate ratios that to be used later in pro-forma financial statements (revenue growth, gross margin etc., see chapter 6 for details);

c) Using historical data from a) and ratios from b) create pro-forma statements (see chapter 6 for details);

d) Estimate free cash flows FCF for 2016-2019 (see chapters 2 and 6 for details);

e) What are risks the company is facing? Discuss, how its tornado diagram would look like (see chapter 3 for details). You don't have to build the diagram itself, unless you want to earn bonus points (5 points maximum);

PROBLEM 2

MacroHard considers selling a Virtual Reality device set HoloGlobe. The management anticipates that new system will have the first year revenues of $500,000 K with subsequent annual revenue growth of 20%. Operating costs are 70% of revenues.

The project requires $600 Mil investment in equipment, which will have a five year anticipated life and will be depreciated using five year MACRS depreciation method toward a zero book value (five year MACRS official depreciation rates are given below - it does require 6 years, this is not a typo!). However, the company will be able to sell the equipment on the after-market at the end of year 5 for 20% of its original cost. The company requires an 12% rate of return from its investment and faces a 35% tax rate (overall the company is profitable). In addition to capital investment, the project requires an outlay of net working capital equal to 20% of revenues in the coming year. I.e., at time 0 (beginning of year 1) net working capital requirement is $100,000 K and will grow in subsequent years. All NWC will be recovered after the project's end.

a) Calculate the NPV and IRR for the project. Should the company undertake the project? (see chapter 2 for details)

b) The marketing and operations department disagree with current projections for operating costs, first year revenues and revenue growth . Considering one factor at a time, at what level of operating costs, initial revenues, and revenues growth (decline) the project will break-even (NPV=0)? (see chapter 3 for details)

c) Looking at percentage difference between the predicted level and critical (break-even) level of each of the three factors, which of them is the most critical? (see chapter 3 for details)

PROBLEM 3

LDM Inc. has the balance sheet as shown below.

Recently the yield on bonds similar to the ones that company has had dropped to 4.25%, so that the market value of the bonds is now about $325 million

The rate on company' short-term notes is equal the market's rate on these notes, which is 2.95%.

a. What are the company's enterprise value and capital structure weights?

b. What is the company's cost of equity according to CAPM, if the U.S. T-bond yield is 2.70 %, the long-term market risk premium is 5.00% and the company's levered equity beta is 1.2?

c. What is the company's WACC?

Attachment:- Problem 1, 2 and 3.rar

Reference no: EM131157490

Questions Cloud

What can people do to break free from media hypnosis : In what ways are people manipulated by the media that they consume? Make sure to give specific examples. What types of consequences can follow from people having more choices of what media they can consume? Do we control our media or does it contr..

Determine the impact of the company mission and vision : Determine the impact of the company's mission, vision, and primary stakeholders on its overall success. Analyze the five (5) forces of competition to determine how they impact the company

Testing of the awbm using initial guess parameter : Testing of the AWBM using ‘initial guess' parameter values adopted from available publications - Calibration using AWBM Auto Calibration

Analyze views of nature expressed by ralph waldo emerson : Analyze the views of nature expressed by Ralph Waldo Emerson and Henry David Thoreau in this week's readings. Then compare and contrast them to one another. You might also want to apply these themes of nature to overall thought of the Transcenden..

What are the companys enterprise value : What are the company's enterprise value and capital structure weights? - What is the company's cost of equity according to CAPM.

Design an electromagnetic cannon : Two molecules interact in a complicated way that can be described by the potential energy (V) vs. separation (r) graph shown. They are placed 16 nm apart and released from rest.

Explain how your individual values drive your actions : Explain how your individual values drive your actions and behaviors, and analyze the alignment between your values and actions and behaviors

How did erp help improve business operations at shell : How did ERP help improve business operations at Shell? How could extended ERP components help improve business operations at Shell? How can integrating SCM, CRM, and ERP help improve business operations at Shell?

What are the strengths of formal strategic planning : What are the strengths of formal strategic planning? What are its weaknesses? From what perspective might innovation be called the single most important building block of competitive advantage? When is a company's competitive advantage most likely to..

User Account

All Pages