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?
Deliverables:
1. Teuer Furniture Excel Spreadsheet
2. 1 Page Executive Summary
3. Put all group members Last Names in both your file names
a. Sulllivan-Smith-Executive Summary.doc
b. Sullivan-Smith-Excel.xlsx
Attachment:- Teuer excelsheets.rar