Archive for March, 2009



Cost of Goods Sold

CoGS

[enlarge] This spreadsheet is a part of ‘Solving Accounting Principles Problem using Microsoft Excel for Windows” created by Rex A Schildhouse to give its reader a better understanding on determining their Cost of Goods Sold based on periodic inventory system scheme. Author : Rex A Schildhouse

Excel Retirement Plan

Excel Retirement Plan

[enlarge] How much pension you need today. Assume, you don’t have liabilities (No house loan, kids education, marriage expenses etc.). Essentially you have managed all your liability and have own house/flat etc and need to maintain current lifestyle. For example, if your currently yearly expenses include your housing/education loan etc. Reduce that amount. Key assumption [...]

Household Budget Worksheet

Household Budget Worksheet

[enlarge] You can use this excel spreadsheet to determine your income and expenses, and disposable income percentage. Author : ACCC