Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • Elite Member Topic Starter
13 years ago
Okay, so I got a new car, blah blah. This loan stuff is confusing as hell to me.

I'd like to see a break down of every payment that I make and what I owe versus what the interest is as I go along.

I'm trying to do this in excel, but failing.

Do I apply the financing percent after every month, or every year? And is it the anniversary of the sale of the car, or Jan 1st?

Edit, kind of like this.
UserPostedImage
UserPostedImage
Cheesey
  • Cheesey
  • 100% (Exalted)
  • Preferred Member
13 years ago
You SHOULD have got a contract that tells you how much you will actually pay for the car by the end of the payments.
UserPostedImage
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • Elite Member Topic Starter
13 years ago

You SHOULD have got a contract that tells you how much you will actually pay for the car by the end of the payments.

"Cheesey" wrote:



Yes, I have that, but I like numbers and want to play with it. I'll be having it paid off in far less than 72 months.
UserPostedImage
Cheesey
  • Cheesey
  • 100% (Exalted)
  • Preferred Member
13 years ago
That should save you alot of money, interest wise.
UserPostedImage
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • Elite Member Topic Starter
13 years ago

That should save you alot of money, interest wise.

"Cheesey" wrote:

Hoping so bud. πŸ™‚ I figure if I throw about 100 extra a month, plus half of my bonus and tax return every year, it should go down quick.
UserPostedImage
Cheesey
  • Cheesey
  • 100% (Exalted)
  • Preferred Member
13 years ago
You bought a 100 thousand dollar car!?!?


(j/k!)LOL
UserPostedImage
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • Elite Member Topic Starter
13 years ago

You bought a 100 thousand dollar car!?!?


(j/k!)LOL

"Cheesey" wrote:

lol, heck no! I owe 10k. You were only one ZERO away. πŸ˜‰
UserPostedImage
vikesrule
DakotaT
  • DakotaT
  • 100% (Exalted)
  • Select Member
13 years ago
Just go to ammortization schedule and pump in your loan amount, interest, and duration and then check the box to see full schedule.
UserPostedImage
macbob
  • macbob
  • 100% (Exalted)
  • Veteran Member
13 years ago

You bought a 100 thousand dollar car!?!?


(j/k!)LOL

"Zero2Cool" wrote:

lol, heck no! I owe 10k. You were only one ZERO away. ;)

"Cheesey" wrote:



Zero-I'd have to agree with Cheesey. Your loan example in your first post is for $100K...I'd sell your house and live in the car...
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • Elite Member Topic Starter
13 years ago
The example is ... an example. It relates nothing to my financial purchase at all. I was merely showing with a graphical representation what my goal is to achieve.
UserPostedImage
Porforis
  • Porforis
  • 100% (Exalted)
  • Veteran Member
13 years ago

The example is ... an example. It relates nothing to my financial purchase at all. I was merely showing with a graphical representation what my goal is to achieve.

"Zero2Cool" wrote:



You were looking to achieve a $100,000 car?
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • Elite Member Topic Starter
13 years ago

The example is ... an example. It relates nothing to my financial purchase at all. I was merely showing with a graphical representation what my goal is to achieve.

"Porforis" wrote:



You were looking to achieve a $100,000 car?

"Zero2Cool" wrote:



Thanks for trying to help, greatly appreciate it.
UserPostedImage
macbob
  • macbob
  • 100% (Exalted)
  • Veteran Member
13 years ago

The example is ... an example. It relates nothing to my financial purchase at all. I was merely showing with a graphical representation what my goal is to achieve.

"Zero2Cool" wrote:



You were looking to achieve a $100,000 car?

"Porforis" wrote:



Thanks for trying to help, greatly appreciate it.

"Zero2Cool" wrote:



Z-just trying to have fun in principle while we figure out how to help. Your example looks good, but I would add a column for your additional payments so that you can do a comparison between alternatives.

The amount of the payment going to interest would be calculated off of the interest rate and the principal balance.

Your principal should be calculated from your previous principal minus the difference between your interest owed from your previous payment and the total amount of your previous payment, with 100% of whatever extra payment you make coming off the principal.

So, principlely, I'd recaclulate the interest each payment, since the principal remaining would change each period. You would just have to modify your principal column to subtract out the additional payment in the previous row.
vegOmatic
13 years ago
There's this thing called the "Internet." On the internet is an outfit called "Google."

You can then find something like this:

http://www.ezcalculator.com/paybreak.htm 

And yes, if you Wiki "Asshole" you'll find my picture there. πŸ˜›
blank
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • Elite Member Topic Starter
13 years ago
I did check the internet, found several items, but none of which I'm seeking. How else do you think I found the graphic?


It's extremely insulting and offensive to be told to use the internet, especially when you're talking to a guy who once googled how to tie a tie half hour before a job interview.
UserPostedImage
vegOmatic
13 years ago
I hope you had a suit to go along with the tie. πŸ™‚
blank
dhpackr
  • dhpackr
  • 60% (Friendly)
  • Registered
13 years ago
use a Pert formula, you should be able to create an algebraic expression to find the values you want.

Pert formula 

you will need a multi-line calculator and no how to compute logarithms.
So if you meet me Have some courtesy, Have some sympathy, and some taste
Use all your well-learned politesse, Or I'll lay your soul to waste
Fan Shout
Mucky Tundra (17h) : Happy Birthday wpr!
Zero2Cool (17h) : Anders Carlson ... released by 49ers
dfosterf (20h) : Happy Birthday!😊😊😊
wpr (21h) : Thanks Kevin.
Zero2Cool (23h) : Happy Birthday, Wayne! πŸŽ‰πŸŽ‚πŸ₯³
beast (7-Nov) : Edge Rushers is the same... it's not the 4-3 vs 3-4 change, it's the Hafley's version of the 4-3... as all 32 teams are actually 4-2
Zero2Cool (6-Nov) : OLB to DE and player requests trade. Yet folks say they are same.
beast (5-Nov) : In other news, the Green Bay Packers have signed Zero2Cool to update their website πŸ˜‹ jk
beast (5-Nov) : Might just re-sign the kicker we got
beast (5-Nov) : Are there any kickers worth drafting next year?
Zero2Cool (5-Nov) : Preston Smith for Malik Willis
Mucky Tundra (5-Nov) : Getting a 7th rounder from the Stillers
Zero2Cool (5-Nov) : At least we get 7th round pick now!! HELLO NEW KICKER
Mucky Tundra (5-Nov) : Steelers getting a premier lockdown corner!
Zero2Cool (5-Nov) : Packers are trading edge rusher Preston Smith to the Pittsburgh Steelers, per sources.
Mucky Tundra (5-Nov) : Preston Smith traded to the Steelers!!!!
Zero2Cool (5-Nov) : CB Marshon Lattimore to Commanders
Zero2Cool (5-Nov) : Bears are sending RB Khalil Herbert to the Bengals, per sources.
Zero2Cool (5-Nov) : ZaDarius Smith continues his "north" tour.
Zero2Cool (5-Nov) : Let the Chiefs trade a 5th for him
Zero2Cool (5-Nov) : Nearing 30, large contract, nope.
Martha Careful (5-Nov) : any interest in Marshon Lattimore?
Zero2Cool (4-Nov) : What does NFL do if they're over cap?
Mucky Tundra (4-Nov) : They've been able to constantly push it out through extensions, void years etc but they're in the hole by 72 million next year I believe
hardrocker950 (4-Nov) : Seems the Saints are always in cap hell
Mucky Tundra (4-Nov) : Saints HC job is not an envious one; gonna be in cap hell for 3 years
Mucky Tundra (4-Nov) : Dennis Allen has now been fired twice mid-season with Derek Carr as his starting QB
Zero2Cool (4-Nov) : Kuhn let go
beast (4-Nov) : I wonder if the Packers would have any interest in Z. Smith, probably not
Zero2Cool (4-Nov) : Shefter says Browns and Lions will figure out how to get a deal done for Za'Darius Smith..
Zero2Cool (4-Nov) : Packers are more likely to have 1,000 yard rusher than 4,000 yard passer
Zero2Cool (3-Nov) : It's raining hard.
Zero2Cool (3-Nov) : Packers inactives vs. Lions: CB Jaire Alexander S Evan Williams C Josh Myers Non-injury inactives: WR Malik Heath OL Travis Glover DE Bren
packerfanoutwest (3-Nov) : Malik Willis: My focus is helping the Packers win, not proving I can start elsewhere. But he could
Zero2Cool (1-Nov) : I had Texans, but the loss of another WR flipped me
wpr (1-Nov) : I thought about taking the Jets but they've been a disaster. Losing to the Pats last week
Zero2Cool (1-Nov) : Surprised more didn't pick Jets in Pick'em.
Please sign in to use Fan Shout
2024 Packers Schedule
Friday, Sep 6 @ 7:15 PM
Eagles
Sunday, Sep 15 @ 12:00 PM
COLTS
Sunday, Sep 22 @ 12:00 PM
Titans
Sunday, Sep 29 @ 12:00 PM
VIKINGS
Sunday, Oct 6 @ 3:25 PM
Rams
Sunday, Oct 13 @ 12:00 PM
CARDINALS
Sunday, Oct 20 @ 12:00 PM
TEXANS
Sunday, Oct 27 @ 12:00 PM
Jaguars
Sunday, Nov 3 @ 3:25 PM
LIONS
Sunday, Nov 17 @ 12:00 PM
Bears
Sunday, Nov 24 @ 3:25 PM
49ERS
Thursday, Nov 28 @ 7:20 PM
DOLPHINS
Thursday, Dec 5 @ 7:15 PM
Lions
Sunday, Dec 15 @ 7:20 PM
Seahawks
Monday, Dec 23 @ 7:15 PM
SAINTS
Sunday, Dec 29 @ 12:00 PM
Vikings
Saturday, Jan 4 @ 11:00 PM
BEARS
Recent Topics
11h / Around The NFL / beast

6-Nov / Green Bay Packers Talk / Zero2Cool

6-Nov / Green Bay Packers Talk / Zero2Cool

6-Nov / Green Bay Packers Talk / beast

6-Nov / Green Bay Packers Talk / Mucky Tundra

6-Nov / Green Bay Packers Talk / Martha Careful

5-Nov / Green Bay Packers Talk / Mucky Tundra

5-Nov / Green Bay Packers Talk / Zero2Cool

5-Nov / Featured Content / Zero2Cool

5-Nov / GameDay Threads / Cheesey

5-Nov / Green Bay Packers Talk / Martha Careful

5-Nov / Green Bay Packers Talk / Martha Careful

5-Nov / Green Bay Packers Talk / Martha Careful

4-Nov / Green Bay Packers Talk / beast

2-Nov / Around The NFL / wpr

Headlines
Copyright Β© 2006 - 2024 PackersHome.comβ„’. All Rights Reserved.