CI Market Dashboard

We have put together a collection of market indicators and track them to help you gauge the direction of the market.


CI Analysis Worksheets

Interactive analysis templates covering DuPont analysis (return on equity), valuing stocks the Warren Buffett way, and more to come.


CI Blog Feed

Happy Thanksgiving!
posted about an hour ago by Wayne Thorp

What is Apple Pay Anyways?
posted 21 hours ago by Jaclyn McClellan

Rapoo E9180P Wireless Keyboard with Touchpad
posted 1 day ago by Hareesh Jayanthi

New Confirming Bearish Signal from Market Dashboard
posted 5 days ago by Wayne Thorp

Active Trader Magazine is No More
posted 6 days ago by Jaclyn McClellan



Computerized Investing > December 1, 2012

Vertex42 Money Manager

PRINT | | | | COMMENTS (8) | A A   Reset

by CI Staff

The Vertex42 Money Manager is an Excel spreadsheet that helps to manage personal financial planning. This free template provides pre-configured formulas to record, budget and plan your finances all in one organized format. The Money Manager encompasses all aspects of your spending, income, savings and more in an easy-to-use spreadsheet that can assist newcomers and frequent Excel users alike in tracking expenses and planning for the future.

The Money Manager helps you organize your financial situation using different worksheets within the file: Budget, Transactions, Categories and Report. This allows you to set a yearly budget and track your expenses by specific sub-categories, such as money going into a college fund, investments or charitable donations.

Unlike many other budgetary tools, the Money Manager allows you to set a budget for the entire year rather than just by month. With a yearly budget, you can project how much you will have (or would like to have) at the end of the year if you spend X amount of money each month. In the Budget worksheet, you can record variable expenses that occur month to month, but vary in amount, such as groceries and gas; when entering the amount spent in the groceries sub-category each month, for example, the worksheet will show you how much you spent total year-to-date as well as your monthly average, so you can budget accordingly for the future. You can also track irregular (non-monthly) expenses, such as vacations and birthday gifts. For instance, if you know you will spend about $600 on Christmas gifts, you can create a special savings sub-category and budget $50 each month in order to prepare for December. This is a great tool for all ages and all income levels. Whether you want to ensure you have enough money for retirement or for next year’s spring break trip, the yearly budget can keep you in check.

In the Transactions worksheet, you can record cash inflow and outflow for multiple accounts, including checking, savings and even the cash in your purse or wallet. The downside to this program versus other online budgetary tools is that you can’t link this spreadsheet to an online banking account, and therefore the transactions won’t upload automatically. Thus, it is important to keep up-to-date with manually tracking and inputting your expenses, and doing so efficiently.

The Report tab illustrates your expenditure and, most importantly, compares your actual spending versus your budgeted spending on a monthly and year-to-date basis. One of the highlights of the Report worksheet is that it provides an actual versus budgeted spending comparison within the categories as well. For example, if you have been going over budget month-to-month, you can view which specific categories you are overspending in. Perhaps decreasing your restaurant expenditure and marginally increasing your grocery budget may do the trick.

This comprehensive personal financial planning spreadsheet is complemented with a thorough Help tab, which details each feature as well as the steps to take in order to make full use of the spreadsheet. Vertex42 notes, however, that though this is a simple management tool, errors in calculations may occur. If formulas within the Money Manager are deleted or shifted, the calculations become error-prone. As long as you follow the directions while customizing categories (which causes the most problems, according to Vertex42) and are careful when adding and deleting rows, the Vertex42 Money Manager will be a great asset in your financial planning. With 2013 quickly approaching, this spreadsheet may be just the tool that will give a boost to your new year’s resolutions, and since it’s free, you won’t need to add it to your budget.

Vertex42

http://www.aaii.com/download-library/download?DL_ID=730

System Requirements: Windows XP/2003/Vista/7

Size: 78.11 K

Price: Free


Discussion

John Carsten from NY posted about 1 year ago:

This file is an Executable file ie .EXE.

Executables may contain things that I don't want in my system.
I elected to not download, as I do with all executable files that are presented to me.


Mark Gahagan from IL posted about 1 year ago:

Tried to open this in a windows virtual machine. It is an .exe file which ostensibly does nothing. I suspect it has done something in the background but my virus checker found nothing. Doesnt work anyway!!


Doug Hart from MD posted about 1 year ago:

Try downloading direct from the Vertex42 site, it is an Excel file only, not executable.

http://www.vertex42.com/Files/download/xls.php?file=money-manager.xls


S Gilford from CA posted about 1 year ago:

If you want a more robust free software application to manage your money, then I would suggest Microsoft Money. Although the retail version of Microsoft Money has been discontinued, Microsoft has made available a free Microsoft Money Plus Sunset version. Money Plus Sunset is available in two versions: Money Plus Deluxe Sunset and Money Plus Home & Business Sunset. Both versions provide the ability to import QIF and OFX file types that most financial institutions provide, thus eliminating much of the manual data entry. Additionally, if you Google "microsoft money forum", you will find free applications that make it easy to obtain and import stock and mutual fund prices into the sunset edition. In summary, Microsoft Money is alive and well.


Gilbert Parker from MI posted about 1 year ago:

I HAVE WINDOWS 7, AFTER DOWNLOADING I TRIED TO OPEN IT AND THE MESSAGE SAYS "APP HAS REQUESTED THE RUNTIME TO TERMINATE IT IN AN UNUSAL WAY"
I HAVE NO IDEA WHAT THAT MEANS.


Antonio Alvarez from PA posted about 1 year ago:

I am using windows Vista and got the same message as Gilbert Parker:"APP HAS REQUESTED THE RUNTIME TO TERMINATE IT IN AN UNUSAL WAY".

It was not a plain Excel File but an executable file.


Yusuf Qamar from KS posted about 1 year ago:

This program does not download ! Error messages appear. Not good.


Richard Tuttle from FL posted about 1 year ago:

I got the error message using the cnet download site. The http://www.vertex42.com site has a lot of templates for free download. You have to download them directly from the vertex42.com site as the Excel file format. The cnet download has an .exe file that performs the download which causes a virus error mentioned above.


You need to log in as a registered AAII user before commenting.
Create an account

Log In