spead sheet planning
VVAREL
week1assignment2.xlsPersonal Financial Goals
| Name: | Date: | 2 | |||||||
| Setting Personal Financial Goals | |||||||||
| Financial Planning Activities: Based on personal and household needs and values, identify specific goals | |||||||||
| that require action for your life. | |||||||||
| Suggested Web sites: | www.financialplan.about.com | www.money.com | |||||||
| Your Personal Financial Plan | |||||||||
| Short-Term Monetary Goals (less than two years) | |||||||||
| Description | Amount needed | Months to achieve | Action to be taken | Priority | |||||
| Example : pay off credit card debt | $850 | 12 | Use money from pay raise | High | |||||
| Intermediate and Long-term Monetary Goals | |||||||||
| Description | Amount needed | Months to achieve | Action to be taken | Priority |
Personal Balance Sheet
| Name: | Date: | 6 | |||||||
| Creating a Personal Balance Sheet | |||||||||
| Financial Planning Activities: List the current values of the asset amount owed for various liabilities; | |||||||||
| sub-tract total liabilities from total assets to determine net worth. | |||||||||
| Suggested Web sites: | www.kiplinger.com | www.money.com | |||||||
| Your Personal Financial Plan | |||||||||
| Balance Sheet as of | |||||||||
| Assets | |||||||||
| Liquid assets | |||||||||
| Checking account balance | $0.00 | ||||||||
| Savings/money market accounts, funds | $0.00 | ||||||||
| Cash value of life insurance | $0.00 | ||||||||
| Other | $0.00 | ||||||||
| Total liquid assets | $0.00 | ||||||||
| Household assets & possessions | |||||||||
| Current market value of home | $0.00 | ||||||||
| Market value of automobiles | $0.00 | ||||||||
| Furniture | $0.00 | ||||||||
| Stereo,video,camera equipment | $0.00 | ||||||||
| Jewelry | $0.00 | ||||||||
| Other | $0.00 | ||||||||
| Other | $0.00 | ||||||||
| Total household assets | $0.00 | ||||||||
| Investment assets | |||||||||
| Savings certificates | $0.00 | ||||||||
| Stocks and bonds | $0.00 | ||||||||
| Individual retirement accounts | $0.00 | ||||||||
| Mutual funds | $0.00 | ||||||||
| Other | $0.00 | ||||||||
| Total investment assets | $0.00 | ||||||||
| Total Assets | $0.00 | ||||||||
| Liabilities | |||||||||
| Current Liabilities | |||||||||
| Charge account and credit card balances | $0.00 | ||||||||
| Loan balances | $0.00 | ||||||||
| Other | $0.00 | ||||||||
| Other | $0.00 | ||||||||
| Total current liabilities | $0.00 | ||||||||
| Long-term, liabilities | |||||||||
| Mortgage | $0.00 | ||||||||
| Other | $0.00 | ||||||||
| Total long-term liabilities | $0.00 | ||||||||
| Total Liabilities | $0.00 | ||||||||
| Net Worth | $0.00 | ||||||||
| (assets minus liabilities) |
Personal Cash Flow Statement
| Name: | Date: | 7 | |||||||||
| Creating a Personal Cash Flow Statement | |||||||||||
| Financial Planning Activities: Record inflows and outflows of cash for a one-(or three-) month period. | |||||||||||
| Suggested Web sites: | www.americasaves.org | www.money.com | |||||||||
| For month ending | Your Personal Financial Plan | ||||||||||
| Cash Inflows | |||||||||||
| Salary (take-home) | |||||||||||
| Other income : | |||||||||||
| Other income : | |||||||||||
| Total Income | $0.00 | ||||||||||
| Cash Outflows | |||||||||||
| Fixed expenses | |||||||||||
| Mortgage or rent | |||||||||||
| Loan payments | |||||||||||
| Insurance | |||||||||||
| Other | |||||||||||
| Other | |||||||||||
| Total fixed outflows | $0.00 | ||||||||||
| Variable expenses | |||||||||||
| Food | |||||||||||
| Clothing | |||||||||||
| Electricity | |||||||||||
| Telephone | |||||||||||
| Water | |||||||||||
| Transportation | |||||||||||
| Personal care | |||||||||||
| Medical expenses | |||||||||||
| Recreation/entertainment | |||||||||||
| Gifts | |||||||||||
| Donations | |||||||||||
| Other | |||||||||||
| Other | |||||||||||
| Total variable outflows | $0.00 | ||||||||||
| Total Outflows | $0.00 | ||||||||||
| Surplus/Deficit | $0.00 | ||||||||||
| Allocation of surplus | |||||||||||
| Emergency fund savings | |||||||||||
| Financial goals savings | |||||||||||
| Other savings |
