Provided below are an analyst's forecasts of revenue, net operating profit after tax (NOPAT), and net operating assets (NOA) as of 12/31/2020 for Abbott Laboratories. Forecast Horizon Period 2022 2023 $34,608.0 $36,684.5 $38,885.5 $41,218.7 $43,691.8 $4,774.4 $5,060.9 $5,364.5 $5,686.4 $6,027.6 $44,579.0 $47,253.7 $50,089.0 $53,094.3 $56,280.0 ($ millions) Reported 2020 2021 Revenue: NOPAT: NOA: 2024 Terminal Period $44,565.6 $6,148.1 $57,405.6 The following additional information is provided (dollar and share amounts in millions). Common shares outstanding: 1,771.230 Net nonoperating obligations (NNO): $11,576.0 Noncontrolling interest (NCI): $219.0 Preferred stock: $0.0 WACC: 4.0% Terminal growth: 2.0%
Q: If the value of a levered firm is $7 million, what is the value of the same firm with all-equity…
A: In MM model with zero taxes, the value of levered firm will be equal to value of unlevered firm.In…
Q: A company is reviewing an investment proposal in a project involving a capital outlay of GHS…
A: To evaluate the potential of a project, the cash flows are first discounted at the company's pre-tax…
Q: Dickson Corporation is comparing two different capital structures. Plan I would result in 39,000…
A: Price per share= Debt amount / ( Shares of all equity firm - Shares after debt )
Q: Zoom Enterprises expects that one year from now it will pay a total dividend of $49 million and…
A: Value of shares can be found as the present value of dividend based on the required rate of return.
Q: During the class lecture we learned that the U.S. commercial paper market collapsed during the 2008…
A: Answer:During the 2008 financial crisis, the U.S. commercial paper market faced significant…
Q: ently uses a six-year-old molding machine to manufacture silver picture frames. The company paid…
A: NPV is time value based method of capital budgeting and can be found as the difference in present…
Q: ABC Company Limited looking to invest in one of the proposed projects. The cost of that project is…
A: IRR is also known as Internal rate of Return. It is a capital budgeting technique which helps in…
Q: Xo X tin 50 42 22-90 93 0 33 6 33 52 93 93 100 100 25 8 & Comp-XM-Board Query-Google Chrome…
A: The question is asking us to predict the number of units Digby will sell in the upcoming year for…
Q: Required: A hedge fund with $1.7 billion of assets charges a management fee of 2% and an incentive…
A: In hedge funds, fees play a crucial role in determining the overall compensation for fund managers.…
Q: You are given the following information concerning three portfolios, the market portfolio, and the…
A: PortfolioRpσpBpX12.00%29.00%1.25Y11.00%24.00%1.1Z8.00%14.00%0.75Market10.00%19.00%1Risk-free4.00%0.0…
Q: Additional Information: i. The Long-Term debt consists of 8% annual coupon bonds, with 15 years…
A: WACC stands for Weighted Average Cost of Capital. It is a financial metric used to evaluate the cost…
Q: A mutual fund has 350 shares of General Electric, currently trading at $24, and 350 shares of…
A: Net Asset Value (NAV) is a key financial metric used in the context of investment funds, including…
Q: RiverRacks (whose WACC is 11.4%) is considering an acquisition of Ratt Adventures (whose WACC is…
A: WACC is the weighted cost of all sources of capital used by the Company. It is the sum of (Weights*…
Q: Kaileika's retirement plan consists of contributing $123 at the end of each month into an RRSP. If…
A: Future value of money is the amount of investment done and amount of interest accumulated over the…
Q: You have been given the following return information for a mutual fund, the market index, and the…
A: The variables that are used in risk analysis for an investment using the excess returns and the…
Q: Question 1 of 15, Step 1 of 1 0/out of 15 Correct Tries remaining:3…
A: The objective of this question is to calculate the monthly mortgage payment for a loan amount of…
Q: Determination of a suitable strategy for a company begins with identifying opportunities and risks…
A: (a) The Economic Environment: The economic environment refers to the state of the economy in a…
Q: Wendell's Donut Shoppe is investigating the purchase of a new $33,000 donut-making machine. The new…
A: Capital budgeting refers to the process of allocating capital to projects that generate returns for…
Q: A stock is expected to pay a dividend of $2.25 at the end of the year (i.e., D1 = $2.25), and it…
A: Expected dividend (D1) = $2.25Growth rate = 3%Required return = 13%
Q: Initial stock price. S 0 interest rate.r Exercise price. K Time to matulty. Tiyeam) Stock price Date…
A: Option Market is a Stock Market Strategy. Under which investor will not purchase the shares of the…
Q: You are analyzing two proposed capital investments with the following cash flows: Project X -…
A: PI of Project X is 1.14PI of project Y is 1.04
Q: 3. Given ft = 0.02 -0.08(1 - exp(-0.1t)) for t = 1,..., 30. Plot forward rate curve ft and implied…
A: 1. : Forward rate, an interest rate applicable to a financial transaction that will occur in the…
Q: The cost of capital for Project A is 15% and the cost of capital for project B is 13%. Calculate the…
A: The Discounted Payback Period (DPP) is the time it takes for a project's net present value (NPV) to…
Q: Esfandairi Enterprises is considering a new three-year expansion project that requires an initial…
A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…
Q: As an active fund manager, you have obtained information on three individual stocks, the market…
A: Weighted average = expected return / standard deviation.Stock 1=20/80∗100.=25%.Stock…
Q: You are analyzing two proposed capital investments with the following cash flows: Year 0 1 2 3 4…
A: The profitability index is used to determine the attractiveness of an investment. It is computed by…
Q: 1 A ten year US treasury note with a face value of $10,000 is selling on the market for $7,210.75.…
A: Yield to maturity (YTM) refers to the total return anticipated on a bond if it is held until its…
Q: What is the project NPV? What is the estimated Internal Rate of Return (IRR) of the project?
A: The internal rate of return is used to assess how profitable a project or investment is. It is a…
Q: Due to demographics and increasing awareness about the potential dangers of smoking, PuffOff, a…
A: Dividend for Year 1 = d1 = $2.15Growth Rate for Year 2 = g2 = -11%Growth Rate for Year 3 = g3 =…
Q: What is the Cost of Preferred Stock for Foggy Futures Weather Forecasters? The firm is in the 40%…
A: Cost of preferred stock can be calculated by using equation below. Cost of preferred stock = Annual…
Q: Matt is saving to buy a new motorcycle. If he deposits $70 at the end of each month in an account…
A: Here,ParticularsValuesMonthly deposits (PMT) $ 70.00Interest rate5.50%Number of compounding…
Q: You are thinking of buying a house beside the College which you will rent to students. You expect to…
A: Present Value can be calculated using PV function in Excel:PV (rate, nper, pmt, [Fv], [type])Rate =…
Q: Suppose you bought a bond with an annual coupon of 9 percent one year ago for $1,160. The bond sells…
A: Bonds are the instruments that represent the debt of an organization and are a type of debt…
Q: What is the cost of Common Stock for Foggy Futures Weather Forecasters? The firm is in the 40% tax…
A: Cost of common stock can be calculated by using equation below.Cost of common stock = (Next…
Q: Olsen Outfitters Inc. believes that its optimal capital structure consists of 65% common equity and…
A: A company's capital structure indicates the mix of all the funding sources available that the firm…
Q: nitial Outlay = Cost of Asset + Installation charges + Opportunity costs of any Existing asset + any…
A: Introduction:Usually, the initial outlay reflects the cash spent to acquire the asset.
Q: Mark Welsch deposits $7,900 in an account that earns interest at an annual rate of 8%, compounded…
A: “Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: SP 24 Serial Problem Business Solutions (Static) LO P1, P2, P4 Santana Rey is considering the…
A: Payback period (PBP) refers to the period or duration within which the company is able to recover…
Q: uppose that you buy a 3-year coupon bond which sells at par. Its nominal value is £1,000 and its…
A: Bonds are one kind of investment in which interest is paid each period and par value of the bond is…
Q: You were hired as a consultant to Quigley Company, whose target capital structure is 35% debt, 10%…
A: A company's average after-tax cost of capital from all sources, including common stock, preferred…
Q: Chaquille's K-House, Inc. made an investment in a project with an initial cost of $10,729,236. This…
A: Net Present Value (NPV) is the difference between the present value of cash inflows and the present…
Q: PLEASE HELP CALCULATE THE FOLLOWING--- Required: 4. Calculate the profitability index for each…
A: The simple average rate of return and the profitability index are both financial metrics used to…
Q: How much should her contributions be?
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Firm X is considering the replacement of an old machine with one that has a purchase price of…
A: Net Cash outflow for new Machine is that amount which is paid by the investor at initial level of…
Q: One can use Black-Scholes model to price any financial derivatives. true or false
A: The Black-Scholes model was specifically designed to value European-style options on non-dividend…
Q: Assume a corporation has earnings before depreciation and taxes of $145,000, depreciation of…
A: Earnings before depreciation and taxes = $145,000Depreciation =$35,000Tax rate = 30%
Q: A Treasury bond that settles on August 10, 2022, matures on May 4, 2028. The coupon rate is 5.8…
A: Settlement dateAug 10, 2022Maturity dateMay 04, 2028Coupon rate5.80%Quoted price $…
Q: a municipal bond with a 5.21% coupon that is also selling at par. If all other features of these two…
A: The correct answer is A. The investor should select the corporate bond..Gains on corporate bonds are…
Q: Case study a. Let's say your friend offer simple investment. You are planning to buy an asset for RM…
A: Rate of return is the amount of profit earned on the investment and this is the percenatge of the…
Q: 2. Last year the return on Harry Company stock was 5 percent. The portion of the return on the stock…
A: Given For the change in interest rate: Actual value = 2.0%Expected value = 0.0%Factor sensitivity =…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
- Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Reported Horizon Period $ millions 2018 2019 2020 2021 2022 TerminalPeriod Sales $56,912 $57,766 $58,632 $59,512 $60,404 $61,008 NOPAT 2,492 2,542 2,580 2,619 2,658 2,684 NOA 4,032 4,097 4,158 4,221 4,284 4,327 Answer the following requirements assuming a discount rate (WACC) of 7.8%, a terminal period growth rate of 1%, common shares outstanding of 135.6 million, net nonoperating obligations (NNO) of $(6,129) million, which is negative because Humana’s nonoperating assets exceed its nonoperating liabilities, and no noncontrolling interest (NCI) on the balance sheet. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31, 2018. Instructions: Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not round), and…Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018 S millions Sales NOPAT NOA Forecast Horizon Period Terminal Period 2021 Reported 2018 2019 2020 2022 $125,515 $134,301 $143,703 $153,761 $164,525 $167,816 14,005 15,042 16,095 17,221 18,427 29,633 31,705 33,924 36,299 38,840 18,795 39,616 Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $31,812 million. Required a Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) model as of February 3, 2019. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: s b. Home Depot stock closed at $220.47 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your…Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,091,242 158,522 428,867 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…
- Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,788,322 211,362 571,823 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales $2,091,242 Net operating profit after tax (NOPAT) 158,522 Net operating assets (NOA) 428,867 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places.. Note: When completing the question…Refine Assumptions for PPE ForecastFollowing are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income (loss) before income taxes 5,197 Income tax provision 547 Net income (loss) 4,650 Net (income) loss attributable to noncontrolling interests (19) Net income (loss) attributable to Medtronic $ 4,631 Consolidated Balance Sheet ($ millions) April 26, 2019 Current assets Cash and cash equivalents $ 4,393 Investments 5,455 Accounts receivable, less…
- Refine Assumptions for PPE ForecastFollowing are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income (loss) before income taxes 5,197 Income tax provision 547 Net income (loss) 4,650 Net (income) loss attributable to noncontrolling interests (19) Net income (loss) attributable to Medtronic $ 4,631 Consolidated Balance Sheet ($ millions) April 26, 2019 Current assets Cash and cash equivalents $ 4,393 Investments 5,455 Accounts receivable, less…Shouldn't the operating expenses for 2020 be 8074.9? Forecasting an Income StatementADP reports the following income statement. AUTOMATIC DATA PROCESSING INC.Statement of Consolidated EarningsFor Year Ended June 30, 2019, $ millions Total revenues $14,175.2 Operating expenses 7,145.9 Systems development and programming costs 636.3 Depreciation and amortization 304.4 Total cost of revenues 8,086.6 Selling, general, and administrative expenses 3,064.2 Interest expense 129.9 Total expenses 11,280.7 Other income expense, net 111.1 Earnings before income taxes 3,005.6 Provision for income taxes 712.8 Net earnings $ 2,292.8 Forecast ADP’s 2020 income statement assuming the following income statement relations. All percentages (other than total revenue growth and provision for income taxes) are based on historic percent of total revenues. Total revenues growth 13% Depreciation and amortization $460.5 million Interest expense No change Other…Forecast income statement - ALL FIGURES IN $ MILLION Financial year ending 31 March 2023 2024 2025 Revenue 165.0 180.0 210.0 Less: Operating expenses 120.0 128.0 145.0 Operating earnings before depreciation 45.0 52.0 65.0 Less: Depreciation 30.0 32.0 25.0 Earnings before interest and tax (EBIT) 15.0 20.0 40.0 Less: Interest expense 5.0 5.0 5.0 Earnings before tax 10.0 15.0 35.0 Less: Tax expense 2.8 4.2 9.8 Net profit (earnings) 7.2 10.8 25.2 In addition, you have collected the following information: Operating working capital (OWC) in each year will be 10% of revenue in that year Capital expenditure (capex) will be $25 million in each year The corporate tax rate is 28%. What is Electrix's free cash flow to the firm (FCF) in year 2025? Thanks!
- Return on total assets ratio: net income/ average total assets 21,331/(321,195+225,248)/2= 0.07807= 7.8% (2020 year) 11588/(162,648+225,248)/2= 0.059= 6.0% (2019 year) Write financial analysis report.Selected 2020 balance sheet and income statement information for Vkusno & Tochka Corporation and Tasty Treats, Inc., follows. ($ millions) Vkusno & Tochka Tasty Treats Sales Revenue Interest Expense Net Income Average Total Assets $96,040 $6,090 $27,786 $294,060 28,260 2,715 5,309 32,549 a. Compute the return on assets (ROA) for each company. Use the 25% statutory tax rate. Note: Round your answers to the nearest million dollars. Numerator ($ millions) + Denominator ($ millions) 0+ $ 0+$ Vkusno & Tochka's ROA $ Tasty Treats' ROA $ Vkusno & Tochka's PM $ Tasty Treats' PM Vkusno & Tochka's ROA Tasty Treats' ROA b. Disaggregate ROA into profit margin (PM) and asset turnover (AT) for each company. • Note: Round your answers to the nearest million dollars. $ Vkusno & Tochka's AT $ Tasty Treats' AT $ Numerator ($ millions) + Denominator ($ millions) 0$ 05 0+$ 0+ $ PM X % x % X 0 AT c. Discuss any differences in these ratios for each company. has the lower ROA ratio. has the higher PM ratio.…Computing, Analyzing and Interpreting Residual Operating Income (ROPI) In its annual report for the fiscal year ended July 27, 2019, Cisco Systems reports the following ($ million): Net operating profit after tax (NOPAT) Net operating assets (NOA) beginning July 27, 2019 $3,404 $6,668 Assuming the following weighted average cost of capital (WACC), what is Cisco's residual operating income (ROPI) for the fiscal year ended July 27, 2019? WACC 7.6% ROPI $ 2,896.192 b. At what level of WACC would Cisco not report positive residual operating income for the year? WACC 51 %