Ch 11: DATA ANALYSIS AND MODELLING (PAGES 617-644) — Previous Year Exam Questions (PYQ)
Intermediate
📚 Financial Management & Business Data Analytics
📖 Ch.11 — DATA ANALYSIS AND MODELLING (PAGES 617-644)
⭐ V1: Previous Year Question (PYQ)
⚡ Free Mode (Answers Locked)
⏱ Duration: 54 Mins
🎯 Total Marks: 30
Passed at: 12 Marks
Max Attempts: 10
⚖️ Statutory Applicability: AY 2026-27 & Current Institute Curriculum
Answer ALL questions. Working notes / statutory sections must form part of the answers.
📑 Exam Questions
6 Questions • Total 30 Marks1(a): Process, Benefits and Types of Data Analysis
5 Marks
Option I vs Option II - Incremental Analysis
End of Year
Operating Profits
PV factor
PV of cash profits (₹)
100000
0.870
87,000
100000
0.756
75,600
160000
0.658
1,05,280
180000
0.572
1,02,960
200000
0.497
99,400
Total
3.353
4,70,240
New Machine Vs Upgraded Machine.
Operating Profits
₹ 4,70,240
Depreciation shield
(800000 - 400000) x 40% = 160000 with annuity
factor 3.353 = 3.353 x 160000
₹ 5,36,480
Salvage value
(1000000 - 50000) x 60% = 570000 @ PVF 0.497
₹ 2,83,290
Incremental cost of
new machine
20,00,000 with PV factor 1(20,00,000)
Sale value of old
machine
60% x 1 lac, PV 1
₹ 60,000
Decrease in NPV with
new machine
₹ 6,49,990
Decision : Continue with the upgraded machine, Option 1
SUGGESTED_ANSWERS TO QUESTIONS_SYL2016_DEC2017_PAPER-14
Academics Department, The Institute of Cost Accountants of India (Statutory Body under an Act of Parliament) Page 11
Analysis - Continue without upgrade vs upgrade old machine
₹
Increase in operating profits
1,00,000 x annuity factor
5 years =100000x3.353
3,35,300
Depreciation shield
400000 x 40% x 3.353
5,36,480
Salvage value at yr 5 end
50000 x 60% x 0.497
14,910
Sub Total - Incremental benefits over upgrade
886690
Incremental cost of upgrade
20,00,000 x 1
(20,00,000)
Net disadvantage of upgrade
11,13,310
Conclusion: Do not upgrade. Continue with the old machine as it is.
(b) (i) Theoretical Minimum Price: Present value of Exercise price - Current stock price
= 210 x e-rt - 190
= 210 x e-0.05×0.5 - 190
= 210 x e-0.025 - 190
= 210 x 0.9753 - 190
= 204.813 - 190
= 14.813
Since value of put option is more than price of put option, recommended action
is buy put option.
Arbitrage Process:
₹
Borrow for spot purchase of stock and the put option
190 + 10
Amount including interest (continuous compounding)
200 xe0.025 =
1.02532x200
205.06
(ii) Price on exercise day is 200
Action : Exercise put option, sell for 210
Gain after repayment of borrowal
210-205.06
4.94
(iii) Price on exercise day is 220
Action : Let the put lapse. Sell in spot market and get 220
Gain after repayment of borrowal
220-205.06
14.94
Thus the minimum gain is 4.94 even if the spot price on exercise day falls below
the strike price. If the price rises, the gain would be 4.94 + (difference between the
spot price on exercise day and 210).
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
1(b): Process, Benefits and Types of Data Analysis
5 Marks
(i)
Analysis of Cash Saving and NPV of Cash inflow
(Amount in D)
Old Machine
New Machine
Difference
Price
400000
750000
Shipping and Installation
60000
Original life
Current Life
Original Salvage value
150000
Current Salvage Value (Cash)
220000
Not Applicable
Book Value
200000
810000
Increase in raw materials
30000
Depreciation
40000
132000
(-)92000
Salaries
290000
290000
Maintenance
100000
70000
30000
Marginal tax rate
34 %
Required return
15 %
CASH FLOWS Replacement
D
Annual Cash-flow After tax Saving
211200
Depreciation tax Benefit
31280
Total Cash Flows after tax
242480
Calculation of Net Present Value:
D
Operating Cash Inflow from 1 to 5 years
812841
Add: PV of Terminal Cash Flow
89496
PV of Total Cash Inflow
902337
Less: Initial Outlay
626800
Net Present Value (NPV)
2,75,538
(ii)
Advice :
Since Net Present Value (NPV) of Cash inflows is positive (+ D 275538), the Company should consider to
replace the existing machine by a New Machine.
2 of 10
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
2(a): Process, Benefits and Types of Data Analysis
5 Marks
:
(i)
Assessment of expected cash flow for each project:
Project A
Scenario
Cash Inflow
(₹)
Probability
Contribution
(₹)
Pessimistic
7,00,000
0.2
1,40,000
Most Likely
9,50,000
0.5
4,75,000
Optimistic
12,00,000
0.3
3,60,000
Expected Inflow (A)
9,75,000
Project B
Scenario
Cash Inflow
(₹)
Probability
Contribution
(₹)
Pessimistic
5,00,000
0.3
1,50,000
Most Likely
10,00,000
0.4
4,00,000
Optimistic
14,00,000
0.3
4,20,000
Expected Inflow (B)
9,70,000
(ii)
Analysis of coefficient of variation for each project
Coefficient of Variation (CV) = Standard Deviation / Expected Cashflow
CV-Project A = 1,80,000/9,75,000 = 0.1846
CV-Project B = 2,50,000 / 9,70,000 = 0.2577
(iii)
Assessment of coefficient of variation for industry:
Project
Expected
Inflow (₹)
Standard
Deviation (₹)
CV
X
8,00,000
1,60,000
0.2000
Y
10,00,000
2,20,000
0.2200
Z
9,00,000
1,80,000
0.2000
Industry Benchmark-CV
0.2067
(iv)
Recommendation:
Project A’s CV (0.1846) is better than the industry benchmark (0.2067), while Project B (0.2577) is
riskier. Therefore, Project A should be selected.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
2(b): Analytics and Model Building (Descriptive, Diagnostic, Predictive, Prescriptive)
5 Marks
Narrate the assumptions of the Black-scholes Option Pricing Model.
Answer:
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
3(a): Process, Benefits and Types of Data Analysis
5 Marks
(i)
Weighted Average Portfolio Beta:
Security
No. of Shares
(Lakh)
MPS (₹ )
Total Value
(₹ In Lakh)
Beta
Product
in Lakh
AS Ltd.
4.50
2250
1.40
3150
BM Ltd.
6.00
4500
1.20
5400
ZM Ltd.
3.00
1.60
1200
13.50
7500
9750
7500
9750
=
Beta
Portfolio
= 1.30
(ii)
Assessment of Government Securities to be acquired for Beta (β ) = 0.975
Particulars
BETA
Amount
Product
Govt. Securities
O
χ
O
Other Securities
1.30
1 –χ
1.3– 1.3χ
Total
1.3– 1.3χ
( )
3.1
3.1
.0
χ
β
Beta
Portfolio
−
=
=
Or, 0.975 = 1.3 – 1.3 χ
3.1
.0
=
χ
= 0.25 i.e. 25 %
Amount to be invested in Govt. Securities = 7500 x 0.25 = ₹ 1875 Lakh
(iii)
No. of shares to be disposed off
Security
M.V. of investment
(₹ In Lakh)
Value of Disposed off
(₹ In Lakh) 25%
MPS
(₹)
No. of Shares to be
disposed off (in Lakh)
AS Ltd.
2250
562.50
1.125
BM Ltd.
4500
1125.00
1.50
ZM Ltd.
187.50
0.75
Total
7500
1875.00
3.375
(iv)
Analysis of Number of NIFTY Contracts to be bought / Sold:
No. of NIFTY Contracts.
Contracts.
2437500
243750000
x
24375
0.975
1.3
x
750000000
=
=
−
No. of NIFTY Contracts to be sold = 100 Contracts
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
3(b): Process, Benefits and Types of Data Analysis
5 Marks
Analysis of Standard Deviation for each project
Coefficient of Variation (CV) = Standard Deviation / Expected Cashflow
Standard Deviation = Coefficient of Variation (CV) * Expected Cashflow
Project X: 0.28 × 13,20,000 = ₹3,69,600
Project Y: 0.40 × 13,60,000 = ₹5,44,000
(iii)
Assessment of NPV of the project
Project X :
PV = 13,20,000 × 2.444 = ₹32,26,080
NPV = 32,26,080 – 30,00,000 = ₹2,26,080
Project Y :
PV = 13,60,000 × 2.322 = ₹31,57,920
NPV = 31,57,920 – 30,00,000 = ₹1,57,920
(iv)
Recommendation:
Project X has lower risk (CV) and higher NPV compared to Project Y. Hence, Project X should be
selected.
🔒 Official Model Solution
Model answers and self-evaluation solutions are available in the Premium Tier & Rankers Plan.
Advertisement