Download

This section contains all spreadsheet files mentioned in Articles section.

Files

• BankAccounts.xls

  BankAccounts.xls will help you keep track on account balances. It's quite similar to a checkbook.

• CreditCards.xls

  Helps to keep track of your credit card balances.

• Expenses.xls

  Helps categorizing expenses and finding where your money really goes. Also very helpful in planning a budget.

• Statements.xls

  Every investor must know how to read financial statements. Whether it is a financial statement of a publicly traded company or a financial statement of a person, it's all the same. The three basic financial statements are: Balance Sheet, Income Statement and Cash-Flow Statement. In general, the Balance Sheet sums up the balances on your accounts and credit cards, the Income Statement tells you where your money came from and where did they go, and the Cash-Flow Statement is the connection between the first two statements. Example use of the Cash-Flow statement: when you buy something and pay with your credit card, you must record it as an expense on the Income Statement, add to "from financing" on the Cash-Flow Statement, and increase credit card liability on the Balance Sheet. When you pay off the credit card debt, then you have to decrease liability on the Balance Sheet and add the amount paid to "to financing" on the Cash-Flow Statement. As you might noticed, paying off debts doesn't involve the Income Statement. After a year of updating your own financial statements you'll probably get so proficient, that you'll be able to quicly find any suspicious activity on any other financial statement.

• LifeEnergy.xls

  A simple calculator for finding how much you really make at your job. This calculator is based on the book Your Money or Your Life by Joe Dominguez.

• FinancialIndependenceDay.xls

  Very simplified 10-year Balance Sheet and Income Statement. The chart shows month-by-month how they change. After almost 10 years of saving at about 30% rate and about 15% return on investment, the passive income may displace earned income. Not may people can afford saving 30% of their income, and not many investments can guarantee 15% return, so for most people it may take many more years to achieve the Financial Independence. However, the purpose of this file is to show the concept. Create your own plan.

• HomebuyerCalculator.xls

  This spreadsheet will help you to decide what makes more sense: buying or renting. It will also show you what kind of return on investment you may expect by investing in your own house.

• REInvestorCalculator.xls

  This spreadsheet will help you to decide whether you should become a landlord or just keep your savings in bonds.

• TaxImpactByState.xls

  This spreadsheet shows the impact of taxes on one's income. The impact is measured by the difference between what employer pays the employee (salary of $50K), and what the employee receives after all payroll and income taxes. The state by state comparison may be helpful in making decision about which state to incorporate in.