🏠 Home How to use e-mentor 🎁 Earn Gifts by Studying
📚 Study Hub
🤖 AI Study PlannerPAID 🔁 Recap Cards ⚔️ 1v1 Study Duels NEW 📋 Test Series 💎 Test Series PackagesTIERS 🎁 Invite FriendsFREE PLANNER 📖 Track Chapters
⚡ Focus & Tools
🎧 Virtual Focus Room LIVE ⏱ Pomodoro Timer 🏆 Leaderboard 🎁 Earn Gifts by Studying
🌐 Community & Info
✍️ Blog ❓ Frequently Asked Questions ℹ️ Read Me First
Login Join Free
📢 UPDATES
📅 25th All India Debate Competition 2026  |  🏆 Leaderboard resets weekly — Keep your streak alive!  |  💡 Join Discussion Board for exam doubt clearing  |  📅 25th All India Debate Competition 2026  |  🏆 Leaderboard resets weekly — Keep your streak alive!  |  💡 Join Discussion Board for exam doubt clearing  | 

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.

Login to Enroll & Start Join Free

📑 Exam Questions

6 Questions • Total 30 Marks

1(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.
Unlock Answers (₹1,000)

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.
Unlock Answers (₹1,000)

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.
Unlock Answers (₹1,000)

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.
Unlock Answers (₹1,000)

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.
Unlock Answers (₹1,000)

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.
Unlock Answers (₹1,000)
Advertisement

Quick Pomodoro Timer

Select a focus duration to launch your session:

25m Standard 50m Deep Focus 15m Quick Sprint
🎧 Join Virtual Focus Room (with 40Hz Audio) →
🔔
Daily Study Reminders
Get notified 15m before your target study sessions.