Compute gross margin ebit margin and ebitda margin

Assignment Help Finance Basics
Reference no: EM131303235

Corporate Financial Management Midterm Exam

QUESTION 1: Utilizing the financial statements for Major Media Company (included in your Midterm Exam Excel file), perform the following computations.

a. Compute the Company's EBIT and EBITDA for each year presented.

b. Compute Gross margin, EBIT margin, and EBITDA margin for each year presented.

c. Analyze Revenue, EBIT, and EBITDA growth. Compute both year-over-year growth and the compound annual growth rate (CAGR) for the period presented.

d. Compute the following ratios. Assume a 365 day year and use end-of-year asset and liability balances.

a. Current ratio

b. EBIT Coverage ratio

c. Long Term Debt ratio

d. Asset Turnover ratio

e. Days Receivable Outstanding

e. Decompose the company's Fiscal Year 2006 Return on Equity (RoE) using a Dupont Analysis. Label each component.

f. Pick what you believe are two important elements of the company's financial profile and briefly (1-4 sentences) explain what they may mean for the company's future performance.

QUESTION 2: D. Lisch Gluten, a cookie manufacturer, is stable, low-growth, company with the following characteristics:

  • RWG had sales of $3 million in the most recent year.
  • Cost of goods sold was $1.75 million, of which $1 million was materials.
  • RWG pays its suppliers 30 days after receiving the invoice and it pays its labor force at the end of each month.
  • The company sells to grocery stores and receives payment 60 days after it invoices its customers.
  • RWG typically keeps 15 days of sales in inventory.
  • The company's Selling, General, & Administrative expenses totaled $600,000 in the past year.
  • Sales and costs occurred at a constant rate throughout the year.
  • Assume a 360 day year in your computations.
  • The company's tax rate is 40%. It made estimated tax payments of $65,000 in April, July, September, and December.

a. Using the data above, compute the company's year-end Accounts Payable, Accounts Receivable, and Inventory balances. Please show your work for partial credit.

b. What is the length of the company's operating cycle? Please show your work for partial credit.

c. What is the length of the company's cash cycle? Please show your work for partial credit.

d. Prepare a cash budget for December using the direct method. Assume the company began the month with $100,000 in cash. How much cash did it end the month with? Ignore interest income and interest expense.

QUESTION 3: You work for a major robotics company and are evaluating the launch of a new product, tentatively named STUDENTfriend. STUDENTfriend is a robot with highly sensitive chemical receptors that allow it to sense the stress and anxiety levels in humans. When stress is elevated, the robot is programmed to approach its human owner, pat it on the back, and whisper encouraging words like, "Don't worry" and "No one will care about your grade on your finance midterm after you graduate." The project specifics are as follows:

  • The company has already spent $20 million developing the robot. An additional $15 million would be required to commercialize the current prototype, all of which will be borrowed. Assume that the investment is made today.
  • The company plans to use an unused building it owns to produce the product. The market value of the building and land if sold today is $3 million. The building is fully depreciated from a book value standpoint.
  • Machinery to produce the robot will cost $10 million and will be depreciated over 5 years using a straight line method.
  • The project is expected to last 5 years, until advancing technology renders the robot obsolete.
  • Revenue is expected to be $15 million in year 1 and $20 million in year 2, before declining by 10% in each of the three subsequent years.
  • Production costs are anticipated to be 40% of revenue.
  • Selling, general and administrative costs are estimated at $2 million in year 1, $3 million in year 2, and $1 million thereafter.
  • Working capital is anticipated to be 10% of sales, half of which will be returned at the end of the project and half of which will be written off.
  • Loving robots are made with toxic materials. Environmental cleanup, net of the sale value of the land and building, is anticipated to cost $400,000 at the end of the project.
  • The company's marginal tax rate is 35%.

a. Given the proposed set of facts and the figures above, compute the project's debt free (unlevered) cash flows.

b. The company's after-tax cost of debt is 4% and its cost of equity is 15%. The company's current weighted average cost of capital is 11%. If the project is accepted, the company's weighted average cost of capital will be 10%. What is the appropriate discount rate to use for evaluating the project?

c. Perform an NPV analysis utilizing the discount rate you have selected. Include all relevant cash flows. Utilize the mid-year convention to discount all future cash flows.

d. Compute the internal rate of return of the project.

e. Should the company accept undertake this project? Why or why not?

QUESTION 4: You are working with the CFO of your company on a report that will be used to set financial policy for your company. As your company has several new board members without finance experience, you have to start with basic concepts before you move into analysis and recommendations.

a. In one or two sentences, explain what is meant by the term "optimal capital structure"?

b. What is meant by the term financial flexibility?

c. In one or two sentences, describe one possible advantage of financial flexibility.

d. In one or two sentences describe a possible disadvantage of financial flexibility.

e. You are analyzing another company (the "peer company") in the same industry as yours. Your company had EBIT margins ranging from 9-11% in the last five years. The peer company had EBIT margins ranging from 5-15% over the same time period, and a debtto-enterprise value of 30%. Based solely on this information, would you recommend your company have more, less, or the same amount of debt? Why (1-4 sentences)?

f. Your company is trying to decide between issuing $100 million in 5 year bonds or $100 million in 10 year bonds. In 1-4 sentences, describe the factors you would consider in developing a maturity recommendation.


Attachment:- Assignment.rar

Reference no: EM131303235

Questions Cloud

What does a hedge funds trades moving against it mean : What does a hedge fund's trades "moving against it" mean?- Why would a fund's trade moving against it cause it to burn through its capital?
Discuss about the u.s. army training : Discuss about the U.S. Army Training.A hazardous situation that I have experienced with the U.S. Army was the use of live ammunition during a training exercise. This is a high-risk activity due to the fact that there is a large volume of people usi..
What does greenspan mean by debt leverage : What does Greenspan mean by "debt leverage"?- Why would it matter if "the maturity of the debt is less than the maturity of the assets it funds"?
Analyze the evidence that each author uses to support thesis : Analyze the evidence that each author uses to support his/her thesis: What types of evidence are used? Does the evidence support his or her thesis?
Compute gross margin ebit margin and ebitda margin : Utilizing the financial statements for Major Media Company (included in your Midterm Exam Excel file), perform the following computations. Compute the Company's EBIT and EBITDA for each year presented. Compute Gross margin, EBIT margin, and EBITDA m..
Why did the fed participate in the bailout of ltcm : What does Lowenstein mean by "individual responsibility"? Connect the idea of individual responsibility to the concept of moral hazard.
The purchase of bear stearns so controversial : Why did Treasury Secretary Paulson want Bear Stearns to sell for such a low price?- Why was the decision by the Fed to orchestrate the purchase of Bear Stearns so controversial?
Compute the design-effective capacity utilization measures : A manufacturer of printed circuit boards has a design capacity of 1000 boards per day. The effective capacity, however, is 700 boards per day. Recently, the production facility has been producing 950 boards per day. Compute the design and effectiv..
What was the change in the unemployment rate : What was the change in the unemployment rate from its low in 2005 to its peak in 2009? How does this compare with Reinhart and Rogoff's average data from post-World War II recessions?

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the expected end of period price

What is the weighted average cost of capital of this company if the debt/equity ratio is 0.25 and the debt is considered to be risk-free? What is the expected end of period price?

  Values and statement of cash flows

What is the present value of investment in equipment if it is expected to provide annual savings of $10,000 for 10 years and to have resale value of $25,000 at the end of that period.

  Knowledge of accounting principles and methods

1. Why does a financial professional working outside accounting need a knowledge of accounting principles and methods? 2. Discuss the purpose of an accounting system and financial statements in terms of the way the system represents the busines..

  What is the expected return on ernst electric stock

The stock of Ernst Electric has a beta of 1.27. The market risk premium is 8.6 percent and the risk-free rate is 3.7 percent. What is the expected return on Ernst Electric stock?

  Computation the investment for each year

Computation the investment for each year and wants to invest equally amounts at the end of each year for the next 6 years to accumulate

  Discuss the efficient markets hypothesis

Discuss the efficient markets hypothesis and its significance for the theory of finance. Explain why market efficiency leads a manager to focus on NPV and free cash flow.

  Interfaces amongst human resources

"Businesses in Singapore are often portrayed as adopting a "unitarist" rather than a "pluralist" attitude to employment relations. Is this justified or are times changing? Illustrate your arguments with contemporary examples.

  Compound interest-future value of an annuity

An investor deposits $50,000 today in the interest bearing account. How much would the investor accumulate by the end of five years if interest is compounded monthly?

  Calculate a table of interest rates

Calculate a table of interest rates for 5 years based on the following information:

  Describe the difference between secured and unsecured

working capital is money to be used for daily operations and any debt that a company may have.nbsp who should be making

  Compute the market value of the bonds

Compute the market value of the bonds. What will the net price be if flotation costs are 11 percent of the market price? How many bonds will the firm have to issue to receive the needed funds?

  Explain what is the expected dividend yield

Explain what is the current value or price of CompU's stock and explain what is the expected dividend yield

Free Assignment Quote

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd