Question: IF POSSIBLE, PLEASE ANSWER THE TWO QUESTIONS IN THE YELLOW BOXES WITH EXCEL FORMULAS. THANK YOU. 397 We have added the Total Free Cash Flow

IF POSSIBLE, PLEASE ANSWER THE TWO QUESTIONS IN THE YELLOW BOXES

IF POSSIBLE, PLEASE ANSWER THE TWO QUESTIONS IN THE YELLOW BOXES WITH EXCEL FORMULAS. THANK YOU.

397 We have added the Total Free Cash Flow and Discounted Cash Flow in the rightmost column. 398 Note: The discount rate used for the Terminal Value is that of the last year for which a cash flow is explicitly forecasted 399 The value of a company is the Discounted Cash Flow of all future Free Cash Flow 400 Therefore, this company is valued to be $142.86 dollars in the current year. 401 402 You are now going to develop forecasts for this company. 403 If the Growth Rate was 5% and the Discount Rate was 12% what would be the value of the company (DCF)? Enter a value not a formula. 404 405 If the Growth Rate was 0% and the Discount Rate was 6% what would be the value of the company (DCF)? Enter a value not a formula. 397 We have added the Total Free Cash Flow and Discounted Cash Flow in the rightmost column. 398 Note: The discount rate used for the Terminal Value is that of the last year for which a cash flow is explicitly forecasted 399 The value of a company is the Discounted Cash Flow of all future Free Cash Flow 400 Therefore, this company is valued to be $142.86 dollars in the current year. 401 402 You are now going to develop forecasts for this company. 403 If the Growth Rate was 5% and the Discount Rate was 12% what would be the value of the company (DCF)? Enter a value not a formula. 404 405 If the Growth Rate was 0% and the Discount Rate was 6% what would be the value of the company (DCF)? Enter a value not a formula

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!

PLEASE ANSWER asap need all white and yellow boxes with excel formula SECTION I-VALUATION ANALYSIS (30 POINTS) NOTES Question 2 (30 points) Prepare a DCF Analysis given the following assumptions:...

PLEASE ANSWER asap need all white and yellow boxes with excel formula. SECTION I-VALUATION ANALYSIS (30 POINTS) NOTES Question 2 (30 points) Prepare a DCF Analysis given the following assumptions:...

PLEASE ANSWER asap need all white and yellow boxes with excel formula SECTION I-VALUATION ANALYSIS (30 POINTS) NOTES Question 2 (30 points) Prepare a DCF Analysis given the following assumptions:...

Start with the partial model in the file Chos P25 Build a Nodelwax Selected data for the Derby Corporation are shown here. Use the data to answer the questions. 1 INPUTS (In Millions) Year Current...

This have to be completed in the attached spreadsheet . 3-1 Homework: Stock Valuation Calculations This homework submission should include all calculations, completed on the designated tab of the...

Seminar in Finance: Can you please help me figure out how to do the Sensitivity and Scenario analysis? Greatly appreciated! sensitivity analysis: Scenario Analysis: Case - Canyon Buff's Chemical...

Case - Canyon Buff's Chemical Equipment This case is a simple capital budgeting exercise that should reinforce your understanding of the following topics: Incremental unlevered net income Free cash...

Case 1 - Company's] Purchase Decision This case is a simple capital budgeting exercise that should reinforce your understanding of the following topics: Incremental unlevered net income Free cash...

Hi There, I need someone to help me with the attached finance worksheet. There are 3 problems in this excel file - one problem on each individual tab. I am attaching a couple of additional files as...

9. Consider the following integral 2-x2- y2 (22 + V1-x2 + y?) dz dy dx. -V1-x2 JVx2 + y? Which of the following statements are correct? I) The boundary of the projection region of the solid given by...

Ahmed (Tax filler) has find a house at ABC city for sale for $170,000. It is estimated that $90,000 is the value of the land and $80,000 is the value of the house. He is purchasing the house on...

The ability of a business to pay its long - term debts as they come due and to earn a sustainability level of income is referred to as: Question 2 4 options: a ) solvency and leverage b ) solvency...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...