Showing posts with label Using. Show all posts
Showing posts with label Using. Show all posts

Tuesday, September 4, 2012

Plan Your Monthly Personal Budget Using Excel Spreadsheet

Plan your monthly personal or family budget without help from any tools should be a difficult task for you. The easiest way to plan your budget is to use help from Microsoft Excel. Use the following steps to create your own personal budget in excel spreadsheet :

1. Write down your daily expenses in one month period
Create four columns and label them with name "Date", "Description", "Category", and "Amount". Start filling the columns with your daily expenses. You can write any description for your expenses. Categorize it based on your defined category, and fill the amount of that expense.

2. Summarize your expenses
Create new columns and summarize your daily expenses into category where you have to use excel function to sum your daily expenses based on their category. Name the new columns with name "Category" and "Expenses". You can create it within the same spreadsheet or in separate spreadsheet.

3. Add budget column
Add a new column next to Amount column in step 2, and label it with name "Budget". Fill your "Budget" column with the same amount with "Expenses" column.

4. Subtract your monthly income with budget and expenses
Sum the total amount of your "Expenses" and "Budget" columns. Create new rows below "Budget" column, and label it "Income" and "Saving". Input your monthly income, and then in "Saving" cell subtract Income with total amount from "Budget" column. If the result is positive, you can use your expenses as your budget reference. If it is negative, you need to adjust your budget where you think you can save the expenses of that category, and try to commit on this budget on the following month.

You can follow those steps above to simplify your monthly personal budgets, or you can also find some personal budgets created in excel available in internet to ease your plan.

Monday, July 2, 2012

How To Find Outperforming Canadian Stocks Using Tsx Stock Screener

Many people are today looking to invest in stocks and this is due to the high returns that this venture is capable of providing. However, it is very challenging to pick the right company that you are going to invest in and at the same time the right price for a specific company's stocks. The best way of choosing the right company and the right price for a specific company's stock is to use the online stock screener that filters your results based on valuations that will only work for you. There are many options here and one of them is the Canada Stock Screener. Canadian stocks have been limited for screening until lately. There are several popular tools today that you can use for Canada and one of the most popular ones is the TSX stock screener.

This service is new in the market and even though it is not the most powerful stock screener it is quite powerful especially for Canadian exchanges. TSX stock screener is completely free and it also allows you to conduct multiple custom criteria even if you are an advanced investor. It also allows you to edit columns on the results page so as to display different criteria that you may be looking for. Toronto Stock Exchange denoted as TSX or formerly TSE is Canada's largest stock exchange, the third largest in the continent of North America and the seventh largest in the world in terms of market capitalization.

This stock exchange is based in Toronto which is the largest city in Canada and it is owned and operated as a TSX group subsidiary for trading of senior equities. Toronto Stock Exchange has a representation of various businesses from Canada, the United States as well as other countries from Europe and other parts of the world. Many people have tried the TSX stock screener and profited from it. Apart from conventional securities, Toronto Stock Exchange also lists investment funds, income trusts, split share corporations and exchange traded funds. This stock exchange is also the leader in various sectors most notably the mining and oil & gas sector since there are more companies listed in this exchange from this sector.

There are several ways in which you can find the outperforming Canadian stocks. The Canada Stock Screener has a wide variety of fundamental and technical criteria that will help you to build a custom screen. Other notable tools include Globe Investor, Stock charts for people who use technical analysis of stock charts, Google Finance, Yahoo Finance, MSN and Finviz which offers technical and fundamental choices on the screen. Using one of the above mentioned tools will enable you find the outperforming stocks in the Canadian market.