Spent 28439 this month.
Sunday 31 December 2017
FI date and graph
Saturday 30 December 2017
Returns
Nifty 500 returned 37.2% for 2017, I had not received such returns and can not measure as well due to change in approach. In 2018 I should be able to measure returns with investments in just 3 funds. India is missing index funds big time.
Tuesday 26 December 2017
Donation to Akshaya Patra
I have donated 950 to Akshaya Patra on my last day at office and it felt really good.
Pay day for December
I have received a salary of 39,389 rupees post tax for the month of December. I should save 50% of post tax salary. My investments this month should be (39,389/2) = 19695. Out of which I move 5500 to Franklin India Taxshield and rest to Franklin India Dynamic P E Ratio Fund Of Funds (14195).
I have paid 2,750 insurance plus kid school fee into debt fund already, I will be left with 16944 to spend in the month of December.
My PF(5,26,289) stands at as of today. Gratuity was settled too and post tax I received 1,49,883 which was invested in dynamic pe fund already.
I have paid 2,750 insurance plus kid school fee into debt fund already, I will be left with 16944 to spend in the month of December.
My PF(5,26,289) stands at as of today. Gratuity was settled too and post tax I received 1,49,883 which was invested in dynamic pe fund already.
Monday 18 December 2017
Concentrating in on fund house and one fund, isn't risky?
I have attended a session today on investment and the coach asked me isn't concentrating on one fund risky?
My answer was its dynamic PE and has less volatility than the market.
Came back to the desk and thought about it.
What are the risks?
1. If two funds Dyn PE invests underperforms I will take a beating.
2. According to recession data, the max drawdown I can have is 33% and I am ok with it.
3. The debt fund may not give 9% like previous years but I am ok with 7-8%.
4. I may not lose my money unless there is chaos in Indian markets and Franklin Templeton goes down under, even then the underlying assets are in India so if India grows fund grows.
It's still a valid point why not have another fund house to the equation?
Should I invest in index funds from different fund houses, even when I am planning to retire in 5 years?
My answer was its dynamic PE and has less volatility than the market.
Came back to the desk and thought about it.
What are the risks?
1. If two funds Dyn PE invests underperforms I will take a beating.
2. According to recession data, the max drawdown I can have is 33% and I am ok with it.
3. The debt fund may not give 9% like previous years but I am ok with 7-8%.
4. I may not lose my money unless there is chaos in Indian markets and Franklin Templeton goes down under, even then the underlying assets are in India so if India grows fund grows.
It's still a valid point why not have another fund house to the equation?
Should I invest in index funds from different fund houses, even when I am planning to retire in 5 years?
18-04-2021 This came true in 2020 Mar the debt fund lost 50% of NAV in a single day.
Monday 11 December 2017
FI date and graph
My FI date has come down to Aug 2022 which is 4 years 9 months. Would like to thank madfientist for creating graph https://lab.madfientist.com/. December probably will not move or may push my FI date as my contributions will not be there due to change in job and higher monthly expenses. Hope to contribute from Jan salary.
Saturday 2 December 2017
Friday 1 December 2017
Dec and Jan are going to be expensive month
December/January is going to be expensive months.
1. Travel (5k)
2. Contemplating to buy a new mobile (7k) as the current one is not charging properly or should I just let go and check if wire is faulty and still use old one. --- Will check with new wire and see if it charges, do not actually need it till Jan 8th.
3. My stint in current company will end on 19th and will not receive full salary plus I have some loss of pays as well. May be I will get at best 1/3rd of salary around 19k. Cash is not a worry I have about 45k for next two months and 20k should be returned to me which I loaned to a friend. ---(4th Dec) It looks like my salary will be delayed so have depend on housing account. (15th Dec) Mom is taking the housing account card with her.
4. Have to purchase new cloths for new office because it will be business formals which I think will cost around 15k. --- Have to see what actually fits into business formals in existing clothing.
5. Planning to replace spectacles (5k). --- Not a mandatory need and can wait for Feb month
Total of 32k + usual 40 k expenses is what I am looking at. I also have a about 50k with housing account (15Dec which I can not sadly use), have to see how these two months spending going to look like.
1. Travel (5k)
2. Contemplating to buy a new mobile (7k) as the current one is not charging properly or should I just let go and check if wire is faulty and still use old one. --- Will check with new wire and see if it charges, do not actually need it till Jan 8th.
3. My stint in current company will end on 19th and will not receive full salary plus I have some loss of pays as well. May be I will get at best 1/3rd of salary around 19k. Cash is not a worry I have about 45k for next two months and 20k should be returned to me which I loaned to a friend. ---(4th Dec) It looks like my salary will be delayed so have depend on housing account. (15th Dec) Mom is taking the housing account card with her.
4. Have to purchase new cloths for new office because it will be business formals which I think will cost around 15k. --- Have to see what actually fits into business formals in existing clothing.
5. Planning to replace spectacles (5k). --- Not a mandatory need and can wait for Feb month
Total of 32k + usual 40 k expenses is what I am looking at. I also have a about 50k with housing account (15Dec which I can not sadly use), have to see how these two months spending going to look like.
Thursday 30 November 2017
Investment Ideas to explore
Investment Ideas to explore
1. Want to beat the Sensex? Just buy stocks the index discards.
http://www.livemint.com/Money/ADwgLwRoIzRfdh3sCH1pJP/Want-to-beat-the-Sensex-Just-buy-stocks-the-index-discards.html
2. Coffee can portfolio
2. Coffee can portfolio
3.
https://economictimes.indiatimes.com/wealth/invest/11-financial-moves-that-will-help-you-make-money-in-2019/articleshow/67298628.cms
4. https://www.valueresearchonline.com/story/h2_storyview.asp?str=46509
- The Five Point Filter
- All listed non-finance companies with a market cap of greater than Rs 100 cr
- Promoter shareholding has increased >3.0 per cent in the past four quarters
- Net sales >9.0 per cent per TTM 2QFY19
- Net Profit >10.0 per cent per TTM 2QFY19
- Increasing or stable ROE in the past 5 years
Wednesday 29 November 2017
Pay day for November
I have received a salary of 82,487 rupees post tax for the month of November. I should save 50% of post tax salary but I am not going to consider bonus in that calculation so pay minus bonus is 53,001. My investments this month should be (53,001/2) = 26,500.5 + bonus (29,486.00) = 55,897. Out of which I move 5500 to Franklin India Taxshield and rest to Franklin India Dynamic P E Ratio Fund Of Funds (50,397).
I have paid 2,750 insurance plus kid school fee into debt fund already, I will be left with 23,750 to spend in the month of December.
My PF(5,23,173) and Gratuity (1,56,801) stands at as of today.
I have paid 2,750 insurance plus kid school fee into debt fund already, I will be left with 23,750 to spend in the month of December.
My PF(5,23,173) and Gratuity (1,56,801) stands at as of today.
Tuesday 21 November 2017
25 times
Before compounding kicks it is really a toil to see that FI is far away. I am trying to simplify and see if I can break the journey to bite size pieces. It is true that the FI number varies for me month on month because the amount spent is different. The FI amount I arrive is 25 times last 12 months expenses. A sudden emergency can derail the journey but its still a good idea to see if I can set some goals.
Today the amount seems to be 80,00,000 so 80k for 1% and contributing 20k will be .25%. If I assume 20k to be single block I need 400 blocks to FI. I have already covered 170 blocks and the distance to cover is about 230 blocks. There will be change in FI money and so the blocks I will have to cover will increase but no one can erase the blocks I have traveled of course a recession can erase some of my distance but in the long run it should help me cover much of the ground.
So here will be distance I have to cover:
1 2 3 4 5 6 7 8 9 10 --- I will have 12k per month of passive income when 10 steps are covered. Achieved it in the end of December 2017
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 --- I will have 13k per month of passive income when 15 steps are covered. Achieved it in the end of March 2018
26 27 28 29 30
31 32 33 34 35 36 37 38 39 40 --- I will have 14k per month of passive income when 15 steps are covered. Achieved it in the starting of August 2018. Took me 4 months and I am sure next 1k passive will take more time than this.
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 --- I will have 15k per month of passive income when 15 steps are covered. (2018 target) Achieved in October 2018 as I have added PF contribution from employer as well.
56 57 58 59 60
61 62 63 64 65 66 67 68 69 70 --- 16k per month Achieved in NOvember 2018 as I have added PF contribution from employer.
71 72 73 74 75 76 77 78 79 80
81 82 83 84 85 --- 17k per month Achieved in February 2019
86 87 88 89 90
91 92 93 94 95 96 97 98 99 100 --- 18k per month Achieved in May 2019
101 102 103 104 105 106 107 108 109 110
111 112 113 114 115 --- 19k per month achieved in August 2019
116 117 118 119 120
121 122 123 124 125 126 127 128 129 130 (2019 target) --- 20k per month
achieved in Nov 2019
131 132 133 134 135 136 137 138 139 140
141 142 143 144 145 --- 21 k per month achieved in Nov 2019
146 147 148 149 150
151 152 153 154 155 156 157 158 159 160 --- 22 k per month
161 162 163 164 165 166 167 168 169 170
171 172 173 174 175 --- 23 k per month
176 177 178 179 180
181 182 183 184 185 186 187 188 189 190 --- 24 k per month
191 192 193 194 195 196 197 198 199 200
201 202 203 204 205 --- 25 k per month
206 207 208 209 210 (2020 target)
211 212 213 214 215 116 217 218 219 220
221 222 223 224 225 --- 26 k per month
226 227 228 229 230
Today the amount seems to be 80,00,000 so 80k for 1% and contributing 20k will be .25%. If I assume 20k to be single block I need 400 blocks to FI. I have already covered 170 blocks and the distance to cover is about 230 blocks. There will be change in FI money and so the blocks I will have to cover will increase but no one can erase the blocks I have traveled of course a recession can erase some of my distance but in the long run it should help me cover much of the ground.
So here will be distance I have to cover:
achieved in Nov 2019
146 147 148 149 150
151 152 153 154 155 156 157 158 159 160 --- 22 k per month
161 162 163 164 165 166 167 168 169 170
171 172 173 174 175 --- 23 k per month
176 177 178 179 180
181 182 183 184 185 186 187 188 189 190 --- 24 k per month
191 192 193 194 195 196 197 198 199 200
201 202 203 204 205 --- 25 k per month
206 207 208 209 210 (2020 target)
211 212 213 214 215 116 217 218 219 220
221 222 223 224 225 --- 26 k per month
226 227 228 229 230
Sunday 12 November 2017
Dream job
In the video, Warren Buffett is talking about creating a dream job. It made me wonder what would be my dream job. How should one create it?
https://www.youtube.com/watch?v=ridk6OvkgGM&t=2378s
Job where
I am the boss.
I do not have to worry about monthly expenses or money to take care of any emergencies.
Be good at what I do, I am planning to be an investor, and beating my own performance will be motivating.
If I have to create a job like that I should be prepared to work for at least the next 6 years, not just dumping money to make 25 times expenses but learning ways to create a job profile that suits me.
On the other hand it a long way down the road until then I have to plow the field to enjoy the harvest.
https://www.youtube.com/watch?v=ridk6OvkgGM&t=2378s
Job where
I am the boss.
I do not have to worry about monthly expenses or money to take care of any emergencies.
Be good at what I do, I am planning to be an investor, and beating my own performance will be motivating.
If I have to create a job like that I should be prepared to work for at least the next 6 years, not just dumping money to make 25 times expenses but learning ways to create a job profile that suits me.
On the other hand it a long way down the road until then I have to plow the field to enjoy the harvest.
Saturday 11 November 2017
Money from rent
I own some ancestral property in my home town in which I had built two houses. I have discussed with mother and have taken 5000 from the rents, hoping to take at least 5000 every month. Invested the amount in Franklin India Ultra Short Bond Fund Super Institutional Plan - Direct - Growth (return is 8.7%) just to make sure that in case of any emergency I do not dip in to long term fund. My emergency fund now stands at 225,999.52.
12/11/2017 My mother has changed her mind and has taken the debit card from me and said she would give 5k cash every month. This comes as a reminder that I should not take it for granted and should plan my retirement with out property yield into consideration.
12/11/2017 My mother has changed her mind and has taken the debit card from me and said she would give 5k cash every month. This comes as a reminder that I should not take it for granted and should plan my retirement with out property yield into consideration.
Tuesday 31 October 2017
Monday 30 October 2017
Pay Day for October
I have made 59,075.00 this month out of which 50% goes to saving(29538).
Franklin India Taxshield (5500) and rest in Franklin India Dynamic P E Ratio Fund Of Fund (24038).
I have paid 2750 for insurance plus kid school fee into debt fund, I will be left with 26787 to spend in the month of November.
My PF(518089) and Gratuity (156801) stands at 674890 as of today.
My PF(518089) and Gratuity (156801) stands at 674890 as of today.
Sunday 29 October 2017
Trading with money I can afford to lose
I'm now in the great position of really trading with money I can afford to lose. And that I think is what makes me a better investor. -- Naked Trader
I think this is where many in investing or trading will fail. They trade with capital they can not afford to lose. This is the case with me too, I should build capital (25 times expenses)which will cover my expenses and next look for investing in individual stocks.
I think this is where many in investing or trading will fail. They trade with capital they can not afford to lose. This is the case with me too, I should build capital (25 times expenses)which will cover my expenses and next look for investing in individual stocks.
Thursday 26 October 2017
Investment Policy Statement
Got this idea from the below link and it raised many questions
http://somerandomguyonline.com/helicopter-investor/
Investment Policy Statement
I already have one but not as specific as it should be.
Original: To have 25 times my last 12 months' expenses and not touch the savings at any cost unless medical emergency or job loss.
My investment strategy is simple, to put money in dynamic PE FOF after-tax investing.
Risk tolerance is low so invested in a dynamic fund that invests in both debt and equity.
Asset Allocation is simple too as the fund does it every month based on PE ratio.
The investment philosophy is to take less risk and ride the equity and debt markets at the same time and long enough to reach my goal to have 25 times my last 12 months' expenses (I should be tracking my expenses every month without fail).
21-07-18:
New statement:
Original ambition remains the same but changes in asset allocation. PE fund is charging me 1.5% and if I am FI a few years from now and plan to withdraw 4% the expenses alone will consume 37.5% of my withdrawal. This is a high-cost option, I think I am making excuses not planing to work and be lazy and planned to retire in 5 years, but caring for my mother the financial burden makes me think I should work as long as I can and build wealth for myself and kid.
My investment strategy is simple, to put money in Nifty 100 index funds after-tax investing.
Risk tolerance is high as I am planning to be in the workforce as long as I can, even if disasters occur I plan to cover expenses through the emergency funds, PF money which I can withdraw in case of job loss or medical emergency.
Asset Allocation is simple too as funds invest in Nifty 100 at low cost. I am not planning to re-balance as I am in the wealth accumulation phase, will think once I am FI on allocation change.
An investment philosophy is to take high risk and ride the equity markets and use emergency and PF cash in case of tough times and long enough to reach my goal to have 25 times my last 12 months expenses (I should be tracking my expenses every month with out fail).
How often you want to monitor your portfolio?
I am monitoring it daily now, which is not a good thing but can not help it. I Will see if I can monitor it only on weekends.
Stick with YOUR plan
Have to see how long I am going to stick to the plan.
(Aug17,Sep17,Oct17,Nov17,Dec17,Jan17,Feb17,Mar17,Apr17,May17,June17,July17) lasted for a year.
A new plan from August 18:
Invest in index funds UTI Nifty Index Fund and UTI Nifty Next 50 Index Fund hoping to invest for 10 years at least. The change in plan is to use a low-cost option and ride the tide with emergency and PF cash cushion.
If money is in the Index I should monitor it once every month to calculate net worth.
http://somerandomguyonline.com/helicopter-investor/
Create an investment policy statement
An investment policy statement (IPS) is a statement or document that outlines your general investment goals and objectives. It also establishes your specific investment strategy, risk tolerance, asset allocation, and investment philosophy. You can also include a section on how often you want to monitor your portfolio and when to rebalance. Write your IPS down. Keep it handy so you can refer to it when needed.
Investment Policy Statement
I already have one but not as specific as it should be.
Original: To have 25 times my last 12 months' expenses and not touch the savings at any cost unless medical emergency or job loss.
My investment strategy is simple, to put money in dynamic PE FOF after-tax investing.
Risk tolerance is low so invested in a dynamic fund that invests in both debt and equity.
Asset Allocation is simple too as the fund does it every month based on PE ratio.
The investment philosophy is to take less risk and ride the equity and debt markets at the same time and long enough to reach my goal to have 25 times my last 12 months' expenses (I should be tracking my expenses every month without fail).
21-07-18:
New statement:
Original ambition remains the same but changes in asset allocation. PE fund is charging me 1.5% and if I am FI a few years from now and plan to withdraw 4% the expenses alone will consume 37.5% of my withdrawal. This is a high-cost option, I think I am making excuses not planing to work and be lazy and planned to retire in 5 years, but caring for my mother the financial burden makes me think I should work as long as I can and build wealth for myself and kid.
My investment strategy is simple, to put money in Nifty 100 index funds after-tax investing.
Risk tolerance is high as I am planning to be in the workforce as long as I can, even if disasters occur I plan to cover expenses through the emergency funds, PF money which I can withdraw in case of job loss or medical emergency.
Asset Allocation is simple too as funds invest in Nifty 100 at low cost. I am not planning to re-balance as I am in the wealth accumulation phase, will think once I am FI on allocation change.
An investment philosophy is to take high risk and ride the equity markets and use emergency and PF cash in case of tough times and long enough to reach my goal to have 25 times my last 12 months expenses (I should be tracking my expenses every month with out fail).
How often you want to monitor your portfolio?
I am monitoring it daily now, which is not a good thing but can not help it. I Will see if I can monitor it only on weekends.
Stick with YOUR plan
Have to see how long I am going to stick to the plan.
(
A new plan from August 18:
Invest in index funds UTI Nifty Index Fund and UTI Nifty Next 50 Index Fund hoping to invest for 10 years at least. The change in plan is to use a low-cost option and ride the tide with emergency and PF cash cushion.
If money is in the Index I should monitor it once every month to calculate net worth.
Thursday 19 October 2017
Expensive month
It is going to be super expensive month, spent about 18k so far, eating out and unnecessary travel costs are high. I have to work over the weekend for support and finish off my work, hope they are productive and I could meet my dead line.
Friday 6 October 2017
New job offer
I have got a job offer and pay will increase by 36%. My last day in current company is 19th December and joining date for new company is January 8th 2018.
Things are not good in current company but hope to move on for short period of time.
Things are not good in current company but hope to move on for short period of time.
Expenses in September
I have spent 19630.48 this month.
Debit card :14200
Credit card :1927.69
Reliance Gift Card:3502.79
I have not got my EMI for debt I loaned, I had to take money from bank to invest. Two monthly defaults so far (21922).
Debit card :14200
Credit card :1927.69
Reliance Gift Card:3502.79
I have not got my EMI for debt I loaned, I had to take money from bank to invest. Two monthly defaults so far (21922).
Thursday 28 September 2017
Pay Day for September
I have made 59,075.00 this month out of which 50% goes to saving(29538).
Franklin India Taxshield (5500) and rest in Franklin India Dynamic P E Ratio Fund Of Fund (24038).
I have paid my 2750 insurance plus my kids school fee into debt fund, I will be left with 26787 to spend in the month of October.
My PF(513005) and Gratuity (156801) stands at 669806 as of today.
My PF(513005) and Gratuity (156801) stands at 669806 as of today.
Thursday 21 September 2017
Weekend support and offer for new job
I have to support over the weekend and this is making me nervous the deployment is fine but the support after that will be tedious spending more than 10 hours in office and having to work over weekend is just awful. I have applied for a job in another company and they said would offer a job, hopefully they will make an offer and I will move to new company in Dec or early.
Friday 15 September 2017
Loaning money
I had loaned money to a friend and he has not been paying me. It is just a mistake and should not lend anyone. Paying 10% of my net worth is stupidest mistake I have made. Helping is fine but risking 10% is not the right thing to do in my current situation.
12/7/2017: I have opened a SIP in FT Dynamic PE FOF for the amount he is going to deposit, it ends on May 2020.
3/6/2018: Still chasing for payments and yet to get pending payment. 9 installments paid so far; 27 pending. I will never loan anyone money and will not participate in peer to peer lending as well.
4/6/2018: Still chasing for payments and yet to get pending payment. 10 installments paid so far; 26 pending. Its just hard to remind friend that they should pay you.
5/7/2018: Still chasing for payments and yet to get pending payment. 11 installments paid so far; 25 pending. I did remind yesterday and today with a message and phone call. I received it today.
6/7/2018: Still chasing for payments and yet to get pending payment in full. 12 installments paid so far; 24 pending. I did remind yesterday with a message and received it today.
7/8/2018: Still chasing for payments and yet to get pending payment in full. 13 installments paid so far; 23 pending. I did remind yesterday with a message and received it today.
8/7/2018: 14 paid so far 22 pending. Still 1961 pending from 4th installment.
9/7/2018: 15 paid so far 21 pending. Still 961 pending from 4th installment.
Below is the plan.
10/9/2018: 17 paid so far 19 pending. Pending payments are received and hope I get to recover the remaining payments in peace.
11/8/2018: 18 paid so far 18 pending. Halfway there hope I get to recover the remaining payments in peace.
12/11/2018: 19 paid so far 17 pending. Late but paid it really is sad to ask your friend for payment, I should never do it.
12/11/2018: 20 paid so far 16 pending. Late but paid it.
02/10/2019: 21 paid so far 15 pending.
24/03/2019: He has not paid in March and giving me excuses :(, on the other hand I have given 1 lakh to friend of mine who sits in my cubicle for one month he should return it on April 15th. I made a bad choice of giving him the debit card but I should not do it anymore.I should get 101500 on April 15th. I have only lent 2 % of my net-worth.
04/01/2019: Paid March Emi 25 days late but sent a message on salary day and received money. 22 paid so far 14 pending. I do not know if he will pay April EMI or not.
05/03/2019: Paid April EMI a month late. 23 paid so far 13 pending. I do not know when will he pay May EMI
06/05/2019: Paid May EMI a month late. 24 paid so far 12 pending. I do not know how long he will pay. I should not lend to anyone and should not more than 1% if to a relative.
12/7/2017: I have opened a SIP in FT Dynamic PE FOF for the amount he is going to deposit, it ends on May 2020.
3/6/2018: Still chasing for payments and yet to get pending payment. 9 installments paid so far; 27 pending. I will never loan anyone money and will not participate in peer to peer lending as well.
4/6/2018: Still chasing for payments and yet to get pending payment. 10 installments paid so far; 26 pending. Its just hard to remind friend that they should pay you.
5/7/2018: Still chasing for payments and yet to get pending payment. 11 installments paid so far; 25 pending. I did remind yesterday and today with a message and phone call. I received it today.
6/7/2018: Still chasing for payments and yet to get pending payment in full. 12 installments paid so far; 24 pending. I did remind yesterday with a message and received it today.
7/8/2018: Still chasing for payments and yet to get pending payment in full. 13 installments paid so far; 23 pending. I did remind yesterday with a message and received it today.
8/7/2018: 14 paid so far 22 pending. Still 1961 pending from 4th installment.
9/7/2018: 15 paid so far 21 pending. Still 961 pending from 4th installment.
Below is the plan.
10/9/2018: 17 paid so far 19 pending. Pending payments are received and hope I get to recover the remaining payments in peace.
11/8/2018: 18 paid so far 18 pending. Halfway there hope I get to recover the remaining payments in peace.
12/11/2018: 19 paid so far 17 pending. Late but paid it really is sad to ask your friend for payment, I should never do it.
12/11/2018: 20 paid so far 16 pending. Late but paid it.
02/10/2019: 21 paid so far 15 pending.
24/03/2019: He has not paid in March and giving me excuses :(, on the other hand I have given 1 lakh to friend of mine who sits in my cubicle for one month he should return it on April 15th. I made a bad choice of giving him the debit card but I should not do it anymore.I should get 101500 on April 15th. I have only lent 2 % of my net-worth.
04/01/2019: Paid March Emi 25 days late but sent a message on salary day and received money. 22 paid so far 14 pending. I do not know if he will pay April EMI or not.
05/03/2019: Paid April EMI a month late. 23 paid so far 13 pending. I do not know when will he pay May EMI
06/05/2019: Paid May EMI a month late. 24 paid so far 12 pending. I do not know how long he will pay. I should not lend to anyone and should not more than 1% if to a relative.
08/07/2019: Paid July EMI a month late. 26 paid so far 10 pending. I don't know if I can recover money, should not lend money ever. If to family only 1% should only be extended.
09/20/2019: Paid August EMI in the month of September on 18th. 9 EMIs are still pending. I don't know if I can recover money, should not lend money ever.If to family only 1% should only be extended.
10/08/2019: Paid September EMI in the month of October on 7th. 8 EMIs are still pending. I don't know if I can recover money, should not lend money ever.If to family only 1% should only be extended.
12/02/2019: Suresh paid 50k this month and has not mentioned any thing on the remaining money and how he is going to pay. In total I received 356908, I lost money on this with low rate of return.
09/20/2019: Paid August EMI in the month of September on 18th. 9 EMIs are still pending. I don't know if I can recover money, should not lend money ever.If to family only 1% should only be extended.
10/08/2019: Paid September EMI in the month of October on 7th. 8 EMIs are still pending. I don't know if I can recover money, should not lend money ever.If to family only 1% should only be extended.
12/02/2019: Suresh paid 50k this month and has not mentioned any thing on the remaining money and how he is going to pay. In total I received 356908, I lost money on this with low rate of return.
Annual
Interest Rate:
|
12.00%
|
Length
of Loan (in Years):
|
3
|
Number
of Payments Per Year:
|
12
|
Total
Number of Periods:
|
36
|
Month
|
Payment
no
|
Monthly
Payment
|
Principal
|
Interest
|
Balance
Loan Outstanding
|
Jun-17
|
1 (Paid)
|
10,960.72
|
7,660.72
|
3,300.00
|
322,339.28
|
Jul-17
|
2 (Paid)
|
10,960.72
|
7,737.33
|
3,223.39
|
314,601.95
|
Aug-17
|
3(Missed Payment) Paid (Later)
|
10,960.72
|
7,814.70
|
3,146.02
|
306,787.25
|
Sep-17
|
4 (Missed Payment)
Mar(Paid 5k) May(Paid 1k) Jun(Paid 1k) Jul(Paid 1k) Aug(Paid 1k) Sep(Paid 1k) Oct(Paid 1k) Paid(Later) |
10,960.72
|
7,892.85
|
3,067.87
|
298,894.40
|
Oct-17
|
5 (Paid)
|
10,960.72
|
7,971.78
|
2,988.94
|
290,922.62
|
Nov-17
|
6 (Paid)
|
10,960.72
|
8,051.50
|
2,909.23
|
282,871.12
|
Dec-17
|
7 (Paid)
|
10,960.72
|
8,132.01
|
2,828.71
|
274,739.11
|
Jan-18
|
8
|
10,960.72
|
8,213.33
|
2,747.39
|
266,525.78
|
Feb-18
|
9
|
10,960.72
|
8,295.46
|
2,665.26
|
258,230.31
|
Mar-18
|
10
|
10,960.72
|
8,378.42
|
2,582.30
|
249,851.90
|
Apr-18
|
11(Paid)
|
10,960.72
|
8,462.20
|
2,498.52
|
241,389.69
|
May-18
|
12(Paid)
|
10,960.72
|
8,546.83
|
2,413.90
|
232,842.87
|
Jun-18
|
13
|
10,960.72
|
8,632.29
|
2,328.43
|
224,210.57
|
Jul-18
|
14(Paid)
|
10,960.72
|
8,718.62
|
2,242.11
|
215,491.96
|
Aug-18
|
15(Paid)
|
10,960.72
|
8,805.80
|
2,154.92
|
206,686.15
|
Sep-18
|
16(Paid)
|
10,960.72
|
8,893.86
|
2,066.86
|
197,792.29
|
Oct-18
|
17(Paid)
|
10,960.72
|
8,982.80
|
1,977.92
|
188,809.49
|
Nov-18
|
18(Paid)
|
10,960.72
|
9,072.63
|
1,888.09
|
179,736.87
|
Dec-18
|
19(Paid)
|
10,960.72
|
9,163.35
|
1,797.37
|
170,573.51
|
Jan-19
|
20(Paid)
|
10,960.72
|
9,254.99
|
1,705.74
|
161,318.53
|
Feb-19
|
21(Paid)
|
10,960.72
|
9,347.54
|
1,613.19
|
151,970.99
|
Mar-19
|
22(Paid on 29thMar)
|
10,960.72
|
9,441.01
|
1,519.71
|
142,529.98
|
Apr-19
|
23(Paid on 3rd May)
|
10,960.72
|
9,535.42
|
1,425.30
|
132,994.55
|
May-19
|
24(Paid on 5th June)
|
10,960.72
|
9,630.78
|
1,329.95
|
123,363.78
|
Jun-19
|
25(Paid on 8th July)
|
10,960.72
|
9,727.08
|
1,233.64
|
113,636.69
|
Jul-19
|
26(Paid on 7th Aug)
|
10,960.72
|
9,824.36
|
1,136.37
|
103,812.34
|
Aug-19
|
27(Paid on 18th Sep)
|
10,960.72
|
9,922.60
|
1,038.12
|
93,889.74
|
Sep-19
|
28 (Paid on 7th Oct)
|
10,960.72
|
10,021.82
|
938.90
|
83,867.91
|
Oct-19
|
29
|
10,960.72
|
10,122.04
|
838.68
|
73,745.87
|
Nov-19
|
30(Paid 50k)
|
10,960.72
|
10,223.26
|
737.46
|
63,522.61
|
Dec-19
|
31
|
10,960.72
|
10,325.50
|
635.23
|
53,197.11
|
Jan-20
|
32
|
10,960.72
|
10,428.75
|
531.97
|
42,768.36
|
Feb-20
|
33
|
10,960.72
|
10,533.04
|
427.68
|
32,235.32
|
Mar-20
|
34
|
10,960.72
|
10,638.37
|
322.35
|
21,596.95
|
Apr-20
|
35
|
10,960.72
|
10,744.75
|
215.97
|
10,852.20
|
May-20
|
36
|
10,960.72
|
10,852.20
|
108.52
|
0.00
|
Subscribe to:
Posts (Atom)