Question: the hidden information hidden is not needed for the question BASIC DCF MATRIX - HOMEWORK REQUIREMENT: Complete a BASIC DCF EXCEL MATRIX using the following

the hidden information hidden is not needed for the question BASIC

the hidden information hidden is not needed for the question

BASIC DCF MATRIX - HOMEWORK REQUIREMENT: Complete a BASIC DCF EXCEL MATRIX using the following assumption: WACC STUDENT # ENDING IN 1 to 5 TERMINAL GROWTH RATE 1.5% 8% BASIC DCF MATRIX REVENUE % REVENUE GROWTH COSTS % OF REVENUE DEPRECIATION HISTORICAL AVE ASSUMPTION 2017 2018 2019 2020 2021 ACT REV 2016 $ 12,902.00 $15,482.40 $18,578.88 $22,294.66 $26,753.59 $32,104.30 23.48% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% $13,314.86 $15,977.84 $19,173.40 $23,008.08 $27,609.70 83.89% 86.00% 86.00% 86.00% 86.00% 86.00% 86.00% $ 405.64 $ 486.77 $ 584.12 $ 700.94 $ 841.13 2.62% 2.62% 2.62% 2.62% 2.62% 2.62% 2.62% $ 1,761.90 $ 2,114.28 $ 2,537.13 $ 3,044.56 $ 3,653.47 $ 458.09 $ 549.71 $ 659.65 $ 791.59 $ 949.90 30.73% 26.00% 26.00% 26.00% 26.00% 26.00% 26.00% $ 1,303.80 $ 1,564.56 $ 1,877.48 $ 2,252.97 $ 2,703.57 $ 405.64 $ 486.77 $ 584.12 $ 700.94 $ 841.13 % OF REVENUE EBIT TAXES % OF EBT A) EBIT (1-TAX)or NOPAT 1) DEPRECIATION 2) CAPEX $ 1,195.24 $ 1,434.29 $ 1,72115 $ 2,065.38 $ 2,478.45 7.72% 7.72% 7.72% 7.72% 7.72% % OF REVENUE 7.72% 7.72% 3) NON-CASH WORKING CAPITAL $ 207.21 $ 248.65 $ 298.18 $ 358.05 $ 429.66 636.59 $ 306.99 $ 1.656.18$ 278.17 $ 2.00% 368.39 $ 302.47 $ 442.27 $ 329.04 $ 530.49 $ 357.63 $ 10.36% 388.87 $ 7,766.98 B) ENTERPRISE CASH FLOW (FCFF) 1) PV OFFCFF Terminal Growth Rate Terminal Value 2) PV of Terminal Value 3) ASSETS NOT REQUIRED TO GENERATE CASH FLOW c) ENTERPRISE VALUE( VALUE OF FIRM) FUNDED DEBT (INTEREST BARING) CASH & MARKTABLE SECURITIES D) VALUE OF EQUITY Number of Shares Outstanding E) PRICE PER SHARE $ 4,744.54 $ 1,000.00 $ 7,400.72 $ 3,000.00 $ 1,000.00 $ 5,400.72 100.000 54.01

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!

could you do both 10% and 20% BASIC DCF MATRIX - HOMEWORK REQUIREMENT: Complete a BASIC DCF EXCEL MATRIX using the following assumption: WACC STUDENT # ENDING IN 1 to 5 6 to 0 TERMINAL GROWTH RATE...

please do one for 10% and 20% thank you ED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay BASIC DCF MATRIX - HOMEWORK REQUIREMENT: Complete a...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

this is the questionplease help me thanksits a project about renovation one level of a building. project management case . This is a renovation project On the basis of group work as a personal...

Business Research Methodology- Question Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Business Research MethodologyQuestion Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

I have attached the case study and the rubric for this. can I get help here to organzie an answer? CATERPILLAR, INC: THE IMPACT OF DECISION BIASES AND RISK ON CAPITAL BUDGETING Timothy D. West...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

ECO550 Week 7 Discussion Board 7 Predicting Price-Setting Strategies...

Dumping of goods abroad A) constitutes a general case for permanent tariffs B) may be part of a firm's price discrimination strategy C) may be part of a nation's strategy to rectify its trade deficit...

Wastewater is collected from a subdivision of 30 ha area that consists of 500 residential units and 2.5 ha of commercial centre. The generated wastewater discharges in the wet well which has two...

40. Price per Liter of Gasoline. Suppose that the mean retail price per liter of regular grade gasoline in the United States is $0.91 with a standard deviation of $.03 and that the retail price per...

1 points Multiple Choice share diverse experiences. believe in personal control of destiny. seek high levels of achievement. be motivated to learn.

4 What does a competency- based approach to training and development entail?

6 Compare and contrast mentoring and coaching.

1 Coaching can be very effective as a form of individual development. What should companies do to ensure that the learning that occurs is helpful for the group and organisation as a whole? During the...