IDX Technology is a privately held developer of advanced security systems. As part of your business development strategy, in late 2008 you initiate discussions with IDX's founder about the possibility of acquiring the business at the end of 2008. Estimate the value of IDX per share using the discounted FCF approach and the following data about IDX: • Debt: $30 million • Excess cash: $110 million Shares outstanding: 50 million Expected FCF in 2009: $45 million Expected FCF in 2010: $50 million Future FCF growth rate beyond 2010: 5% Weighted-average cost of capital: 9.4%
Q: Find the present amount needed to attain a future amount of F dollars in the given time using an…
A: Discounting The process of arriving at the present value based on future cash flows is known as…
Q: Suppose that a 11-year bond with a face value of 3000 dollars is redeemable at par and pays…
A: We know the quantum and timing of the cash flows emanating from a bond. We have to find the book…
Q: Correct answer needed. Explain also.
A: The risk return relationship of individual stocks as well as portfolio is measured by SML. The SML…
Q: Some portfolio manages consistently outperform the market. support weak-form market efficiency
A: given Some port filo manages consistently outperform the market.
Q: ames has a mortgage of $88,500 at 4% for 15 years. The property taxes are $3,700 per year, and the…
A: The PITI payment includes payments for mortgage, insurance and taxes towards the mortgage.
Q: Find the periodic payment for each sinking fund that is needed to accumulate the given sum under the…
A: Future Value is $2,200,000 Interest rate r is 4% compounded quarterly Quarterly rate is 4%4=1% Time…
Q: Waller, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 20…
A: Particulars Values Par Value of Bond, FV $1,000.00 Coupon rate 5% Time to maturity 20 years…
Q: Highland Pet Supplies Company forecasts earnings per share of $1.50 during the coming year. Highland…
A: 1. According to Gordon's growth model, P = [ D (1+g) ] ÷ ( ke -g). Where, P = current market price D…
Q: A stock is selling for $32.70. The strike price on a put, maturing in one year, is $35. The possible…
A: The binomial pricing model is used to price options where the future price of the underlying stock…
Q: Determine how much is in each account on the basis of the indicated compounding after the specified…
A: initial Principal Value is 7200 The interest rate is 2.5% The time period is 1 year To Find:…
Q: PMI is normally required on mortgages that have adjustable rates have graduated payments are…
A: Several situations have been described explaining when PMI is required. We have to find the correct…
Q: You are given the following cash flow information for Project A PV Outflows TV Inflows $150,000.00…
A: MIRR is used to determine the attractiveness of a project. It considers the concept of IRR as it is…
Q: A CMO has been issued with 3 tranches and a residual. At origination: - Tranche A investors own $9…
A: Data given: Tranche A investors own $9000 Tranche B investors own $ 17000 Tranche Z investors own $…
Q: Determine the values K, L, M, and N in the table. 3.2 Calculate the total present value of the net…
A: Net present value is the one of the important capital budegting method based on time value of money…
Q: Suppose that without an adjustment for the relationship between the yield on a bond to be hedged and…
A: We have the hedge ratio without an adjustment for the relationship between the yield on a bond to be…
Q: 12. The 180-day interest rates in Canada and U.K. are 7% and 3%, respectively. The spot exchange…
A: Realized rate of return refers to the return that was achieved from the investment made by…
Q: The risk-free return is 5%, Company x has a beta of 1.5 and an expected return of 20%. Calculate the…
A: Solution:- Capital Asset Pricing Model (CAPM) is an equity model which calculates the required rate…
Q: a. What are the expected returns of the two stocks? b. What are the standard deviations of the…
A: Expected return Return is the main goal of every investment. The minimum rate of return that an…
Q: An investment has been found to have two different IRRs, one at 14% and the other at 20%. When a…
A: A project has two IRRs. We need to find the zone of rate of return when NPV will be positive and the…
Q: Question 18 Compute the probability of the up-step: q = (S-Sd) / (Su-Sd) Enter as decimal Question…
A: Concept. According to bartleby guidelines, if question involves multiple subparts, then 1st sub 3…
Q: piedmont hotels is an all-equity company. its stock has a beta of 1.23. the market risk premium is…
A: Solution:- Capital Asset Pricing Model (CAPM) is a model which gives a formula to calculate the…
Q: You are evaluating the proposed acquisition of a new machine costing $54,000, and it falls into the…
A: Company has to do many projects but resources are limited and the projects are to be selected on the…
Q: Read Machine needs $25.7 million to fund an expansion project. The firm has decided to raise the…
A: Amount needs to raise = $25,700,000 Stock price = $18.75 Underwriter spread = 0.071 Number of…
Q: expenses. What is their financi leverage at 40,000 items per year? What is their combined leverage?…
A: Given data SPT currently sells products at a price of $12 and has $ 5,000 interest expenses. In the…
Q: You sell a 50 put for 4 and buy a 55 call for 5. Stock ends at $47. Premium=.....
A: put Strike price is 50 Call strike price is 55 put premium is 4 Call premium is 5 Ending price of…
Q: marie chi inherited 425,000 from her grandmother and decided to invest the funds at 8% per year.how…
A: Investment amount (PV) = 425,000 Interest rate (r) = 8% Period (n) = 20 Years
Q: You have a Bond paying 5.48% semi-annual coupon and maturing on 14-Jul-2029 and currently trading at…
A: 5.48% s - semi-annual coupon 6.22%p.a. -T+1 basis
Q: An investor buys one American Call option on one share of stock of ABC. The option's strike price is…
A: An American call option is a type of option where the holder of the call can ask for the delivery of…
Q: at causes market weights for WACC to be significantly different than the book value w
A: WACC is the weighted average cost of capital and is the benchmarke hurdle rate and is the cost of…
Q: Kat receives ₱10,000.00 monthly starting on Mar. 2, 2023 until Feb. 2, 2024 as a cash gift from…
A: Present value of annuity With periodic interest rate (r), period (n) and periodic payment or annuity…
Q: Sammie's Club wants to buy a 320,000-square-feet distribution facility on the northern edge of a…
A: Going-in capitalization rate/Direct Capitalization Method Projected first-year NOI divided by the…
Q: Assume that both portfolios A and B are well diversified, that E(rA) = 22%, and E(rB) = 17%. If the…
A: Expected return of A , ErA is 22% Expected return of A , ErB is 17% Beta of A is 1.5 Beta of B is…
Q: A project has an initial cost of $40,000, expected net cash inflows of $11,000 per year for 7 years,…
A: Net Present Value (NPV) is the profit in today's dollar terms. If the NPV is positive that means the…
Q: The Pioneer Petroleum Corporation has a bond outstanding with an $80 annual interest payment, a…
A: YTM refers to the yield to maturity on a bond. It is the return provided by the bonds assuming the…
Q: Which of the following is defined as comparing actual performance to planned performance and…
A: Performance refers to the subjective measurement of the use of assets by the firm during its primary…
Q: Filer Manufacturing has 9,908,628 shares of common stock outstanding. The current share price is…
A: Market value basis is different from book value basis. In case of market value basis we look at the…
Q: Suppose you have a 30 year mortgage for 221,564 with quarterly payments of 5,552 what is the total…
A: Interest can be computed as follows = Total Payment - Principle Amount of Mortgage Total payment is…
Q: Jer Anna Ginzburg, CFA, is using the following information to analyse a potential investment in an…
A: We have to find the value using Price to FFO multiple.
Q: he Hartley Hotel Corporation is planning a major expansion. Hartley is financed 100 percent with…
A: IRR is internal rate of return and is the one of the fundamental capital budgeting method that is…
Q: John invests R50 000 at FS bank for 5 years. He gets an interest rate of 7,2% per annum compounded…
A: Future value of the amount includes the amount that is being deposited and the amount of interest…
Q: For the following loan, make a table showing the amount of each monthly payment that goes toward…
A: Loans are paid by the equal monthly installments and these equal monthly installments carry the…
Q: Delta Games Private Limited is a digital gaming company creating fun-to-play games for millenials.…
A: Given Expected Series-A Investment = $5,000,000 Rate of Return = 40% Delta's ownership : Founders =…
Q: Kellogg Company manufactures cereal and other convenience food under its many well-known brands such…
A: The Capital Asset Pricing Model is a model that describes the relationship between the expected…
Q: Kat Receives 10,000 pesos monthly starting on March 2, 2023 until February 2, 2024 as a cash gift…
A: These are questions based on time value of money. We will use the standard time value of money…
Q: The last four years of returns for a stock are as shown here: a. What is the average annual return?…
A: Year Return 1 -3.60% 2 27.50% 3 12.40% 4 3.80% To Find: Average Anual return Variance…
Q: You work for leveraged buyout firm and are evaluating a potential buyout of UnderWater Company…
A: We have certain questions related to leveraged buyout. We have to answer them one by one.
Q: Find the effective yield on a discount loan with the given discount rate r and the time. (Round your…
A: We have to find the effective yield on a discount loan.
Q: Is the debt primarily short-term or long-term? Why?
A: We have to find if the debt is primarily long term and short term. As a first step we will have to…
Q: Banking. Josiah has an income of $137,000 that he is willing to spend over a year. If his bank…
A: bank interest refers to the amount that is being paid by the bank to the account holder for the…
Q: Crenshaw Enterprises has gathered projected cash flows for two projects. Project 3 -$ 197,000 Year 0…
A: This is a case of capital budgeting. We will have to find the rate at which NPV of the two projects…
Hi,
I'm unsure how to solve this question without using Excel
Thanks
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- You have been asked by your employers to demonstrate your knowledge in business valuation process, by analyzing the value of Best Group Savings and Loans Company (BGSLC). The company paid a dividend of GH¢ 250,000 this year. The current return to shareholders of companies in the same industry as BGSLC is 12%, although it is expected that an additional risk premium of 2% will be applicable to BGSLC, being a smaller and unquoted company. Compute the expected valuation of BGSLC, if: The current level of dividend is expected to continue into the foreseeable future The dividend is expected to grow at a rate 4% par into foreseeable future The dividend is expected to grow at a 3% rate for three years and 2% afterwardsLana is thinking about making an iventment in a new venture called BluePearl - after performing an analysis of similar firms, she discovered several other firms (3) with the following Enterprise Value to FCF ratios: Firm 1: 5.9 Firm 2: 7.6 Firm 3: 9.1 The cashflows for BluePearl this year are expected to be $1,300,000. If BluePearl doesn't have any debt or cash currently, and 700,000 shares outstanding - what is the Price Per Share for BluePearl?Your PE firm is considering acquiring a publicly traded digital advertising company, Star Dust Enterprises (SDE). The following are some key statistics of the stock of SDE today (t = 0). SDE is 100% equity financed. Its cost of capital (apply this to all cash flows) is 11.2% and the payout ratio is 79%. Expected earnings per share of SDE at next year (t = 1) are $6.6. Assume that without new investments, expected earnings of SDE would remain at their time-1 level in perpetuity. All future investments are expected to generate $0.2 in incremental earnings for each $1 of investment. For an investment made at time t, incremental cash flows are generated starting in year t + 1. (a) Compute expected dividend per share of SDE next year (t = 1): $ (b) Compute expected dividend per share of SDE two years from now (t = 2): $ (c) What is the present value of growth opportunities (PVGO) of SDE today? $
- Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 50002023 60002024 70002025 80002026 90002027 100002028 11000 Determine the following:a. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.7. Your company is currently contemplating whether to buy Hot House, a national chain of computer systems consultants based in California. Your job is to estimate the market value of the equity in Hot House. To accomplish this task, you have gathered the following information. The estimated FCFF generated by Hot House for each of the next five years are as follows. CFF 1 $2,400 2 3 4 5 $2,910 $3,452 $4,452 $5,352 Subsequent to year 5, you estimate that the cash flows will grow at 6% indefinitely. Currently, the company has $5 million of debt outstanding, but that debt balance is expected to increase by 5% at the end of each year. Thus, the current debt balance of $5 million will increase to $5.25 million at the end of year 1, $5.5125 million at the end of year 2, etc. Fortunately, the before-tax cost of debt is expected to remain stable at 12%. Finally, you estimate that the required return on the unlevered equity is 16%. If the company has 1 million shares outstanding, what is the…RTE Telecom Inc., which is considering the acquisition of Lucky Coro, estimates that acquiring Lucky will result in an incremental value for the firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company: Data Collected (in millions of dollars) Year 1 Year 2 Year 3 EBIT $120 $14.4 $18.0 Interest expense 505560 Debt 29.7 35.1 37.8 Total net operating capital 109.2 111.3 1134) Lucky Corp is a pubicly traded company, and its market- determined pre-merger beta is 1.20 You also have the following information about the company and the projected statements: Lucky currently has a $12.00 million market value of equity and S 7:80 million in debt. The risk-free rate is 3.5%, there is a 5.60% market risk premium, and the Capital Asset Pricing Model produces a pre merger required rate of return on equity rs of 10.22% Lucky's cost of debt is 5.50% al a laxtale of 35% The projections assume that the company will have…
- Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022 50002023 60002024 70002025 80002026 90002027 100002028 11000 Determine the following: DO IT IN EXCELa. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.Budget Wings Airlines is considering upgrading its fleet of aircraft as it expands from a regional airline to one offering service to a more nationwide portfolio of cities and airports. In support of this process, the CFO has asked you to determine the appropriate weighted average cost of capital (WACC) to use in the discounted cash flow analysis. You spend the morning gathering the following information: - Budget Wings has debt outstanding with a market value of $150 million. This debt is in the form of bonds that are currently priced at $946.33 per $1,000 face value and pay a coupon of 3.45%. The current yield-to-maturity (YTM) on these bonds is 4.11%. - Budget Wings stock is currently priced at $54.41 per share. You expect that next year's dividend will be $3.75 and you expect dividends to grow at 3%. The current market value of Budget Wings' common equity is $240 million. - Budget Wings has preferred equity outstanding with a market value of $30 million that offers an annual…Softek Corporation forms a separate legal entity, Startek, to develop new technology. The entity is funded by $2,000,000 in outside equity and $26,000,000 in debt. Softek guarantees Startek's debt. The entity is expected to generate the following cash flows at the end of two years: Cash Flow Probability $14,520,000 0.50 42,350,000 0.20 60,500,000 0.30 A discount rate of 10 percent is appropriate. Required Assume qualitative analysis of Startek's VIE status is inconclusive. Quantitatively analyze whether Startek is a variable interest entity. Instructions: Use negative signs with your answers, when appropriate. • Enter $ answers in millions ($11,000,000 equals $11 million). • Enter Probability answers using decimals. Expected Present Cash Flow Value Probability Expected Investment Residual Expected Fair Value Returns S PV Gains $ $ Expected Losses
- Your firm is planning to invest in a new electrostatic power generation system. Ampthill Inc is a firm that specializes in this business. Ampthill has a stock price of $25 per share with 20 million shares outstanding. Ampthill's equity beta is 1.4. It also has $220 million in debt outstanding with a debt beta of 0.1. Your estimate of the asset beta for electrostatic power generators is closest to 1.18 1 0.79 1.3(EBIT-EPS analysis) A group of retired college professors has decided to form a small manufacturing corporation that will produce a full line of traditional office furniture. The investors have proposed two financing plans. Plan A is an all-common-equity alternative. Under this agreement, 1 million common shares will be sold to net the firm $20 per share. Plan B involves the use of financial leverage. A debt issue with a 20-year maturity period will be privately placed. The debt issue will carry an interest rate of 10 percent, and the principal borrowed will amount to $6 million. The marginal corporate tax rate is 21 percent. a. Find the EBIT indifference level associated with the two financing proposals. b. Prepare a pro forma income statement that proves EPS will be the same regardless of the plan chosen at the EBIT level found in part a. c. Prepare an EBIT-EPS analysis chart for this situation. d. If a detailed financial analysis projects that long-term EBIT will always be close to…Photochronograph Corporation (PC) manufactures time series photographic equipment. It is currently at its target debt-equity ratio of .75. It’s considering building a new $76 million manufacturing facility. This new plant is expected to generate aftertax cash flows of $7.4 million in perpetuity. The company raises all equity from outside financing. There are three financing options: 1. A new issue of common stock: The flotation costs of the new common stock would be 6.3 percent of the amount raised. The required return on the company’s new equity is 12 percent. 2. A new issue of 20-year bonds: The flotation costs of the new bonds would be 2.8 percent of the proceeds. If the company issues these new bonds at an annual coupon rate of 5 percent, they will sell at par. 3. Increased use of accounts payable financing: Because this financing is part of the company’s ongoing daily business, it has no flotation costs, and the company assigns it a cost that is the…