Quick Budget Excel Spreadsheet

I’d like to share with you a useful budgeting tool that I developed in Excel. My objective was to calculate a quick and dirty forecast of my monthly cash flow based on my monthly income and expenses. I’ve officially named the tool “Quick Budget” to reflect that it only takes between 5 – 20 minutes to throw together a household budget.

I chose to develop the tool as an Excel spreadsheet because I find Excel the most flexible and easy to work with for these types of things.

Feel free to download Quick Budget and try it for yourself. I hope you find it useful.

Quick Budget is very simple and easy to use.

Step 1: Input you income. Precisely your monthly after tax income. If you have more than one earner in your family you can easily add additional rows to capture each person’s income. Don’t know your after tax monthly income? Calculate it using my 2011 Income Tax Calculator.

Step 2: Input your expenses. I’ve included the most common expense categories such as housing, food & groceries, transportation, clothing, communication, entertainment etc. Simply input an estimate of what you pay for each expense line each month and the template will automatically calculate out what you’ll pay for the entire year.  If you pay additional expenses that are not included in my template feel free to enter new rows to account for those expenses. Just make sure you adjust the “total expenses” formula to capture all expenses.

Step 3: View your monthly cash flow. There is no action required on your part for this step. The template will automatically calculate your monthly cash flow and cumulative cash flow by month based on the income and expenses you entered previously.

Download: Quick Budget Excel Template

This is version 1.0 of my Quick Budget Excel Template. If you have any constructive feedback on how to improve the tool please send me an email.

Posted in Budgeting, General | Tagged , , | Leave a comment

Employment Insurance – How It Works

What is Employment Insurance?

Employment Insurance (EI) provides temporary financial assistance to unemployed Canadians who have lost their job through no fault of their own (due to shortage of work, seasonal layoffs, or mass layoffs) and who are available for and able to work, but can’t find a job.

For the purposes of this post I will be referring to regular employment insurance benefits.

What are the eligibility criteria to receive regular employment insurance benefits?

  • You have paid premiums into the EI Account;
  • You lost your employment through no fault of your own;
  • You have been without work and without pay for at least seven consecutive days in the last 52 weeks;
  • You have worked for the required number of insurable hours in the last 52 weeks or since the start of your last EI claim, whichever is shorter;
  • You are ready, willing, and capable of working each day; and
  • You are actively looking for work (you must keep a written record of employers you contact, including when you contacted them).

You may not be entitled to receive EI regular benefits if:

  • You voluntarily left your employment without just cause;
  • You were dismissed for misconduct; or
  • You are unemployed because you are directly participating in a labour dispute (strike, lockout, or other type of dispute).

Do I need to apply for employment insurance benefits?

Yes you do need to apply for employment insurance benefits. EI benefits are not paid out automatically.

When should I apply for employment insurance benefits?

Apply as soon as you stop working. If you wait longer than 4 weeks after you stop working you risk losing your employment insurance benefits. Also, it takes a while for the Government of Canada to process your application so the early you submit the better.

How do I apply for Employment Insurance benefits?

To apply for employment insurance benefits you must submit an application online through the Service Canada Website.

How do I know if my application for employment insurance has been processed?

You can track the status of your application through “My Account” on the Service Canada Website.

When will I start to receive employment insurance benefits?

Once you submit your application, all the necessary documentation and your application is approved you will begin to receive payments within 28 days.

What will I be paid for my employment insurance benefits?

Numerous factors go into determining your specific employment insurance benefit so it is tough to know. The basic formula is 55% of your average insurable weekly earnings. The maximum insurable earnings (as of January 1st 2012) is $45,900. That means the maximum you will receive per week is $485.

How long will I be paid my employment insurance benefits?

Another tough one to estimate, but the range is between 14 – 45 weeks. The number of weeks that you are eligible to receive employment insurance benefits depends on several factors. Those factors include the number of hours of insurable employment that you accumulated during the previous 52 weeks prior to your claim and the unemployment rate in your region.

What types of Employment Insurance benefits are there?

There are essentially 3 types of employment insurance.

  1. Employment Insurance Regular Benefits are available to individuals who lose their jobs through no fault of their own (for example, due to shortage of work, seasonal layoffs, or mass layoffs) and who are available for and able to work, but can’t find a job.
  2. Employment Insurance Maternity and Parental Benefits provide support to individuals who are pregnant, have recently given birth, are adopting a child, or are caring for a newborn.
  3. Employment Insurance Sickness Benefits are for individuals who are unable to work because of sickness, injury, or quarantine.

Where can I find more information on Employment Insurance?

  • Visit the Service Canada Website
  • Call the Employment Insurance Telephone Information Service (1-800-206-7218)
Posted in Employment, General, Insurance | Tagged , | Leave a comment

Estimate Your Canadian Pension Plan (CPP) Benefit

I have no plans to retire any time soon, but I thought it would be interesting to see how much Canadian Pension Plan (CPP) benefit I had accrued to date.

I’ve been contributing to the CPP since I started working in 2004, so I figured I must have some CPP pension benefit accumulated for when I retire after age 60.

The Government of Canada will provide you with an estimate of your monthly CPP pension benefit through their Service Canada website. Here is how you can access yours.

Step 1: Go to the Service Canada Website

Step 2: Login to your account (or register if you don’t already have one). Click the “estimate my CPP benefit” link.

Step 3: View your CPP benefit estimate summary

My CPP pension benefit estimate tells me that if I retire at age 65 I would be entitled to $408.32 per month or $4,899.84 per year. The maximum retirement pension monthly amount at age 65 for this year is $986.67 so that means I am eligible for ~41% of the maximum benefit amount.

I was quite shocked at how high these estimates were considering that I have only been contributing to CPP for 7 years and did not contribute anywhere near the maximum CPP amount in my first years of working.

So, what is your monthly CPP pension benefit estimate?

Posted in Retirement | Tagged , , | 1 Comment

Online Auto Insurance Quote Comparison Tool

My car insurance policy is up for renewal soon so I decided to do some shopping around on the internet to see if I could find a better deal.

One thing that I learned right away about shopping for car insurance online is that it’s a very tedious process to go to each insurer’s website and fill out all of our driving history and vehicle information to get a quote. When you are interested in quotes from several insurance companies the time it takes to do this really adds up.

Luckily, I came across this website called Kanetix.ca that provides a useful tool for comparing car insurance quotes from multiple Canadian insurance companies. The main benefit is that you simply enter your driving history and vehicle history details just once. This is handy because the tool will use that information to produce auto insurance quotes from multiple companies and lay them out in an easy to compare chart.

The tool also very flexible in the sense that it allows you to change coverage options such as   the deductible on comprehensive coverage and collision coverage as well as liability amounts. When you change a coverage option the tool will automatically recalculate and display a new set of auto insurance quotes for you to compare.

Once you find a car insurance quote that appeals to you the tool also provides you with options to contact the insurance company to apply such as the phone # or a link to apply online.

How to use the Kanetix.ca Car Insurance Quote Comparison Tool in 5 Quick Steps

Step 1: Navigate to Kanetix.ca and enter your Canadian postal code.

Step 2: Enter your driver details

Step 3: Enter your vehicle information

Step 4: Check if you are eligible for a discount

Step 5: Submit and compare car insurance quotes from multiple Canadian insurance companies! It’s as easy as that.

If you are in the market for car insurance, I recommend that you give the Kanetix Auto Insurance Tool a try.

 

Posted in General, Insurance, Saving | Tagged , , , , , , | Leave a comment

List of Stock Screeners

Canadian Stock Screeners

TMX Stock Screener
Globe Investor Stock Screener
Morningstar Stock Screener
Stock Charts Stock Screener

US Stock Screeners

Yahoo Finance Stock Screener
Google Finance Stock Screener
FinViz Stock Screener
MarketWatch Stock Screener
Nasdaq Stock Screener

TMX Stock Screener

Globe Investor Stock Screener

MorningStar Stock Screener

StockCharts Stock Screener

Google Finance Stock Screener

 Yahoo Finance Stock Screener

FinViz Stock Screener

 MarketWatch Stock Screener

Nasdaq Stock Screener

What stock screener is your favourite?

Posted in Investing | Leave a comment

Trade Commission Fee Comparison – Canadian Online Discount Brokers

Below is a comparison of the trade commission fees charged by Canadian discount brokers for electronic stock trades.

Parameters

  • 0-9 trades per quarter
  • Less than $50,000 in account assets

Discount Brokerage

Online Trade Commission Fees

1¢ per share
($4.95 minimum, $9.95 maximum)
1¢ per share
($1.00 minimum, 0.5% of trade value maximum)
1.5% of trade value (stock price <=$2.00)
3¢ per share (stock price >$2.00)
($28.95 minimum)
$19.99 (up to 1,000 shares, 2¢/share thereafter)
1.5% of trade value (stock price <=$2.00)
3¢ per share (stock price >$2.00)
($29.00 minimum)
1.5% of trade value (stock price <=$2.00)
3¢ per share (stock price >$2.00)
($29.00 minimum)
1.5% of trade value (stock price <=$2.00)
3¢ per share (stock price >$2.00)
($28.95 minimum)
1.5% of trade value (stock price <=$2.00)
3¢ per share (stock price >$2.00)
($29.00 minimum)
1.5% of trade value (stock price <=$2.00)
3¢ per share (stock price >$2.00)
($28.88 minimum)
$9.95 ($0.01 per share fee for orders of 1000 shares or greater)
Posted in Investing | Tagged , | Leave a comment

List of Canadian Discount Stock Brokers

List of Canadian Discount Brokers

Discount Brokerage

Website Link

   Questrade
  Interactive Brokers 
RBC Direct Investing
Scotia iTrade
TD Waterhouse
BMO InvestorLine
CIBC Investor’s Edge
Disnat
HSBC InvestDirect
TradeFreedom
Posted in Investing | Tagged , , , | Leave a comment

How To View Your Account Balance For Canadian Taxes

Do you owe the Canadian government any tax dollars? Better yet, does the Canadian government owe you?

There is an easy way to find out. The Canadian Revenue Agency (CRA) provides a handy tool on their website called “MyAccount” that displays your current account balance and statement of account.

How do I access it?

Step 1: Go to the CRA website

Step 2: Click on the “MyAccount” link

Step 3: Login to “MyAccount” with your username and password. If you don’t have an account then you will have to register one.

Step 4: Once logged in, click on the “Accounts and Payments” tab

Step 5: Click on “Account balance and statement of account”

Step 6: View your account balance and statement of account

And that’s all there is too it. From now on you’ll always know where you stand with the Canadian government on your taxes.

 

Posted in General, Tax | Tagged , , | Leave a comment

2011 Income Tax Calculator

Download: 2011 Income Tax Calculator

For those of you that live in Ontario you might find this useful. I have created a 2011 income tax calculator that will derive your total income tax payable, average tax rate and net income based on your gross income.

I’m open to creating the same calculator for other provinces if I receive enough requests. Give it a try and let me know what you think.

Posted in Calculators, Tax | 3 Comments

How To Tell If You’re Underpaid

Do you work hard? Skip your lunch, work weekends and put in long hours at the office? How do you know if you’re being compensated fairly for the work that you do?

It is generally inappropriate to ask your co-workers what they are making. Most people won’t tell you or it will create an awkward situation if they do tell you because odds are one of you is making much more than the other.

Here are a few simple ways to determine if you are being paid fairly.

Do a job search for comparable positions online – Do a search on popular online job boards such as Monster.com or CareerBuilder.com for job postings that are comparable to your position. Some job posting will include a salary range or hourly wage that you can use to compare against your current pay to determine if you are under or over paid. If the job posting doesn’t offer a salary range or hourly wage it might be worth your while to call the hiring manager or recruiter directly and ask them what the typical salary range is for this particular position.

Use Glassdoor.com to find out what similar positions at different companies are paid - Glassdoor is a great resource for determining what other people in the same position are being paid at other companies. Simply search under “salaries” for your job position in the city that you work in. Even better, if you know a company with similar positions as yours search for that company directly.

For example, say my job title was a “Customer Service Representative” (CSR) with a major telecommunications company.  If I search “Telus” I can find salary/wage ranges for the position of Customer Service Representative to compare against my own salary or hourly wage.

As you can see from the screenshot below the salary range for a CSR at Telus is 22K to 50K per year with an average of $37K. If I was currently being paid less than 30K for this position I’d start to question why I was below the average.

Ask your boss - Definitely the riskier of the options, but hey its not as direct as asking for a raise outright. Approach your boss when he/she is in a good mood and pose the question “am I being paid inline with the market rate for my job?” If anything, it will be interesting to see you boss’s response and how he/she values your contributions.

So are you underpaid?

Posted in General | Tagged , , , | Leave a comment