Using the DCF methodology required in question 1, please take one of your suggestions and reevaluate the

Question:

Using the DCF methodology required in question 1, please take one of your suggestions and reevaluate the buy-out. To complete this question, you will have to present a second Excel template that includes your new assumed values and supports your recommendations. Further, please comply with the following:

Assumptions must be reasonable – i.e., do not select arbitrary values. Some discussion should be provided that explain how you arrived at your new assumed values.

Variable changes should be restricted to the discount rate, the FCFs, and/or the terminal value. Please present only one set of assumptions (e.g., do not submit a table that includes multiple values for the same variables.)

For more information on creating Excel Spreadsheets, please visit the Excel Lab

Only one excel template is required. I have used two for illustration purpose

1) Change in discount rate from 13% to 18%

2) Decrease in FCF and Terminal cash flow by 10%

Discount Rate
Depending upon the context, the discount rate has two different definitions and usages. First, the discount rate refers to the interest rate charged to the commercial banks and other financial institutions for the loans they take from the Federal...