1. Go through the case ‘Financial Detective’ attached. Also, there are financials of companies at the end of the case. In the case there are 8 industries and 2 companies in each of the industries
2. So, our project is to replicate the same case in Indian context. Choose any 7 out of those 8 industries and 2 Indian companies in each of the industries. The financials must be in the same format as in the case.
3. Basically, the case ‘Financial Detective’ must be replicated in Indian context.
4. Our requirement:
1. Excel sheet:
1 tab: Financials in the same format as given at the end of the case
28 tabs: Financials of all the chosen companies. (Feel free to club the tabs. More than 1 company’s financial can be put in a single tab)
In the 1st tab, as each of them needs to be expressed as a percentage (as in the case). So, the calculation needs to be shown i-e values needs to be taken (linked) from the other 28 tabs.
2. Word file: The case in Indian context i-e 7 industries and 2 companies in each of the industries.