How to Make a Budget in Excel - Aux. 1

This is part 1 in an Auxiliary series of step-by-step instructional videos aimed to help the viewer learn how to create a simple yet versatile family budget for home use, w/ an emphasis on getting-out & staying-out of debt. This series is a viewer-driven series: comments, questions, and feedback are always welcome and used to create additional content.

Don't forget to Like, Subscribe, and Share this video with anyone else you feel could benefit from learning how to Control their Money.

Support the Channel:

This is the 2nd Edition of this video. If you have been redirected here from the 1st Edition, welcome! If you are a new viewer, welcome!

Comments and feedback are welcome. Don't forget to subscribe to get updates and new videos on the Budget series as well as additional tutorials.

Thanks to "Jeff & Danny" for contributing their music to the video. If you like the music, make sure to tell them in the comments below!

[icemanjg]

The blooper clip at the end had both me and my wife in stitches. Always nice to end financial sit-downs with a bit of comedic relief.

[rkestep]

Thank you so much for creating these videos! I just found them 3 days ago and have been super excited as I follow along and input my numbers. I feel so much more in control now that I can see what is what and where it is all going. God Bless you and again, thank you so much. Blessings.

[reneehouse]

hi, just wanted to say your videos are great. really easy to understand. just one thing about the LAS. if your bank allows you to, you are much better off paying your payments weekly instead of monthly. you can save a really large amount of interest.
great job! keep it going.

[matthewbaguet]

I liked your additions to the amortization table. I do have one comment on the video / formulas - you have the text listed as "Months saved off loan" but the formula you entered represented 'years' off loan. Making extra payments shave off years of payments rather than a few monthly payments as you discussed in the video. That's why there are so many extra lines of info at the bottom of the spreadsheet after the loan is payed off - this displays extra 'months saved' off loan. Overall, great job on the video!

[saltyd]

You do a great Job on your videos. How can you make a chart for a credit card when the emergency comes up and you have to use the credit card.

[shareewynter]

I'm working from a macbook pro and I'm still fairly new to this software. I'm having issues unlocking the sheet on my MacBook Pro as well as gradient fills from you previous video series.

[Advocatekids]

I can not  express to you how appreciative I am of you making this series sir!  I have made my spreadsheet following your 5 part vids and are currently moving on to the auxiliary series.  Quick question though.  Is there a way to copy and paste the loan amortization spreadsheet on another page within the same spreadsheet instead of creating a new one every time?  Again thank you so much!  I have Office 2011 on my Mac.  I don't have all the fill effects on excel like you have been showing but still I have a great looking spreadsheet that will help my balance out a budget alloting and spending times for a life time! :-)

[allansandidge]

Abyssal, thanks so much! I hope you monitor this and answer questions! But once i did this for my car loan payment i immediately encountered issues. It was calculating that I was paying 10 cents more per month then i should acutally be paying. After double checking all of this, i called my bank. It took them literally two hours to find out that it was because of my loan ORIGINATION date and my payment date that these values were coming out different. HOwever, why would they even do ughhh.. oh because we didnt want to charge you 7.66 upfront to refinance your car we added it into the montly payment so it makes it harder for you to track it at home! Can you please find a way. or do you know a way i can take that 7.66 and have it contributed into all of the values? I know i can divide that number by the total amount of payments and it gives me what needs to be added.. but there are so many values i get confused! And i want this schedule to keep up with extra payments and money saved etc. thanks! ANYONE PLEASE HELP! Im 28 and just NOW learning money! haha

[sharonwaters]

I can't figure out (or find where you show us) what to do in the balance left cells to get it to automatically generate the amount.

[PureHouse]

Love your videos! Has helped tremendously! I do have a question regarding Credit cards would it apply here as well? Obviously I would not add the PMI, etc but would I need to do something different? 

[irisvillacorte]

Do you have a video for credit card payment tracker etc

[decoff]

Do you have a VTC on your original Excel Budget Spreadsheet ? the one you show in the beginning of this video.

[andreamigdalski]

How do you copy and paste your charts and formulas to the next month without all the numerical data?

[joshuadepetra]

It doesnt populate all the columns if the interest rate is 0%. What should i do then?

[jesusmoreno]

when I Downloaded the schedule and tried to move it to my working spreadsheet it wouldn't let me. is there a reason for this or a work around? I tried copying the schedule into my current budget and trying to use it from there, but it wouldn't work.

[joannatrujillo]

I am trying to complete the End of Year but can not find the video. Can you help me please?

[jayroy]

How would you make this work with a loan that you have already started paying on for a few years?

[Ivydude]

Hi Abyssal Spark. I love your videos and have a question. On the loan amortization sheet under "loan period in years", it only allows you to put in 1, 2, 3, 4… values. But I have a car payment loan that has a life of 3 years and 1 month.  How do I enter this period in? Thanks in advance.

[MrRobbieDanger]

I tried using this loan schedule for my car loan but for some reason the info given by this graph does not match the info given to me by my bank. Any ideas on this?

[danielsambangala]

thanks a lot but you don't teach how to underline and and put the left inf in the tables ( if i may call it a table) the way you did. basically not showing all the steps to make it look organised. please make a video of that if possibl.