Simple Steps for Creating a Budget in Excel

[{"selector":"#anim-f99250b9-1fa2-47dd-b662-6659209f9448","keyframes":{"opacity":[0,1]},"delay":300,"duration":2500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c5d6a30e-f5ec-4746-977e-cc2891933d33","keyframes":{"transform":["translate3d(116.98717%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":300,"duration":2500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2e8ed7f5-4ebf-4257-8142-7a93ed42bbd3 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-32.63281239461658%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] Learn more

Want to know if you can afford a vacation? How much you can save for retirement? How you can pay off your mortgage faster? These questions can all be answered if you have a budget.

[{"selector":"#anim-a5f8c1da-5772-4a10-8a24-d5e22f0d8399","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4fac41bc-d81f-4377-8bfe-d54680865a61","keyframes":{"transform":["translate3d(106.02740%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-679245aa-14c5-426c-9237-fc677acab8a6","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ad768647-eec3-4c82-b5e6-57f4a3ca67cf","keyframes":{"transform":["translate3d(99.75787%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ea6ead7e-32eb-4ada-9ba4-cb414e087304","keyframes":{"opacity":[0,1]},"delay":450,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5e98b6b0-74db-4a79-84a3-6161d18f3070","keyframes":{"transform":["translate3d(-115.18988%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":450,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

A budget is a listing of your income and the amount you can afford to spend on your expenses and put into savings.

[{"selector":"#anim-9a153e29-ea23-4255-ab19-f5bfccf6f27c","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6470dc1c-a0f2-4319-8be1-d46ed5a2bfc3","keyframes":{"transform":["translate3d(-105.47945%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4e507657-f5b1-448d-8bab-db4660774543","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2bfea6a1-78b8-4e97-855e-02ca238dca5f","keyframes":{"transform":["translate3d(-100%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2e9b639b-cf4f-4b51-8122-0cf6a6c97c0a","keyframes":{"opacity":[0,1]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-85f38f8c-93a7-4cdf-9f2f-a34bea93560b","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e8b7ba98-2094-4c44-a468-f97db67505d8","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5745f62c-0efb-45c6-9908-440b7652587e","keyframes":{"transform":["translate3d(-115.18988%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

As an overview, here are the steps necessary to create a budget in Excel:

[{"selector":"#anim-0301fe30-ed97-4832-b507-35b4e187eab3","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d88c7567-b7f7-4bf0-9524-d9ceebdc60c1","keyframes":{"transform":["translate3d(106.57535%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-034fa07d-0930-4777-95ca-b4534cb25c0e","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0a2274af-6534-4d69-b831-76ca03c47927","keyframes":{"transform":["translate3d(99.75787%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c199cbbe-2150-4a69-99fe-474360f549e2","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f302822f-f451-49d0-bf35-45fbcd60deb4","keyframes":{"transform":["translate3d(115.23810%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-275bac39-6607-4e03-b44c-f3346204bac8","keyframes":{"opacity":[0,1]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-18eda9a0-f481-4f13-9c9e-b9a56d8bd231","keyframes":{"transform":["translate3d(115.55555%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

For many of you, your goals will include down payments on houses, refinancing student loans, college for your children and funding retirement.

[{"selector":"#anim-f5adf560-28b2-4401-931e-e52be27d5085","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c76183d4-3a80-41fb-8a0b-00e5a8c435ef","keyframes":{"transform":["translate3d(-98.59155%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-43f33309-3129-4b17-ac57-bd90d3976b32","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ecc708d0-c2b9-4493-b79b-326ea265b906","keyframes":{"transform":["translate3d(107.67124%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5707a15a-de05-4d0c-af2a-afd0b4274d88","keyframes":{"opacity":[0,1]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8424bfa7-7dfe-454c-bf20-aef5da7b8d8f","keyframes":{"transform":["translate3d(-115.92356%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eec4e800-16ba-4d42-9082-e73d8c699732","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-08ff2561-189f-42e6-9f2d-f96b5c4c2f34","keyframes":{"transform":["translate3d(-115.33547%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

The most common time periods for a budget include a monthly or annual view.

[{"selector":"#anim-d3654ded-0813-4bcf-be74-99adc4fb8546","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c80aa531-2b43-4081-99fe-c1861a06952a","keyframes":{"transform":["translate3d(99.75787%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ae2b5992-4b50-43dc-921e-f8bfb00e5fac","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-583235b8-a36e-4454-bc25-baf1bf21314d","keyframes":{"transform":["translate3d(106.57535%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e2c01876-545a-47c7-a06e-4aecfcdd2fdb","keyframes":{"opacity":[0,1]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-545b8b02-8aae-425c-b86f-ae76f6d4d034","keyframes":{"transform":["translate3d(115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5b2a6ab9-c315-4b98-bcf0-7a8a4fcf69e3","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-852c5fec-5208-49d4-8949-55d52f05a812","keyframes":{"transform":["translate3d(115.23810%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

Figure out how much Form W-2 or Form 1099 income you’re going to earn during your budgeting period (1099 vs. W-2 can result in different tax situations).

[{"selector":"#anim-347c8fda-7ed2-4cfe-bfc9-687d7ba6ba6d","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5387ade5-03a4-458c-a165-64be232c6e50","keyframes":{"transform":["translate3d(-98.59155%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-29cb12d5-493e-4928-886f-c05885999de0","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0a1e6024-c119-495e-963c-e630a3d0a7a2","keyframes":{"transform":["translate3d(107.67124%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-511d8c9e-f999-4bb2-9046-029a1677008f","keyframes":{"opacity":[0,1]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3a967ebf-2f51-43e0-bc2f-ccd50347c01e","keyframes":{"transform":["translate3d(-115.92356%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":800,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4101a098-25e4-4034-8cfe-60f9913a78c2","keyframes":{"opacity":[0,1]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9b2758ec-18dc-4a05-bd82-c411e08e91b4","keyframes":{"transform":["translate3d(-115.01598%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more

Swipe up TO READ more ABOUT THE Simple Steps for Creating a Budget in Excel

[{"selector":"#anim-111ff01e-9ef0-4893-b0d8-dd0aaf6ff372","keyframes":{"transform":["translate3d(-115.55555%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-444a3a17-8c0f-4be8-8bd5-c1533571b12e","keyframes":{"opacity":[0,1]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7cae397f-3910-4683-9ac3-19560088b556","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":1500,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] Swipe Up

Other stories

[{"selector":"#anim-4c9e8267-aab7-45dc-b499-b031239b7a60","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-612af43e-ef15-4b55-8429-8d520865fd0b","keyframes":{"transform":["translate3d(-119.99999%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-75d129b3-8a6f-43f1-9217-325211f4533c","keyframes":{"opacity":[0,1]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7eea41b3-7db5-47f1-9d29-83aa00a72cda","keyframes":{"transform":["translate3d(-191.04478%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":400,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-050218e2-7a05-418c-9dc5-5881ac235231","keyframes":{"opacity":[0,1]},"delay":600,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-339ca20f-72d1-46b4-9c7d-bc477b423c84","keyframes":{"transform":["translate3d(-120.68965%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":600,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c23ee743-cacc-4531-8826-3e63f6c587bb","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2c87c468-2a61-4bc0-b9cc-290dec71639e","keyframes":{"transform":["translate3d(-191.04478%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-af036c5f-6df2-4be2-a0db-c9c1d84c7d62","keyframes":{"opacity":[0,1]},"delay":1200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f2543a21-25d5-4552-9d82-349b8c85d6fd","keyframes":{"transform":["translate3d(-119.99999%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1200,"duration":2000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b58d00aa-7aed-4d64-a6b3-5b3fa28930bf","keyframes":{"opacity":[0,1]},"delay":1700,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f5f8f815-bca4-4362-b618-db0c890c17ec","keyframes":{"transform":["translate3d(-190.54727%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1700,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3b49a50e-e62f-4785-a116-4ecf11602abb","keyframes":{"opacity":[0,1]},"delay":300,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-05565099-bc21-42e9-82db-f4e9d5d4f3bd","keyframes":{"opacity":[0,1]},"delay":900,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0588ca75-d534-4dbe-bff8-514a8c863c71","keyframes":{"opacity":[0,1]},"delay":1500,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-efe83f92-93d0-4f72-9907-f12d586d997a","keyframes":{"opacity":[0,1]},"delay":200,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-068901ca-57a4-47c4-ac5c-81aaa613c5ab","keyframes":{"transform":["translate3d(-120.68965%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b5e3ee21-5f81-465b-9505-fe0b7203debf","keyframes":{"opacity":[0,1]},"delay":800,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1eba809d-f8a7-4217-887e-e5c5dd159773","keyframes":{"transform":["translate3d(-120.68965%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":800,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a4246f71-834e-41fe-81b7-d797f93658be","keyframes":{"opacity":[0,1]},"delay":1400,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7f752560-056f-4482-ab7a-601c6a5fd0fa","keyframes":{"transform":["translate3d(-119.99999%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1400,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Teaching Kids about Money Management: Budget, Save + Spend 13 Best Budgeting Apps for Couples to Grow Together [2022] 15 Best Debit Cards for Kids & Teens to Become Money Savvy

Simple Steps for Creating a Budget in Excel

Want to know if you can afford a vacation? How much you can save for retirement? How you can pay off your mortgage faster? These questions can all be answered if you have a budget.

A budget is a listing of your income and the amount you can afford to spend on your expenses and put into savings.

What is a Budget?

As an overview, here are the steps necessary to create a budget in Excel:

How to Create a Budget in Excel

For many of you, your goals will include down payments on houses, refinancing student loans, college for your children and funding retirement.

1. Identify Your Financial Goals

The most common time periods for a budget include a monthly or annual view.

2. Determine the Period Your Budget Will Cover

Figure out how much Form W-2 or Form 1099 income you’re going to earn during your budgeting period (1099 vs. W-2 can result in different tax situations).

3. Calculate Your Total Income

Swipe up TO READ more ABOUT THE Simple Steps for Creating a Budget in Excel

Other stories