Tuesday, April 4, 2023

The last financial year (FY 2022-23)

 Analysis of the inflow and outflow of last FY:

1) In Inflow,  (a) the noteworthy mention is the share of 'Loan Repay', which is 33.1%. For a person completely dependent on Salary, this is a good sign. (b) There are lot of entries in 'Other' category, which is prompting me to change the categories for next year. (c) The amount I received via Mediclaim (INR 82413/-) for Miss AA Devi is something new for me and thankful to CSoD. (d) The earning from Market is still below 1%, and its a shame.(e) the start of rental income is a huge thumbs-up. (f) the interest from PPF stood at around INR 72K, which 6K per month.

2) In Outflow, (a) the reduction in Fixed Asset is a great relief, (b) The transport expenses saw a jump after I relocated, (c) the loss of money under Travel for the UK tickets is such a shame, (d) the pending money for buying land was cleared, (e) I paid 7.14 Lakh in taxes to government, (f) Food expenses are still below 2% and that's not a good sign, (g) the rubber sampling experiment was worth trying, (h) opening the Sukanya Samridhi account for R'dali is an event I longed for, (i) the 2.5 Lakh investment in house construction was worth considering the probable return in future although it might take more than 4 years.


How I fared against what I aimed at the start of this FY:

1) Regular income from immoveable property is still a distant dream. The search for land near Urpad stopped after I found the land near graveyard is in the name of Deuta, and applied in Basundhara.

2) Still I don't have any policy on equity- when to sell, what to buy etc.

3) Haven't been able to explore 80D and the current health policy. Shame on me!


Plan for next FY:

1) In the excel file:

    i) Making some change in Outflow tracking. Letting go Travel and Nina, and included a new category for Miss AA Devi. Travel will be merged with either personal or recreation. Nina will come in Donation or with context.

    ii) In Inflow, bank interests- Savings and FD will be merged. Dividend and amount from selling market will be one column as I hardly sell stocks. With Others, will try to bring a relevant category

    iii) The Sharekhan settlement money to be subtracted from the expense sheet, although in the Sharekhan Trading sheet, it may remain as it is.

    iv) Since Homeloan deduction is compensated by the contribution by Dada and Maa, I should only mention INR 17/- in the Outflow section. This is not tracked for the amount, but for the activity.

2) Action items:

    i) Get clarification of the EPF and VPF thingies. Currently there are 2 accounts under one UAN. What's the significance of VPF?

    ii) Focus on health policy - know more, open if necessary. 

    iii) Explore ULIP, maybe one will be interesting. 

    iv) No opening of FD in Zing's accounts. 

3) Keep the focus on the immovable properties and agriculture projects. 


Row data - Outflow:

Fixed AssetFoodPersonalRecreationGift/DonationTransportTravelInvestmentNinaTaxFirst/UniueTotal
April21000282551121384959530056281252960540761170325001394398
May2210068638534729388615326541843023665611705000176467
June27274996183755226281812888372296430187756118250000470189
July155276900112036710151556970500001843017705611700304603
August1251317610053936027116700028430610446117016485281866
Sept15863800535622601754155502455884844605692324936255557
Oct258675269117901148440005643028409569234490163613
Nov9064629812315101612226004743026298569230151626
Dec277472606205141780410968002008843013650569358154230925
Jan50118313775320040263500020510611195744392034261421
Feb20005230213411204890352040033493010940575120422676
Mar8302520811393280134896402055543006636933056.8191231.8
Total114,39173,741322,83421,10360,70556,54399,9142,306,324267,472714,890266,6564,304,573
Percentage2.46%1.59%6.94%0.45%1.31%1.22%2.15%49.58%5.75%15.37%5.73%92.54%


Row Data - Inflow:

Salary+off rmbrsmnt+mediclaimMarket (selling of equity, Dividend, MF, settlement etc)Loan Repay(includes interest, if applicable)Interest (Savings Account)Interest (FDs)Others
April22523084070867320000₹ 954,743
May225230311011173₹ 239,513
June225218114553867335381600055000₹ 839,574
July225230182958673277016790₹ 305,292
August2252302742386733325₹ 269,970
Sept229477113238673843839935₹ 297,846
Oct2329071318867315569₹ 258,467
Nov22947721968673₹ 240,346
Dec22946588053367310954200₹ 283,097
Jan228957346981450₹ 265,105
Feb2887462917836565500₹ 380,819
Mar28491349768673126225500₹ 316,684
Total28500804120115425843555218770163269₹ 4,651,456
61.27%0.89%33.16%0.76%0.40%3.51%


No comments:

Post a Comment