Reference no: EM132144096

Assignment - Alternative Valuation Methods

You may do this assignment individually or with one other person.

In this assignment, you use horizon value calculation methods to estimate the current market value of a privately held company.

Select a non-financial company for which financial information is available for several fiscal years. Obtain financial statements for at least the three most recent years. Use the selected company's financial statements, together with other information described, to calculate the values indicated in questions 1-4.

Part 1 - Determining value multiples

Perpetuity based valuation method

1a. Estimate a growth rate for the company. Use any appropriate method, such as the average of several years' growth rates for sales (or total revenue), the average of several years' growth rates in net income (or operating income), or the average dividend growth rate. Specify how you determine the growth rate.

b. Estimate the required return for the company using the capital asset pricing model if beta is available for the company (assume the risk free rate is 2.5% and the expected market return, 12.5%). If beta is not available, use the company's average annual stock return for the last three years as the required return.

Valuation estimated by capitalizing an operating variable

2a. Select an appropriate income statement line item from which to estimate a value multiple for an operating variable. E.g., net income can be used to calculate the price earnings ratio; total revenue to calculate the price to sales ratio; total cash flow to calculate the price to cash flow ratio; and etc.

b. Find the value of the selected operating variable for the most recent year.

c. Find the company's current equity value (market capitalization or price per share * number of shares outstanding).

d. Using 2b and c, calculate the selected value multiple for the public company.

Valuation estimated by capitalizing an asset

3a. Select an appropriate balance sheet line item from which to estimate a value multiple for a non-operating, financial variable. E.g., book value of equity can be used to calculate the price to book value ratio; total assets to calculate the price to total assets ratio; and etc.

b. Find the value of the selected asset for the most recent year.

c. Using 2c and 3b, calculate the selected value multiple for the public company.

Valuation estimated using a non-financial asset

4a. Find the number of employees for the company for the most recent fiscal year.

b. Using 2c and 4a, calculate the price to employee ratio for the selected company.

Part 2 - Determining the value of a privately held company

Assume the value multiples you calculated in part 1 are representative of the entire industry (rather than just the selected company).

5. Estimate the value the privately held company for which the most recent financial statement are attached would have in the market

a. based on valuation using the growing perpetuity method (assuming the required return and growth rate from question 1).

b. using the value multiple for the operating variable calculated in question 2.

c. using the value multiple for a non-operating variable calculated in question 3.

d. using the employee value multiplier calculated in question 4.

6. Briefly discuss the differences in values obtained in question 5 using the different methods, and indicate which estimate(s) of value are likely to be most accurate given the characteristics, the industry, or the principal determinants of value of the firm selected in part 1.

Income Statement (thousands)
Total Revenue	3290
Cost of Revenue	2144
Gross Profit	1146
Operating Expenses
Research Development	220
Selling General and Administrative	538
Non Recurring	11
Others	69
Total Operating Expenses	838
Operating Income or Loss	308
Income from Continuing Operations
Total Other Income/Expenses Net	23
Earnings Before Interest and Taxes	285
Interest Expense	26
Income Before Tax	259
Income Tax Expense	104
Net Income	155

 

Balance Sheet (thousands)
Cash And Cash Equivalents	168
Net Receivables	252
Inventory	207
Other Current Assets	12
Total Current Assets	639
Property Plant and Equipment	1266
Goodwill	321
Intangible Assets	162
Other Assets	130
Total Assets	2518
Accounts Payable	176
Short/Current Long Term Debt	118
Other Current Liabilities	205
Total Current Liabilities	499
Long Term Debt	518
Other Liabilities	26
Deferred Long Term Liability Charges	26
Total Liabilities	1069
Common Stock	838
Retained Earnings	654
Other Stockholder Equity	-43
Total Stockholder Equity	1449
Number of employees	18

 

Statement of cash flows (thousands)
Net Income	155
Operating Activities
Depreciation	87
Adjustments To Net Income	51
Changes In Accounts Receivables	12
Changes In Liabilities	-11
Changes In Inventories	4
Changes In Other Operating Activities	-8
Total Cash Flow From Operating Activities	290
Investing Activities
Capital Expenditures	-22
Investments	12
Other Cash flows from Investing Activities	-76
Total Cash Flows From Investing Activities	-86
Financing Activities
Dividends Paid	-128
Sale Purchase of Stock	-100
Net Borrowings	0
Other Cash Flows from Financing Activities	0
Total Cash Flows From Financing Activities	-228
Effect Of Exchange Rate Changes	-12
Change In Cash and Cash Equivalents	-36