Order Assignments Now Get Upto 50% Off Get UPTO 50% OFF on Your 1st Assignment. Redeem Code: NEWCUST22 Order Now
Search
Listening..

Business Valuation Assignment Sample

University: Kensington College of business London

  • Unit No: 10
  • Level: Undergraduate/College
  • Pages: 11 / Words 2699
  • Paper Type: Assignment
  • Course Code:
  • Downloads: 288

Trading Comparable

Company name

Share price

Eps

P/E

Tesco

256.7

14.7

17.46

Morrisons

252

13

19.38

Average

254.35

13.85

18.42

Valuation

Target company EPS

12.7

Average competitors P/E

20.71

Implied share price

276.57

Current share price

321

Upside from current share price

66.65

Company name

Share price

Eps

P/E

Sainsburry

321

12.7

25.29

Transaction comparable

Target Company name

Transaction date

Transaction value

EBITDA (million)

TV / EBITDA

Tesco

02/05/18

20239

270

74.9592592593

Morrisons

23/04/18

215331.144

806

267.1602282878

Target Company name

Transaction value

EBITDA (million)

TV / EBITDA

Target company sainsburry

160347523

121

1325186.14049587

Discounted cash flow model

Tax Rate

35.0%

Net Debt

$83.4

Shares

35.021

Unlevered Free Cash Flow Calculation

Calendar Year Ending December 31,

CAGR

2007A

2008P

2009P

2010E

2011E

2012E

2008-2012

EBIT

$120.0

$126.2

$133.2

$137.7

$142.4

$147.3

3.9%

Plus: Non-deductible Goodwill Amort.

-

-

-

-

-

-

EBITA

$120.0

$126.2

$133.2

$137.7

$142.4

$147.3

3.9%

Less: Provision for Taxes

(42.0)

(44.2)

(46.6)

(48.2)

(49.9)

(51.6)

Unlevered Net Income

$78.0

$82.0

$86.6

$89.5

$92.6

$95.8

3.9%

Plus: D&A (excl. non-deductible GW amort.)

15.3

15.9

16.7

16.0

15.6

15.4

Less: Capital Expenditures

(18.0)

(16.0)

(14.1)

(14.6)

(15.1)

(15.6)

Less: Increase in Net Working Capital

(9.5)

8.3

3.1

3.2

3.3

3.4

Unlevered Free Cash Flow

$65.8

$90.2

$92.3

$94.2

$96.4

$99.0

2.3%

Total Enterprise Value

Total Equity Value

Terminal EBITDA Multiple

Terminal EBITDA Multiple

7.5x

8.0x

8.5x

7.5x

8.0x

8.5x

Discount

10.0%

$1,042.4

$1,088.1

$1,133.9

Discount

10.0%

$959.0

$1,004.7

$1,050.5

Rate

11.0%

1,003.0

1,046.7

1,090.4

Rate

11.0%

919.6

963.3

1,007.0

(WACC)

12.0%

965.5

1,007.3

1,049.1

(WACC)

12.0%

882.1

923.9

965.7

Implied Perpetuity Growth Rate

Total Price Per Share

Terminal EBITDA Multiple

Terminal EBITDA Multiple

7.5x

8.0x

8.5x

7.5x

8.0x

8.5x

Discount

10.0%

1.0%

1.5%

1.9%

Discount

10.0%

$27.38

$28.69

$30.00

Rate

11.0%

1.9%

2.4%

2.9%

Rate

11.0%

26.26

27.51

28.75

(WACC)

12.0%

2.8%

3.3%

3.8%

(WACC)

12.0%

25.19

26.38

27.58

DCF Analysis (2008-2012): Perpetuity Growth Method

Total Enterprise Value

Total Equity Value

Terminal Perpetuity Growth Rate

Terminal Perpetuity Growth Rate

3.0%

3.5%

4.0%

3.0%

3.5%

4.0%

Discount

10.0%

$1,260.8

$1,335.1

$1,421.7

Discount

10.0%

$1,177.4

$1,251.7

$1,338.3

Rate

11.0%

1,103.6

1,158.0

1,220.1

Rate

11.0%

1,020.2

1,074.6

1,136.7

(WACC)

12.0%

981.4

1,022.5

1,068.8

(WACC)

12.0%

898.0

939.1

985.4

Implied Terminal EBITDA Multiple

Total Price Per Share

Terminal Perpetuity Growth Rate

Terminal Perpetuity Growth Rate

3.0%

3.5%

4.0%

3.0%

3.5%

4.0%

Discount

10.0%

9.9x

10.7x

11.6x

Discount

10.0%

$33.62

$35.74

$38.22

Rate

11.0%

8.7x

9.3x

10.0x

Rate

11.0%

29.13

30.68

32.46

(WACC)

12.0%

7.7x

8.2x

8.7x

(WACC)

12.0%

25.64

26.82

28.14

(1) Assumes net debt of $83.4mm as of 5/16/08.

(2) Assumes outstanding diluted shares of 35.021 million.

Students also like this: Meaning of Financing Costs and Calculation

="68">

Download Full Sample
Cite This Work To export references to this Sample, select the desired referencing style below:
Global Assignment Help.(2022) Business Valuation Assignment Sample Retrieved from: https://www.globalassignmenthelp.com/free-samples/business-plan/business-valuation-assignment-sample
Copy to Clipboard
Business Valuation Assignment Sample Global Assignment Help ,(2022),https://www.globalassignmenthelp.com/free-samples/business-plan/business-valuation-assignment-sample
Copy to Clipboard
Global Assignment Help (2022) Business Valuation Assignment Sample[Online]. Retrieved from: https://www.globalassignmenthelp.com/free-samples/business-plan/business-valuation-assignment-sample
Copy to Clipboard
Global Assignment Help Business Valuation Assignment Sample. (Global Assignment Help, 2022) https://www.globalassignmenthelp.com/free-samples/business-plan/business-valuation-assignment-sample
Copy to Clipboard
Global Assignment Help Business Valuation Assignment Sample. [Internet]. Global Assignment Help.(2022), Retrieved from: https://www.globalassignmenthelp.com/free-samples/business-plan/business-valuation-assignment-sample
Copy to Clipboard

Are you in need of business plan assignment help? You have come at the right place. The writers of Global Assignment Help have top qualifications in business studies and great writing skills. We have been providing business decision making assignment help for years. One of the most frequent queries for our writers is about international business strategy assignment help which we fulfill without any hassle. Shoot your queries now and get the best solutions!

Boost Grades & Leave Stress

Share Your Requirements Now for Customized Solutions.

Lowest Price
USD 7.13

Delivered on-time or your money back

100+ Qualified Writers

For Best Business Plan Assignment Help

View All Writers
FREE Tools

To Make Your Work Original

  • tools Paraphrasing Tool

    Easy to Use Paraphrasing Tool to Simplify Complex Academic Writing

    Check Paraphrasing
  • tools Plagiarism Checker

    Check your work against plagiarism & get a free Plagiarism report!

    Check Plagiarism
  • tools Reference Generator

    Get citations & references in your document in the desired style!

    Generate References
  • tools Grammar Checker Tool

    Make your content free of errors in just a few clicks for free!

    Grammar Checker
  • tools Essay Typer

    Generate plagiarism-free essays as per your topic’s requirement!

    Essay Typer
  • Dissertation Outline Generator

    Get Structured Outline by Professionals for Your Dissertation

    Check Dissertation
GAH whatsapp