Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Corporate Financial Management Discounted Cash Flow Assignment Monro, Inc. (MNRO) provides automotive undercar repair, and tire sales and services in the United States. It offers

Corporate Financial Management Discounted Cash Flow Assignment Monro, Inc. (MNRO) provides automotive undercar repair, and tire sales and services in the United States. It offers range of state inspections services on passenger cars, light trucks, and vans; products and services for brakes; mufflers and exhaust systems; and steering, drive train, suspension, and wheel alignment. The company also provides maintenance services, including oil change, heating and cooling system flush and fill service, belt installation, fuel system service, and a transmission flush and fill service. In addition, it replaces and services batteries, starters, and alternators; and offers inspection and air conditioning services. The company operates its stores under the brand names of Monro Auto Service and Tire Centers, Tread Quarters Discount Tire Auto Service Centers, Mr. Tire Auto Service Centers, Tire Choice Auto Service Centers, and Car-X Tire & Auto. As of March 28, 2020, it operated 1,283 company-operated stores, 98 franchised locations, eight wholesale locations, and two dealer-operated stores in 32 states. Monro, Inc. was founded in 1957 and is headquartered in Rochester, New York. As of 11/01/2020, Monro had 33.3 million shares of common stock outstanding and a market capitalization (MVE) of $1,383.0 million. The firms stock has a beta of 1.08. You have been hired as a financial consultant to perform a discounted cash flow valuation of the company using a 2 stage, unlevered free cash flow approach. Please use the information provided on the following pages to complete your assignment. Your valuation date should be 11/01/2020. Summary of recent results and financial position: (in $millions)image text in transcribed As of 11/01/2020 Monro had total outstanding debt of $839.9 million and excess cash of $81.5 million. The interest rate on the firms debt (cost of debt) is 4.75%. Monro has no outstanding preferred stock or minority interest. Management guidance: Monros management team has given you the following estimates for the fiscal years ending 9/30, to use as the basis for your valuation.image text in transcribed Beyond 2025, the firm expects that it will achieve a stable long term cash flow growth rate of 3.0% in perpetuity. (Gordon growth rate) Market Information: The yield on the 10 year US Treasury note was 1.23% on 11/01/2020. The expected equity market risk premium is 5.25%. Assignment Instructions: Using an Excel spreadsheet please prepare a discounted unlevered free cash flow valuation of Monro as of 11/01/2020. Please be sure to estimate the companys: 1. Implied intrinsic enterprise value 2. Implied intrinsic total equity value, and, 3. Implied intrinsic share value Please make sure to highlight your answers in easily identifiable and highlighted cells. Please also be sure to show any work related to your determination of the discount rate used in your analysis as well as the projected cash flows used in your valuation.

For the 12 months ended 9/30. 2019 2020 Revenue Cost of Goods Sold Gross Profit SG&A Expenses Operating Income, EBIT 1,257.7 760.2 497.5 1,151.0 732.6 418.4 341.3 77.1 348.8 148.7 134.3 95.6 58.9 72.5 Capital Spending Depreciation Operating Capital Investment Net Investment 5.1 6.3 29.4 80.5 Tax Rate 22.1% 22.6% 2021E 2022E 2023E 2024E 2025E 3.0% 5.0% 8.0% 8.0% 8.0% 7.5% 8.0% 9.0% 9.0% 9.0% Revenue Growth EBIT Margin Capex % of Revenue Operating Capital Investment D&A % of Revenue 9.0% 9.0% 9.0% 9.0% 9.0% $5.0 $5.0 $5.0 $5.0 $5.0 7.0% 7.0% 7.0% 7.0% 7.0% Tax Rate 23.0% 23.0% 23.0% 23.0% 23.0% For the 12 months ended 9/30. 2019 2020 Revenue Cost of Goods Sold Gross Profit SG&A Expenses Operating Income, EBIT 1,257.7 760.2 497.5 1,151.0 732.6 418.4 341.3 77.1 348.8 148.7 134.3 95.6 58.9 72.5 Capital Spending Depreciation Operating Capital Investment Net Investment 5.1 6.3 29.4 80.5 Tax Rate 22.1% 22.6% 2021E 2022E 2023E 2024E 2025E 3.0% 5.0% 8.0% 8.0% 8.0% 7.5% 8.0% 9.0% 9.0% 9.0% Revenue Growth EBIT Margin Capex % of Revenue Operating Capital Investment D&A % of Revenue 9.0% 9.0% 9.0% 9.0% 9.0% $5.0 $5.0 $5.0 $5.0 $5.0 7.0% 7.0% 7.0% 7.0% 7.0% Tax Rate 23.0% 23.0% 23.0% 23.0% 23.0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Financial Models For Management And Planning

Authors: James R Morris, John P Daley

2nd Edition

1498765041, 9781498765046

More Books

Students also viewed these Finance questions

Question

understand the general outline and structure of the current book.

Answered: 1 week ago

Question

b. A workshop on stress management sponsored by the company

Answered: 1 week ago