SVKM’s NMIMS

School of Business Management

Programme: MBA Batch: 2022 - 2024

Academic Year: 2023 – 2024 Subject: Wealth Management
Date: 07 December 2023 Time: 11:00 to 13:00 Duration: - 2 Hrs

N.B.:-

1. There are four questions in this paper. All questions are compulsory.

2. Each question carries10 marks.

3. For answering the questions use of this excel book is only allowed.

4. Access to Internet / intranet is prohibited.

5. Each question has been provided in the designated excel sheet for that question.

6. Answer each question in the designated excel sheet for that question.

7. While answering the question don’t leave unnecessary space.

8. Cover your answer area by thick box border in the same way as questions are covered

9. While answering do not change question data.

 Semester: V
Marks: 40
Duration: - 2 Hrs

et for that question.

y as questions are covered

Q1: Mr Rohvir an employee at JCL ltd approached you for his retirement planning. His annual expenses
today are Rs. 10 lakh out of which Rs. 2 lakh are health related expenses and rest of Rs. 8 lakh are
general expenses. However he is committed to change his living standard and thereby reduce the general
expenses to 75% of current general expenses but health expenses are expected to increase by 50%. He is
currently 32 years old and is expected to retire at 65. He life expectancy si 80 years. Expected overall
inflation rate is 5%. The return on retirement corpus is expected to be 7%. You are required to:

a. Solve the case to arrive at inflation adjusted annual expenses of client at the time of retirement. 2 Marks

b. Appraise Rohvir about the retirement corpus required to finance the expenses of non-earning life. 3 Marks
c. He is currently investing Rs. 12000 pm in large cap equity oriented funds which are expected to
generate a return of 12% annually. Ralate and find out if this investment enough to finance his retirement
corpus. 3 Marks
d. Judge the rate of retrun that Rohvir needs so as to finance his retirement corpus adequately,
considering that he can invest only Rs. 12000 pm? 2 Marks

Answer:

Current Age 32
Retirement Age 65
Life Expectancy 80

No. of years to retire 33

No. of years post retirement 15

Part(a)
Health Expenses 200,000
General Expenses 800,000
Total expenses 1,000,000
Adjustments:
General expenses reduction % 75%
Expenses will be 600000

Increase % in Health Expenses 50%

Health Expenses will be 300000

Total ADJUSTED Expenses 900000

Inflation rate 5%
Inflation Adjusted Expenses Anually ₹ 4,502,869.69

Part(b)
No. of year post retirement 15
Return on Retirement Corpus 7%
Inflation rate 5%
Inflation adjusted rate 1.90%
nper 15
Type 1
PMT ₹ 4,502,869.69
Retirement Corpus needed annually ₹ 59,382,901.91

Part(c)
Investment 12000
Expected return 12.0%
Inflation adjusted rate 1.90%
No. of years 33
His investment will value at retirement ₹ 60,522,749.51

Since the future value of investment is more than the retirement corpus needed as calculated in part (b),
His investment is enough.
Part (d)
Amount he can invest 12000
Retirement corpus @12% return ₹ 60,522,749.51
Rate 12.00%
nper 33
PV 4502869.69
Retirement corpius needed ₹ 59,382,901.00
Required Rate of return can be 1%
years
years
years
per month
per month
Q2: Chandan, aged 35 years, is working as a faculty mamber in a management institute with an annual sala
65 years. His wife is aged 30 years and has a life expectancy up to age 70. He has a life insurance for Rs 1
Chandan would like to have an emergency fund of Rs.5,00,000/- and also to create education fund for his t
younger child are Rs.12,00,000/- in todays terms. He will be required to spend on higher education when th
He has an outstanding loan of Rs.10,00,000/- on his house property, currently valued at Rs.80,00,000/-. Be
Candan agreed.
Chandan wishes to provide the present income to the family for 1 year in case of his untimely death. Then
period of his spouse.
Chandan wants to know whether he is adequately insured, and, in case if not, what is the additional amoun
Demonstrate the use of need based approach and appraise Chandan about the requirement of additional lif

Answer:

Age of Chandan 35
Retirement age 65
No. of years to retirement 30

Age of wife 30
Life expectancy 70

Life insurance currently 10,000,000.00

Value of present investment 550,000
Balance at bank 50,000

Fund he wants to have 500,000

Education expenses
Elder child 1,000,000.00
Younger child 1,200,000.00
Inflation rate 5.50%
Future education expenses after adjusting inflation:
Elder child 1708144.458354
Younger child 2539309.754204
Total Education expenses 4,247,454.21
Loan Details:
Oustanding Loan 1,000,000
Current Value of the Loan 800,000

Rate of return 8%
Inflation in next 35 years 4%
ute with an annual salary of Rs. 14,00,000/-. He is married and has two children aged 8 years and 4 years and is expected to retir
life insurance for Rs 1 Crore at present. Value of his present investments (in his name) is Rs.5,50,000/- and balance at bank is Rs
ducation fund for his two children. In present times, the college expenses for the kind of education he wants for elder child are R
gher education when the child turns of 18. Education inflation in India on an average is assumed to be 5.5%.
at Rs.80,00,000/-. Being a mortgage loan, the bank had insisted for a loan protection insurance at the time of disbursement of lo

untimely death. Then onwards, 75% of his present income till elder child attains age of 18 and 50% of present income for the rem

the additional amount of life insurance required. Assume the rate of return at 8% and average inflation over the next 35 years to
ement of additional life insurance.
and is expected to retire at the of age of
d balance at bank is Rs.50,000/-
ts for elder child are Rs.10,00,000/- and
%.
e of disbursement of loan to which

sent income for the remaining surviving

ver the next 35 years to be 4%.

10 Marks
Q3: Mr. X is a citizen of USA and a person of African origin. Appraise him about his residential status
with the help of the following data of his stay in India for the Assessment Year 2023-24.
F.Y.
2022-23
2021-22
2020-21
2019-20
2018-19

Also assess which of the following incomes will be taxable in his hands:-
Partiulars of Income
Income from house property from Mumbai house
Amount of gift received in Delhi from Indian friend above exemption limit
Income from Denmark Business received in Denmark.Business is controlled from india
Income from sale of agricultural land in Japan
Income earned in Paris in previous yr 2011-12. Remitted in India Now

Investigate about the sensitivity of above income items w.r.t. different residential status one accessee ca
asssume.

Answer:
Assesment Year
Details given:
F.Y.
2022-23
2021-22
2020-21
2019-20
2018-19

Conditions

Basic Condition 1 (The person should have stayed in INDIA for 182 days in the PY)
Basic Condition 2 (The person should have stayed in India for last 60 days in the
precedding PY and additionally should have stayed for 365 days in India in the last 4
PPYs)

Additional Condition 1 (the person should have stayed at least 2 years in the last 10 years
preceding the Previous year)

Additional Condition 2 (The person should have stayed for 730 days in the last 10
preceeding PYs)
 All the basic conditions and additional conditions should have been satisfied for him to be the c
fully. Hence, MR. X is not a citizen of INDIA.

The code table is as follows:

Category
Income received in india
Income accrued in india
Income deemed to be received in India
Income deemed to be accrued in India
Income other than the above (Business set up and Controlled in India)
Income other than A1,A2,A3,A4,B1
Income generated oustide India or Agricultural Income

Partiulars of Income
Income from house property from Mumbai house
Amount of gift received in Delhi from Indian friend above exemption limit
Income from Denmark Business received in Denmark.Business is controlled from india
Income from sale of agricultural land in Japan
Income earned in Paris in previous yr 2011-12. Remitted in India Now
out his residential status
2023-24.
Days
71
208
11
70
110

Amount INR
5000000
75000
25000000
30000000
50000

al status one accessee can

10 Marks

2023-2024

Days
71
208
11
70
110

No. of Days Condition fulfilled (yes/no)

71 NO

470 YES

399 NO

399 NO
fied for him to be the citizen of india but, none of the conditions satisfied
not a citizen of INDIA.

Code OR ROR RNOR

A1 Taxable Taxable Taxable
A2 Taxable Taxable Taxable
A3 Taxable Taxable Taxable
A4 Taxable Taxable Taxable
B1 Taxable Taxable Non-Taxable
B2 Taxable Non-Taxable Non-Taxable
O Non-Taxable Non-Taxable Non-Taxable

Amount INR Code OR ROR RNOR

5000000 A3 5000000 5000000 5000000
75000 A2 75000 75000 75000
25000000 B2 25000000 0 0
30000000 O 0 0 0
50000 O 0 0 0
Q4: Mr. XMan, aged 25, is a manager earning Rs 12,00,000 annually. He is planning to marry Yeti and they plan
11,00,000 in student loans, borrowed at 10% for 8 years, 12 months back, whose repayment starts after 12 months
month. They plan to purchase a home for Rs 1,00,00,000 next year, partly financed by his parents by Rs 50,00,000
on the house and cars totals Rs 20,000 annually. Health and life insurance, cost them Rs 25,000 annually. Mr. XM
and has another Rs 4,00,000 in a equity index mutual fund (12% annual return expected). Mrs. XMan has Gold w
return. She drives a three-year-old Car for which she paid Rs 3,00,000, worth 2,50,000 now and would be worth R
monthly payment for the Car Loan is Rs 10,000. Mr. X drives a six-year-old Car worth Rs 3,00,000 now (Rs, 2,50
of 50,000 for the current year. Income tax at 15% overall for Mr Xman, and nothing for Yeti.

(a) Appriase Mr & Mrs.. Xman about their total assets and liabilities & net worth this year? Next year?
(b) Ascertain the monthly payout on their mortgage?
(c) Examine if Mr Xman take mortgage loan provided the bank only funds upto EMI of 35% of take home salary
would he get the loan?

Answer

PART (A)
For current year,
Partticulars
Income of Mr. Xman
Gold with Mrs. Xman
Student loan @10% for 8 years Mrs. Xman
Income of Mrs. X
Car and House Insurance
Health and Life insurance
Savings in Account (Mr. Xman)
Equity index Mutual fund (Mr. Xman)
Car of Mrs. XMAN
Car Loan
Car of Mr. X

Monthly Expenses

Tax
Net worth of both

For next year,

Partticulars
Income of Mr. Xman
Gold with Mrs. Xman
Student loan @10% for 8 years Mrs. Xman
Income of Mrs. X
Car and House Insurance
Health and Life insurance
Savings in Account (Mr. Xman)
Equity index Mutual fund (Mr. Xman)
Car of Mrs. XMAN
Home
Car of Mr. X
Monthly Expenses
Home Loan
Tax
Net worth of both

Student Loan CALCULATION

Rate
Tenure
Principal
EMI
Amt paid up in 1 year
Oustanding student loan
 techt and owes Rs
,00,000 annually from next
for 20 years. The insurance
count (3.5% annual interest)
d is giving 10% annual
0,000 on her car loan. The
Consider monthly expenses

3+3 Marks
2 Marks
2 Marks

Assets Liabilities Total Principal

1,200,000.00 1,200,000.00 interest rate
1,200,000.00 1,200,000.00 Tenure
1,100,000.00 -1,100,000.00 NPER
700,000.00 700,000.00 Adjusted int. rate
20,000 -20,000.00 MORTGAGE SCHEDULE

25000 -25,000.00 No. of payments

300,000 300,000.00 1
400000 400,000.00 2
250,000 250,000.00 3
100,000 -100,000.00 4
300,000 300,000.00 5

50,000 -50,000.00 6

285,000.00 -285,000.00 7
2,770,000.00 8
9
10
11
12
Assets Liabilities Total 13
1,200,000.00 1,200,000.00 14
1,320,000.00 1,320,000.00 15
₹ 899,701.03 -899,701.03 16
700,000.00 700,000.00 17
20,000 -20,000.00 18
25000 -25,000.00 19
310,500 310,500.00 20
448000 448,000.00 21
225,000 225,000.00 22
10,000,000 23
250,000 250,000.00 24
50,000 -50,000.00 25
5,000,000 26
293,775.00 -293,775.00 27
3,165,023.97 28
29
30
31
10% 32
8 33
1,100,000 34
₹ 16,691.58 35
₹ 200,298.97 36
₹ 899,701.03 37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
 PART(b)
5,000,000
8.50%
20 years
240 Hence, monthly payout on Mortgage is Rs. 43,391.16
0.71%
GAGE SCHEDULE
Acummulated outstanbding
EMI INTEREST PRINCIPAL principal paid up principal
₹ -43,391.16 ₹ -35,416.67 ₹ -7,974.50 ₹ -7,974.50 ₹ 4,992,025.50
₹ -43,391.16 ₹ -35,360.18 ₹ -8,030.98 ₹ -16,005.48 ₹ 4,983,994.52
₹ -43,391.16 ₹ -35,303.29 ₹ -8,087.87 ₹ -24,093.34 ₹ 4,975,906.66
₹ -43,391.16 ₹ -35,246.01 ₹ -8,145.16 ₹ -32,238.50 ₹ 4,967,761.50
₹ -43,391.16 ₹ -35,188.31 ₹ -8,202.85 ₹ -40,441.35 ₹ 4,959,558.65

₹ -43,391.16 ₹ -35,130.21 ₹ -8,260.95 ₹ -48,702.30 ₹ 4,951,297.70

₹ -43,391.16 ₹ -35,071.69 ₹ -8,319.47 ₹ -57,021.77 ₹ 4,942,978.23

₹ -43,391.16 ₹ -35,012.76 ₹ -8,378.40 ₹ -65,400.17 ₹ 4,934,599.83
₹ -43,391.16 ₹ -34,953.42 ₹ -8,437.75 ₹ -73,837.92 ₹ 4,926,162.08
₹ -43,391.16 ₹ -34,893.65 ₹ -8,497.51 ₹ -82,335.43 ₹ 4,917,664.57
₹ -43,391.16 ₹ -34,833.46 ₹ -8,557.70 ₹ -90,893.14 ₹ 4,909,106.86
₹ -43,391.16 ₹ -34,772.84 ₹ -8,618.32 ₹ -99,511.46 ₹ 4,900,488.54
₹ -43,391.16 ₹ -34,711.79 ₹ -8,679.37 ₹ -108,190.83 ₹ 4,891,809.17
₹ -43,391.16 ₹ -34,650.31 ₹ -8,740.85 ₹ -116,931.67 ₹ 4,883,068.33
₹ -43,391.16 ₹ -34,588.40 ₹ -8,802.76 ₹ -125,734.43 ₹ 4,874,265.57
₹ -43,391.16 ₹ -34,526.05 ₹ -8,865.11 ₹ -134,599.55 ₹ 4,865,400.45
₹ -43,391.16 ₹ -34,463.25 ₹ -8,927.91 ₹ -143,527.46 ₹ 4,856,472.54
₹ -43,391.16 ₹ -34,400.01 ₹ -8,991.15 ₹ -152,518.61 ₹ 4,847,481.39
₹ -43,391.16 ₹ -34,336.33 ₹ -9,054.84 ₹ -161,573.44 ₹ 4,838,426.56
₹ -43,391.16 ₹ -34,272.19 ₹ -9,118.97 ₹ -170,692.41 ₹ 4,829,307.59
₹ -43,391.16 ₹ -34,207.60 ₹ -9,183.57 ₹ -179,875.98 ₹ 4,820,124.02
₹ -43,391.16 ₹ -34,142.55 ₹ -9,248.62 ₹ -189,124.60 ₹ 4,810,875.40
₹ -43,391.16 ₹ -34,077.03 ₹ -9,314.13 ₹ -198,438.72 ₹ 4,801,561.28
₹ -43,391.16 ₹ -34,011.06 ₹ -9,380.10 ₹ -207,818.83 ₹ 4,792,181.17
₹ -43,391.16 ₹ -33,944.62 ₹ -9,446.55 ₹ -217,265.37 ₹ 4,782,734.63
₹ -43,391.16 ₹ -33,877.70 ₹ -9,513.46 ₹ -226,778.83 ₹ 4,773,221.17
₹ -43,391.16 ₹ -33,810.32 ₹ -9,580.85 ₹ -236,359.67 ₹ 4,763,640.33
₹ -43,391.16 ₹ -33,742.45 ₹ -9,648.71 ₹ -246,008.38 ₹ 4,753,991.62
₹ -43,391.16 ₹ -33,674.11 ₹ -9,717.05 ₹ -255,725.44 ₹ 4,744,274.56
₹ -43,391.16 ₹ -33,605.28 ₹ -9,785.88 ₹ -265,511.32 ₹ 4,734,488.68
₹ -43,391.16 ₹ -33,535.96 ₹ -9,855.20 ₹ -275,366.52 ₹ 4,724,633.48
₹ -43,391.16 ₹ -33,466.15 ₹ -9,925.01 ₹ -285,291.53 ₹ 4,714,708.47
₹ -43,391.16 ₹ -33,395.85 ₹ -9,995.31 ₹ -295,286.84 ₹ 4,704,713.16
₹ -43,391.16 ₹ -33,325.05 ₹ -10,066.11 ₹ -305,352.95 ₹ 4,694,647.05
₹ -43,391.16 ₹ -33,253.75 ₹ -10,137.41 ₹ -315,490.36 ₹ 4,684,509.64
₹ -43,391.16 ₹ -33,181.94 ₹ -10,209.22 ₹ -325,699.58 ₹ 4,674,300.42
₹ -43,391.16 ₹ -33,109.63 ₹ -10,281.53 ₹ -335,981.11 ₹ 4,664,018.89
₹ -43,391.16 ₹ -33,036.80 ₹ -10,354.36 ₹ -346,335.48 ₹ 4,653,664.52
₹ -43,391.16 ₹ -32,963.46 ₹ -10,427.70 ₹ -356,763.18 ₹ 4,643,236.82
₹ -43,391.16 ₹ -32,889.59 ₹ -10,501.57 ₹ -367,264.75 ₹ 4,632,735.25
₹ -43,391.16 ₹ -32,815.21 ₹ -10,575.95 ₹ -377,840.70 ₹ 4,622,159.30
₹ -43,391.16 ₹ -32,740.30 ₹ -10,650.87 ₹ -388,491.57 ₹ 4,611,508.43
₹ -43,391.16 ₹ -32,664.85 ₹ -10,726.31 ₹ -399,217.88 ₹ 4,600,782.12
₹ -43,391.16 ₹ -32,588.87 ₹ -10,802.29 ₹ -410,020.17 ₹ 4,589,979.83
₹ -43,391.16 ₹ -32,512.36 ₹ -10,878.80 ₹ -420,898.97 ₹ 4,579,101.03
₹ -43,391.16 ₹ -32,435.30 ₹ -10,955.86 ₹ -431,854.83 ₹ 4,568,145.17
₹ -43,391.16 ₹ -32,357.69 ₹ -11,033.47 ₹ -442,888.30 ₹ 4,557,111.70
₹ -43,391.16 ₹ -32,279.54 ₹ -11,111.62 ₹ -453,999.92 ₹ 4,546,000.08
₹ -43,391.16 ₹ -32,200.83 ₹ -11,190.33 ₹ -465,190.25 ₹ 4,534,809.75
₹ -43,391.16 ₹ -32,121.57 ₹ -11,269.59 ₹ -476,459.84 ₹ 4,523,540.16
₹ -43,391.16 ₹ -32,041.74 ₹ -11,349.42 ₹ -487,809.26 ₹ 4,512,190.74
₹ -43,391.16 ₹ -31,961.35 ₹ -11,429.81 ₹ -499,239.07 ₹ 4,500,760.93
₹ -43,391.16 ₹ -31,880.39 ₹ -11,510.77 ₹ -510,749.84 ₹ 4,489,250.16
₹ -43,391.16 ₹ -31,798.86 ₹ -11,592.31 ₹ -522,342.15 ₹ 4,477,657.85
₹ -43,391.16 ₹ -31,716.74 ₹ -11,674.42 ₹ -534,016.57 ₹ 4,465,983.43
₹ -43,391.16 ₹ -31,634.05 ₹ -11,757.11 ₹ -545,773.68 ₹ 4,454,226.32
₹ -43,391.16 ₹ -31,550.77 ₹ -11,840.39 ₹ -557,614.07 ₹ 4,442,385.93
₹ -43,391.16 ₹ -31,466.90 ₹ -11,924.26 ₹ -569,538.33 ₹ 4,430,461.67
₹ -43,391.16 ₹ -31,382.44 ₹ -12,008.72 ₹ -581,547.06 ₹ 4,418,452.94
₹ -43,391.16 ₹ -31,297.38 ₹ -12,093.79 ₹ -593,640.84 ₹ 4,406,359.16
₹ -43,391.16 ₹ -31,211.71 ₹ -12,179.45 ₹ -605,820.30 ₹ 4,394,179.70
₹ -43,391.16 ₹ -31,125.44 ₹ -12,265.72 ₹ -618,086.02 ₹ 4,381,913.98
₹ -43,391.16 ₹ -31,038.56 ₹ -12,352.60 ₹ -630,438.62 ₹ 4,369,561.38
₹ -43,391.16 ₹ -30,951.06 ₹ -12,440.10 ₹ -642,878.72 ₹ 4,357,121.28
₹ -43,391.16 ₹ -30,862.94 ₹ -12,528.22 ₹ -655,406.94 ₹ 4,344,593.06
₹ -43,391.16 ₹ -30,774.20 ₹ -12,616.96 ₹ -668,023.90 ₹ 4,331,976.10
₹ -43,391.16 ₹ -30,684.83 ₹ -12,706.33 ₹ -680,730.23 ₹ 4,319,269.77
₹ -43,391.16 ₹ -30,594.83 ₹ -12,796.33 ₹ -693,526.57 ₹ 4,306,473.43
₹ -43,391.16 ₹ -30,504.19 ₹ -12,886.97 ₹ -706,413.54 ₹ 4,293,586.46
₹ -43,391.16 ₹ -30,412.90 ₹ -12,978.26 ₹ -719,391.80 ₹ 4,280,608.20
₹ -43,391.16 ₹ -30,320.97 ₹ -13,070.19 ₹ -732,461.99 ₹ 4,267,538.01
₹ -43,391.16 ₹ -30,228.39 ₹ -13,162.77 ₹ -745,624.76 ₹ 4,254,375.24
₹ -43,391.16 ₹ -30,135.16 ₹ -13,256.00 ₹ -758,880.76 ₹ 4,241,119.24
₹ -43,391.16 ₹ -30,041.26 ₹ -13,349.90 ₹ -772,230.66 ₹ 4,227,769.34
₹ -43,391.16 ₹ -29,946.70 ₹ -13,444.46 ₹ -785,675.12 ₹ 4,214,324.88
₹ -43,391.16 ₹ -29,851.47 ₹ -13,539.69 ₹ -799,214.82 ₹ 4,200,785.18
₹ -43,391.16 ₹ -29,755.56 ₹ -13,635.60 ₹ -812,850.42 ₹ 4,187,149.58
₹ -43,391.16 ₹ -29,658.98 ₹ -13,732.19 ₹ -826,582.60 ₹ 4,173,417.40
₹ -43,391.16 ₹ -29,561.71 ₹ -13,829.46 ₹ -840,412.06 ₹ 4,159,587.94
₹ -43,391.16 ₹ -29,463.75 ₹ -13,927.41 ₹ -854,339.47 ₹ 4,145,660.53
₹ -43,391.16 ₹ -29,365.10 ₹ -14,026.07 ₹ -868,365.54 ₹ 4,131,634.46
₹ -43,391.16 ₹ -29,265.74 ₹ -14,125.42 ₹ -882,490.95 ₹ 4,117,509.05
₹ -43,391.16 ₹ -29,165.69 ₹ -14,225.47 ₹ -896,716.43 ₹ 4,103,283.57
₹ -43,391.16 ₹ -29,064.93 ₹ -14,326.24 ₹ -911,042.66 ₹ 4,088,957.34
₹ -43,391.16 ₹ -28,963.45 ₹ -14,427.71 ₹ -925,470.38 ₹ 4,074,529.62
₹ -43,391.16 ₹ -28,861.25 ₹ -14,529.91 ₹ -940,000.29 ₹ 4,059,999.71
₹ -43,391.16 ₹ -28,758.33 ₹ -14,632.83 ₹ -954,633.12 ₹ 4,045,366.88
₹ -43,391.16 ₹ -28,654.68 ₹ -14,736.48 ₹ -969,369.60 ₹ 4,030,630.40
₹ -43,391.16 ₹ -28,550.30 ₹ -14,840.86 ₹ -984,210.46 ₹ 4,015,789.54
₹ -43,391.16 ₹ -28,445.18 ₹ -14,945.99 ₹ -999,156.45 ₹ 4,000,843.55
₹ -43,391.16 ₹ -28,339.31 ₹ -15,051.85 ₹ -1,014,208.30 ₹ 3,985,791.70
₹ -43,391.16 ₹ -28,232.69 ₹ -15,158.47 ₹ -1,029,366.77 ₹ 3,970,633.23
₹ -43,391.16 ₹ -28,125.32 ₹ -15,265.84 ₹ -1,044,632.61 ₹ 3,955,367.39
₹ -43,391.16 ₹ -28,017.19 ₹ -15,373.98 ₹ -1,060,006.59 ₹ 3,939,993.41
₹ -43,391.16 ₹ -27,908.29 ₹ -15,482.88 ₹ -1,075,489.46 ₹ 3,924,510.54
₹ -43,391.16 ₹ -27,798.62 ₹ -15,592.55 ₹ -1,091,082.01 ₹ 3,908,917.99
₹ -43,391.16 ₹ -27,688.17 ₹ -15,702.99 ₹ -1,106,785.00 ₹ 3,893,215.00
₹ -43,391.16 ₹ -27,576.94 ₹ -15,814.22 ₹ -1,122,599.22 ₹ 3,877,400.78
₹ -43,391.16 ₹ -27,464.92 ₹ -15,926.24 ₹ -1,138,525.46 ₹ 3,861,474.54
₹ -43,391.16 ₹ -27,352.11 ₹ -16,039.05 ₹ -1,154,564.51 ₹ 3,845,435.49
₹ -43,391.16 ₹ -27,238.50 ₹ -16,152.66 ₹ -1,170,717.17 ₹ 3,829,282.83
₹ -43,391.16 ₹ -27,124.09 ₹ -16,267.07 ₹ -1,186,984.25 ₹ 3,813,015.75
₹ -43,391.16 ₹ -27,008.86 ₹ -16,382.30 ₹ -1,203,366.55 ₹ 3,796,633.45
₹ -43,391.16 ₹ -26,892.82 ₹ -16,498.34 ₹ -1,219,864.89 ₹ 3,780,135.11
₹ -43,391.16 ₹ -26,775.96 ₹ -16,615.20 ₹ -1,236,480.09 ₹ 3,763,519.91
₹ -43,391.16 ₹ -26,658.27 ₹ -16,732.90 ₹ -1,253,212.99 ₹ 3,746,787.01
₹ -43,391.16 ₹ -26,539.74 ₹ -16,851.42 ₹ -1,270,064.41 ₹ 3,729,935.59
₹ -43,391.16 ₹ -26,420.38 ₹ -16,970.78 ₹ -1,287,035.20 ₹ 3,712,964.80
₹ -43,391.16 ₹ -26,300.17 ₹ -17,090.99 ₹ -1,304,126.19 ₹ 3,695,873.81
₹ -43,391.16 ₹ -26,179.11 ₹ -17,212.06 ₹ -1,321,338.24 ₹ 3,678,661.76
₹ -43,391.16 ₹ -26,057.19 ₹ -17,333.97 ₹ -1,338,672.22 ₹ 3,661,327.78
₹ -43,391.16 ₹ -25,934.41 ₹ -17,456.76 ₹ -1,356,128.98 ₹ 3,643,871.02
₹ -43,391.16 ₹ -25,810.75 ₹ -17,580.41 ₹ -1,373,709.38 ₹ 3,626,290.62
₹ -43,391.16 ₹ -25,686.23 ₹ -17,704.94 ₹ -1,391,414.32 ₹ 3,608,585.68
₹ -43,391.16 ₹ -25,560.82 ₹ -17,830.35 ₹ -1,409,244.67 ₹ 3,590,755.33
₹ -43,391.16 ₹ -25,434.52 ₹ -17,956.64 ₹ -1,427,201.31 ₹ 3,572,798.69
₹ -43,391.16 ₹ -25,307.32 ₹ -18,083.84 ₹ -1,445,285.15 ₹ 3,554,714.85
₹ -43,391.16 ₹ -25,179.23 ₹ -18,211.93 ₹ -1,463,497.08 ₹ 3,536,502.92
₹ -43,391.16 ₹ -25,050.23 ₹ -18,340.93 ₹ -1,481,838.01 ₹ 3,518,161.99
₹ -43,391.16 ₹ -24,920.31 ₹ -18,470.85 ₹ -1,500,308.86 ₹ 3,499,691.14
₹ -43,391.16 ₹ -24,789.48 ₹ -18,601.68 ₹ -1,518,910.54 ₹ 3,481,089.46
₹ -43,391.16 ₹ -24,657.72 ₹ -18,733.44 ₹ -1,537,643.99 ₹ 3,462,356.01
₹ -43,391.16 ₹ -24,525.02 ₹ -18,866.14 ₹ -1,556,510.13 ₹ 3,443,489.87
₹ -43,391.16 ₹ -24,391.39 ₹ -18,999.78 ₹ -1,575,509.90 ₹ 3,424,490.10
₹ -43,391.16 ₹ -24,256.80 ₹ -19,134.36 ₹ -1,594,644.26 ₹ 3,405,355.74
₹ -43,391.16 ₹ -24,121.27 ₹ -19,269.89 ₹ -1,613,914.15 ₹ 3,386,085.85
₹ -43,391.16 ₹ -23,984.77 ₹ -19,406.39 ₹ -1,633,320.54 ₹ 3,366,679.46
₹ -43,391.16 ₹ -23,847.31 ₹ -19,543.85 ₹ -1,652,864.39 ₹ 3,347,135.61
₹ -43,391.16 ₹ -23,708.88 ₹ -19,682.28 ₹ -1,672,546.67 ₹ 3,327,453.33
₹ -43,391.16 ₹ -23,569.46 ₹ -19,821.70 ₹ -1,692,368.37 ₹ 3,307,631.63
₹ -43,391.16 ₹ -23,429.06 ₹ -19,962.10 ₹ -1,712,330.48 ₹ 3,287,669.52
₹ -43,391.16 ₹ -23,287.66 ₹ -20,103.50 ₹ -1,732,433.98 ₹ 3,267,566.02
₹ -43,391.16 ₹ -23,145.26 ₹ -20,245.90 ₹ -1,752,679.88 ₹ 3,247,320.12
₹ -43,391.16 ₹ -23,001.85 ₹ -20,389.31 ₹ -1,773,069.19 ₹ 3,226,930.81
₹ -43,391.16 ₹ -22,857.43 ₹ -20,533.74 ₹ -1,793,602.93 ₹ 3,206,397.07
₹ -43,391.16 ₹ -22,711.98 ₹ -20,679.18 ₹ -1,814,282.11 ₹ 3,185,717.89
₹ -43,391.16 ₹ -22,565.50 ₹ -20,825.66 ₹ -1,835,107.77 ₹ 3,164,892.23
₹ -43,391.16 ₹ -22,417.99 ₹ -20,973.18 ₹ -1,856,080.95 ₹ 3,143,919.05
₹ -43,391.16 ₹ -22,269.43 ₹ -21,121.74 ₹ -1,877,202.68 ₹ 3,122,797.32
₹ -43,391.16 ₹ -22,119.81 ₹ -21,271.35 ₹ -1,898,474.03 ₹ 3,101,525.97
₹ -43,391.16 ₹ -21,969.14 ₹ -21,422.02 ₹ -1,919,896.05 ₹ 3,080,103.95
₹ -43,391.16 ₹ -21,817.40 ₹ -21,573.76 ₹ -1,941,469.81 ₹ 3,058,530.19
₹ -43,391.16 ₹ -21,664.59 ₹ -21,726.57 ₹ -1,963,196.38 ₹ 3,036,803.62
₹ -43,391.16 ₹ -21,510.69 ₹ -21,880.47 ₹ -1,985,076.85 ₹ 3,014,923.15
₹ -43,391.16 ₹ -21,355.71 ₹ -22,035.46 ₹ -2,007,112.30 ₹ 2,992,887.70
₹ -43,391.16 ₹ -21,199.62 ₹ -22,191.54 ₹ -2,029,303.84 ₹ 2,970,696.16
₹ -43,391.16 ₹ -21,042.43 ₹ -22,348.73 ₹ -2,051,652.58 ₹ 2,948,347.42
₹ -43,391.16 ₹ -20,884.13 ₹ -22,507.03 ₹ -2,074,159.61 ₹ 2,925,840.39
₹ -43,391.16 ₹ -20,724.70 ₹ -22,666.46 ₹ -2,096,826.07 ₹ 2,903,173.93
₹ -43,391.16 ₹ -20,564.15 ₹ -22,827.01 ₹ -2,119,653.08 ₹ 2,880,346.92
₹ -43,391.16 ₹ -20,402.46 ₹ -22,988.70 ₹ -2,142,641.79 ₹ 2,857,358.21
₹ -43,391.16 ₹ -20,239.62 ₹ -23,151.54 ₹ -2,165,793.33 ₹ 2,834,206.67
₹ -43,391.16 ₹ -20,075.63 ₹ -23,315.53 ₹ -2,189,108.86 ₹ 2,810,891.14
₹ -43,391.16 ₹ -19,910.48 ₹ -23,480.68 ₹ -2,212,589.54 ₹ 2,787,410.46
₹ -43,391.16 ₹ -19,744.16 ₹ -23,647.00 ₹ -2,236,236.54 ₹ 2,763,763.46
₹ -43,391.16 ₹ -19,576.66 ₹ -23,814.50 ₹ -2,260,051.05 ₹ 2,739,948.95
₹ -43,391.16 ₹ -19,407.97 ₹ -23,983.19 ₹ -2,284,034.24 ₹ 2,715,965.76
₹ -43,391.16 ₹ -19,238.09 ₹ -24,153.07 ₹ -2,308,187.31 ₹ 2,691,812.69
₹ -43,391.16 ₹ -19,067.01 ₹ -24,324.16 ₹ -2,332,511.46 ₹ 2,667,488.54
₹ -43,391.16 ₹ -18,894.71 ₹ -24,496.45 ₹ -2,357,007.92 ₹ 2,642,992.08
₹ -43,391.16 ₹ -18,721.19 ₹ -24,669.97 ₹ -2,381,677.88 ₹ 2,618,322.12
₹ -43,391.16 ₹ -18,546.45 ₹ -24,844.71 ₹ -2,406,522.60 ₹ 2,593,477.40
₹ -43,391.16 ₹ -18,370.46 ₹ -25,020.70 ₹ -2,431,543.29 ₹ 2,568,456.71
₹ -43,391.16 ₹ -18,193.24 ₹ -25,197.93 ₹ -2,456,741.22 ₹ 2,543,258.78
₹ -43,391.16 ₹ -18,014.75 ₹ -25,376.41 ₹ -2,482,117.63 ₹ 2,517,882.37
₹ -43,391.16 ₹ -17,835.00 ₹ -25,556.16 ₹ -2,507,673.79 ₹ 2,492,326.21
₹ -43,391.16 ₹ -17,653.98 ₹ -25,737.18 ₹ -2,533,410.98 ₹ 2,466,589.02
₹ -43,391.16 ₹ -17,471.67 ₹ -25,919.49 ₹ -2,559,330.47 ₹ 2,440,669.53
₹ -43,391.16 ₹ -17,288.08 ₹ -26,103.09 ₹ -2,585,433.55 ₹ 2,414,566.45
₹ -43,391.16 ₹ -17,103.18 ₹ -26,287.98 ₹ -2,611,721.54 ₹ 2,388,278.46
₹ -43,391.16 ₹ -16,916.97 ₹ -26,474.19 ₹ -2,638,195.73 ₹ 2,361,804.27
₹ -43,391.16 ₹ -16,729.45 ₹ -26,661.71 ₹ -2,664,857.44 ₹ 2,335,142.56
₹ -43,391.16 ₹ -16,540.59 ₹ -26,850.57 ₹ -2,691,708.01 ₹ 2,308,291.99
₹ -43,391.16 ₹ -16,350.40 ₹ -27,040.76 ₹ -2,718,748.77 ₹ 2,281,251.23
₹ -43,391.16 ₹ -16,158.86 ₹ -27,232.30 ₹ -2,745,981.07 ₹ 2,254,018.93
₹ -43,391.16 ₹ -15,965.97 ₹ -27,425.19 ₹ -2,773,406.26 ₹ 2,226,593.74
₹ -43,391.16 ₹ -15,771.71 ₹ -27,619.46 ₹ -2,801,025.72 ₹ 2,198,974.28
₹ -43,391.16 ₹ -15,576.07 ₹ -27,815.09 ₹ -2,828,840.81 ₹ 2,171,159.19
₹ -43,391.16 ₹ -15,379.04 ₹ -28,012.12 ₹ -2,856,852.93 ₹ 2,143,147.07
₹ -43,391.16 ₹ -15,180.63 ₹ -28,210.54 ₹ -2,885,063.47 ₹ 2,114,936.53
₹ -43,391.16 ₹ -14,980.80 ₹ -28,410.36 ₹ -2,913,473.83 ₹ 2,086,526.17
₹ -43,391.16 ₹ -14,779.56 ₹ -28,611.60 ₹ -2,942,085.43 ₹ 2,057,914.57
₹ -43,391.16 ₹ -14,576.89 ₹ -28,814.27 ₹ -2,970,899.69 ₹ 2,029,100.31
₹ -43,391.16 ₹ -14,372.79 ₹ -29,018.37 ₹ -2,999,918.06 ₹ 2,000,081.94
₹ -43,391.16 ₹ -14,167.25 ₹ -29,223.91 ₹ -3,029,141.98 ₹ 1,970,858.02
₹ -43,391.16 ₹ -13,960.24 ₹ -29,430.92 ₹ -3,058,572.89 ₹ 1,941,427.11
₹ -43,391.16 ₹ -13,751.78 ₹ -29,639.39 ₹ -3,088,212.28 ₹ 1,911,787.72
₹ -43,391.16 ₹ -13,541.83 ₹ -29,849.33 ₹ -3,118,061.61 ₹ 1,881,938.39
₹ -43,391.16 ₹ -13,330.40 ₹ -30,060.76 ₹ -3,148,122.38 ₹ 1,851,877.62
₹ -43,391.16 ₹ -13,117.47 ₹ -30,273.70 ₹ -3,178,396.07 ₹ 1,821,603.93
₹ -43,391.16 ₹ -12,903.03 ₹ -30,488.13 ₹ -3,208,884.21 ₹ 1,791,115.79
₹ -43,391.16 ₹ -12,687.07 ₹ -30,704.09 ₹ -3,239,588.30 ₹ 1,760,411.70
₹ -43,391.16 ₹ -12,469.58 ₹ -30,921.58 ₹ -3,270,509.88 ₹ 1,729,490.12
₹ -43,391.16 ₹ -12,250.56 ₹ -31,140.61 ₹ -3,301,650.48 ₹ 1,698,349.52
₹ -43,391.16 ₹ -12,029.98 ₹ -31,361.19 ₹ -3,333,011.67 ₹ 1,666,988.33
₹ -43,391.16 ₹ -11,807.83 ₹ -31,583.33 ₹ -3,364,595.00 ₹ 1,635,405.00
₹ -43,391.16 ₹ -11,584.12 ₹ -31,807.04 ₹ -3,396,402.04 ₹ 1,603,597.96
₹ -43,391.16 ₹ -11,358.82 ₹ -32,032.34 ₹ -3,428,434.38 ₹ 1,571,565.62
₹ -43,391.16 ₹ -11,131.92 ₹ -32,259.24 ₹ -3,460,693.62 ₹ 1,539,306.38
₹ -43,391.16 ₹ -10,903.42 ₹ -32,487.74 ₹ -3,493,181.36 ₹ 1,506,818.64
₹ -43,391.16 ₹ -10,673.30 ₹ -32,717.86 ₹ -3,525,899.23 ₹ 1,474,100.77
₹ -43,391.16 ₹ -10,441.55 ₹ -32,949.61 ₹ -3,558,848.84 ₹ 1,441,151.16
₹ -43,391.16 ₹ -10,208.15 ₹ -33,183.01 ₹ -3,592,031.85 ₹ 1,407,968.15
₹ -43,391.16 ₹ -9,973.11 ₹ -33,418.05 ₹ -3,625,449.90 ₹ 1,374,550.10
₹ -43,391.16 ₹ -9,736.40 ₹ -33,654.77 ₹ -3,659,104.67 ₹ 1,340,895.33
₹ -43,391.16 ₹ -9,498.01 ₹ -33,893.15 ₹ -3,692,997.82 ₹ 1,307,002.18
₹ -43,391.16 ₹ -9,257.93 ₹ -34,133.23 ₹ -3,727,131.05 ₹ 1,272,868.95
₹ -43,391.16 ₹ -9,016.16 ₹ -34,375.01 ₹ -3,761,506.06 ₹ 1,238,493.94
₹ -43,391.16 ₹ -8,772.67 ₹ -34,618.50 ₹ -3,796,124.55 ₹ 1,203,875.45
₹ -43,391.16 ₹ -8,527.45 ₹ -34,863.71 ₹ -3,830,988.26 ₹ 1,169,011.74
₹ -43,391.16 ₹ -8,280.50 ₹ -35,110.66 ₹ -3,866,098.92 ₹ 1,133,901.08
₹ -43,391.16 ₹ -8,031.80 ₹ -35,359.36 ₹ -3,901,458.29 ₹ 1,098,541.71
₹ -43,391.16 ₹ -7,781.34 ₹ -35,609.82 ₹ -3,937,068.11 ₹ 1,062,931.89
₹ -43,391.16 ₹ -7,529.10 ₹ -35,862.06 ₹ -3,972,930.17 ₹ 1,027,069.83
₹ -43,391.16 ₹ -7,275.08 ₹ -36,116.08 ₹ -4,009,046.26 ₹ 990,953.74
₹ -43,391.16 ₹ -7,019.26 ₹ -36,371.91 ₹ -4,045,418.16 ₹ 954,581.84
₹ -43,391.16 ₹ -6,761.62 ₹ -36,629.54 ₹ -4,082,047.70 ₹ 917,952.30
₹ -43,391.16 ₹ -6,502.16 ₹ -36,889.00 ₹ -4,118,936.70 ₹ 881,063.30
₹ -43,391.16 ₹ -6,240.87 ₹ -37,150.30 ₹ -4,156,087.00 ₹ 843,913.00
₹ -43,391.16 ₹ -5,977.72 ₹ -37,413.44 ₹ -4,193,500.44 ₹ 806,499.56
₹ -43,391.16 ₹ -5,712.71 ₹ -37,678.46 ₹ -4,231,178.90 ₹ 768,821.10
₹ -43,391.16 ₹ -5,445.82 ₹ -37,945.35 ₹ -4,269,124.25 ₹ 730,875.75
₹ -43,391.16 ₹ -5,177.04 ₹ -38,214.13 ₹ -4,307,338.37 ₹ 692,661.63
₹ -43,391.16 ₹ -4,906.35 ₹ -38,484.81 ₹ -4,345,823.18 ₹ 654,176.82
₹ -43,391.16 ₹ -4,633.75 ₹ -38,757.41 ₹ -4,384,580.59 ₹ 615,419.41
₹ -43,391.16 ₹ -4,359.22 ₹ -39,031.94 ₹ -4,423,612.53 ₹ 576,387.47
₹ -43,391.16 ₹ -4,082.74 ₹ -39,308.42 ₹ -4,462,920.95 ₹ 537,079.05
₹ -43,391.16 ₹ -3,804.31 ₹ -39,586.85 ₹ -4,502,507.80 ₹ 497,492.20
₹ -43,391.16 ₹ -3,523.90 ₹ -39,867.26 ₹ -4,542,375.06 ₹ 457,624.94
₹ -43,391.16 ₹ -3,241.51 ₹ -40,149.65 ₹ -4,582,524.71 ₹ 417,475.29
₹ -43,391.16 ₹ -2,957.12 ₹ -40,434.05 ₹ -4,622,958.75 ₹ 377,041.25
₹ -43,391.16 ₹ -2,670.71 ₹ -40,720.45 ₹ -4,663,679.21 ₹ 336,320.79
₹ -43,391.16 ₹ -2,382.27 ₹ -41,008.89 ₹ -4,704,688.10 ₹ 295,311.90
₹ -43,391.16 ₹ -2,091.79 ₹ -41,299.37 ₹ -4,745,987.46 ₹ 254,012.54
₹ -43,391.16 ₹ -1,799.26 ₹ -41,591.91 ₹ -4,787,579.37 ₹ 212,420.63
₹ -43,391.16 ₹ -1,504.65 ₹ -41,886.52 ₹ -4,829,465.89 ₹ 170,534.11
₹ -43,391.16 ₹ -1,207.95 ₹ -42,183.21 ₹ -4,871,649.10 ₹ 128,350.90
₹ -43,391.16 ₹ -909.15 ₹ -42,482.01 ₹ -4,914,131.11 ₹ 85,868.89
₹ -43,391.16 ₹ -608.24 ₹ -42,782.92 ₹ -4,956,914.03 ₹ 43,085.97
₹ -43,391.16 ₹ -305.19 ₹ -43,085.97 ₹ -5,000,000.00 ₹ 0.00
 PART(b)

Funding support by Mr Xman office 35% of take home salary

35% OF TAKE HOME SALARY ₹ 320,250.00
Amount he has to pay himself IN AN YEAR ₹ 200,443.94
Total emi of a year ₹ 520,693.94

Hence, the amount provided by bank is not enough to pay the loan.
He can take loan through different mediums such as