Personal Budget Formula Tips

Part of the Video Series How to Set a Budget

Viewing videos requires the latest version of Adobe's Flash Player.
Get the latest Flash player.

How to use Budget Formulas in this free series of personal finance video from our professional Certified Public Accountant (CPA).

Rating:
Views: 1,207
Comments: 0 (comment now)

Favorited: 0 | Add to Favorites

Tags: budget, expenses, personal, personal finance
Bookmark at:

All Videos in the Series, How to Set a Budget

Member Comments

Video Transcript

Personal Budget Formula Tips
I'm using a spread sheet for this family budget. Programs that you can use for this includes excel from Microsoft Office for Windows or Mac. Number from I work from just Macs and you also can have alternatives. Such as Open Office for Windows and Mac and then legal documents. Some of the formulas that we use are basically really simple. Addition, subtraction, sorting, coping, pasting, and a little bit later we would do coloring. For example on addition we would be using equal of sums of E6 through E19. If you look here we would go back and you would see sales E6 through E19 and in sum down here and sale E20. The same here in column G where I had my difference I"m using simple subtraction formula column F minus column E. You can see that right there so we have subtraction. One thing that I like to do with the budget is sort it by the due date so I know in sequence when your bills are due. That is pretty easy to due in Excel it is work function.

About the Expert

Expert: Tom Noah has been a Certified Public Accountant (CPA) for more than 27 years. In that time he has held positions at several companies as an accountant and as a director of financial planning. Read More