Make a copy of the Google Sheet below to tinker with it and evaluate for yourself. To make a copy, click on File -> Make a Copy! docs.google.com/spreadsheets/d/1AOurJzV6OL-7a966GX5sjvhOL5Aqa7NvH_sjonnGKDY/edit?usp=sharing
@ziddiaa71659 күн бұрын
Excellent presentation mate. Love how intellectual and mathematical your videos are.
@hiteshbabani3 күн бұрын
The plan also targets the emotional quotient. Cash flow for the first four years is lower than the loan option which means a person opting for a Tiguan can opt for X1 for similar EMI and within the BMW range, someone opting for X1 on loan can also look at X3 with buyback as the EMI will be similar. Basically, target the segment upgradation itch. Same for Mercedes.
@akshatvaid9 күн бұрын
Very useful video. Your content continues to be insightful.
@pranayk379 күн бұрын
Glad you found it useful! Thank you
@amlendu1239 күн бұрын
You should probably do a split of the screen share with your own picture. It was creating a lot of distraction , the frequent flip between the excel and your narration video.
@pranayk379 күн бұрын
Ok
@gauravarora31948 күн бұрын
@@pranayk37 Try using loom for recording videos with face over screen.
@chandanbansal20048 күн бұрын
@@pranayk37 i agree, but great calculations
@cbrcoder8 күн бұрын
Great Video.Mercedes has similar plan called "Star Agility". End of the day, I think normal bank loan is better because you are not locked into fixed valuation driven decision at the end of 5 year term. Also most business users get Interest deducted from tax so even better deal.
@pankajkanal11575 күн бұрын
Very informative....and the 360 plan actually also makes sense if you want to have lower cash flows.Superb Share
@abhisheksrivastava84799 күн бұрын
BMW 360 plan helps people play "The Status Game".
@pranayk379 күн бұрын
Low EMIs do make it more accessible
@dromlakhani6 күн бұрын
Pranay this is very good What about the taxation? This also changes the picture
@animeshsinha95709 күн бұрын
Essentially the 360 plan is renting the car for 5 years and then giving it back to BMW, with the added worry of accidental damage and higher than prescribed annual mileage (similar to actually renting a self drive car). Doesn’t make sense in my opinion, for people who keep their cars for a longer term.
@animeshsinha95709 күн бұрын
I always wanted to understand the catch behind these financing schemes when I repeatedly configure a 330li and see digestible EMIs. Great video Pranay!
@pranayk379 күн бұрын
Thank you, please share with prospective buyers who might find it useful!
@prakashrbiyani44874 күн бұрын
I have spoken to BMW and they have said that they will evaluate the value during last phase of emi and even if the condition of the car is excellent but market value is lower then they will recover the remaining amount
@PrathamNebhaani5 күн бұрын
Appreciate the video. Thanks
@yashpatil33677 күн бұрын
Great explanation man. Can you also consider making a video about these cars which the brands will sell later as official refurbished? Would love to know about those scenarios as well.
@varunwagle9 күн бұрын
Loved the video! Doesn't the 360˚ Finance Plan also include service cost for 4 years? If we factor that in, the 360 plan would save about an extra lakh rupees, is that a fair assessment?
@pranayk378 күн бұрын
Good point. Though Service and Maintenance package can be purchased when buying through a regular loan and you can negotiate to get it at a low price
@harshasblr8 күн бұрын
But you can drive only 10k kms per year with the 360 plan. I calculated before buying the X5 and bank loan seemed much better because at the end of 4 years or 5 years you will have to clear the rest of the car amount if you want to keep the car. If you do that you will save a little but if you consider to keep the car and continue the loan for the balance amount, you will lose a lot of money.
@pranayk378 күн бұрын
@@harshasblr Beautiful car, congrats! And that's what my analysis shows as well -- 360 plan turns out to be slightly more expensive with the set of assumptions I've taken
@mok25694 күн бұрын
In case of 360, you pay a lower monthly outflow. What if we invest the balance between 360 and regular loan at an estimated 12% yearly return for the next 5 years, we would end up with over 41 lacs in collected amount which can actually be used to pay off the buyback if one decides to keep the car.. what are your thoughts?
@vineeth92587 күн бұрын
Nice one! ! Changed one assumption that the sale value is same as the buy back value (I feel that makes the comparison more equal weighted), and the difference between loan and buy back is 1.5 lakh, so basically you are paying a 1.5 lakh as premium for have the buy back guarantee and also for the work required for selling it back. And regarding one time payment, it directly boils down to the difference between loan interest rate and the assumed discount rate.
@pranayk377 күн бұрын
Glad you played with the google sheet! The intent is to let everyone work with their assumptions and arrive at a decision that they’re comfortable with
@dr.ryanpereira46877 күн бұрын
Hi Pranay, your final opinion is correct, that is normal loan is better than 360 , however there is a higher difference in the interest payments made in 360 compared to normal loan. Please calculate that and see.
@pranayk377 күн бұрын
Even if one is paying more interest in a scenario, how does it matter? As long as the overall outlay is lower
@abe49857 күн бұрын
I have leased a car in North America and this is exactly how it works. Buyback is like leasing a car for a contracted residual value at the end of lease
@pranayk377 күн бұрын
What do people in the US do? Assuming majority take buyback
@sameerdeshpande9 күн бұрын
Will be interesting to see for how much does a 5 year old X1 sell in the second hand market.
@sagars97556 күн бұрын
Never go with these schemes , even for a small scratch at the of 3 yrs they wl make u paint the whole door (if the scratch is on the door) and then take it back , like in the mini condition how u bought it brand new :) biggest scam ever :p
@mahipdeva35439 күн бұрын
Hey Sir! Regards! Super amazing video, loved it, thanks! Need help w a doubt! Got 10k AXIS ATLAS MILES - do I transfer them to Accor before 20th Dec(that damn Rs199+GST) or do I wait for Axis Bank/Accor to have some promotional offer wrt point transfer!? Would sincerly appreciate your help, thankyou tons!
@pranayk378 күн бұрын
I think you can transfer now. The calendar also resets on Dec 31st so might as well transfer to not have this impact your next year's transfer limit
@mahipdeva35438 күн бұрын
@@pranayk37 Oh yes, I just missed that calender reset and the limit, thankyou, you always prove to be a seasoned advisor in all the terms, grateful sincerly!
@vineeth92587 күн бұрын
As an extension, would be great to see a video regarding comparison of the full payment vs loan for a car around 10 - 15 lakh including the other charges and pros and cons.
@pranayk376 күн бұрын
Thanks for the suggestion
@apdlhloon9 күн бұрын
Have an X5 2020 got m340i in march
@pranayk378 күн бұрын
Nice!
@varun38298 күн бұрын
Can you please share the financing on m340i
@apdlhloon8 күн бұрын
We got a normal bank loan from hdfc at 8.75
@jayysetiya92318 күн бұрын
@@varun3829the interest rate on M340i is upwards of 11% if u take the 360 plan but regular banks offer much less rates, i got a M340i at 7.4% interest rate from regular bank , so the difference is huge
@soumyajitdas71628 күн бұрын
Thanks a lot. Exactly what I was looking for. Also, how does company lease policies fare against the 360 plan? Saving on taxes might make it the most lucrative deal, thoughts?
@pranayk378 күн бұрын
The tax benefit of 30% should be higher on a higher sum of EMI. Hence with a company lease, my hunch is that regular loan will be more beneficial since it has the higher monthly emi. But worth checking with someone who might have taken a lease car on a buyback
@soumyajitdas71626 күн бұрын
@@pranayk37Thanks a lot. Yeah, the higher EMI helps on saving few bucks but comes with a higher interest rate too. Need to do some math now 😁. Great content. Keep up the good work and best wishes buddy.
@SarthakGupta-l5d14 сағат бұрын
Your discounting factor is off by few basis points. Second if you take into account the difference of normal EMI vs 360 EMI. You need to factor the expected return generated on that differential amount and discount that back to get the true picture of cost of ownership.
@pranayk3714 сағат бұрын
Return generated is the discounting factor.. instead of taking everything to future value, I've pulled it back to present value. It's the same thing.
@manoouu7 күн бұрын
I was waiting for someone to make this type of NPV calculations and spoon feed me why not to buy a luxury car. 😂
@pranayk377 күн бұрын
😂😂😂
@drbjee9 күн бұрын
Just makes sense !
@adityatripathy88683 күн бұрын
G Do they have a similar plan on x5?
@wwe39rko6518 сағат бұрын
Isnt there 3 option? One to return the bmw,another to buy a new one in exchange of old one or the preferred of all three is to keep the bmw by paying the extra?
@adityatripathy88683 күн бұрын
Do I get depreciation on the full value of the car
@11Subham9 күн бұрын
5,401,610 mehhhh. Would've purchased all cash, sadly falling short by 1000 🤣
@shriram8559 күн бұрын
I’m curious ,if we can buy the car from the 360 plan after someone completes 5 yrs. If someone wants to buy a second hand car, I think this would avoid the hassle of looking in the outside market . What are your thoughts on this??
@pranayk379 күн бұрын
Sure go for it if you find someone looking to sell
@abdulimran38053 күн бұрын
Dezire ya Brezza ki buy back scheme hai toh batao.
@edwinlawrence76948 күн бұрын
Each model has a different percentage of buy buy and it’s according to the millage and the downpayment the video is good for people who want to buy the x1
@pranayk378 күн бұрын
Correct. This is a framework to evaluate. You can change your assumptions in the Google sheet and make your own decision
@ritinv257 күн бұрын
This is essentially leasing marketed under a different name!
@sagars97556 күн бұрын
Exactly bmws r not selling normally so thats the bait 😂
@pujithmarodia9 күн бұрын
Great video, Pranay. I'm keen on hearing your opinion. Does it almost always make more sense to buy used for these types of cars, seeing how the increased taxation has made them quite unreasonable for what you get in return?
@pranayk378 күн бұрын
Depends on the deal you're getting, no thumbrule
@bivinmathew61866 күн бұрын
Hi Pranay, I think you should do a calculation including the applicable taxes, insurance expenses for the years after the first and cost of repairs/maintenance packages for the duration of ownership. Please correct me if I am mistaken, but I understand that the 360 plan includes all of the above, while the same expenses would be additional to the amount that is considered by you for a regular loan. As such, would you think it’s likely that that the 360 plan works out better?
@pranayk376 күн бұрын
Hi, not sure that Service and maintenance package is included, I checked their Terms again. But even if we assume it is, you can buy a service and maintenance package. It costs 88K for an X1 as per their website. One can try negotiating and bringing it down, but yes you're right - it will make BMW 360 slightly better. With the current assumptions, BMW 360 is worse by 1.48L and it will then be worse by ~60K
@bivinmathew61866 күн бұрын
@@pranayk37 The quote you received from BMW considers a “total” insurance cost of INR 82,980 while a single year’s premium for a zero-depreciation policy for the X1 could be much higher. And we need to multiply that amount by 5 times (for 5 years) if the vehicle is bought without the 360 plan. For calculation’s sake, let’s say 1.5 lakhs per year (it could easily be even higher!), this itself adds another 6.7 lakhs to expenditure over five years. The RTO charges on the quote also seem to be noticeably lower than charges paid when purchased ordinarily.
@rsrdubsteps7522 күн бұрын
You are essentially financing the depreciation of the car , looks good on surface. Go for a pre-owned car, best value for money.
@pranayk37Күн бұрын
Not always, but I see your point
@litanmohanta71387 күн бұрын
Whats the logic for 10% discount rate ? What id the right approach to decide % it in this case
@pranayk377 күн бұрын
Whatever you are confident of earning on that money
@rohit508485 күн бұрын
Great analysis. Though, shouldn't the total cost of ownership also include cost of maintenance (~1 lac per year if done at bmw, a total of 5 lacs) and cost of fuel (assuming 50k km, 16 kmpl so a total of 2.8 lacs)? Would be the same in all three scenarios
@shrenictejawat64259 күн бұрын
Shouldn’t the loan amount decrease in the bmw 360 program since bmw is going to buy back at 25L so the loan amount required becomes 26L (51L-25L). Thus decreasing the emi amount
@pranayk379 күн бұрын
The emi amount used is as per their quotation, so it's based on actuals
@cbrcoder8 күн бұрын
The way BMW looks at it is if they are financing the depreciation!
@yogensachdev8 күн бұрын
Question: What exactly is Zerodha's larger network i.e zero1 ?
@pranayk378 күн бұрын
zero1byzerodha.com/network
@Chets9 күн бұрын
Bro just get the zeiss duravision platinum coat dont go for blueguard or blueprotect. My recommendation to you. You will have almost no lens reflection glaring when making videos.
@pranayk379 күн бұрын
😂 this is some zeiss lens only
@Chets8 күн бұрын
@@pranayk37 yep i figured it out by seeing them that is why i recommend u dvp coating rather then dvbp or dvbg. i am optometrist from Pune.
@eshanjain9 күн бұрын
Superb Video! Although with the diverse investment plans and the way stock market has been playing, 10% Discount Rate feels a bit conservative. Thanks to your excel, i could see that if i increase it to 20%, the bmw 360 seems to be the best plan, second being the regular loan followed by the downpayment.
@pranayk379 күн бұрын
10% post tax is almost 14% pre tax. It's not conservative at all IMO. Glad you found the Google sheet useful
@eshanjain9 күн бұрын
@@pranayk37 My bad! Forgot to account for the taxation.
@rishabh78244 күн бұрын
Reminds me of my costing class...
@pranayk374 күн бұрын
😂😂
@anurag-kumar208 күн бұрын
Is the market resale value including inflation-adusted or as of today?
@pranayk378 күн бұрын
Today
@miza007iphone6 күн бұрын
I bought BMW 320ld but I choose not to go buy back plan. I took bank loan N I feel it's better. 10,000 km / year is far less as I go 15000 / year.
@RohanJitSingh8 күн бұрын
I thought balloon scheme was better cuz you can invest the down payment of 7/8 lacs as a lumpsum and then see the calculation as per how much the money has grown over 5 years.. Your thoughts?
@pranayk378 күн бұрын
That's what we've done indirectly. The discount rate of 10% assumes that you'll be able to grow the money at 10%. I've just looked at present value instead of future value. Which are two sides of the same coin
@Adhionyt5 күн бұрын
If i buy a second hand car like 2021 bmw 2 series for 40 lakhs do I want to pay luxury tax and road tax for that,from my state(kerala)
@JewelTalkwithKkunal6 күн бұрын
Just one thing. I am confirm that i will use car only 5 years then upgrade. In that case In 360 plan 65k emi Normal 1L I am getting 35k extra cash flow for my business per month That is 4.20L extra cash for businesss which makes me 25% PA. M I right?
@pranayk375 күн бұрын
Change the 10% to 25% and you'll see buyback will become better
@abdulimran38053 күн бұрын
BMW ka mileage kitna hai
@pranayk37Күн бұрын
Kaafi
@bsr4u19855 күн бұрын
Did you consider the Value of Servicing and Insurance cost for coming 4 years in BMW 360 Finance vs Taking a loan from a Bank.
@adityatripathy88683 күн бұрын
Please tell me if I have to pay tax on the money i get from bmw at the end of 5 years.
@akashdash60239 күн бұрын
I think there's a similar Balloon Financing scheme by Mercedes.
@pranayk378 күн бұрын
It's called mercedes agility plan, yes
@akash40436 күн бұрын
Question can we purchase that 5 yr old car from bmw for 25 lacs
@pranayk375 күн бұрын
Pretty sure they'll make a buck on it
@aslamremeez6408 күн бұрын
Luxuary vehicles are good to keep as second car not the primary car in india.
@pranayk378 күн бұрын
If that's the case, limit of 10k Km in a year probably should be ok
@thiyaga71748 күн бұрын
only concern is that 10000kms/year..! owning a BMW and not driving 10k KMs in a year isn't worth buying ..! i bet buying used BMW is much more worth it
@pranayk378 күн бұрын
They have a 15K km option too.. but I get your point
@ggautham75374 күн бұрын
What do you mean isn’t worth buying? If you can afford it and like the feature and luxury it offers, how does how many kms you ride matter?
@ashishshetty19269 күн бұрын
Why was the road tax 0 ??
@pranayk378 күн бұрын
Didn't notice. Just picked up the actual quotation
@aditya79556 күн бұрын
as a fellow goolger pls dont let him buy an x1, way too overpriced and has 134bhp, 134bhp?????? thats a joke
@pranayk375 күн бұрын
He has bought, and enjoying it
@armangodara22678 күн бұрын
You didn’t consider car discounts though
@pranayk377 күн бұрын
Discount is considered. It's there in the quotation
@proxieddomain13 сағат бұрын
1. Don't buy what you can't afford. 2. If you can afford it then don't sell it till you really need to. 3. If you sell it don't buy what you can't afford.
@pranayk3712 сағат бұрын
Golden
@rohangarg59244 сағат бұрын
hey man- something seems off. Why would anybody buy this car with a regular loan then? everybody would go for the 360 plan since the difference in total cost of ownership is negligible and ofc EMI is much lower in the 360. I guess the catch is the 10k limit on mileage in a year. BMW finance division must be making a loss here as comapred to a regular bank, no?
@rohangarg59244 сағат бұрын
or the buyback price must be higher than the ~29L residual value of the car and not 25L. I get that you have taken the 25L number from the official quote, just saying that this doesn't seem like a good deal for the BMW people although it's a good way to boost sales
@DTruth-m4z5 күн бұрын
Dude...ur all wrong...buy back price is what you pay if you want your car back after 5 years...simple as that
@rohitsharma-gd8ft4 күн бұрын
Agreed
@mand1219946 күн бұрын
What about the opportunity cost of money you would have saved by paying a lower emi with BMW BB plan? Looks like both you and your friend are from science background. 😋
@pranayk375 күн бұрын
That's what the 10% is.. the higher you make it, you'll see buyback plan becomes better
@Y_man09 күн бұрын
so it only makes sense if you have a monthly expendable income of X Rupees as EMI and plan to upgrade to another car. so this is more for affluent enthusiasts who would like to try out a new car every 3 to 5 years depending on their monthly expendable appetite :) it still is very tempting...just need to convince the wife :D
@Y_man09 күн бұрын
@pranay: would you go for it personally? what factors would you consider?
@pranayk379 күн бұрын
Personally I like money in the bank more than a luxury car :) It's something I've often thought about - what's the fine line between "YOLO" and "Money for the future".. and I've made my peace with not spending more than what my portfolio generates in a year. Another way to look at it is spending not more than 5-10% of net worth on a car. Unless of course your net worth is like 100Cr
@Y_man09 күн бұрын
@@pranayk37 for sure! That makes a lot of sense😇 Thanks for replying.. Means a lot❤️
@vinayaksrivastava7 күн бұрын
Best senerio is that don't waste your money into luxury cars which are basically money pit.
@pranayk376 күн бұрын
Fair. Though some people work hard and earn money just to be able to pursue their dream of owning a particular car :)
@18hourgaming669 күн бұрын
X1 not even xDrive more than half a crore - complete loot.
@pranayk379 күн бұрын
I blame it on the taxation more than bmw
@soumyajitdas71628 күн бұрын
@@pranayk37that is so true.
@sideprince698 күн бұрын
When you go electric car you will end up using or traveling a lot
@udayanchabukswar4 күн бұрын
Buying a bmw with so much calculation is a waste. If one has to do all these calculations then dont buy. Because India is unpredictable and anytime someone can ramp into your vehicle/ anything can happen and then all calculations fall apart. Best case scenario is when one can buy a car with no tension.
@mukundipad29 күн бұрын
Paisa zero karne ka scheme
@pranayk378 күн бұрын
That stands true for all luxury cars
@vineetgupta43919 күн бұрын
very misleading video but good point u made the full disclose abt how Excell sheet can be misleading....Ankur wariku excel compounding sheet only works in excel sheet not real life
@pranayk378 күн бұрын
Why misleading?
@sidgupta195717 сағат бұрын
This is not misleading. Pranay is not talking about company stock/mutual fund returns which don’t compound consistently every year. It is a car loan/buy back cost benefit analysis which would exactly look what the excel sheet is showing.
@sunshinelife70555 күн бұрын
Can you review hondas buyback options offered on elevate ,amaze They are advertising 3rd year to 8 th year buyback scheme
@pranayk375 күн бұрын
You can use the same framework and google sheet to evaluate it. The underlying principle doesn't change