Hey! I have included two files you will need. The first titled TBBC is part 1 of the project. The...

Question

Hey! I have included two files you will need. The first titled TBBC is part 1 of the project. The second file is an example of our lecture 6.

Starting from your Excel file from part 1 of the project, add another worksheet for historical analysis & forecast assumptions. Similar to our lecture 6, you will calculate revenue growth, % or revenue, efficiency measures (Inventory days, etc.) for some income statement and balance sheet items. Then you will make assumptions for these ratios. Below this table, use texts (words) to describe your historical analysis results and explain why you make such assumptions for the next five years of these ratios.
Based on your forecast assumptions, project the next five years of the income statement and balance sheet. Finally, project the statement of cash flow.

Thank you.

tbbc-final-project-geovany-hernandez-mdcriszx.xlsx class-6-financial-statement-forecasting-lecture-geovany-hernandez-jpruidig.xlsx

Riddhi · Accepted Answer

The Boston Beer Company Inc.is the company having its headquarters in Boston and in the business of brewery for beers and selling in retail stores and restaurants. In the current forecast we are forecasting the revenue, financial statements, and cash flow statement for the next 5 years from 2021 based on the data available from 2018 to 2020 for forecasting from 2021 to 2025. 
In assuming the income statement, we assume the revenue growth of 39% from 2021 to 2025 which is the stable growth rate as the case was in 2020.

Hey! I have included two files you will need. The first titled TBBC is part 1 of the project. The second file is an example of our lecture 6. Starting from your Excel file from part 1 of the project,...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment