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
@ziddiaa7165Ай бұрын
Excellent presentation mate. Love how intellectual and mathematical your videos are.
@hiteshbabaniАй бұрын
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.
@prosenjitkarmakar423318 күн бұрын
Very good explanation capturing most of the important parameters. Thanks mate
@akshatvaidАй бұрын
Very useful video. Your content continues to be insightful.
@pranayk37Ай бұрын
Glad you found it useful! Thank you
@march26camel2 күн бұрын
great presentation.. !! Thanks a lot..
@cbrcoderАй бұрын
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.
@abhisheksrivastava8479Ай бұрын
BMW 360 plan helps people play "The Status Game".
@pranayk37Ай бұрын
Low EMIs do make it more accessible
@pankajkanal1157Ай бұрын
Very informative....and the 360 plan actually also makes sense if you want to have lower cash flows.Superb Share
@prakashrbiyani4487Ай бұрын
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
@amlendu123Ай бұрын
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.
@pranayk37Ай бұрын
Ok
@gauravarora3194Ай бұрын
@@pranayk37 Try using loom for recording videos with face over screen.
@chandanbansal2004Ай бұрын
@@pranayk37 i agree, but great calculations
@manojpentakota3004Ай бұрын
You should add 1 more comparison vs full payment. Post dp, do a systematic withdrawal plan with the remaining cash, and see how that goes. That way, you don't miss the opportunity cost of cash in hand.
@dromlakhaniАй бұрын
Pranay this is very good What about the taxation? This also changes the picture
@abe4985Ай бұрын
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
@pranayk37Ай бұрын
What do people in the US do? Assuming majority take buyback
@animeshsinha9570Ай бұрын
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.
@animeshsinha9570Ай бұрын
I always wanted to understand the catch behind these financing schemes when I repeatedly configure a 330li and see digestible EMIs. Great video Pranay!
@pranayk37Ай бұрын
Thank you, please share with prospective buyers who might find it useful!
@SarthakGupta-l5dАй бұрын
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.
@pranayk37Ай бұрын
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.
@sameerdeshpandeАй бұрын
Will be interesting to see for how much does a 5 year old X1 sell in the second hand market.
@sagars9755Ай бұрын
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
@manoouuАй бұрын
I was waiting for someone to make this type of NPV calculations and spoon feed me why not to buy a luxury car. 😂
@pranayk37Ай бұрын
😂😂😂
@vineeth9258Ай бұрын
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.
@pranayk37Ай бұрын
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
@anurup8725 күн бұрын
Very nice video
@PrathamNebhaaniАй бұрын
Appreciate the video. Thanks
@ritinv25Ай бұрын
This is essentially leasing marketed under a different name!
@sagars9755Ай бұрын
Exactly bmws r not selling normally so thats the bait 😂
@chiragsankhala597410 күн бұрын
Hi Pranay . Regards great video . But does this mean BMW finance division is making huge losses for selling their car in Indian market ? Are they making profits. ? I mean the finance division ?
@varunwagleАй бұрын
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?
@pranayk37Ай бұрын
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
@harshasblrАй бұрын
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.
@pranayk37Ай бұрын
@@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
@mok2569Ай бұрын
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?
@dharnikshah26229 күн бұрын
The difference of cash flow savings between the 360* plan and the normal bank EMI has to be calculated into this? Even a 4-6% safe returns, would further reduce the cost of 360* plan ?
@dr.ryanpereira4687Ай бұрын
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.
@pranayk37Ай бұрын
Even if one is paying more interest in a scenario, how does it matter? As long as the overall outlay is lower
@premjitc23 күн бұрын
I see a nice time trial bike set up in the background !!
@pranayk3723 күн бұрын
I'm actually selling it because I upgraded to a new bike. Let me know if you're interested. It's a road bike, polygon strattos S4. Its less than a year old
@premjitc23 күн бұрын
@ Thanks a lot !! Just upgraded to an Orbea Orca Aero ! But great content , very well laid out.
@yogensachdevАй бұрын
Question: What exactly is Zerodha's larger network i.e zero1 ?
@pranayk37Ай бұрын
zero1byzerodha.com/network
@miza007iphoneАй бұрын
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.
@bivinmathew6186Ай бұрын
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?
@pranayk37Ай бұрын
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
@bivinmathew6186Ай бұрын
@@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.
@shriram855Ай бұрын
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??
@pranayk37Ай бұрын
Sure go for it if you find someone looking to sell
@vineeth9258Ай бұрын
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.
@pranayk37Ай бұрын
Thanks for the suggestion
@drbjeeАй бұрын
Just makes sense !
@adityatripathy8868Ай бұрын
Do I get depreciation on the full value of the car
@yashpatil3367Ай бұрын
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.
@shrenictejawat6425Ай бұрын
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
@pranayk37Ай бұрын
The emi amount used is as per their quotation, so it's based on actuals
@cbrcoderАй бұрын
The way BMW looks at it is if they are financing the depreciation!
@soumyajitdas7162Ай бұрын
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?
@pranayk37Ай бұрын
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
@soumyajitdas7162Ай бұрын
@@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.
@adityatripathy8868Ай бұрын
G Do they have a similar plan on x5?
@litanmohanta7138Ай бұрын
Whats the logic for 10% discount rate ? What id the right approach to decide % it in this case
@pranayk37Ай бұрын
Whatever you are confident of earning on that money
@bkjhunАй бұрын
I'm about to buy one with a hefty year end discount....normally i agree bank loan is better that the 360 plan. But with such a heavy discount does 360 make better sense?
@pranayk37Ай бұрын
You can input your values in the Google sheet and take your own call :)
@RohanJitSinghАй бұрын
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?
@pranayk37Ай бұрын
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
@edwinlawrence7694Ай бұрын
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
@pranayk37Ай бұрын
Correct. This is a framework to evaluate. You can change your assumptions in the Google sheet and make your own decision
@RushrushhhАй бұрын
Have an X5 2020 got m340i in march
@pranayk37Ай бұрын
Nice!
@varun3829Ай бұрын
Can you please share the financing on m340i
@RushrushhhАй бұрын
We got a normal bank loan from hdfc at 8.75
@jayysetiya9231Ай бұрын
@@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
@11SubhamАй бұрын
5,401,610 mehhhh. Would've purchased all cash, sadly falling short by 1000 🤣
@rsrdubsteps752Ай бұрын
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
@rohit50848Ай бұрын
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
@abdulimran3805Ай бұрын
Dezire ya Brezza ki buy back scheme hai toh batao.
@mahipdeva3543Ай бұрын
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!
@pranayk37Ай бұрын
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
@mahipdeva3543Ай бұрын
@@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!
@pujithmarodiaАй бұрын
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?
@pranayk37Ай бұрын
Depends on the deal you're getting, no thumbrule
@anurag-kumar20Ай бұрын
Is the market resale value including inflation-adusted or as of today?
@pranayk37Ай бұрын
Today
@adityatripathy8868Ай бұрын
Please tell me if I have to pay tax on the money i get from bmw at the end of 5 years.
@bsr4u1985Ай бұрын
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.
@eshanjainАй бұрын
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.
@pranayk37Ай бұрын
10% post tax is almost 14% pre tax. It's not conservative at all IMO. Glad you found the Google sheet useful
@eshanjainАй бұрын
@@pranayk37 My bad! Forgot to account for the taxation.
@VivekKumar-l9b2c10 күн бұрын
Where is the excel sheet?😅
@pranayk3710 күн бұрын
Pinned comment
@VivekKumar-l9b2c10 күн бұрын
@ that was quick 🫠 Thanks for sharing! The BMW 360 plans are well-crafted and deliver clear information. Each aspect of the plan is explained thoroughly, helping potential buyers make informed decisions. Great job Pranay, for making remarkable videos. Keep up the good work 👍
@proxieddomainАй бұрын
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.
@pranayk37Ай бұрын
Golden
@ChetsАй бұрын
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.
@pranayk37Ай бұрын
😂 this is some zeiss lens only
@ChetsАй бұрын
@@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.
@ashishshetty1926Ай бұрын
Why was the road tax 0 ??
@pranayk37Ай бұрын
Didn't notice. Just picked up the actual quotation
@JewelTalkwithKkunalАй бұрын
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?
@pranayk37Ай бұрын
Change the 10% to 25% and you'll see buyback will become better
@akash4043Ай бұрын
Question can we purchase that 5 yr old car from bmw for 25 lacs
@pranayk37Ай бұрын
Pretty sure they'll make a buck on it
@rishabh7824Ай бұрын
Reminds me of my costing class...
@pranayk37Ай бұрын
😂😂
@AdhionytАй бұрын
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)
@wwe39rko65Ай бұрын
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?
@rohangarg5924Ай бұрын
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?
@rohangarg5924Ай бұрын
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
@pranayk37Ай бұрын
It is a compelling offer by bmw. My assumption is that the Lifetime value of the buyback customer is much higher than regular loan and that's why bmw does this Also the final buyback price after 5 years is something that isn't set in stone. They can change it later depending on market dynamics
@ashred9665Ай бұрын
Getting a 1.5 L car for 60+ L should be illegal and punishable for sheer foolishness.
@pranayk37Ай бұрын
A large part of it is the taxation also
@akashdash6023Ай бұрын
I think there's a similar Balloon Financing scheme by Mercedes.
@pranayk37Ай бұрын
It's called mercedes agility plan, yes
@armangodara2267Ай бұрын
You didn’t consider car discounts though
@pranayk37Ай бұрын
Discount is considered. It's there in the quotation
@aslamremeez640Ай бұрын
Luxuary vehicles are good to keep as second car not the primary car in india.
@pranayk37Ай бұрын
If that's the case, limit of 10k Km in a year probably should be ok
@mand121994Ай бұрын
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. 😋
@pranayk37Ай бұрын
That's what the 10% is.. the higher you make it, you'll see buyback plan becomes better
@abdulimran3805Ай бұрын
BMW ka mileage kitna hai
@pranayk37Ай бұрын
Kaafi
@thiyaga7174Ай бұрын
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
@pranayk37Ай бұрын
They have a 15K km option too.. but I get your point
@ggautham7537Ай бұрын
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?
@aditya7955Ай бұрын
as a fellow goolger pls dont let him buy an x1, way too overpriced and has 134bhp, 134bhp?????? thats a joke
@pranayk37Ай бұрын
He has bought, and enjoying it
@Y_man0Ай бұрын
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_man0Ай бұрын
@pranay: would you go for it personally? what factors would you consider?
@pranayk37Ай бұрын
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_man0Ай бұрын
@@pranayk37 for sure! That makes a lot of sense😇 Thanks for replying.. Means a lot❤️
@DTruth-m4zАй бұрын
Dude...ur all wrong...buy back price is what you pay if you want your car back after 5 years...simple as that
@rohitsharma-gd8ftАй бұрын
Agreed
@vinayaksrivastavaАй бұрын
Best senerio is that don't waste your money into luxury cars which are basically money pit.
@pranayk37Ай бұрын
Fair. Though some people work hard and earn money just to be able to pursue their dream of owning a particular car :)
@sheryazkhan16803 күн бұрын
Can we buy the car in cash by paying 50% amount? 🤔
@devanshsofta26 күн бұрын
One thing that people don’t understand when you buy the car on loan you get a tax deduction over the interest amount paid but when you lease the car you get a tax deduction on the entire monthly payment
@pranayk3726 күн бұрын
What's the upper limit for tax deduction on car loan interest? I know for real estate is 2L per annum, wasn't aware for car loan
@18hourgaming66Ай бұрын
X1 not even xDrive more than half a crore - complete loot.
@pranayk37Ай бұрын
I blame it on the taxation more than bmw
@soumyajitdas7162Ай бұрын
@@pranayk37that is so true.
@sideprince69Ай бұрын
When you go electric car you will end up using or traveling a lot
@craigslist132328 күн бұрын
Any financial manipulation like this is NEVER profitable for the customer, be it car buying or some fancy loan
@udayanchabukswarАй бұрын
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.
@vineetgupta4391Ай бұрын
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
@pranayk37Ай бұрын
Why misleading?
@sidgupta1957Ай бұрын
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.
@mukundipad2Ай бұрын
Paisa zero karne ka scheme
@pranayk37Ай бұрын
That stands true for all luxury cars
@sunshinelife7055Ай бұрын
Can you review hondas buyback options offered on elevate ,amaze They are advertising 3rd year to 8 th year buyback scheme
@pranayk37Ай бұрын
You can use the same framework and google sheet to evaluate it. The underlying principle doesn't change