Pro Forma Financial Statements and Financial Forecasting

Read the Harvard Business School Publication Case- Taste Good Limited: Preparing Pro Forma Financial Statements Download Harvard Business School Publication Case- Taste Good Limited: Preparing Pro Forma Financial Statements. After reading and analyzing the case facts, financial documents, and reviewing the Taste Good Limited Excel Sheet Template Download Taste Good Limited Excel Sheet Template, complete the following: Based on the assumption sheet provided in the Taste Good Limited Excel Sheet Template, create Pro Forma Income Statements (including a statement of profit and loss and a statement of financial position) for the next 4 years. You must provide detailed explanations for all projected calculations (use the “Explanation for Projections” column). Please note, in the Taste Good Limited Excel Sheet Template, the “Year 2021 Actual” and “Assumption Sheet” tabs are for reference and data pulling. The “Pro Forma Student Template” 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. Assignment Guidelines: Please see Chapter 3 (specifically textbook pages 79-95) to review instructions, formulas, and content for creating Pro Forma Financial Statements. You are required to use the Taste Good Limited Excel Sheet Template to create these Pro Forma Financial Statements (Part 1), please see page 91 of the textbook for guidance and instructions for Excel calculation input. Pro Forma Financial Statements template must be uploaded as an excel sheet. This allows me to view your formula inputs and calculations. Please submit Part 2 (questions) of the assignment in Word Doc or PDF format. Please note that if Part 1 and 2 are not submitted in each of their the requested formats, then they will not be graded. See the Case Project Rubric Or download the rubric here Case Project Rubric.pdf