Suppose you work as an Equity Research Analyst for the Teachers’ Retirement Pension Fund. Your fund...

Suppose you work as an Equity Research Analyst for the Teachers’ Retirement Pension Fund. Your fund is offered to purchase TechRevolution public offering at $3.30 per share. While your fund’s manager is very interested in this stock, he also wants to make sure the fund pays a fair price per share, so he asked you to determine the fundamental price of the firm’s stock. Using various sources, you gathered the following information about TechRevolution

Year	Free cash flow (FCF forecast), $	Other data
2020	700,000	FCF growth rate (2023 to ∞) = 2.5% per year
2021	735,000	Weighted average cost of capital = 14% per year
2022	765,000	Market value of company’s debt = $3,000,000
2023	790,000	Market value of preferred stock = $0
Terminal	TBD	Common shares outstanding = 1,000,000

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

jeff jeffy answered 2 years ago

You work at the equity research department of a large investment bank and your task is...

You work at the equity research department of a large investment bank and your task is to determine the value of the company Example.com using the WACC method. You have the following estimates for Example.com’s yearly financials for the year 2018. a. Net Income is £300 million. b. The corporate tax rate is 25%. c. The interest expense is £100 million. d. Depreciation is £150 million. e. Capital expenditure is £200 million. f. Net working capital in December 2017 is...

Suppose you are a strategist for a hedge fund. Your research indicates that the quality spread...

Suppose you are a strategist for a hedge fund. Your research indicates that the quality spread for BBB bonds and AAA bonds is 150 basis points in periods of economic slowdown and only 100 bp in periods of economic expansion. Currently, the economy is in a recession, and one- and two-year zero coupon bonds for AAA and BBB bonds are trading at 6% and 7.5%. Leading economic indicators, though, strongly point to the economy hitting its trough relatively soon and...

This is your first week at a mutual fund as an analyst. Your boss asked you...

This is your first week at a mutual fund as an analyst. Your boss asked you to evaluate the price risk of two 30-year bonds – Bond A and Bond B. Bond A has a coupon rate of 4%, while Bond B has a coupon rate of 8%. Both bonds pay their coupons semi-annually . A) Construct an Excel spreadsheet showing the prices of each of these bonds for yields to maturity ranging from 1% to 15% at intervals of...

Immunization with Coupon Bonds Suppose that you are managing a pension fund with obligations to make...

Immunization with Coupon Bonds Suppose that you are managing a pension fund with obligations to make perpetual payments of $2.6 million per year to beneficiaries. The required rate of return is 16%. a. If the duration of 5-year maturity bonds with coupon rates of 12% (paid annually) is 4.0 years and the duration of 20-year maturity bonds with coupon rates of 6% (paid annually) is 7.9 years, how much of each of these coupon bonds (in $ market value) will...

Justin Owens is an analyst for an equity mutual fund that invests in British stocks. At...

Justin Owens is an analyst for an equity mutual fund that invests in British stocks. At the beginning of 2008, Owens is examining domestic stocks for possible inclusion in the fund. One of the stocks that he is analyzing is British Sky Broadcasting Group (London Stock Exchange: BSY). The stock has paid dividends per share of £9, £12.20, and £15.50 at the end of 2005, 2006, and 2007, respectively. The consensus forecast by analysts is that the stock will pay...

You are the pension fund manager for a consulting company. Your workers will begin to retire...

You are the pension fund manager for a consulting company. Your workers will begin to retire 10 years from now. You estimate that you will need $1.2 million exactly 10 years from now to fund the first year payments. Due to inflation and growth in the number of retirees, your annual obligations will grow by 5% per year, and will continue forever. Your financial advisors tell you that you can plan on earning 8.0% per year on invested funds. (a)...

Compose a research report on Bar Codes vs. RFID. You work as an efficiency analyst at...

Compose a research report on Bar Codes vs. RFID. You work as an efficiency analyst at one of the largest retail companies in the world, with multiple stores in every state, as well as in many other countries. For the past 25 years, the company has used bar code readers at checkout counters that scan the bar code on products to determine from a database the price to charge customers and to keep a record of inventory. The company is...

You are investing for your retirement and your financial advisor has strongly recommended the mutual fund,...

You are investing for your retirement and your financial advisor has strongly recommended the mutual fund, Fidelity Select Retailing Portfolio, FSRPX. She suggested this fund can meet your needs since it has been around since December 1985 and has performed quite well. Being the aggressive investor that you are, you want to invest in a fund that has a high annual return rate. The annual returns (in percents, from oldest to newest) are as follows: 14.18, -7.36, 38.71, 29.53, -5.03,...

You deposit X in an account today in order to fund your retirement. You would like...

You deposit X in an account today in order to fund your retirement. You would like to receive payments of 50 per year, in real terms, at the end of each year for a total of 12 years, with the first payment occurring seven years from now. The inflation rate will be 0.0% for the next 6 years and 1.2% per annum thereafter. The annual effective rate of return is 6.3%. Calculate X to the nearest dollar.

Suppose that you manage a pension fund that has liabilities of $2 million, $4 million, $8...

Suppose that you manage a pension fund that has liabilities of $2 million, $4 million, $8 million, and $10 million coming due in 1, 2, 3, and 4 years, respectively. You want to invest in bonds whose cash flows will exactly match the liabilities. The following bonds are available: 1-year, 2-year, 3-year, and 4-year annual-coupon bonds selling at par; the yields (YTMs) are 1%, 2%, 3%, and 4%, respectively. What's the necessary dollar amount of investment in 1-year bond today?

Question