Financial Tool set 1

5 Year Projections - This worksheet estimates the key financial figures for a company over five years. The projections include abbreviated income and cash flow statements, and a balance sheet. 

7 Year Balloon Loan Amortization - This worksheet calculates monthly loan payments and prepares an amortization schedule for a 7 year balloon loan. A balloon loan requires a large final payment at some future date.

24 Month Sales Forecast - Use this worksheet to forecast 2 years of product sales. The first two key data entries that you need to make are the first fiscal year and the first month of the forecast. With the first year and month entered, the spreadsheet will automatically enter the remaining years and months. Your next step is to enter the number of units and selling price for each month.

36 Month Sales Forecast - This worksheet forecasts 3 years of product sales. The first two key data entries that you need to make are the first fiscal year and the first month of the forecast. With the first year and month entered, the spreadsheet will automatically enter the remaining years and months. Your next step is to enter the number of units and selling price for each month.

48 Month Sales Forecast - This spreadsheet forecasts 4 years of product sales. The first two key data entries that you need to make are the first fiscal year and the first month of the forecast. With the first year and month entered, the spreadsheet will automatically enter the remaining years and months. Your next step is to enter the number of units and selling price for each month.

52 Week Sales Record - Use this worksheet to keep track of weekly sales by product or product line. Begin by entering the first date of the first week of the 52 week period that you want to track. Next enter the product name and sales numbers for each product by date.

401K Planner - This worksheet forecasts the growth in value of your 401K plan and to project the monthly income you will receive from the plan upon retirement. It also compares the wealth accumulation in the 401K plan in contrast to the growth of a taxable savings plan. The forecasted monthly income during retirement is pre-tax. After tax retirement income will depend on the marginal tax rates upon retirement.

401K Reallocation Planner - This spreadsheet helps you to reallocate your investments in your 401(k). Enter your current 401(k) investments by category. Then input the new percentages (new allocation %). The "Change Needed" column calculates the amounts by which you will need to increase accounts (negative numbers represent the amounts by which you need to decrease accounts).

Note: Click on bold word to download. Appreciation goes to jaxworks.com.