Monthly payment on a compounded daily car loan? [duplicate]
I would like to know how they calculated such monthly payment The formula is:  Your values would come out to be: r = (1+3.06/(100*365))^31-1=0.002602 (converting your annual percentage to a monthly rate equivalent of daily compounded interest) PV = 12865.57 n = 48 Inserting your values into the formula: P = [r*(PV)]/[1-(1+r)^(-n)] P = [0.002602*(12865.57)]/[1-(1.002602)^(-48)] P = 285.47
The fluctuation of interest rates during the next year could easily dwarf the savings this attempt to improve your credit score will have; or the reverse is true. Will the loan improve your score enough to make a difference? It will not change the number of months old your oldest account is. It will increase the breadth of your accounts. Applying for the car loan will result in a short term decrease in the score because of the hard pull. The total impact will be harder to predict.  A few points either way will generally not have an impact on your rate. You will also notice the two cores in your question differ by more than 30 points. You can't control which number the lender will use. You also have to realize the number differs every day depending on when they pull it that month. The addition of a car loan, assuming you still have the loan when you buy the house, will not have a major impact on your ability to get afford the home mortgage. The bank cares about two numbers regarding monthly payments: the amount of your mortgage including principal, interest, taxes and insurance; and the amount of all other debt payments: car loan, school loans, credit cards. The PITI number should be no more than 28%-33% of your monthly income; the other payments no more than 10%.  If the auto loan payments fit in the 10% window, then the amount of money you can spend each month on the mortgage will not be impacted. If it is too large, then they will want to see a smaller amount of your income to go to PITI. If you buy the car, either by cash or by loan, after you apply for the mortgage they will be concerned because you are impacting directly numbers they are using to evaluate your financial health. I have experienced a delay because the buyer bought a car the week before closing. The biggest impact on your ability to get the loan is the greater than 20% down payment, Assuming you can still do that if you pay cash for the car.  Don't deplete your savings to get to the 50% down payment level. Keep money for closing costs, moving expenses, furnishing, plus other emergencies. Make it clear that you can easily cover the 20% level, and are willing to go higher to make the loan numbers work. "I'm impressed.  She must have a substantial income to agree to a $500/month car payment.  I imagine her income is about 20K per month for that to make sense.  What kind of work does she do?  To answer your question, typical lease do not work the way you describe.  Paying an extra $2000 will allow you to skip 4 payments (provided the payments were exactly $500) any time in the future.  It does not modify the terms of the lease which would include the payment amount.  Also one does not receive a fiance charge reduction benefit as with a loan.  Essentially you are providing a loan to the leasing company for free. To be explicit you cannot tell the mortgage company anything as she is applying for the loan, not you.  She can tell the mortgage company the new payment is $400, but she would be falsifying the application which is not advisable. Perhaps the mortgage company is doing her a favor.  They are indicating her life is out of control financially.  Either she is attempting to purchase way to much home or her consumer debt is out of control.  It could be a combination of both.   My first paragraph was written to be ""tongue in check"" in order to demonstrate absurdity.  Without a substantial income and an substantial net worth, a 500/month car payment is simply ridiculous.  While it is someone average, when you compare it to the average income (~54K/year) you understand why 78% of US households live paycheck-to-paycheck (are broke), and have no retirement savings. For your and her sake, please stop giving all your hard earned money to banks." This is not the case with your brother only. There are many business which run on this premise. It goes till the time all the conditions are in control and get busted when things goes out of way.  You have mentioned the loan amount and not the monthly repayment amount. Even if you say, a new loan will not solve his problem, what are the way out ? Telling things nicely sometime does not work especially when facts are otherwise. Hence you need to make a compete case study which should also consider his capacity to pay. As of now it seems he has debts of around 20 months of his earning, which can be considered high, depending upon the terms of major loan such as car loan and personal loan. A case study is way out. You can explain him with such case study that he should not go for further loans. Easier to copy paste than type this out. Credit: www.financeformulas.net Note that the present value would be the initial loan amount, which is likely the sale price you noted minus a down payment.   The loan payment formula is used to calculate the payments on a loan.   The formula used to calculate loan payments is exactly the same as the   formula used to calculate payments on an ordinary annuity. A loan, by   definition, is an annuity, in that it consists of a series of future   periodic payments. The PV, or present value, portion of the loan payment formula uses the   original loan amount. The original loan amount is essentially the   present value of the future payments on the loan, much like the   present value of an annuity. It is important to keep the rate per period and number of periods   consistent with one another in the formula. If the loan payments are   made monthly, then the rate per period needs to be adjusted to the   monthly rate and the number of periods would be the number of months   on the loan. If payments are quarterly, the terms of the loan payment   formula would be adjusted accordingly. I like to let loan calculators do the heavy lifting for me. This particular calculator lets you choose a weekly pay back scheme. http://www.calculator.net/loan-calculator.html A loan that does not begin with **at least a 20% deposit** and run through a term of **no longer than 48 months** is the world's way of telling you that *you can't afford this vehicle*.  Consumer-driven cars are rapidly depreciating assets. Attenuating the loan to 70 months or longer means that payments will not keep up with normal depreciation, thus trapping the buyer in an upside down loan for the entire term. Hi guys, have a question from my uni finance course but I’m unsure how to treat the initial loan (as a bond, or a bill or other, and what the face value of the loan is).  I’ll post the question below, any help is appreciated.  “Hi guys, I have a difficult university finance question that’s really been stressing me out....  “The amount borrowed is $300 million and the term of the debt credit facility is six years from today  The facility requires minimum loan repayments of $9 million in each financial year except for the first year.  The nominal rate for this form of debt is 5%. This intestest rate is compounded monthly and is fixed from the date the facility was initiated.  Assume that a debt repayment of $10 million is payed on 31 August 2018 and $9million on April 30 2019. Following on monthly repayments of $9 million at the end of each month from May 31 2019 to June 30 2021.  Given this information determine the outstanding value of the debt credit facility on the maturity date.”  Can anyone help me out with the answer? I’ve been wracking my brain trying to decide if I treat it as a bond or a bill.”  Thanks in advance, The principal of the loan is the amount you borrow.  The capitalized interest is added to the principal of the loan, because you are not paying this interest as it accrues.  So when you begin payments, the principal of the loan is $5,500 + $436 = $5,936. Using the standard amortization formula (see this page for details), the per-month payment for a ten-year payment plan at 6.8% interest on principal of $5,936 is $68.31.  One hundred twenty payments (each month for ten years) totals $8,197.40. The MWRR that you showed in your post is calculated incorrectly. The formula that you use... ($15,750 - $15,000 - $4,000) / ($15,000 + 0.5 x $4,000) Translates into a form of the DIETZ formula of (EMV-BMV-C)/(BMV + .5 x C) The BMV is the STARTING balance. And as a matter of fact, the starting balance was NOT 15,000. It was IN FACT 11,000. See, the starting value for a month MUST BE the ending value of the prior month. So the BMV of 11,000 would give you the correct answer. Because if you added 4,000 at the start of the month (on day 1), it would have to have been ADDED to the 11,000 of the PRIOR month's ENDING value. Make sense? That would also mean that the addition of 4000 to the 11000 would imply that you started day 1 with 11,000. Make sense? Summary: When doing the calculations, you may use the ending value on the last day of the month to get your EMV. BUT YOU MAY NOT take the ending value on day 1 to get the BMV. That simply can not make sense since you already added a bunch of money during the day. Think about it. Davie Since the compounding period and payment period differs (Compounded Daily vs Paid Monthly), you need to find the effective interest rate for one payment period (month).   This means that each month you pay 0.33387092772% of the outstanding principal as interest.  Then use this formula to find the number of months:  Where PV = 21750, Pmt = 220, i = 0.0033387092772  That gives 120 Months.  Depending on the day count convention, (30/360 or 30.416/365 or Actual/Actual), the answer may differ slightly. Using Financial Calculator gives extremely similar answer.  The total cash paid in the entire course of the loan is 120 x $220 = $26,400 I think you are making this more complicated that it has to be.  In the end you will end up with a car that you paid X, and is worth Y. Your numbers are a bit hard to follow.  Hopefully I got this right. I am no accountant, this is how I would figure the deal: The payments made are irrelevant.  The downpayment is irrelevant as it is still a reduction in net worth.   Your current car has a asset value of <29,500>.  That should make anyone pause a bit.   In order to get into this new car you will have to finance the shortfall on the current car (29,500), the price of the vehicle (45,300), the immediate depreciation (say 7,000).  In the end you will have a car worth 38K and owe 82K.  So you will have a asset value of <44,000>.  Obviously a much worse situation.  To do this car deal it would cost the person 14,500 of net worth the day the deal was done.  As time marched on, it would be more as the reduction in debt is unlikely to keep up with the depreciation. Additionally the new car purchase screen shows a payment of $609/month if you bought the car with zero down.  Except you don't have zero down, you have -29,500 down.  Making the car payment higher, I estamate 1005/month with 3.5%@84 months.  So rather than having a hit to your cash flow of $567 for 69 more months, you would have a payment of about $1000 for 84 months if you could obtain the interest rate of 3.5%. Those are the two things I would focus on is the reduction in net worth and the cash flow liability.   I understand you are trying to get a feel for things, but there are two things that make this very unrealistic.  The first is financing.  It is unlikely that financing could be obtained with this deal and if it could this would be considered a sub-prime loan.  However, perhaps a relative could finance the deal. Secondly, there is no way even a moderately financially responsible spouse would approve this deal.  That is provided there were not sigificant assets, like a few million. If that is the case why not just write a check? "Loan officer here. Yes. You pay the per diem. I'd recommend not paying it off for like 6 months. You can pay it down to basically nothing and then hold it for six months and pay it off. Better for credit. If it's a simple interest rate, most car loans are, multiply the current principal balance by the interest rate and divide it by 365. That's the per diem or daily interest. For example, ""10,000 dollar auto loan at 3%. 10000*0.03= 300. 300/365= 0.82. So each day the balance is 10k the loan cost 82 cents. So in a month, your first payment is 100 dollars, 24.65 goes to interest 75.35 goes to principal. Then the new principal is 9924.65. So the next month, another 30 days with the new per diem of 0.815, the 100 payment is 75.50 in principal 24.50 in interest and so on." If you're able to pop this data into excel you can quickly calculate the solution. Every one of these problems boils down to 'Interest Rate', 'Term', 'Payment', 'Present Value', and 'Future Value' (FV will typically be zero). Excel has a formula to calculate any of these components based off of the other inputs.   In this case, the given information is: Interest Rate: 7.56%  Term: 36 Months Monthly PMT: $350 Present Value: ?   You can use the =PV() formula and input the other known values. One caveat is that you'll need to adjust the interest rate to account for the monthly compounding. So, the formula would be =PV(.0063,36,-350). This gives a result of $11,242, which is the amount you'd be able to borrow. [All of these can also be solved on the TI-84+, but I don't have my old calculator on me to walk through the steps]  To calculate the total interest paid, you would then find out how much you'll be paying over the life of the loan. If your monthly payment is $350 for 36 months, the total amount you'd pay is $12,600 ($350*36). Subtract the $11,242 calculated in step one, and you are left with $1,358 worth of interest.   Hope that makes sense. Let me know if you want me to go over any of the steps in more detail. As a former finance student, I would highly recommend locking down the TVM functions, as they will pop up quite often throughout your schooling/career.   Best of luck! There is a 3rd option: take the cash back offer, but get the money from a auto loan from your bank or credit  union. The loan will only be for. $22,500 which can still be a better deal than option B. Of course the monthly payment can make it harder to qualify for the mortgage. Using the MS Excel goal seek tool and the pmt() function:  will make the total payment equal to 24K. Both numbers are well above the rates charged by my credit union so option C would be cheaper than option B. If your APR is quoted as nominal rate compounded monthly, the APR is 108.6 %. Here is the calculation, (done in Mathematica ). The sum of the discounted future payments (p) are set equal to the present value (pv) of the loan, and solved for the periodic interest rate (r).  Details of the effective interest rate calculation can be found here. http://en.wikipedia.org/wiki/Effective_interest_rate#Calculation "a link to this article grabbed my Interest as I was browsing the site for something totally unrelated to finance.  Your question is not silly - I'm not a financial expert, but I've been in your situation several times with Carmax Auto Finance (CAF) in particular. A lot of people probably thought you don't understand how financing works - but your Car Loan set up is EXACTLY how CAF Financing works, which I've used several times. Just some background info to anyone else reading this - unlike most other Simple Interest Car Financing, with CAF, they calculate per-diem based on your principal balance, and recalculate it every time you make a payment, regardless of when your actual due date was.  But here's what makes CAF financing particularly fair - when you do make a payment, your per-diem since your last payment accrued X dollars, and that's your interest portion that is subtracted first from your payment (and obviously per-diem goes down faster the more you pay in a payment), and then EVerything else, including Any extra payments you make - goes to Principal. You do not have to specify that the extra payment(S) are principal only. If your payment amount per month is $500 and you give them 11 payments of $500 - the first $500 will have a small portion go to interest accrued since the last payment - depending on the per-diem that was recalculated, and then EVERYTHING ELSE goes to principal and STILL PUSHES YOUR NEXT DUE DATE (I prefer to break up extra payments as precisely the amount due per month, so that my intention is clear - pay the extra as a payment for the next month, and the one after that, etc, and keep pushing my next due date). That last point of pushing your next due date is the key  - not all car financing companies do that. A lot of them will let you pay to principal yes, but you're still due next month. With CAF, you can have your cake, and eat it too. I worked for them in College - I know their financing system in and out, and I've always financed with them for that very reason.  So, back to the question - should you keep the loan alive, albeit for a small amount. My unprofessional answer is yes! Car loans are very powerful in your credit report because they are installment accounts (same as Mortgages, and other accounts that you pay down to 0 and the loan is closed). Credit cards, are revolving accounts, and don't offer as much bang for your money - unless you are savvy in manipulating your card balances - take it up one month, take it down to 0 the next month, etc. I play those games a lot - but I always find mortgage and auto loans make the best impact.  I do exactly what you do myself - I pay off the car down to about $500 (I actually make several small payments each equal to the agreed upon Monthly payment because their system automatically treats that as a payment for the next month due, and the one after that, etc - on top of paying it all to principal as I mentioned).  DO NOT leave a dollar, as another reader mentioned - they have a ""good will"" threshold, I can't remember how much - probably $50, for which they will consider the account paid off, and close it out. So, if your concern is throwing away free money but you still want the account alive, your ""sweet spot"" where you can be sure the loan is not closed, is probably around $100.  BUT....something else important to consider if you decide to go with that strategy of keeping the account alive (which I recommend). In my case, CAF will adjust down your next payment due, if it's less than the principal left. SO, let's say your regular payment is $400 and you only leave a $100, your next payment due is $100 (and it will go up a few cents each month because of the small per-diem), and that is exactly what CAF will report to the credit bureaus as your monthly obligation - which sucks because now your awesome car payment history looks like you've only been paying $100 every month - so, leave something close to one month's payment (yes, the interest accrued will be higher - but I'm not a penny-pincher when the reward is worth it - if you left $400 for 1.5 years at 10% APR - that equates to about $50 interest for that entire time - well worth it in my books. Sorry for rambling a lot, I suck myself into these debates all the time :)"