Take car loan out of mortgage to improve equity
"I guess I don't understand how you figure that taking out a car loan for $20k will result in adding $20k in equity.  A car loan is a liability, not an asset like your $100k in cash.  Besides, you don't get a dollar-for-dollar consideration when figuring a car's value against the loan it is encumbered by.  In other words, the car is only worth what someone's willing to pay for it, not what your loan amount on it is. Remember that taking on a loan will increase your debt-to-income ratio, which is always a factor when trying to obtain a mortgage.  At the same time, taking on new debt just prior to shopping for a mortgage could make it more difficult to find a lender.  Every time a credit report (hard inquiry) is run on you, it temporarily impacts your credit score.  The only exception to this rule is when it comes to mortgages.  In the U.S., the way it works is that once you start shopping for a mortgage with lenders, for the next 30 days, additional inquiries into your credit report for purposes of mortgage funding do not count against your credit score, so it's a ""freebie"" in a way.  You can't use this to shop for any other kind of credit, but the purpose is to allow you a chance to shop for the best mortgage rate you can get without adversely impacting your credit. In the end, my advice is to stop looking at how much house you can buy, and instead focus on a house with payments you can live with and afford.  Trying to buy the most house based on what someone's willing to lend you leaves no room in the near-term for being able to borrow if the property has some repair needs, you want to furnish/upgrade it, or for any other unanticipated need which may arise that requires credit.  Don't paint yourself into a corner.  Just because you can borrow big doesn't mean you should borrow big. I hope this helps. Good luck!"
"By the sounds of things, you're not asking for a single formula but how to do the analysis... And for the record you're focusing on the wrong thing. You should be focusing on how much it costs to own your car during that time period, not your total equity.  Formulas:  I'm not sure how well you understand the nuts and bolts of the finance behind your question, (you may just be a pro and really want a consolidated equation to do this in one go.) So at the risk of over-specifying, I'll err on the side of starting at the very beginning. Any financial loan analysis is built on 5 items: (1) # of periods, (2) Present Value, (3) Future Value, (4) Payments, and (5) interest rate.  These are usually referred to in spreadsheet software as NPER, PV, FV, PMT, and Rate. Each one has its own Excel/google docs function where you can calculate one as a function of the other 4. I'll use those going forward and spare you the 'real math' equations.  Layout: If I were trying to solve your problem I would start by setting up the spreadsheet  up with column A as ""Period"". I would put this label in cell A2 and then starting from cell A3 as ""0"" and going to ""N"". 5 year loans will give you the highest purchase value w lowest payments, so n=60 months... but you also said 48 months so do whatever you want.  Then I would set up two tables side-by-side with 7 columns each. (Yes, seven.) Starting in C2, label the cells/columns as: ""Rate"", ""Car Value"", ""Loan Balance"", ""Payment"", ""Paid to Interest"", ""Principal"", and ""Accumulated Equity"". Then select and copy cells C2:I2 as the next set of column headers beginning in K2. (I usually skip a column to leave space because I'm OCD like that :) ) Numbers: Now you need to set up your initial set of numbers for each table. We'll do the older car in the left hand table and the newer one on the right. Let's say your rate is 5% APR. Put that in cell C1 (not C3). Then in cell C3 type =C$1/12. Car Value $12,000 in Cell D3. Then type ""Down Payment"" in cell E1 and put 10% in cell D1. And last, in cell E3 put the formula =D3*(1-D$1). This should leave you with a value for the first month in the Rate, Car Value, and Loan Balance columns. Now select C1:E3 and paste those to the right hand table. The only thing you will need to change is the ""Car Value"" to $20,000. As a check, you should have .0042 / 12,000 / 10,800 on the left and then .0042 / 20,000 / 18,000 on the right.  Formulas again: This is where spreadsheets become amazing. If we set up the right formulas, you can copy and paste them and do this very complicated analysis very quickly.  Payment The excel formula for Payment is =PMT(Rate, NPER, PV, FV). FV is usually zero. So in cell F3, type the formula =PMT(C3, 60, E3, 0). Obviously if you're really doing a 48 month (4 year) loan then you'll need to change the 60 to 48. You should be able to copy the result from cell F3 to N3 and the formula will update itself.  For the 60 months, I'm showing the 12K car/10.8K loan has a pmt of $203.81. The 20K/18K loan has a pmt of 339.68.  Interest The easiest way to calculate the interest is as =E3*C3. That's (Outstanding Loan Balance) x (Periodic Interest Rate). Put this in cell G4, since you don't actually owe any interest at Period 0.  Principal If you pay PMT each month and X goes to interest, then the amount to principal is ""PMT - X"". So in H4 type =-F3 - G3. The 'minus' in front of F3 is because excel's PMT function returns a negative amount. If you want to, feel free to type ""=-PMT(...)"" for the formula that's actually in F3. It's your call.  I get 159 for the amount to principal in period 1.  Accumulated Equity As I mentioned in the comment, your ""Equity"" comes from your initial Loan-to-Value and the accumulated principal payments. So the formula in this cell should reflect that. There are a variety of ways to do this... the easiest is just to compare your car's expected value to your loan balance every time. In cell I3, type =(D3-E3). That's your initial equity in the car before making any payments. Copy that cell and paste it to I4. You'll see it updates to =(D4-E3) automatically. (Right now that is zero... those cells are empty, but we're getting there) The important thing is that as JB King pointed out, your equity is a function of accumulated principal AND equity, which depreciates. This approach handles those both.  Finishing up the copy-and-paste formulas I know this is long, but we're almost done.  Rate // Period 1 In cell C4 type =C3.  Payment // Period 1 In cell F4 type =F3.  Loan Balance // Period 1 In cell E4 type =E3-H4. Your loan balance at the end of period is reduced by the principal you paid. I get 10,641.  Car Value // Period 1 This will vary depending on how you want to handle depreciation. If you ignore it, you're making a major error and it's not worth doing this entire analysis...  just buy the prettiest car and move on with life. But you also don't have to get it scientifically accurate. Go to someplace like edmunds.com and look up a ballpark. I'm using 4% depreciation per year for the old (12K) car and 7% for the newer car. However, I pulled those out of my ass so figure out what's a better ballpark.  In G1 type ""Depreciation"" and then put 4% in H1. In O1 type ""Depreciation"" and then 7% in P1. Now, in cell D4, put the formula =D3 * (1-(H$1/12)).  Paste formulas to flesh out table As a check, your row 4 should read 1 / .0042 / 11,960 / 10,641 / 203.81 / 45 / 159 / 1,319. If so, you're great. Copy cells C4:I4 and paste them into K4:Q4.  These will update to be .0042 / 19,883 / 17,735 / 339.68 / 75 / 265 / 2,148.  If you've got that, then copy C4:Q4 and paste it to C5:C63. You've built a full amortization table for your two hypothetical loans. Congratulations.  Making your decision I'm not going to tell you what to decide, but I'll give you a better idea of what to look at. I would personally make the decision based on total cost to own during that time period, plus a bit of ""x-factor"" for which car I really liked.  Look at Period 24, in columns I and Q. These are your 'equities' in each car. If you built the sheet using my made-up numbers, then you get ""Old Car Equity"" as 4,276. ""New Car Equity"" is 6,046. If you're only looking at most equity, you might make a poor financial decision.  The real value you should consider is the cost to own the car (not necessarily operate it) during that time... Total Cost = (Ending Equity) - (Payment x 24) - (Upfront Cash).  For your 'old' car, that's (4,276) - (203.81 * 24) - (1,200) = -1,815.75 For the 'new' car, that's (6,046) - (339.68 * 24) - (2,000) = -4,106.07.  Is one good or bad? Up to you to decide. There are excel formulas like ""CUMPRINC"" that can consolidate some of the table mechanics, but I assumed that if you're here asking you would have gotten stuck running some of those.  Here's the spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0Ah0weE0QX65vdHpCNVpwUzlfYjlTY2VrNllXOS1CWUE#gid=1" Yes, there are times when co-signing is the right choice. One is when you know more about the person than the loan issuer does. Consider a young person who has just started working in a volatile field, the kind of job where you can be told on Friday that you only get one shift next week but things might pick up the week after, and who makes maybe $12 an hour in that job. You've done the math and with 40 hour weeks they can easily afford the loan. Furthermore, you know this person well and you know that after a few weeks of not enough shifts, they've got the gumption to go out and find a second job or a different job that will give them 40 hours or more a week. And you know that they have some savings they could use to ensure that no payments will be missed even on low-wage weeks. You can cosign for this person, say for a car loan to get them a car they can drive to that job, knowing that they aren't going to walk away and just stop making the payments. The loan issuer doesn't know any of that.  Or consider a young person with poor credit but good income who has recently decided to get smart about money, has written out a budget and a plan to rehabilitate their credit, and who you know will work passionately to make every payment and get the credit score up to a place where they can buy a house or whatever their goal is. Again, you can cosign for this person to make that happen, because you know something the lender doesn't. Or consider a middle aged person who's had some very hard knocks: laid off in a plant closing perhaps, marriage failure, lost all their house equity when the market collapsed, that sort of thing. They have a chance to start over again somewhere else and you have a chance to help. Again you know this isn't someone who is going to mismanage their money and walk away from the payments and leave you holding the bag. If you would give the person the money anyway (say, a car for your newly graduated child) then cosigning instead gives them more of a sense of accomplishment, since they paid for it, and gives them a great credit rating too. If you would not give the person the entire loan amount, but would make their payments for many months or even a year (say, your brother's mortgage for the house where he lives with a sick wife and 3 small children), then cosigning is only making official what you would have done anyway.  Arrange with the borrower that if they can't make their payments any more, you will backstop them AND the item (car, house, whatever) is going up for sale to cover your losses. If you don't think you could enforce that just from the strength of the relationship, reconsider co-signing. Then sign what you need to sign and step away from it. It's their loan, not yours. You want them to pay it and to manage it and to leave you out of it until it's all paid off and they thank you for your help. If things go south, you will have to pay, and it may take a while for you to sell the item or otherwise stop the paying, so you do need to be very confident that the borrower is going to make every single payment on time. My point is just that you can have that confidence, based on personal knowledge of character, employment situation, savings and other resources, in a way that a lender really cannot. "It's a little unusual, but I don't think the financial terms are completely unreasonable on their face. What you describe is similar to an interest-only loan, where you make payments that only cover the interest due each month, and the entire principal is due as a single ""balloon payment"" on a specified date (in this case, the date on which the condo is sold).  Your monthly payment of $500 on a principal of $115K is equivalent to an annual interest rate of 5.22%, which at least is not completely usurious.  With a traditional mortgage you might pay a rate as low as 3%, if you had sufficient income and excellent credit - but I don't know, from what you've said, whether that's the case.  Did you make the current arrangement because you were unable to get a loan from a bank? The main difference here is that instead of the balloon payment being a fixed $115K, it's ""75% of the gross proceeds of the sale"".  If the condo eventually sells for $155K, that would be $116,250, so that's slightly advantageous to them (assuming that ""gross proceeds"" means ""before deducting commissions for either the buyers' or sellers' realtors or any other costs of the sale""), and thus slightly disadvantageous to you.  If the condo appreciates in value, that's more of a win for them and more of a relative loss for you.  But it's also possible that the value of the condo goes down, in which case this arrangement is better for you than a fixed balloon payment.  So this deal does prevent you from getting a larger share of any gains in the value of the property, but it also helps insulate you from any losses.  That's important to keep in mind. There's also the issue of needing their consent to sell.  That's potentially problematic - usually in a joint ownership scheme, either owner has the right to demand to be bought out or to force a sale.  I guess it depends on whether you think your parents would be likely to consent under reasonable circumstances, or to insist on holding the property against your best interests. It's true that you aren't building equity with this arrangement, and if you thought you were, you are mistaken or misled.  But let's compare it with other options. If you would qualify for a traditional 30-year fixed mortgage at 3%, your monthly payment would be slightly lower ($484), and you would be building some equity because your payments would reduce the principal as well as paying the interest.  But a 30-year loan builds equity very slowly at first - after 7 years you'd have only about $20,000 in principal paid down. If we assume that 5.2% represents the interest rate you'd otherwise pay based on your creditworthiness, then your monthly payment would be $631.  So compared to that, you have an extra $130 per month that you can save or invest in whatever you want - you're not forced to invest it in your house. Note that in either case you'd still be paying the condo fees, property taxes, insurance, and maintenance yourself.  So we might as well eliminate those from consideration.   It might be a good idea to find out what other options you would have - perhaps try to get an interest rate quote on a traditional mortgage from a bank, based on your income and credit history.  Then you can decide what to do, taking into account: your financial situation; how much of a monthly payment could you afford? your relationship with your parents; are they likely to be reasonable about renegotiating?  Do they in general tend to respect your wishes?  Would it harm your relationship if you tried to get out of the deal, and how important is that to you? To what extent do you actually want to pay for equity in this property? Do you really believe it's a good investment, and have evidence to support that?   Your options include: Try to renegotiate the terms of the loan from your parents Try to ""refinance"" the loan, by getting a loan from a bank and paying off some agreed-upon amount of principal to your parents Try to force the sale of the condo and move to another house, financing it some other way Consult a lawyer as to whether your agreement with your parents is legally enforceable.  For instance, do they have a lien on the property?" Use the $11k to pay down either car loan (your choice). You should be able to clear one loan very quickly after that lump sum. After that, continue to aggressively pay down the other car loan until it is clear. Lastly, pay off the mortgage while making sure you are financially stable in other areas (cash-on-hand, retirement, etc) Reasoning: The car loans are very close in value, making it a wash as far as payoff speed. The 2.54% interest is not a large factor here. As a percentage of all these numbers, the few bucks a month isn't going to change your financial situation. This is assuming you will pay off both loans well ahead of schedule, making the interest rate negligible in the answer. Paying off the mortgage last is due to the risk associated with the car loans. The cars are guaranteed to lose value at an alarming rate. While a house certainly may lose value, it is far from an expectation. It is likely that your house will maintain and/or increase in value, unless you have specific circumstances not disclosed here. This makes the mortgage a lower risk loan in your financial world. You can probably sell the house to clear the loan balance if necessary. The cars are far more likely to depreciate beyond the loan balance. As for refinancing: Many institutions charge up-front fees when doing any type of vehicle loan. Typically this is in the neighborhood of 1% the value of the loan, with a floor of $100 (although this may vary by lender). However, for the loan the be secured by the vehicle, the principle value must be less than the collateral value. In your case, this means there is a collateral shortfall of $4,000. When working with a traditional bank, you would have two options: pay the difference up front (reducing the principle value of the loan), or obtaining a separate loan for the difference. This separate loan would often have a higher interest rate unless you have some other form of collateral to secure it with. I doubt CarMax would do a separate loan. All that being said, if you plan on selling the vehicle within the next twelves months, don't bother refinancing. It won't be worth the hassle. The risk besides the extra interest is that you might be upside down on the loan. Because the car loses value the moment you drive off the lot, the slower you pay it off the longer it takes to get the loan balance below the resale value. Of course if you have a significant down payment, the risk of being upside down is not as great. Even buying a used car doesn't help because if you try to sell it back to the dealer the next week they wont give you the full price you paid. Some people try and split the difference, get the longer term loan, but then pay it off as quickly as the shorter term loan. Yes the interest rate is higher but if you need to drop the payment back to the required level you can do so. Why would you trade a lower interest rate over a higher one?  I wouldn't use the mortgage to pay off the car.  Also, you should have loan/lease payoff on your auto insurance, which if the car is totaled means your loan would be paid by insurance.  I don't think you'd be able to take advantage of that if your car payments become one with the mortgage.  Finally not all mortgage interest may be deductible. Also, I can't think of any way you'd be able to use the car loan to pay off the mortgage.  You wouldn't be able to borrow more than the car is worth, and for a new car it loses quite a bit of value immediately. What's missing in your question, so Kate couldn't address, is the rest of your financial picture.  If you have a fully funded emergency account, are saving for retirement, and have saved up the $15K for the car, buy in cash.  If you tell me that if the day after you buy the car in cash, your furnace/AC system dies, that you'd need to pay for it with an $8K charge to a credit card, that's another story.  You see, there's more than one rate at play. You get close to zero on you savings today. You have a 1.5% loan rate available. But what is your marginal cost of borrowing? The next $10K, $20K? If it's 18% on a credit card, I personally would find value in borrowing at sub-2.5% and not depleting my savings.  On the other side, the saving side, does your company offer a 401(k) with company match? I find too many people obsessing over their 6% debt, while ignoring a 100% match of 4-6% of their gross income.  For what it's worth, trying to place labels on debt is a bit pointless. Any use of debt should be discussed 100% based on the finances of the borrower.