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

  Departmental budgeting and reallocation

Suppose the role of a university president and describe what your macro budgetary focus would be.

  Your company will generate 46500 in cash flow each year for

your company will generate 46500 in cash flow each year for the next twelve years from a new information database. the

  What would be the price if comparable debt yields 8 and

a 1000 bond has a coupon of 6 and matures after 10 years.a. what would be the bonds price if comparable debt yields 8

  What role does budgeting play in financial planning why

1. what role does budgeting play in financial planning?2. why should you prepare personal financial

  The amount of the dividends it pays out after financing

Dennis Corp has plans calling for a capital budget of $60 million. Its optimal capital structure is 60 percent equity and 40 percent debt. Its earnings before interest and taxes (EBIT) were $98 million for the year. The firm has $200 million in asset..

  Trader breakeven with a profit of zero

Explain what two values of the stock price in three months does the trader breakeven with a profit of zero?

  What are the portfolio weights for a portfolio that has

determining portfolio weights what are the portfolio weights for a portfolio that has 100 shares of stock a that sell

  Two main payment methods in acquisition offers

What are the two main payment methods in acquisition offers? -  How large is the typical acquirer relative to the typical target?

  What is the profitability index of the project

the accounting rate-of-return method, and (c) the payback period method. 3. What is the profitability index of the project? 4. What is the IRR of the project?

  Cranberry corp. has two divisions of equal size

Cranberry Corp. has two divisions of equal size: a computer manufacturing division and a data processing division. Its CFO believes that stand-alone data processor companies typically have a WACC of 8%, while stand-alone computer manufacturers typica..

  What is the market predicting about the movement of future

If a yield curve looks like the one below, what is the market predicting about the movement of future short-term interest rates? What might the yield curve indicate about the market's predictions about the inflation rate in thefuture?

  Youre considering a project with initial cash outlay of

you are considering a project with an initial cash outlay of 80000 and expected free cash flows of 20000 at the end of

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