Create three scenarios for scenario inputs given. Outputs are Terminal Value and Enterprise Value Create a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create three scenarios for scenario inputs given. Outputs are Terminal Value and Enterprise Value Create a Data Table that shows sensitivity of Enterprise Value to two input parameters of your choice from: Gross margin, Revenue Growth in years 1-5, steady growth after year 5 or discount rate. Do conditional formatting for data tables Gross Margin Fixed Costs Revenue Growth Rate for Years 1-5 FCF Steady Growth Discount Rate Year 1 Revenue Tax Rate Terminal Year Revenues Gross profits Fixed Costs Net Operating Income Taxes Free Cash Flow NPV for Years 1-5 Cash Flows Terminal Value (as of Year 5) PV of Terminal Value Enterprise Value Current 30% $1,500.00 12% $5,000.00 21% 653.905 4,357.23 2,472.409 3,126.314 1 5,000 1,500 -1,500 0 0 Optimistic 60% $1,000 20% 5% 8% $10,000 Scenario Inputs Base Case 2 5,400 1,620 -1.500 120 -25.2 94.8 40% $1,250 10% 3% 12% $7,500 Pessimistic 30% $1,500 5% 1% 16% $5,000 5,832 6,298.56 6,802.445 1,749,6 1,889.568 2,040.733 -1,500 249.6 -52.416 197.184 -1,500 -1,500 389.568 540.733 -81.809 -113.554 307.759 427.179 Create three scenarios for scenario inputs given. Outputs are Terminal Value and Enterprise Value Create a Data Table that shows sensitivity of Enterprise Value to two input parameters of your choice from: Gross margin, Revenue Growth in years 1-5, steady growth after year 5 or discount rate. Do conditional formatting for data tables Gross Margin Fixed Costs Revenue Growth Rate for Years 1-5 FCF Steady Growth Discount Rate Year 1 Revenue Tax Rate Terminal Year Revenues Gross profits Fixed Costs Net Operating Income Taxes Free Cash Flow NPV for Years 1-5 Cash Flows Terminal Value (as of Year 5) PV of Terminal Value Enterprise Value Current 30% $1,500.00 12% $5,000.00 21% 653.905 4,357.23 2,472.409 3,126.314 1 5,000 1,500 -1,500 0 0 Optimistic 60% $1,000 20% 5% 8% $10,000 Scenario Inputs Base Case 2 5,400 1,620 -1.500 120 -25.2 94.8 40% $1,250 10% 3% 12% $7,500 Pessimistic 30% $1,500 5% 1% 16% $5,000 5,832 6,298.56 6,802.445 1,749,6 1,889.568 2,040.733 -1,500 249.6 -52.416 197.184 -1,500 -1,500 389.568 540.733 -81.809 -113.554 307.759 427.179
Expert Answer:
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these accounting questions
-
After years of steady growth in net income, The Performance Drug Company sustained a loss of $1.6 million in 2015. The loss was primarily due to $5 million in expenses related to a product recall....
-
Given the following data on inputs and outputs at a work center, determine the cumulative deviation and the backlog for each time period. The beginning backlog is7. PERIOD Input Planned2 Actua2 200...
-
Table 3-6 gives data on X (net profits after tax in U.S. manufacturing industries [$, in millions]) and Y (cash dividend paid quarterly in manufacturing industries [$, in millions]) for years 1974 to...
-
In September, Larson Inc. sold 45,000 units of its only product for $438,000, and incurred a total cost of $405,000, of which $43,000 was fixed costs. The flexible budget for September showed total...
-
During the prior-year audits of McKimmon Inc., a private company, the auditor did tests of controls for all relevant financial statement assertions. Some of the related controls are manual while...
-
A virtual machine is generated from a physical server by which method in a P2V migration?
-
For each of the following sets of numbers, calculate a \(95 \%\) confidence interval for the mean ( \(\sigma\) not known); before going through the steps in calculating the confidence interval, the...
-
An importer of childrens toys, Fun N Games, Inc., receives a price quotation from a German toy maker offering toy train sets: KBG train sets. Locomotive. Four cars. Transformers. Thirty pieces of...
-
SportsWorld purchased equipment costing $10,000. The equipment has a residual value of $1,000, and an estimated useful life of 5 years or 36,000 shoes. Actual units produced during the year were...
-
Bedco manufactures bed sheets and pillowcases which it supplies to a major hotel chain. It uses a just-in-time system and holds no inventories.The standard cost for the cotton which is used to make...
-
1 Write statement(s) to add a text field named userName to a frame named registration. [2 pts] Question2 Write code for a lotto program. Declare an array of the winning numbers. Name the array...
-
William and Nancy Liebhart together own three houses on the same block in Watertown, Wisconsin. Besides a few other houses, the rest of the block was previously occupied by an abandoned transformer...
-
In January 2013, Wesley Erik Hawley met Denise T. Reed. The two became romantically involved in March 2013 and eventually were engaged to be married. Mr. Hawley was a widower and a thoroughbred horse...
-
Highland Marketplace obtained a \($28,000,000\) loan from First Community Bank in September 2007. The loan was secured by real estate located in Highland, Utah. Highland utilized the loan proceeds to...
-
Wawel Savings Bank entered into a loan agreement with Jersey Tractor Trailer Training (JTTT), Inc., for the amount of $315,000. In the agreement, JTTT pledged all capital equipment and assets of the...
-
In June 2014, Penn State Hershey Medical Center and PinnacleHealth System signed a letter of intent for a proposed merger. Hershey is located in Hershey, in Dauphin County in Pennsylvania and...
-
Warm Their Feet, producers of durable locally made suede boots intend to close down their PR unit and allow only the Advertising and Marketing units to function with the excuse that the Advertising...
-
Give the structural formulas of the alkenes that, on ozonolysis, give: a. (CH3)2C=O and CH2=O b. Only (CH3CH2)2C=O c. CH3CH=O and CH3CH2CH=O d. O=CHCH2CH2CH2CH=O
-
Suppose a queueing system fitting the M/M/ 1 model has W = 120 minutes and L = 8 customers. Use these facts (and the formula for W) to find and . Then find the various other measures of performance...
-
Use Risk Solver Platform for Education to formulate and solve the model shown in Problem 2.13 in a spreadsheet. Refer to problem 2.13 You are given the following linear programming model in algebraic...
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
Take the company you chose for question 2 (or choose another), and search for information about the company's social and environmental responsibility practices. Some companies publish annual...
-
As technology becomes more pervasive, new and complex ethical issues have arisen in the workplace, which have contributed to ethical and, at times, legal challenges for employers and employees....
-
Warren Buffett is a world-famous investor and CEO of conglomerate Berkshire Hathaway, which includes companies as diverse as Kraft Heinz, Geico Auto Insurance, and Benjamin Moore Paints. Buffett...
Study smarter with the SolutionInn App