Using the excel results for Adobe (ADBE), complete the forecasted financial model for 2021 to 2025 for
Fantastic news! We've Found the answer you've been seeking!
Question:
- Using the excel results for Adobe (ADBE), complete the forecasted financial model for 2021 to 2025 for free cash flow and enterprise value.Add short term growth rates for the next 5 years to the model.
- Compare results of the model for the company's value and stock price to the actual value and stock price.What explains the differences?
Please show excel results and formulas
Transcribed Image Text:
Sales growth Current assets/Sales Current liabilities/Sales Net fixed assets/Sales Other long term assets/Sales Other long term liabilitis/Sales Cost of goods sold/Sales R&D/Sales Sales&Marketing/Sales Administration Amortization of intangible assets Depreciation rate Cash/Sales Debt/Assets Interest rate on debt Interest paid on cash & mkt. sec. Tax rate Dividend growth Year Income statement, unit in million Sales COGS R&D Sales & Marketing Administration Amortization of intangible assets Depreciation Interest expense Taxes Net income Dividend to shareholders Year Balance sheet, unit in million Cash and cash equivalents Current assets Fixed assets Goodwill Other long term assets Total assets Current liabilities Debt Other long term liabilities Common stock Total liabilities and equity 7.57% 63.30% 42.83% 34.14% 15.80% 10.81% 13.38% 17.00% 27.91% 7.52% 1.26% 5.50% 34.80% 16.95% 2.73% 0.00% 2.30% 0.00% 2021 $13,355 $1,787 $2,271 $3,727 $1,005 $168 $734 $365 $307 $2,991 $0 2021 $4,647 $8,454 $4,559 $10,742 $2,110 $30,513 $5,721 $4,117 $1,444 $13,264 $24,545 2022 $14,366 $1,922 $2,443 $4,009 $1,081 $181 $790 $392 $330 $3,218 $0 2022 $4,999 $9,094 $4,904 $10,742 $2,270 $32,010 $6,154 $4,117 $1,553 $13,264 $25,088 2023 $15,454 $2,068 $2,628 $4,313 $1,162 $195 $849 $422 $355 $3,462 $0 2023 $5,378 $9,783 $5,276 $10,742 $2,441 $33,620 $6,620 $4,117 $1,670 $13,264 $25,671 2024 $16,623 $2,225 $2,827 $4,639 $1,250 $209 $914 $454 $382 $3,724 $0 2024 $5,785 $10,523 $5,675 $10,742 $2,626 $35,352 $7,121 $4,117 $1,797 $13,264 $26,299 2025 $17,882 $2,393 $3,041 $4,990 $1,345 $225 $983 $488 $411 $4,005 $0 2025 $6,223 $11,320 $6,105 $10,742 $2,825 $37,214 $7,660 $4,117 $1,933 $13,264 $26,974 Sales growth Current assets/Sales Current liabilities/Sales Net fixed assets/Sales Other long term assets/Sales Other long term liabilitis/Sales Cost of goods sold/Sales R&D/Sales Sales&Marketing/Sales Administration Amortization of intangible assets Depreciation rate Cash/Sales Debt/Assets Interest rate on debt Interest paid on cash & mkt. sec. Tax rate Dividend growth Year Income statement, unit in million Sales COGS R&D Sales & Marketing Administration Amortization of intangible assets Depreciation Interest expense Taxes Net income Dividend to shareholders Year Balance sheet, unit in million Cash and cash equivalents Current assets Fixed assets Goodwill Other long term assets Total assets Current liabilities Debt Other long term liabilities Common stock Total liabilities and equity 7.57% 63.30% 42.83% 34.14% 15.80% 10.81% 13.38% 17.00% 27.91% 7.52% 1.26% 5.50% 34.80% 16.95% 2.73% 0.00% 2.30% 0.00% 2021 $13,355 $1,787 $2,271 $3,727 $1,005 $168 $734 $365 $307 $2,991 $0 2021 $4,647 $8,454 $4,559 $10,742 $2,110 $30,513 $5,721 $4,117 $1,444 $13,264 $24,545 2022 $14,366 $1,922 $2,443 $4,009 $1,081 $181 $790 $392 $330 $3,218 $0 2022 $4,999 $9,094 $4,904 $10,742 $2,270 $32,010 $6,154 $4,117 $1,553 $13,264 $25,088 2023 $15,454 $2,068 $2,628 $4,313 $1,162 $195 $849 $422 $355 $3,462 $0 2023 $5,378 $9,783 $5,276 $10,742 $2,441 $33,620 $6,620 $4,117 $1,670 $13,264 $25,671 2024 $16,623 $2,225 $2,827 $4,639 $1,250 $209 $914 $454 $382 $3,724 $0 2024 $5,785 $10,523 $5,675 $10,742 $2,626 $35,352 $7,121 $4,117 $1,797 $13,264 $26,299 2025 $17,882 $2,393 $3,041 $4,990 $1,345 $225 $983 $488 $411 $4,005 $0 2025 $6,223 $11,320 $6,105 $10,742 $2,825 $37,214 $7,660 $4,117 $1,933 $13,264 $26,974
Expert Answer:
Answer rating: 100% (QA)
Answer Year 0 1 2 3 4 5 Income Statement Sales 50000 55000 60500 66550 73205 80526 Costs of Goods So... View the full answer
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780135811603
5th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
In Problem 10.16, we projected financial statements for Walmart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 12.17-12.19 (pages 948-950) include the actual amounts for 2012...
-
Seven years ago, after 14 years in public accounting, Sylvia Banks, CPA, resigned her position as managers of cost systems for Coastal Bend CPA and started National Software, Inc. In the 2 years...
-
The following question is designed to highlight key concepts from the Loyalty Programs topic article titled, "StarBUCKS, Loyalty, and Breakage" (Nevraumont 2019). Q. Author's position. "If you hire...
-
A construction company employs three sales engineers. Engineers 1, 2, and 3 estimate the costs of 30%, 20%, and 50%, respectively, of all jobs bid by the company. For i = 1, 2, 3, define Ei to be the...
-
You are given the equation(s) used to solve a problem. For each of these, a. Write a realistic problem for which this is the correct equation(s). b. Finish the solution of the problem. |(9.0 x 10...
-
A cabin uses approximately \(25 \mathrm{~kW}\) of electricity per day. What size solar system would be needed to fuel \(90 \%\) of the
-
On January 1, 2012, Payne Corporation purchased a 75% interest in Salmon Company for $585,000. A summary of Salmon Companys balance sheet on that date revealed the following: The equipment had an...
-
I need help solving Exercise 1. Consider the function f(x, y) = y? - 6xy + 10x3. Which of the following points, if any (and possibly more than one) lie on f(x, y) - 5? (1,1), (1, 5), (2,9)
-
Suppose there is a credit market imperfection due to limited commitment. As in the setup with collateralizable wealth we examined in this chapter, each consumer has a component of wealth which has...
-
Assignment 1: Myths and Media Part 1) Read through the list of True/False survey questions O How many of the 'FALSE' items did you think were true? Which ones? How many of the 'TRUE' items did you...
-
When inputting an answer, round your answer to the nearest 2 decimal places. If you need to use a calculated number for further calculations, DO NOT round until after all calculations have been...
-
A project manager is arguing that his project is positive NPV and thus should be invested in right away.You ask for the details and find that it is a very risky project where much of the uncertainly...
-
The city council is conducting a cost-benefit analysis for a new bridge. The construction materials for the bridge will cost $100 million. The maintenance costs are estimated at $6 million per year....
-
Column array origPriceTable cotains the price per pound of various deli items. Column array changePrice indicates price adjustments for a given column. Assign newPriceTable with origPriceTable plus...
-
Consider data center network (DCN) architecture designs. What is the difference between 3-Tier DCN and a fat tree DCN? Which type is more costly to implement?
-
on WinCo Inc. purchases 11,250 litres of a material each year from a single supplier. Currently, the company obtains materials in batches of 2,250 litres. The material costs $7.50 per litre, the cost...
-
Under what conditions is the following SQL statement valid?
-
The machine in Problem 1 will generate incremental revenues of $4 million per year along with incremental costs of $1.2 million per year. If Dailys marginal tax rate is 21%, what are the incremental...
-
How is an exchange rate used?
-
If Jims adjusts its payout policy to 70% of net income, how will the net new financing change? the following income statement and balance sheet for Jims Espresso Income Statement Sales Costs Except...
-
Distinguish between Maximax, Maximin, and Minimax regret decision-making models. Ex- plain why the attitude of the decision maker towards risk taking influences which model he/she would be...
-
Discuss the assumptions underlying probabilistic cost-volume-profit analysis.
-
Explain the reasons why overproducing a good may lead to real costs. How does un- derproducing a good differ from overproducing? Discuss the nature of the costs involved.
Study smarter with the SolutionInn App