Question: Please answer using excel. Thank you Q1.: At the beginning of its fiscal year 2021, an analyst made the following forecast for Generic Inc., the

Please answer using excel. Thank you

Please answer using excel. Thank you Q1.: At the beginning of its

fiscal year 2021, an analyst made the following forecast for Generic Inc.,

Q1.: At the beginning of its fiscal year 2021, an analyst made the following forecast for Generic Inc., the consumer foods company, for 2021-2023 (in millions of dollars): 2021F 1,714 2022F 1,677 Free cash flow to equity holders 2023F 1,653 2024F 1,637 Use a required return of 9 percent. Assume that free cash flow will grow at 3 percent per year after 2024. Develop an Excel template to calculate the following: a) present value of FCFE over 2021-2024. b) present value of the terminal value of FCFE beyond 2024 c) total value of the firm d) Generic had 369 million shares outstanding at the end of 2020, trading at $47 per share. Calculate value per share. e) Based on the given data, what should be the investment strategy? Q2.: The valuation assumptions about FMA Inc. are provided as follows. Suppose the cost of equity is 6% and FCFE will grow at a constant rate of 2% beyond 2022. 2020 2021F 2022F Net Profit Working Capital Net long-term operating assets Net Debt 25,000 23,000 26000 56,000 52,000 51000 180,000 190,000 195000 75,000 76,000 78000 Develop an Excel template to calculate the following: a) free cash flow to equity (FCFE) for the forecast period. b) present value of FCFE over 2021-2022. c) present value of the terminal value of FCFE beyond 2022 d) total value of the firm e) FMA had 75000 shares outstanding at the end of 2020, trading at $7 per share. Calculate value per share. f) Based on the given data, what should be the investment strategy? Q3.: Forecast the income statement and balance sheet of DCG for FY 2021, FY2022 and FY2023. Based on the forecasts, estimate DCG's share value using DCF valuation model. Develop an Excel template to estimate the following: a) cost of equity b) terminal growth rate c) present value of FCFE in 2021, 2022 and 2023 d) present value of the terminal value of FCFE beyond 2023 e) present value of FCFE f) share value estimate (source the weighted average of shares outstanding from DatAnalysis) g) investment strategy

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q1.: At the beginning of its fiscal year 2021, an analyst made the following forecast for Generic Inc., the consumer foods company, for 20212023 (in millions of dollars): 2021F 2022F 2023F 2024F Free...

Q1.: At the beginning of its fiscal year 2021, an analyst made the following forecast for Generic Inc., the consumer foods company, for 2021-2023 (in millions of dollars): 2021F 2022F 2023F 2024F...

Please answer those blank spaces with yellow highlights at the end. Thank you!!! Step 1: Data collection Nike, Inc.'s Fiscal Year 2021 Total Revenue: $44.5 billion Nike, Inc.'s Total Debt: $12.657...

Business, Management Whole Foods Market's Generic & Intensive Growth Strategies Updated Sep 16, 2015 Andrew Thompson Whole Foods Market generic strategy, intensive growth strategies, Porter model,...

can you please help me out with this assignment case study with the question ? UVA-F-1553 CALIFORNIA PIZZA KITCHEN Everyone knows that 95% of restaurants fail in the first two years, and a lot of...

The Case - Protect a Case Corporation Protect A Case Corporation (PAC) is a newly established, small privately held retail business that sells a standard phone case at competitive prices. The company...

Help please! I am trying to organize a paper to analyze an SEC 10K for the Pfizer company for a final project but I do not know where to start. Attached is the SEC 10K report, and I have to use three...

Please help me with the questions below. Thank you! Answer the questions below for this year and last year, using your SEC 10-K: Link to SEC...

in part (i) please make reference to how to calculate the continuing value and show all steps to get answers please. 2. At the beginning of its fiscal year 2006, an analyst made the following...

A company allocates $7.50 overhead to each unit produced. the company uses a Plantwide overhead rate with direct labor hours as the allocation base. given the amounts below, how many direct labor...

A CIO said that while he would not use a public network such as the Internet with an ASP for some types of ISs, he would allow employees to use the web for other types, such as an accounting...

In Chapter 8 of the textbook reading, the "Financial Literacy for My Life" section describes various frauds or scams. How can individuals protect themselves from falling victim to one of these...

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...