Case Report 3
Your case report 3 will consist again of one Excel file.
Excel File Requisites.
Once you have the file from case report 2, you will need to create a new tab, the name of this new tab will be FORECAST.
Describe the strategy of your firm in a way that you can identify specifically the future behavior of the revenues, expenses, assets, and liabilities.
See column M inside the FORECAST tab. You must describe the strategy in a way that can be translated into financial numbers. See the 3 most important slides from this particular module, they are included under the TAB FORECAST column T to follow the textbook example.
As you see the example in EXXON, you will need to complete the next five years’ income statements and balance sheet, everything should be related to column M. And follow the mechanics described in column T (the 3 PPT slides from module 11)
The plug-in cell row must be a CASH account in the Balance Sheet.
Your file must be exactly as you see in the Exxon mobile example.
Column M must be elaborated using the latest 2 case reports and according to the actual and future strategic vision of your firm.