Saving and Budgeting

...now browsing by category

 

8 Steps to Controlling Your Debt

Monday, February 15th, 2010

Recent reports that were compiled and published by the United States Federal Reserve indicate that consumer debt has increased at exponential rates in the past decade. There is roughly $3 trillion in current consumer debt whether it is non-revolving or revolving in nature. At the present time, the US economy is in a state of flux and what most financial experts would say reeks of instability with many fingers pointing to the current political administration in Washington, D.C.

Despite such a gloomy outlook and the past 18-month economic track record, this “cloud” does have a silver lining. Where your personal debt is concerned, you can get this under control and maintain things wisely so that you can weather economic hardships. If you are truly in over your head financially, we have some suggestions for how you can get a handle on this and survive your struggles.

8 steps to getting debt under control

There are 8 steps that you can take in order to get your debt under control and we have listed them here:

1. Find out what the real cost of each debt is – avoid the temptation created by the words “low monthly payments.” This is nothing short of brainwashing and has been used continuously in marketing campaigns to dupe consumers into believing that “easy monthly payments” means spending less than what the total cost actually is once you have fulfilled the agreement and paid off the debt.

2. Get off your behind and create a monthly budget – we cannot stress this enough. Additionally, you will want to establish and develop some type of savings plan, especially where retirement is concerned.

3. Dump those high interest credit card accounts – better yet, figure out how to survive financially with a minimal amount of “plastic” money.

4. Always remit more than the minimum payment due on your charge accounts and other credit cards – it will take you decades to pay off a high balance since most of your payment will be eaten up by the interest on the account.

5. Don’t apply for a consolidation loan to generate a better monthly cash flow – this makes no sense as it only creates more long-term debt for you. Consumers have the tendency to do this in order to improve their quality of life when in reality they are just driving themselves further into debt.

6. Don’t be a sucker for credit consolidation advertisements – most of these companies don’t reduce your debt like they advertise, they just restructure it.

7. Never borrow money against the equity in your home – why would you steal money from your retirement nest egg or deplete funds that could go towards a real financial emergency?

8. Never be too proud to seek out and pay for professional help – let’s face it, most of us do not possess a CPA’s or financial planner’s mentality where balancing and maintaining a budget is concerned. Why not rely on the services of an expert? It just makes sense.

Budgeting Using Excel

Friday, November 13th, 2009

An overview of Excel spreadsheet

In the simplest of terms, Excel is a spreadsheet software application that can be utilized for the purposes of manipulating, organizing, and storing specific data. It is a rectangular shaped table which is comprised of vertical columns labeled with letters from the English alphabet and horizontal rows labeled numerically. The alphabetically labeled columns ascend in order from top to bottom whereas the rows ascend in order from left to right.

If more than 26 columns are needed, then the alpha labeling is doubled. In other words, where the first column is labeled as “A”, the 27th column is labeled as “AA.” Needless to say, as an accounting, budget-tracking, or charting tool, Microsoft Excel is an invaluable tool available to anyone, whether for business or home purposes. It provides you with a means of monitoring financial growth as well as other activities such as home budgeting.

8 steps to developing your budget using Excel spreadsheet

If anything, Excel spreadsheet is by far the most honest and simplest accounting systems that you can utilize. Here are the 8 steps you need to take when using this software application to create a budget for your business or household:

Track your monthly spending and save all your invoices and receipts – meaning all fixed monthly expenditure documentation (e.g. loan payments, utility bills, etc.) and try to establish what you spend on entertainment and food. Keep in mind that unforeseen expenses happen when you least expect it so add roughly another 10% of the total of the above to cover that.

Record this on paper – categorization and organization is the key here.

Don’t complicate things – start as simple as you can because you can always make corrections because columns and rows can always be altered when you are in the process of setting up your budget. Make sure that you have created columns for all expenditure including for what you actually spent versus what the estimate was as well as the gain or loss that resulted.

Finalize the labeling or titling of your columns and rows – double check and make sure that you have left no stone unturned.

Begin entering your data and learn the formulas necessary to calculate monetary totals – once you learn this, it is a real time saver. There is a help index so you can learn the different formulas involved for the 4 basic math functions.

Calculate your totals for a one-year period – divide each total by 12 in order to establish what the monthly average expenditure is for each category.

Save your Excel spreadsheet budget to your computer and assign it a file name – you just went to a lot of trouble to create and develop your business or family budget so protect that data by saving it to your hard drive.

Keep your records current – as tedious as this is, always make sure that you have listed things as accurately as possible. Omissions can cause financial inconveniences and even have disastrous consequences if you aren’t careful.