Faculty of Management

Osmania University
Practical Question Bank
BBA ( Business Analytics)
Semester V w.e.f. 2021
COURSE CODE: DSE - 503
COURSE: (B) MARKETING ANALYTICS – I (M)

Total Marks : 35 Record : 10 Marks

Practicals : 20 Marks
Viva Voice: 5 Marks
Record Work:
1. Input: Students must write the procedure/steps for the given
question /problem.
2. Process: Students must write Steps/ Navigations to execute
3. Output: Students must show the Result/Output and interpret the
results.
4. Use Excel

From the link given below, download the data set and answer the questions
Marketing Campaign Data Set – (Link)
1. (i) Name the companies and their count in the data. Show it with pivot table.
(ii) What are the unique categories of Campaign. Give a count of them. Which channel
is used the most.
(iii) Give descriptives of Target Audience.
2. Prepare a Pivot table for target audience and customer segment and the total acquisition
cost for each group.
3. What are the unique categories of Campaign, give a count of them.
4. Average acquisition cost per channel. Give descriptives.
5. Cost per acquisition by campaign type
6. Performance by Location and Language
7. Give an account of Campaign, Channel and acquisition cost. Which is most effective.
8. Which Company, for which Campaign and for which Channel is paying the highest
acquisition cost.
9. Return on Investment by Each Location
10. Conversion Rate by Language. Which is the most effective.
11. What is the Customer Acquisition by Campaign and Time Frame.
12. List out the top 10 performing Campaigns. Give analysis of these Campaigns by
analyzing target audience, channel, language and content type.
13 Give an analysis of Campaign performance by demographics
14. Apply Slice and Dice -
(i) Slice by Channel, Campaign type
(ii) Slice by Language and Location

15. Dice the data by different Metrics

(i) Clicks
(ii) Conversions
(iii) Cost per Acquisition
16. Give your inferences from Slice and Dice of the data.
17. Find the Correlation between Number of clicks and Cost of Acquisition.
18. On what factors does ROI depend. Use Simple Linear Regression Analysis and interpret
the output.
19. On what multiple factors does ROI depend. Use Multiple Regression Analysis and
interpret the output.
20. Explain the variances in Number of Clicks, Impression, Engagement rate, Conversion
Rate, Cost per acquisition and ROI.
Create a Dash board of Market Campaign data.
From the Brand Data given below, download the data set and answer the questions.
–(Link)
21. Analyze Brand Performance by Country
22. Give Descriptives of the given data
23. Which companies have been founded before 2000. Which is the long standing company.
24. Analye the Brand Valuation Trends over time. Calculate the percentage change in brand
valuation for each brand.
25. Name top 10 brands of Electonics, Software industry and their brand value.
26. Give Ranking as per the Brand Value ($M) in 2021, 2022 and 2023. Did the ranking
change or remained the same.
27. Compare the performance of new Vs established brands ( Companies founded before
2010 and after 2010)
28. Create a pivot table and use filters for year, country and genre etc to give inferences on
brand value.
29. Slice the data by Genre/Industry
(i) Top brands by valuation in each genre
(ii) Average brand valuation change for different industries(2022 vs 2023)
(iii) How brand rating varies across industries.
30. Dice by Rank or Rating.
(i) How brand valuation correlates with rank or rating.
(ii) If there are any outliers in terms of valuation compared to rank or rating.
31. Slice by country:
(i) Top Brands by valuation from each country
(ii) Average Brand Valuation Growth by country.
(iii) How brand rating compares across different countries
32. Forecast the brand valuation of the top ten companies for three coming years. Give your
inferences.
33. Which country has the higher brand value and the ratings
34. Do you find any correlation in the brand valuation in 2022 and brand valuation in 2023.
If give your inferences through scatter plot.
35. Give a detail explanation on Brand Valuation with a dash board.
36. The table given below gives the details of sales of different Two Wheeler Companies in
India.
 Find
(i) Company’s market share.
(ii) Find the relative market share of each company.
(iii) Draw a pie chart to show the market share of each company
(iv) Give your inferences.
(v) Give Growth analysis of the company.
(vi) Identify the leaders and laggards.
(vii) How different companies are performing compared to each other.

37. A firm is interested in an experiment to ascertain the effect of advertising on the sale of
its product in different stores. It has devised six treatments A, B, C, D, E and F. There
are four blocks, each containing six stores of comparable sizes. As a result of the
experiment, the following data emerge.

The firm is interested to know if advertisement treatments ( reported in the above table)
have a significant effect on the sale of the product.
( Conduct Two Way ANOVA)
38. Suppose a manufacturer of a breakfast food is interested to know the effectiveness of
three different types of packaging. He puts each kind of packaged breakfast food into
five different stores. He finds that during a given week the number of packages sold
were as follows.
Packaging 1: 25, 28, 21, 30, 26
Packaging 2: 27, 25, 25, 33, 30
Packaging 3: 22, 29, 26, 20, 30
The mean sales of these three packaging are
Packaging 1: 26
Packaging 2: 28
Packaging 3: 24.
The manufacturer would like to know whether the differences among these means are
significant.
( Conduct One way ANOVA)
39. The management of the Punjab National Bank wants to test the effectiveness of an
advertising company that is intending to enhance the awareness of the bank’s service
features. It administered a questionnaire campaign, designed to measure the awareness
of services offered. After the advertising campaign designed to measure the awareness of
services offered. After the advertising campaign, the bank administered the same
questionnaire to the same group of people. Both the before and after advertising
campaign scores are given in the following table.

Test the hypothesis that there is no significant difference in consumer awareness of bank
services offered after the advertising campaign.
(Conduct Paired T-Test)
40. The table given below gives the data on sales of a product, advertising expenditure and
personal selling ( number of selling agents) in respect of eight sales territories. Find the
regression of sales for a given expenditure on advertising and a specific number of
selling agents. Also find the sales, if the advertising expenditure is 80 thousand and
 when the selling agents ae 25 in a territory.
( Conduct Multiple Regression and interpret your results).

41. Given the following data, calculate how number of stores, average store size, number of
employees impact the total revenue of a particular store.

42. For the following data use forecasting tools and forecast the five year future revenue and
also give the forecast summary. Give your interpretations.
43. The given data is the sales data from 1991 to 2020. Use 3 year, 5 year and 7 year
forecasting methods and find the reveue in 2024 by all the three methods.

44. The sales of a company in lakh of rupees for the year 2004 to 2010 are given below.

Estimate the sales figures for the year 2013 and 2015 using an equation of the form
𝑌 = 𝑎𝑏 𝑥 , where X = years and Y = sales.

45. The cost of monthly promotions of a company in (‘000 Rs. ) is given below.
 Find the seasonal variation by the method of monthly averages.

46. Find the seasonal variations by ratio-to trend method from the data given below:

47. Find the seasonal variations by ratio-tp trend method from the data given below:

48. Apply ratio to moving average method to ascertain seasonal indices from the following
data.
49. Prepare a data set of 20 items with their product attributes with colour, material, Price,
product features, marketing claims etc.
50. List the any 5 smart phone attributes and conduct cojoint analysis. Give your inferences.
51. List any 5 Skin care products attributes and conduct cojoint analysis. Give your
inferences.
52. List any 5 smart phone attributes and conduct discrete choice analysis.
 Osmania University
Practical Question Bank
BBA ( Business Analytics)
Semester V w.e.f. 2021
COURSE CODE: DSE - 503
COURSE: (C) HR ANALYTICS – I (HR)

Total Marks : 35 Record : 10 Marks

Practicals : 20 Marks
Viva Voice: 5 Marks
Record Work:
1. Input: Students must write the procedure/steps for the given
question /problem.
2. Process: Students must write Steps/ Navigations to execute
3. Output: Students must show the Result/Output and interpret the
results.
4. Use Excel

Analyze the Employee Data Set –(Link)

1. Calculate basic statistics for numerical variables like age, annual salary, bonus, and years

at the company (mean, median, mode, standard deviation, min, max).

2. How many people are employed in the organization. Use Count IF function to find the

number of employees belonging to each of the departments. Also give your analysis

gender wise.

3. Count the number of different job titles are available and how many employees are there

in each of the job titles.

4. How many analysts are working in the organization. Give an account of Analysts

working in different departments and business units. Insert necessary graph.

5. Give the demographics of the employees. Prepare a dash board in excel.

[Type text]
6. Prepare a Pivot table to summarize the demographics of the employees department wise.

7. What is the salary range of the employees department wise. Insert a graph and give your

inferences.

8. Use AVERAGEIF function to find the average amount of money paid to employees in a

given job title, department or the entire company,

9. Create a chart to visualize the salary distribution.

10. Analyse the pay equity across different demographics like gender or ethnicity, Use Pivot

tables and charts.

11. Give the distribution of employees country wise and their salary.

12. Find the Top five job roles and their salary from which country.

13 Which departments has more US citizens.

14. IF an employee has exited , what was the minimum service he has rendered.

15. To which employees the bonus was announced. Analyse the data and give your

inferences.

16. Give age wise distribution of the employees in the organization in pivot table.

17. Calculate basic statistics for numerical variables like age, annual salary, bonus, and years

at the company (mean, median, mode, standard deviation, min, max).

18. Visualize data using histograms, bar charts, and pie charts to identify patterns and trends.

19. Calculate correlation coefficients between numerical variables (e.g., age and salary, years

at company and job satisfaction) to identify relationships.

[Type text]
20. Create scatter plots to visualize the relationship between two variables.

Analyze the Recruitment Data Set – (Link)

21. Give a brief description of the data set and the different attributes of the data.

22. Evaluate the prevalence of Python experience, other skills gender wise.

23. Evaluate the prevalence of highest qualification among the candidates.

24. Find the correlation between internship and the recruitment outcomes.

25. Analyze the internship on salary and recruitment outcomes.

26. Calculate average time taken from application to offer.

27. Calculate the offer acceptance rate – analyze factors influencing offer acceptance by

salary, location, job role.

28. Find the recruitment channel effectiveness.

29. Establish the relationship between candidate scores and other variables ( experience,

qualifications)

30. Analyze salary offers based on factors like experience qualifications and location.

31. Identify the potential biases in the recruitment process

32. Calculate descriptive statistics for numerical variables.

33. Create histograms, bar charts and scatter plots and other visualization to explore data

patterns.

34. Analyze age Experience Years ad salary.

35. From which source has the highest offer letters released and accepted.

Analyze the Employee Attrition Rate Data set- (Link)

36. Calculate descriptive statistics – mean, median, mode and standard deviation for

[Type text]
 numerical variables.

37. Analyze categorical variables and give inferences.

38. Examine relationships between categorical variables through pivot tables.

39. Identify relationships between numerical variables.

40. Identify factors contributing to work life balance

41. Access the impact of worklife balance on attrition.

42. Calculate average tenure by department and job role.

43. Identify potential talent gaps like age, experience and skills. How is their impact on

Performance rating

44. Identify High-Potential employees based on performance and tenure.

45. Examine salary differences based on job role, department, experience and other factors.

46. Assess trends in salary growth.

47. Correlate performance ratings with other variables

48. Identify factors influencing job satisfaction.

49. Calculate gender wise performance satisfaction with respect to current role and company.

50. What is the percent of salary hike and performance rating and attrition.

51. Compare gender, job satisfaction, monthly income and attrition.

52. Analyze job role, satisfaction and performance rating and percent salary hike on attrition.

53. Calculate attrition rate department wise, job role and other relevant categories.

Prepare a dash board of attrition.

[Type text]
 Faculty of Management
Osmania University
Practical Question Bank
BBA ( Business Analytics)
Semester V w.e.f. 2021
COURSE CODE: DSE - 503
COURSE: (A) FINANCIAL ANALYTICS – I (F)

Total Marks : 35 Record : 10 Marks

Practical’s : 20 Marks
Viva Voice: 5 Marks
Record Work:
1. Input: Students must write the procedure/steps for the given
question /problem.
2. Process: Students must write Steps/ Navigations to execute
3. Output: Students must show the Result/Output and interpret the
results.
4. Use Excel

1. Ambitious enterprises is currently working at 50% capacity and produces 10000

units. At 60% working, raw material cost increases by 2% and selling price falls by
2%.
At 80% capacity, raw material cost increases by 5% and selling price falls by 5%.
At 50% working capacity, the product cost is Rs. 180 per unit and is sold at Rs. 200
per unit.
The unit cost of Rs. 180 is made up as follows:

Prepare a marginal cost statement showing the estimated profit at 60% and
80% capacity.

2. The following figures relate to two products A and B dealt by the firm:

[Type text]
 Prepare a break even chart for each product and find out the break even point.

3. From the following particulars of XYZ company

Plot the following data on a graph (break- even chart) and determine
(a) Break Even Point
(b) Profit if the output is 30000 units
(c) If the present value of sales is Rs. 650000, what is the margin of safety on the
basis of data given.
4. Calculate from the following data (i) value of the output at which the business breaks
even and (ii) the percentage of capacity at which it breaks even:

5. ABC Company Ltd produces and markets industrial containers and packing cases.
Due to competition the company proposes to reduce the selling price. If the present
level of profit to be maintained, indicate the number of units to be sold if the proposed
reduction in selling price is (a) 5% (b) 10% (c) 15% (d) 20%
The following additional information is available

[Type text]
6. A mechanical toy factory presents the following information for the year

The available capacity is a production of 20,000 units per year. The firm has an offer
for the purchase of 5,000 additional units at a price of Rs. 40 per unit. It is expected
that by accepting this offer there will be a saving of Rs. 1 per unit in material cost on
all units manufactured; the fixed overhead will increase by Rs.35000 and the overall
efficiency will drop by 2% on all production.
Draft a report to the management giving your recommendations as to whether this
offer can be accepted.
7. ABC Ltd. Having installed capacity of 1,00,000 units of a product is currently
operating at 60% utilization. At current levels of input prices, FOB unit costs ( after
taking credit for applicable export incentives) work out as follows:

The Company has received three foreign offers from different sources as under:
Source X: 5000 Units @ Rs. 60 per unit FOB
Source Y: 10000 Units @ Rs. 55 Per unit FOB
Source Z: 10000 Units @ Rs. 52 Per unit FOB
Advice the company as to whether any or all the export order should be accepted or
not.

8. The following figures are extracted from the records of XYZ Company Ltd.

[Type text]
 On the basis of the above information, the management is inclined to discard
Department B. What are your inferences.

9. The Directors are contemplating the purchase of a new machine to replace an old one
which has been in the factory for 5 years. From the following information prepare a
statement for submission to the Board of Directors showing the effect of installation
on costs and profits and comment on the results shown. Ignore the interest.

10. The following information at 50% capacity is given. Prepare a flexible budget and
forecast the profit and loss at 60%, 70%, 80% and 90% capacity.

[Type text]
 It is estimated that fixed expenses will increase by 5% above 75% capacity and remain
constant below 75%. Semi Variable Expenses will not change between 45% and 60%
capacity, will rise by 10% between 60% and 75% capacity, a further increase of 5%
when capacity crosses 75%. The estimated sales at various levels of capacity are:

11. The cost of an article at a capacity level of 10000 units is given under A below. For a
variation in capacity above or below this level, the individual expenses vary as
indicated in B below:

[Type text]
 You are required to prepare a flexible budget at production levels of 8000 units, 12000
units and 15000 units.

12. A Corporation Pvt Ltd. Uses 12 different items in the manufacturing process. Their
annual requirement and unit costs are given as follows.

Apply ABC analysis and give a graphical representation.

13. Find out the Economic Order Quantity ( EOQ) from the following particulars and also
show a graph identifying economic order quantity.

14. EXE Limited has received an offer of quantity discount on its order of materials as
under:

[Type text]
 (a) The annual requirement for the material is 5000 tones. The ordering cost per order
is Rs. 1200 and the stock holding cost is estimated at 20% of material cost per
annum. You are required to compute the most economical purchase level.
(b) What will be your answer to the above question if there are no discounts offered
and the price per tonne is Rs. 1500?

15. From the data given below, calculate

(i) Material Cost Variance
(ii) Material Price Variance
(iii) Material Usage

16. A factory is currently working to 50% capacity and produces 10,000 units. Estimate
the profits of the company when it works at 60% and 80% capacity and offer your
inferences.
At 60% working, raw material cost increases by 2% and Selling price falls by 2%.
At 80% working, raw material cost increases by 5% and the Selling Price falls by 4%
At 50% capacity working the product costs Rs. 180 per unit and is sold at Rs. 200 per
unit. The unit cost of Rs. 180 is made up as follows:

[Type text]
17. ABC Ltd manufacturers four brands of toys – A, B, C, D. If the company limits the
manufacture to just one brand, the monthly production will be:
A – 50000 Units
B – 100000 Units
C – 150000 Units
D - 300000 Units
You are given the following information from which you are requested to find out the
profit or loss made on each brand showing clearly the following elements –
(a) Direct Cost
(b) Works Cost
(c) Total cost

Factory overhead expenditure for the month was Rs. 1,62000. Selling and
Distribution cost should be assumed @ 20% of works cost. Factory overhead expenses
should be allocated to each brand on the basis of units which could have been
produced in a month when single brand production was in operation.

18. X Ltd. Has furnished the following information for the month of January 2022.

Calculate all the fixed overhead variances and give your inferences.

19. The particulars obtained from the records of M/s Jeevan Industries for the year 2019
are given below:

[Type text]
 Prepare a cost sheet showing prime cost, factory cost, cost of production, total cost
and sales per unit.
During 2020, the industry expects to receive an order for 5000 units. It is estimated
that
(i) The prices of raw materials and factory wages will rise by 15% and 10%
respectively.
(ii) There will be no change in the total factory overheads and office overheads.
(iii) Selling overheads per unit will remain the same.
Prepare an estimated cost sheet. The factory intends to earn the same rate of
profit on cost.
20. Popeye Company is a metal and wood cutting manufacturer, selling products to the
home construction market. Consider the following data for the month of October
2020.

[Type text]
 Prepare
(i) An income statement with a separate supporting schedule of cost of goods
manufactured.
(ii) For all manufacturing items, indicate by V or F whether each is basically a
variable cost or a fixed cost (where the cost object is a product unit)

21. The following is the Trial Balance of M/s Kasturi Agencies as on 31 st March 2022.
Prepare Profit and Loss Account for the year ending 31st March 2022.

Closing stock is valued at Rs. 18210.

[Type text]
22. From the following information taken from Ved & Co . prepare a Balance Sheet as on
that date taking into consideration the following adjustments.
(i) Closing Stock Rs. 9500
(ii) One Quarter of insurance premium fall in next year
(iii) Provide 10% depreciation on furniture
(iv) Loan to X carries 8% interest p.a.
(v) Loan from Y carries 6% interest p.a.
(vi) Goods worth Rs.500 have been taken by the proprietor for private use
(vii) Provide 5% for bad and doubtful debts
(viii) Salaries include salary to proprietor @Rs. 200 per month

23. The following balances were taken from the books of Shri Ram Prasad on 31 st March
2017.

[Type text]
 Prepare trading and profit and loss account end balance sheet as on 31st March 2017,
after keeping in view these adjustments:
(i) depreciate old buildings at 2 ½ % and new additions to buildings at 2% and
office furniture at 5%.
(ii) Write off further bad debts Rs. 570.
(iii) Increase the bad debts reserve to 6% of debtors.
(iv) On 31st March 2017, Rs. 570 are outstanding for salary
(v) rent receivable Rs. 200.
(vi) Interest on capital at 5%
(vii) on 31st March 2017 stock is valued at Rs.14,290.
(viii) Unix paid insurance Rs. 240
24. The following is the statement of Profit and Loss of Sanyasi Ltd. For the years ended
31st March 2017 and 31st March 2018.

[Type text]
 Prepare a Common Size Statement of Profit and Loss for the years 2017 and 2018 and
interpret your results.

25. The following is the Income Statement of ABC & Co. for the years 2020 and 2021.
Prepare the Common Size Income Statement and give your inferences.

26. Choose any company from screener.in and prepare Common Size Statement for the
Profit and Loss Statement for 5 years data. Interpret the results.

27. Convert the following Balance Sheets into Common Size Balance Sheet and interpret
your results.

[Type text]
28. Convert the given Balance Sheets of the years 2017 and 2018 of the Ved & Co
company. Prepare Common Size Balance Sheet and give your interpretations about
the company and their investments.

29. Choose any company from screener.in and prepare Common Size Statement Balance
Sheet Statement for 5 years data. Interpret the results.

[Type text]
30. The following are the balance sheets of concern as at 31st March 2021 and 2020.
Prepare a comparative Balance sheet and study the financial position of the concern.

31. From the table in Q.25 Prepare a Comparative statement of the Income statement for
years and give your inferences.

32. From the table in Q.27 Prepare a Comparative Balance sheet for the companies and
give your inferences.

33. Choose two different companies from the same sector, from screener.in and prepare a
comparative statement analysis for the year 2023 of Income Statement.

34. Choose any two companies from the same sector, from screener.in and prepare a
comparative statement analysis for the year 2023 of the Balance sheet.

[Type text]
35. The following are the extracts from the Balance sheet of Bhuvan Ltd., as on 31st March
2021.

Calculate and give your comments

(i) Debt-Equity Ratio (Long-term Debt to Equity)
(ii) Proprietary Ratio
(iii) Solvency Ratio
(iv) Fixed Assets to Proprietor’s Funds Ratio
(v) Fixed Assets Ratio
(vi) Current Assets to Proprietors Funds Ratio

36. The following is the Income Statement of X Ltd. As on 31 st March 2020 and 2021.

Calculate the profitability Ratios and Comment on the company’s Financials.

(i) Gross Profit Ratio
(ii) Operating Ratio
[Type text]
 (iii) Expense Ratio
(iv) Net Profit Ratio
(v) Operating Profit Ratio

37. XYZ Limited is an all-equity firm which has an equity capital of Rs. 15,00,000 where
the par value of the share is Rs. 10. The firm is in need of another Rs.36,00,000 to
finance its activities which would generate an EBIT of Rs. 9,00,000 after expansion.
The finance manager has drawn up the following four alternatives.
Alternative (1): Raise the entire amount required as equity
Alternative (2): 50% of the required amount as equity and the remaining as debt
@8%p.a.
Alternative (3): 40% as equity, 30% as debt @ 7.5% and the remaining funds as
preference
share capital @10% rate of dividend.
Alternative (4): 30% as equity, 40% as debt @ 8% pa., and the remaining funds as
preference capital @ 9.5% rate of dividend.
The preference share has a par value of Rs. 100 and the applicable tax rate is 30%.
You are required to advise which of the alternatives is better.

38. From the data given below,

[Type text]
 Calculate
(i) Growth Ratios
(ii) Profitability Ratios
(iii) Activity Ratios
(iv) Solvency Ratios
(v) Liquidity Ratios

39. The table shows the income statement for Tata motors Ltd. for the fiscal years ending
March 2020 through March 2024, which is taken from
https://ticker.finology.in/company/TATAMOTORS.
Profit & Loss (All Figures in Cr. Adjusted EPS in Rs.)

[Type text]
 (i) Forecast the income statement for TATAMOTORS LTD for the fiscal year
ending March 2027.
(ii) Use an appropriate forecasting method to justify your forecasts for each line
item on the income statement.
(iii) Consider factors such as industry trends, economic conditions, and the
company's historical performance when making your forecasts.
(iv) Present your forecasts in a clear and concise format.

40. The table shows the Balance Sheet statement for TATAMOTORS Ltd. for the fiscal
years ending March 2020 through March 2024, which is taken from
https://ticker.finology.in/company/TATAMOTORS.
Balance Sheet (All Figures are in Crores.)

[Type text]
 (i) Forecast the Assets side and Liabilities side for TATAMOTORS LTD for the
fiscal year ending March 2027.
(ii) Use an appropriate forecasting method to justify your forecasts for each line
item on the income statement.
(iii) Consider factors such as industry trends, economic conditions, and the
company's historical performance when making your forecasts.
(iv) Present your forecasts in a clear and concise format.

41. The data given below is the Quarterly report of HDFCBANK Ltd.

[Type text]
42. Conduct vertical analysis for the following data.
Profit & Loss (All Figures in Cr. Adjusted EPS in Rs.)

Give your inferences.

43. Conduct Horizontal Analysis for the following data

Give your inferences.

[Type text]
44. The Table given below is the historical data on Crude Oil Prices on the first Friday of
each month from January 2006 through June 2008. Using Forecasting tools forecast
the demand when the price is 315 along with the forecast sheet for the following data.

45. The following is the total sales in Crores in Rupees of Tata motors Ltd. Forecast the
sales for the next three years through the Forecast tool. Also use Regression analysis
tool to forecast the and give your inferences.

46. Select any company’s Income Statement from screener.in and forecast the Income
statement. Give your inferences.
47. Select any company’s Balance Sheet from screener.in and forecast the Liabilities side
and assets side. Give your inferences.
48. The following data is the U.S. All Grades Retail Gasoline Prices (Dollars per Gallon)

[Type text]
 (i) Find the trends in the oil prices over time.
(ii) Visualize the data in time series graph. Find the upward trend and
downward trend.
(iii) Are there any seasonal patterns in the data.
(iv) Are there any outliers in the data.
(v) Do price tend to fluctuate more in certain times of the year?
(vi) How much of monthly and yearly variances are possible. Interpret your
analysis.
calculate standard deviation to see how much the monthly closing prices deviate from
the average price over this twelve year period. A higher standard deviation indicates
greater volatility, while a lower standard deviation indicates that the prices were more
stable.

49. The balance sheet of R & Co Pvt. Ltd., as on 31 st March 2017 and 2018 are presented
as follows:

Additional Information:
(i) Purchased a new fixed asset costing Rs.25,000 ; Paid Rs. 13000 cash and
gave short term bills for the remainder.

[Type text]
 (ii) Issued additional capital for cash.
(iii)Disposed of a fully depreciated asset having on original cost of Rs. 7000 and
no salvage value.
(iv) Net profit for the year amounted to Rs. 2000 ( after tax)
Prepare cash flow statement and give your inferences.
50. From the following summarized balance sheet of XYZ Ltd., as on 31 st Dec.2018 and
2019 and the Income statement for the year 2019, you are required to prepare the
Cash Flow Statement. All working should form part of your answer.

Additional Information:
(i) Plant having cost of Rs.80 and accumulated depreciation of Rs.60 was sold
for Rs.20
(ii) Foreign Exchange Loss of Rs. 40 represent loss in value of short term
investments.
(iii) Debentures of Rs. 180 were redeemed during the year.
(iv) Out of the interest expense of Rs. 400 , Rs. 170 were paid during the year.
(v) Dividend of Rs. 1200 together with dividend tax at 10% was paid during the
year.
[Type text]
 Prepare the Cash flow statement for the year ending 2019 and give your inferences.

51. Select any company from screener.in, and analyze the cash flow statement, using
variances, ratios and growth rates.
52. Select any company from screener.in, and analyze the cash flow statement, using
variances, ratios and forecast for the next three years.

[Type text]