Question: This is a follow-up project of a project.
Both the new project instructions and the excel file as well as the solutions for the previous project.
Instructions:
1. Download the Teuer Furniture (A): Discounted Cash Flow Valuation case
a. https://hbr.org/product/teuer-furniture-a-discounted-cash-flow-valuation/KEL778-PDF-ENG
2. Using information from the case and exhibits, complete the following Pro Forma sheets (these are the last 3 tabs in the Excel sheet included with the case)
a. Teuer IS Pro Forma
b. Teuer BS Pro Forma
c. Teuer CFA Pro Forma
3. Write a 1-page executive summary -- This is a one page memo that summarizes your analysis. It should be in paragraph form and address the following:
a. Makes sure you include explanations for your
i. Assumptions;
ii. Input Values
iii. Rationale
b. Discuss your calculated Share price
i. How confident are you in the analysis?
ii. How might you address any concerns affect your confidence level?
Attachment:- homework.rar