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

  Ratio analysis is an important tool in financial analysis

ratio analysis is an important tool in financial analysis. identify at least four ratios usinga. balance sheet data

  The bruckners want sufficient liquid assets to cover six

you have new clients erik and senta bruckner. they are in their mid-30s and have two children stella and chloe ages 6

  What is the price per share of nogrowth stock

NoGrowth Corporation currently pays a dividend of $0.43 per quarter, and it will continue to pay this dividend forever. what is the price per share of NoGrowth stock if the firms equity cost of capital is 14.8%?

  The sole owner of duarte spring company

1. You're the sole owner of Duarte Spring Company; you paid $200K for the business when you acquired the firm five years ago. Duarte is a manufacturer of high-end springs used by major aerospace and aircraft manufacturing companies. Six months ago, y..

  You bought one of great white shark repellant cos 9 percent

you bought one of great white shark repellant co.s 9 percent coupon bonds one year ago for 770. these bonds make annual

  What must be the dividend yield

Shares of common stock of the Samson Co. offer an expected total return of 21.2%. The dividend is increasing at a constant 5.8% per year. What must be the dividend yield?

  Purchase of the largest local commercial bank

You are the mayor of a community of 12,000 people. You are active in virtually all of the civic activities of the town and as such your opinion is solicited on political, economic, sociological, and other factors.

  How would you define efficient security markets

How would you define efficient security markets? The efficient market hypothesis is interpreted in a weak form, a semistrong form, and a strong form. How can we differentiate its various forms?

  Liberal accounts receivable policy

Assume all sales and purchases are on credit. Which one of the following statements is correct concerning the cash cycle? a. the cash cycle starts when inventory is purchased

  What is the market value per share after the dividen

Verbal Communications, Inc., has 14,000 shares of stock outstanding with a par value of $1 per share and a market value of $32 per share. The firm just announced a 100 percent stock dividend. What is the market value per share after the dividen

  Achievement of organizational goals

At Sandwich Blitz, Jenny noticed what appeared to be a discrepancy in the time sheet of one of consumer associates. When she asked unit manager about this, she learned that the crew supervisor had allowed the associate to swap out work hours against ..

  A qualified plan''s summary plan description (spd)

Determine the correct qualified plan's summary plan description (SPD).

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