Overview
Read the Harvard Business School Publication Case- Washington Enterprises, Inc: Pro Forma Financial StatementDownload Harvard Business School Publication Case- Washington Enterprises, Inc: Pro Forma Financial Statements. After reading and analyzing the case facts, financial documents, and reviewing the Washington Enterprises, Inc Excel Sheet TemplatDownload Washington Enterprises, Inc Excel Sheet Template, complete the following:
- Based on the assumption sheet provided in the Washington Enterprises, Inc. Excel Sheet Template, create Pro Forma Income Statements (including a statement of profit and loss, a statement of financial position, and statement of cashflows) for the next 3 years. You must provide detailed explanations for all projected calculations (use the "Explanation for Projections" column). Please note, in the Washington Enterprises, Inc. Excel Sheet Template, the "Actual" (2025) column in the Pro Forma tab and "Assumption Sheet" tab (and column) are for reference and data pulling. The "Pro Forma" tab is where your calculations and explanations will be completed.
- Answer the following series of questions regarding the case content. Please be sure to have at least 4 or 5 viable paragraphs to answer each bullet point series of questions. Therefore, you should have a minimum of 8 paragraphs to answer the questions below Critically evaluate the given assumptions. What are the pros and cons of percentage of sales method of forecasting?
- Discuss how the quality of financial projections can be improved by enhancing current methods or alternative analysis methods.