By Uma Bakshi -
B.Com Business Analytics
Business Applications For Emerging Technologies
2025-26
Q1. Use Microsoft Excel to solve the following:
Use Microsoft Excel to solve the following.
Download a company’s (TATAMOTORS.NS) financial statements like P&L, Balance Sheet, Cash flow etc for the past 10 years  to solve the following questions. 
Download TATAMOTORS.NS financial statements calculate the year-on-year growth rate of revenue.  Create a bar chart to visualize the growth.  Forecast the revenue for next three years.
Step 1: Download 10 Years of Financial Statements
Best source (free): Yahoo Finance
1. Go to Yahoo Finance and search: TATAMOTORS.NS
2. Open the Financials tab → Income Statement
3. Switch to Annual
4. Copy the Total Revenue for the last 10 years
5. Paste into Excel like this:


 
Step 2: Calculate Year-on-Year (YoY) Revenue Growth
Add a new column:
=(B3-B2)/B2
Format as Percentage:
• Select column C
• Home → % (Percentage format)


 
Step 3: Create a Bar Chart for YoY Growth
1. Select Year (A2:A11) and YoY Growth % (C3:C11)
2. Go to Insert → Column or Bar Chart → Clustered Column
3. Add:
o Chart Title: Tata Motors YoY Revenue Growth
o Y-axis: Percentage (%)
4. Optional polish:
o Right-click bars → Add Data Labels
o Format negative years in red
 


Step 4: Forecast Revenue for Next 3 Years (Excel Method 1 – Built-in Forecast)
Assume:
• Year in column A
• Revenue in column B
1. Add future years:
o 2025
o 2026
o 2027
2. Click on the Revenue column (B2:B11)
3. Go to Data → Forecast Sheet
4. Set:
o Forecast end: 2027
o Confidence Interval: Optional
5. Click Create
Excel will generate:
• Forecasted revenue
• Upper & lower bounds
• A forecast chart

 

 


Comments

Post a Comment

Popular posts from this blog

By Uma Bakshi -
Image
ADVANCE DATA VISUALIZATION PRACTICAL QUESTION BANK NOTES (Q11-Q20) B.COM – BUSINESS ANALYTICS SEM V GLOBAL SUPER STORE ORDERS LINK        Global Super Store Data      Import Global Super Store Data from your files.      11. Percentage of total sales for each ‘Ship mode’.              Step1: Click on data           Step2: Click on New Measure on Table Tool Bar           Step3: Enter “ Total Sales = Sum(O rders [S ales ])” and then click                          on tick mark.           Step4: A new field gets added “Total Sales”           Step5: Go to “Report” just above the “Data”         Step6 : Then select the table from Visualizations.       ...
Read more
By Uma Bakshi -
Image
                                                              ADVANCE DATA VISUALIZATION PRACTICAL QUESTION BANK NOTES Questions (1-10) Download and install PowerBI on your desktop. Get Started. Click on Import data from Excel. Import Financial Sample from your files. FINANCIAL SAMPLE LINK           Q1: Percentage of total ‘Gross Sales’ for each Month.                     Step1:  Click on Modelling on tool bar.                                    Click on Quick measure                                    A...
Read more
By Uma Bakshi -
Image
 Data Driven Decision Making B.Com Business Analytics Sem I Questions (6-10) : Python   Q6. Write a program to assign three values to the variables a, b and c            and perform the operations addition, multiplication, ((a+b)+c),          ( a-(b+c)), (a*(b+c)), (a + (b*c)), (a*(b-c)).           #Write a program to assign three values to the variables a, b and c     and perform the operations addition, multiplication, ((a+b)+c),   (a-(b+c)), (a*(b+c)), (a + (b*c)), (a*(b-c)).    a =  int ( input ( 'Enter a number of your choice' ))           b=  int ( input ( 'Enter a number of your choice' ))      c=...
Read more