My girl needed a bank statement and stub last week and I was worried about her loosing her not getting her car loan 😴 but everything good now only because of deelscafe good work 👍.
@therealsaint30752 жыл бұрын
@Bitrus Sabo same here
@randyhaimila71184 жыл бұрын
This function was rather intimidating to me at first, but he explained it so well and put me at ease.
@akredytoshoot4 жыл бұрын
And where do you put the state tax?
@suzifood57863 жыл бұрын
I like how you teach your viewers to know how to do this. it's so clear and easy to understand thank you❤️💪
@SixMinutesSmarter3 жыл бұрын
You're so welcome! However, don't get car loans...Pay cash!
@phillipburrell90039 ай бұрын
Great instructions! This is exactly what I needed. Thanks for putting this out.
@peggystreetinfluencer2 жыл бұрын
Ralph, this was amazing and so easy to understand! Thank you!
@hcab81183 жыл бұрын
Best video ever regarding this topic
@learner3404 Жыл бұрын
I always like your tutorial and your voice.
@adamadam3718 Жыл бұрын
Good Job, I solved my exam question quickly.
@elmengh2 жыл бұрын
awesome video and super easy to understand, I did just like you demonstrated then I copy column then added a few columns so that Im able to display several scenarios. thanks for posting!!
@SixMinutesSmarter2 жыл бұрын
Glad it helped! I read an article this weekend that the average new car price is now $47,000 and the average monthly car payment is $700. That is insane to me. I really like the idea of making side-by-side calculators so you can see the impact of a different down payment or a different interest rate.
@elmengh2 жыл бұрын
@@SixMinutesSmarter yeah I believe this too as lower supply has created higher demand for cars so some dealers are adding "Market Adjustment" fee of $3k and last month I see theyre rasing it to $5k so thats my first qst when i call and if answer is yes then I hang up and call nxt dealership lol.
@sreevandana5482 Жыл бұрын
Thank you so much. I was looking for this 😊👍
@elvergontemeto7142 жыл бұрын
Brother what happened to the local tax they always include on every single vehiclr they sell
@aerynsunn7500 Жыл бұрын
Fantastic! You explained it so well. Thank you.
@kelly415504 жыл бұрын
Hello, Can you make a video of total cost of ownership of a car for 5yrs? Thanks
@beverleyb53722 жыл бұрын
Question for you @Six Minutes. Smarter. : I noticed in the Total Cost of Finance field that you did "=Total Paid-Cost of Car." This would have the finance cost also include the down payment instead of being the interest only, correct? Shouldn't the Cost of Finance be only interest since that is the amount you are forced to pay over what you borrowed? Am I thinking incorrectly on this? Thanks for your help!
@telljansiddiqi5 ай бұрын
you are amazing the way you explain
@matthewbishop8743 Жыл бұрын
Why are you including downpayment amount in the amount financed for the formula on line 8?
@ronnijernigan9839 Жыл бұрын
Hello! QQ, can you do this formula while adding the number of days until the first payment and how that would affect the outcome
@jrjohnson78754 жыл бұрын
What if there was no loan borrowed. Would I just use the price of the product?
@robindelgado58782 жыл бұрын
Great job on the explanation. Ty!
@ceec49912 жыл бұрын
How would we do this in reverse? For example I’m paying $300 a month, for 72months (6 years), with an interest rate of 5%. What’s the formula to find the total loan amount? (I keep seeing =PV, but I’m confused at how when I use PV, the outcome is a lesser number then if I multiply monthly payment (300) by Term (72 months). How is it more expensive at 0%? I’m so confused and need help Ralph.
@amazingmage2222 Жыл бұрын
I am having an issue with this format. It breaks my amortization schedule unless I set the interest to 0% totally confused here
@vbuen3233 жыл бұрын
Awesome video but if you’re putting a down payment, the total cost of the car decreases, but you wrote the formula where the total cost increases. You need to enter a negative value to determine true price of the car. The way you entered it was taking on another $4500, which isn’t accurate. The total value borrowed would be $-4500 less and thus decreasing monthly payment and less interest owed.
@SixMinutesSmarter3 жыл бұрын
Total price of the car must include the down payment. A big down pmt reduces loan and finance cost, but not the price.
@deedixon17292 жыл бұрын
what about the state taxes
@Hemapapacutie4 жыл бұрын
Bro I need help in excel
@reardelt2 жыл бұрын
Is the first installment at time=0 or 1 month after?
@waseemullahkhan2 жыл бұрын
Thank you, simply explained
@saraguerrero24323 жыл бұрын
Is there always going to be down payment? My teacher gave me a problem but did not mentioned anything about finding the down payment
@SixMinutesSmarter3 жыл бұрын
No, there doesn't have to be a down payment. The down payment is used to reduce the amount of the loan. The loan amount is really what you use in the PMT function. To make the calculator more realistic, I like having down payment amount and calculate the loan by subtracting the down payment from the car price. If you want, enter 0 as the down payment and you'll see the loan is the same as the car price. You could even enter a negative value in the down payment and that would indicate you're borrowing more than the price of the car. This might occur if you were rolling older car trade-in debit into the new loan.
@diem82133 жыл бұрын
Very clear! This is awesome!!! Thank you! Much aloha! ❤️🙏🏽⭐️
@gabrielrojas87183 жыл бұрын
And the estate taxes? Many times people finance this cost too..
@tinagirl19923 жыл бұрын
This really helped. Thank you.
@WAN0N03 жыл бұрын
Great vid. Thank you 👌
@ShawnPenoyer Жыл бұрын
can i hire you to create a calculator format in Excel if i provide you the details?
@diem82133 жыл бұрын
Would love a video on leasing a car with the spreadsheet
@SixMinutesSmarter3 жыл бұрын
I'll look into that, but leasing a car is even worse than getting a car loan. Best to avoid it.
@moneymakingdrip25003 жыл бұрын
big question i want this bmw m4 cs really bad its 50,000 grand when i loan it and three years later the car price is depreacted like 20,000 grade well do i still have to pay that 50,000 grade or the price of what its going to be?
@SixMinutesSmarter3 жыл бұрын
buy a Honda and save up. Three years later, buy the M4 for 30 grand. If you buy two M4s, i’ll take one.
@moneymakingdrip25003 жыл бұрын
@@SixMinutesSmarter i found this 2018 bmw m4 for 37,000 but its the regular one i truly want the cs one but i guess i should just get the 37,000 one and buy the other one in the uture because the msrp is gonna be like a whole 30,000 more just for the cs
@SixMinutesSmarter3 жыл бұрын
Geez, I just looked up the BMW M4 CS. It's like $70,000 - $100,000 US. I'll have to stick with my 5-year-old Ford a little bit longer. Even better, invest the $70K in a fund averaging 11% for the next 20 years and you'll end up with $564,000.
@moneymakingdrip25003 жыл бұрын
@@SixMinutesSmarter also roth ira if you invest 230,000 over 20 or 30 years and you'll have 2 million and spending it down have 4 million I want the car because I'm young and if I start making 12,000 a month and put 5 thousand a month would be fun
@brianm19013 жыл бұрын
but what if youre paying bi-weekly?
@Cybercredible2 жыл бұрын
I also got two biweekly paystub for my loan to be approved.
@ceec49912 жыл бұрын
Can you do one including taxes
@SixMinutesSmarter2 жыл бұрын
Easiest to create a couple new rows under car price. One row for taxes and another row for price+taxes. You may pay taxes all at start along with down payment. Or some may roll taxes into the loan, increasing the balance and loan payments. Taxes will vary by state, and some states (like Oregon) won't have taxes. There could be some other fees to include, too. Destination charge and doc processing fees.
@molgallery Жыл бұрын
It is still approximation because taxes and fees are not included in final payment …
@SixMinutesSmarter Жыл бұрын
taxes and fees at purchase are often included in the purchase price. You could make fields for the car price, one for taxes, one for fees. Then, total that and make a total price. Use the total price in the calculation. Total price - down payment = loan amount.
@madisontaylorz2 жыл бұрын
WOW! Thank you!
@cdaniels92893 жыл бұрын
Thank you so much...😊.
@francoisopperman73663 жыл бұрын
Hello. Lets say I want to include the deposit in the price of the car, meaning the company pays the deposit and not the customer. How would I calculate that in Excel. Deposit may change from 10% / 15% / 20% / 30% / 40%
@SixMinutesSmarter3 жыл бұрын
I'd create a couple of extra rows (cells) beneath original price. So, we might have list price of the car as $30,000, then have a value for deposit rate. That would be the value of 10%, 15%, etc. Then the cell below would be Modified car price. That would be =(original list price) - (original list price * deposit rate). Now, you'd base your loan calculations off the modified car price. But the cost of finance would be based on the original list price. This is an interesting scenario where a company benefit can really make a car lease or car loan a very good deal.
@marvinshield69353 жыл бұрын
What about tax
@SixMinutesSmarter3 жыл бұрын
yep, the price of the car should include taxes and other fees. Those will vary by state (no sales tax in Oregon ). However, i bet most people financing a car roll those costs into the loan. for more detail, create a few additional rows under car price. include tax, fees, other. then have a row for total price. The rest would be the same. total price - down payment is loan amount.