Final Exams and Video Playlists: www.video-tutor.net/
@ube-23s
3 ай бұрын
Can you calculate it without a calculator/formula.?
@jgideon27
3 жыл бұрын
Man, you're great. I love how you take an excel lesson and turn it into life lessons - get that interest down is right!
@HelenaAkorli-lk4gs
Ай бұрын
Thanks for this information.. actually was stuck with a little task given to me by my tutor and of course I have sorted it out because of this man's information
@susanaspiegel7692
3 жыл бұрын
Thank you so much for this video! I experience a lot of anxiety when it comes to doing math problems to the point where adrenaline kicks in. Your video helped me figure it out in just a few minutes and I'm so grateful to you.
@mhelbrinas386
2 жыл бұрын
Sinigang na isda
@paulmccoy2334
Жыл бұрын
Really help me out alot to understand how it's calculated
@cristinasmith1092
5 жыл бұрын
THANK YOU SO MUCH!! YOU ARE AMAZING. I'm taking accounting online for the summer and it's been rough. Seriously I owe you a huge thank you! God bless
@kiawilliams5541
3 жыл бұрын
Straight to the point! You made it so easy!! THANK YOU!!
@kirkwhitfield5257
Ай бұрын
brilliant video learnt how much my mortgage will cost
@LegendaryBoneThugs
11 ай бұрын
saved me HUNDREDS of dollars on new HVAC system and Car Loan. Thanks, really easy to follow along!!
@apathetic5913
3 жыл бұрын
Thank you for taking your time to teach us. I understand this way better than my teacher explained. This will be very beneficial for my upcoming math assessment! 👍
@zindela210
2 жыл бұрын
Thank you so much. Excel spreadsheet was so helpful. I am an engineer and I really got stuck with this financial problem 💲💲💲 #SouthAfrica 🌍
@GrandMastaYosh
2 жыл бұрын
Thank you! This helped with my final project...
@LoneStarStinger
4 жыл бұрын
Omg you just helped me so much. This is EXACTLY what I needed for my math project
@thebatmanwhoeatsnachos2863
3 жыл бұрын
Same lol ,dumb taco truck interest project
@donny4405
2 жыл бұрын
This Channel literally has EVERYTHING! I love this, helped me in my Excel class!
@ecinaj026
4 жыл бұрын
Thank you so much for this video, I finally have done the assessment that I was struggling for a few days on how to work it out.
@sunnypandey1920
4 жыл бұрын
Pls help me dear
@tanisha9069
Жыл бұрын
this man knows everything
@FunnyFernandez
Жыл бұрын
God bless you !!! Was stuck on this damn thing for 2 hours KZitem was my last hope
@SR-sk6py
2 жыл бұрын
Had problems with these questions; thanks for your video , this help me a lot 👏.
@teconlilian4080
2 жыл бұрын
You SAVED my day! Very well explained. Thank you so much!
@anthonyrivera5490
3 ай бұрын
I'm so glad I saw this video. I wanted to know how to get rid of the negative monthly payment, and you showed me how. Thank you very much, I really appreciate it!
@nacho8049
Жыл бұрын
So clear and perfectly explained. Thanks for this great video!!
@kyasane
3 жыл бұрын
Great video! Thank you so much for this! Absolute life saver.
@Tendertroll1
4 жыл бұрын
Thanks so much, this helps me a lot before I head into the dealership !
@BrittanyAllen01
3 ай бұрын
Thank you for the information and helpful tips😊
@IsThisPaulYin.
3 ай бұрын
Bro, how you know everything? When I was high school, I used to watch your videos for my cal class and AP chem, and now I am in college studying finance. And I was watching this video to learn some tips on using excel and the voice sounded familiar, and I saw it's you again. Thanks for your videos, helping me through my career!
@anayelizuniga1503
Жыл бұрын
Thank you so much. I have been struggling even after other people had shown me. You made more easy and understanding.😊
@Elly-gu5wn
2 жыл бұрын
I thought this is just a tutorial about excel and calculation. A bonus words of wisdom in the end. Which i always hear from my any person who doesn’t want to use debt. I’ll rather used debt to produce more income out of it.
@Jags22079
Жыл бұрын
Thank you for the video
@rayson0101
2 жыл бұрын
Man, thank you so much. Your explaination save me a lot of troubles. Appreciated, Good video!
@sxylkn36
5 жыл бұрын
Thank You for sharing!!
@tejashreeambawade6266
Жыл бұрын
Thank you. Your efforts are much appreciated
@Leslie.mp3
3 жыл бұрын
You just saved my life, I was so lost on this chapter of my excel course, and my exam is due this week! You are a great teacher!
@Sylvia.Torres
7 ай бұрын
Great video! Thank you!
@tomosmells
2 жыл бұрын
Simple and to the point, nice vid
@berlindaarmijo9251
3 жыл бұрын
Thank you. Well done! Wanted to get an idea for the 5 acres I would like to purchase before I make an appt to the bank.
@kg655
4 жыл бұрын
Thank you! I really appreciate it.
@sandimarielavati2354
4 жыл бұрын
Martinez is legit and reliable. Have worked with him some months back and believe me he’s one of the legit hackers he’s the best if you need help with paying off debt ,credit score fix , credit card ,bank account,phone hack, PayPal hack . Contact him on +12013507159 via WhatsApp Mail him on martinezraber@gmail.com
@accountsmarronbrosltd3254
2 жыл бұрын
Thank you so much. Now I can make decisions with this formula.
@als2ff27
Жыл бұрын
Thank You man! Appreciate it :)
@raeleneeldridge436
Жыл бұрын
Very clearly explained. Thank you
@koran_4e271
Жыл бұрын
Thank you this was very helpful
@TheBlunderBoard
3 жыл бұрын
Thanks a lot, you help me to fix a little issue i had on my excel sheet
@ayseriraq100
2 жыл бұрын
Appreciated your kindly offer your explanation are great.
@tareqzrekat3611
7 ай бұрын
Thanks man!
@sankettrama1472
4 жыл бұрын
Thanks it helped ... Love from India
@christopherhillsofficial
2 жыл бұрын
School never thought me shit. Another weapon added to my knowledge 🔥🔥
@barcyettehenriquezpastene6406
Жыл бұрын
Thank you!
@sklee1644
2 жыл бұрын
Thanks. It is very clear.
@keyettashelton
3 жыл бұрын
Good info thanks so much
@IceLyle
Жыл бұрын
You helped solve the mystery for us thanks very much
@jaymuller6004
3 жыл бұрын
Amazing explanation !!! Simple and effective
@TheOrganicChemistryTutor
3 жыл бұрын
Thanks!
@jaymuller6004
3 жыл бұрын
@@TheOrganicChemistryTutor ....I just watched your other video "How To Create an Amortization Table In Excel"... very well done again
@ifeomachime4771
3 жыл бұрын
Very helpful.
@RajKaregaKhalsa1984
8 ай бұрын
Great Video
@christyhart1777
4 жыл бұрын
This is great, how would i add the rounding function to 2 places in this formula
@sevegarza4768
2 жыл бұрын
This is a fantastic walk-through. There is one thing I would like to say about the mortgage calculation part around min. 7:20 in the video you mention negotiating an interest rate. In 2022 there is no real way to negotiate your interest rate if you use a conventional loan from a bank or private lender. All of their loan rates are determined by your credit score, income, and debt-to-income ratio.. So rather than try to renegotiate something that isn't negotiable, you could work on improving your debt to income ratio, put more cash down, earn more income, or you can pay down points at closing to reduce your interest rate. Something else to note is that most home loans do not have a penalty for paying them off early.
@keithashford1219
Жыл бұрын
I agree with this to an extent. While you may not be able to negotiate with one lender, you are able to shop around to see who will give the better deal.
@seanlyons-nt2kz
Жыл бұрын
Thanks so much
@frandygaming9621
3 жыл бұрын
Really helped me
@hyfzyvahlobitana6388
2 жыл бұрын
Thank you so much.
@chamnabkem5459
4 жыл бұрын
Such a useful source to watch! Thanks sir for this wonderful video ❤️
@BaldurKhr
2 жыл бұрын
Man, you are amazing
@maryoitr600
2 жыл бұрын
nice that help ful content
@katietravadi2362
3 жыл бұрын
god this helped, you covered everything too god bless
@talyakarabulut1634
2 жыл бұрын
Really helpful :)
@3gkevh53
3 жыл бұрын
Thanks man
@visswaayful
Жыл бұрын
🙏 thank you
@hubbabt
4 жыл бұрын
Annual rate you mentioned here is it the stated rate or it is the effective interest rate?
@Barbie-iy8oq
4 жыл бұрын
Thanks allot
@CristhianTR
2 жыл бұрын
Good video man! What would happen if the interest in the first 03 years would be 0% and 3.15% for the following 07 years? how could I calculate that?
@danielm.9552
3 жыл бұрын
tysmm
@jukieramus
3 жыл бұрын
Does the pmt formula use straight line or reducing balance method ?
@shobhanapatel4113
4 жыл бұрын
Thanks for this video But one thing I do not under stand-in a personal loan they take out monthly payment 197.00 then end of the month then 45.00 as withdrawal
@Dehcorum
4 жыл бұрын
If someone was sending it to you would you sign on this? If so where would you sign
@soulvqant
3 жыл бұрын
can we still get monthly payment without having loan amount but we have the future value? or do we need to use other financial formula?
@whitetailfarms05
4 жыл бұрын
would you be willing to help build a payment amortization. I have to have insurance and taxes along with extra payments and actual payment made columns.
@kawaiidarkbutterfly5570
3 жыл бұрын
I was staring at my computer for a few hours trying to figure out a formula to use that works
@ronnak8427
5 ай бұрын
Is there a way of making a Mortgage calculator with prepayments?
@jjsmallpiece9234
4 жыл бұрын
If the interest rate is variable, you need to change the number of repayments, if yoy have made some payments at a different interest rate already
@eneoji2580
2 жыл бұрын
Is this example computation apply annuity??
@Puja_vlogger
3 ай бұрын
Which excel you are using
@itsreallyalvarez
3 жыл бұрын
Can you add a balloon?
@sreytouchkong8838
2 жыл бұрын
Thank you, if we borrow money from bank the amount 3000$ have 3 years the interest 1.45% for month how we calcuate this ? Thank you
@JahidHasan-rt4mz
3 жыл бұрын
i wish i could donate something for this channel..
@LuisRodriguez-sv3gu
3 ай бұрын
For total interest I had to put it like this =-cell-cell if not it would add both cells instead of subtracting. Can someone explain why this is happing?
@mohiuddinbabor8744
4 жыл бұрын
If the payment is at the end of the year, what will happen?
@clearcontentment3695
2 жыл бұрын
The best idea is to pay it in install Ments of one dollar over the next two millenniums
@purabkhatiwora6504
2 жыл бұрын
How to calculate the amount of time of EMI when we know the principal amount, rate of interest and emi amount?
@MuhammadFarrukh-yr7uk
10 ай бұрын
What if there is a charge off or bad debt in period 7? or if the loan book has an annualised bad debt of 1% per annum.What's the formula then ?
@cavey93
2 жыл бұрын
By dividing the interest rate by 12 you are not calculating the proper compound interest per month. Results will not be too different though.
@presncubez
Жыл бұрын
Very good observation the interest, the monthly interest is not properly calculated
@ambrose_8
2 жыл бұрын
Can't seem to find a formula explanation for interest paid after X years, since we know we pay more interest in the first years of a loan.
@cameronspalding9792
4 жыл бұрын
Is this based on compound interest
@sandimarielavati2354
4 жыл бұрын
Martinez is legit and reliable. Have worked with him some months back and believe me he’s one of the legit hackers he’s the best if you need help with paying off debt ,credit score fix , credit card ,bank account,phone hack, PayPal hack . Contact him on +12013507159 via WhatsApp Mail him on martinezraber@gmail.com
@saraguerrero2432
2 жыл бұрын
how much of each payment is interest?
@chanelzero0831
2 жыл бұрын
WHY IS THERE A NEGATIVE IN C8, I mean how can I get a correct or actual value without the negative its messing up my whole sheet
@jjsmallpiece9234
4 жыл бұрын
Instant gratification is best, when you have a new car,
@Puja_vlogger
3 ай бұрын
Monthly mortgage payment is error It's showing #value !
@zizis9839
Жыл бұрын
what if you have the term (20 yrs), the interest rate (7%) and the monthly pymt ($3488). How do you calculate the loam amount?
@LegendaryBoneThugs
11 ай бұрын
Easy, your LOAN AMOUNT is "about" $450,000. Monthly payments of $3,488.85. Total Cost will be $837,322.85. Total Interest Paid $387,322.85 Hope this helps. You're paying almost TWICE what the house is worth. ouch.
@TheBioethicist
Жыл бұрын
When I do the exact same formula it gives me a payment of $8,333. What's going wrong?
@kinnarikateja5064
4 жыл бұрын
Total cost is principal + total interest
@sandimarielavati2354
4 жыл бұрын
Martinez is legit and reliable. Have worked with him some months back and believe me he’s one of the legit hackers he’s the best if you need help with paying off debt ,credit score fix , credit card ,bank account,phone hack, PayPal hack . Contact him on +12013507159 via WhatsApp Mail him on martinezraber@gmail.com
@billp7151
3 жыл бұрын
NY ACCENT? OR JERSEY ACCENT?
@osthelovevibes8857
2 жыл бұрын
Number of payment how calculated 120 answer? ????
@srai6433
2 жыл бұрын
(No. of years)10 * 12 months in a year = 120 months
@jjsmallpiece9234
4 жыл бұрын
no point paying increased payments if you can't then afford to buy short term needs like food, power bills etc
@christopherdouglas1711
3 жыл бұрын
Some months back I tried renting an apartment from TRUILA but I had a low credit score of 616 due to my unpaid student loans. So I was being denied of every offer due to my credit. I had lived with my sister for quite some time , when she put to birth the house became cramped. I was recommended to Credit patchup LLC by a co worker. I contacted them at jon@creditpatchup.com They got back to me almost immediately and we came to an agreement and they started to work on my credit profile. 10days after the work my score jumped +170 points , they marked all late payments as on time payments and cleared the negatives affecting my file. I issued for the rental again this time on Zillow and was given a home. I’m glad I met Credit patchup LLC
Пікірлер: 130