Financial calculator

THE ULTIMATE FINANCIAL CALCULATOR Main Menu Investment Valuation Financial Statements Time Value of Money l Rates of Return Capital Budgeting Loans and Leasing Copyright © 1997 KMT Software, Inc. All Rights Reserved. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Investment Valuation Basic Bond Valuation Book Value Liquidation Value Click a button above to select a Calculator worksheet. Price Earning Multiple Constant Growth File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Financial Statements Liquidity Analysis Activity Ratios Debt Ratios Profitability Ratios Click a button above to select a Calculator worksheet. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Time Value of Money PV - Single Amount PV - Mixed Stream PV - Annuity FV - Single Amount FV - Annuity Deposits to a Sum Click a button above to select a Calculator worksheet. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Rates of Return Rate to Meet a Goal Real Rate of Return Holding Period Return After Tax Return Taxable Equivalent Rate Effective Annual Rate Yield to Maturity Expected Return (CAPM) Click a button above to select a Calculator worksheet. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Capital Budgeting Net Present Value Internal Rate of Return Payback Period Click a button above to select a Calculator worksheet. Annualized Net Present Value Initial Investment File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Loans and Leasing Car Lease Payment Affordable Auto Simple Interest Loan Add-On Interest Loan Loan Pay-off Amount Loan Consolidation Refinance Calculator Balloon Payment Loan Bi-Weekly Loan Home Mortgage Affordability Home Eq. Loan Affordability Personal Debt Safety Ratio Click a button above to select a Calculator worksheet. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Basic Bond Valuation Par Value of the Bond Years to Maturity Required Rate of Return Coupon Rate of Bond Payment of interest: Annual Semi-annual Value of the bond is: l DESCRIPTION Use this worksheet to determine the value of a bond. If the bond pays interest on a semi-annual basis (twice per year), be sure to select the semi-annual option button. $1,000 10 12.000% 10.000% $887.00 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Book Value Total Assets Total Liabilities Number of Common Shares Outstanding The book value per share is: l DESCRIPTION Book value per share is the amount per common share that would be received if all the firm's assets are sold for their exact book (accounting) value and if the proceeds remaining after all liabilities (and preferred stock) are satisfied are then divided among the common stockholders. $6,000,000 $4,500,000 100,000 $15.00 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Liquidation Value Liquidation Value of Assets Total Liabilities Book Value of Preferred Stock Number of Common Shares Outstanding The liquidation value per share is: l DESCRIPTION The liquidation value per share is the amount per common share that common stockholders will receive upon liquidation (selling off of assets) of the company. The calculation assumes payment of all liabilities and preferred stock. $5,250,000 $4,500,000 $0 100,000 $7.50 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Price/Earnings (P/E) Multiple Average P/E Ratio for Firms in the Industry Earnings per Share The value per share is: l DESCRIPTION The price/earnings multiple approach uses an average P/E ratio to find a quick estimate of a company's value per common share of stock. 7.0 $2.60 $18.20 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Constant Growth Estimated Dividend per Share Expected Annual Growth Rate of Dividends Investor's Required Rate of Return The value per share is: l DESCRIPTION The constant growth model assumes that dividends will grow at a constant annual rate. $1.50 7.00% 15.00% $18.75 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Liquidity Analysis and Ratios Net Working Capital Current Assets Current Liabilities The net working capital is: Current Ratio Current Assets Current Liabilities The current ratio is: Quick Ratio Current Assets Inventory Current Liabilities The quick ratio is: l DESCRIPTION Liquidity refers to the ease with which a firm can pay its bills. The three basic measures of liquidity are net working capital, the current ratio, and the quick (acid-test) ratio. $1,223,000 $620,000 $603,000 $1,223,000 $620,000 1.97 $1,223,000 $289,000 $620,000 1.51 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Activity Ratios Inventory Turnover Cost of Goods Sold Inventory The inventory turnover is: Average Collection Period Accounts Receivable Annual Sales The average collection period is: Fixed Asset Turnover Sales Net Fixed Assets The fixed asset turnover is: Total Asset Turnover Sales Total Assets The total asset turnover is: l DESCRIPTION Activity ratios are used to measure the speed at which various accounts are converted into sales or cash. $2,088,000 $289,000 7.22 $503,000 $3,074,000 58.91 $3,074,000 $2,374,000 1.29 $3,074,000 $3,597,000 0.85 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Debt Ratios Debt Ratio Total Liabilities Total Assets The debt ratio is: Debt-equity Ratio Long-term debt Stockholders' Equity The debt-equity ratio is: Times Interest Earned Earnings Before Interest and Taxes Interest Expense The times interest earned ratio is: Fixed-payment Coverage Ratio Earnings Before Interest and Taxes Interest Expense Principal Payments Lease Payments Total Preferred Dividends Tax Rate The fixed-payment coverage ratio is: l DESCRIPTION The debt ratios measure the degree of indebtedness and the company's ability to pay debts. $1,643,000 $3,597,000 45.7% $1,023,000 $1,954,000 52.4% $418,000 $93,000 4.5 $418,000 $93,000 $71,000 $35,000 $10,000 29% 1.87 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Profitability Ratios Gross Profit Margin Sales Cost of Goods Sold The gross profit margin is: Operating Profit Margin Operating profit Sales The operating profit margin is: Net Profit Margin Net Profits After Taxes Sales The net profit margin is: Return on Assets (ROA) Net Profits After Taxes Total Assets The return on assets is: Return on Equity (ROE) Net Profits After Taxes Stockholders' Equity The return on equity is: Earnings Per Share (EPS) Earnings Available to Common Stockholders' Common Shares Outstanding The earnings per share are: Price/Earnings (P/E) Ratio Market Price per Share of Common Stock Earnings Per Share The price/earnings ratio is: l DESCRIPTION Profitability ratios allow you to evaluate the firm's earnings with respect to a given level of sales, a certain level of assets, the owners' investment, or share value. $3,074,000 $2,088,000 32.1% $418,000 $3,074,000 13.6% $231,000 $3,074,000 7.5% $231,000 $3,597,000 6.4% $231,000 $1,954,000 11.8% $221,000 76,262 $2.90 $32.25 $2.90 11.1 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Present Value - Single Amount Future Amount (at the end of n periods) Number of Periods (n) Interest Rate Per Period (per n periods) The present value is: $1,700.00 8 8.00% $918.46 Calculating an Interest Rate Future Amount (at the end of n periods) Present Value Number of Periods (n) The interest rate per period is: $1,700.00 $918.46 8 8.00% Calculating the Number of Periods Future Amount (at the end of n periods) Present Value Interest Rate Per Period (per n periods) The number of periods are: l DESCRIPTION This worksheet allows you to calculate the present value of a single (lump sum) future amount. It also allows you to calculate the interest rate (or discount rate) if you know the present value, future value, and number of periods. A third calculation allows you to calculate the number periods if you know the future value, present value, and rate per period. $1,700.00 $918.46 8.00% 8 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Present Value of a Mixed Stream Periodic Discount Rate Cash Flow $400 $800 $500 $400 $300 9.00% Period (n) 1 2 3 4 5 6 7 8 9 10 The present value is: l $1,904.76 DESCRIPTION This worksheet allows you to calculate the present value of a mixed stream of cash flows. A mixed stream of cash flows shows no particular pattern. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Present Value of an Annuity Choose one of the following options: Ordinary Annuity Annuity Due Payment Per Period Number of Periods Interest Rate Per Period (per n periods) The present value of the annuity is: $700.00 5 8.00% $2,794.90 Calculating an Interest Rate Payment Per Period Present Value Number of Periods (n) The interest rate per period is: $700.00 $2,794.90 5 8.00% Calculating the Number of Periods Payment Per Period Present Value Interest Rate Per Period (per n periods) The number of periods is: l DESCRIPTION This worksheet calculates the present value of an annuity. Select the Annuity Due option button if you want to perform calculations assuming that the cash flows occur at the beginning of the period. The Ordinary Annuity assumes cash flows occur at the end of the period. You can use this worksheet to calculate the periodic interest rate when you know the annuity payment, present value of the annuity, and the number of periods. You can also use this worksheet to calculate the number of periods when the annuity payment, present value, and interest rate are known. $700.00 $2,794.90 8.00% 5 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Future Value - Single Amount Compounding Choices (select one): Annual Semi-annual Quarterly Bi-monthly Present Value Number of Periods (n) Interest Rate Per Period (per n periods) The future value is: $100.00 2 8.00% $116.64 Calculating an Effective Interest Rate Compounding Frequency (select one): Annual Semi-annual Quarterly Bi-monthly Nominal Interest Rate Number of Years The effective rate per period (per n periods) is: 8.00% 2 8.24% Calculating the Number of Periods Present Value Future Value Interest Rate Per Period (per n periods) The number of periods is: l DESCRIPTION This template allows you to calculate the future value of a single (lump sum) future amount. It also allows you to calculate the effective interest rate (or discount rate) if you know the nominal interest rate, compounding frequency (per year) and number of years. A third calculation allows you to calculate the number of periods if you know the present value, future value, and rate per period. $100.00 $116.64 8.00% 2 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Future Value of an Annuity Choose one of the following options: Ordinary Annuity Annuity Due Payment Per Period Number of Periods Interest Rate Per Period (per n periods) The future value of the annuity is: $1,000.00 5 7.00% $5,750.74 Calculating an Interest Rate Payment Per Period Future Value Number of Periods (n) The interest rate per period is: $1,000.00 $5,750.74 5 7.00% Calculating the Number of Periods Payment Per Period Future Value Interest Rate Per Period (per n periods) The number of periods is: l DESCRIPTION This worksheet calculates the future value of an annuity. Select the Annuity Due option if you want to assume the cash flows occur at the beginning of the period. The Ordinary Annuity (which is the default) assumes cash flows occur at the end of the period. You can use this worksheet to calculate the periodic interest rate when you know the annuity payment, future value of the annuity, and the number of periods. You can also use this worksheet to calculate the number of periods when the annuity payment, future value, and interest rate are known. $1,000.00 $5,750.74 7.00% 5.00 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Deposits to a Sum Select the type of annuity: Ordinary Annuity Annuity Due Amount to be Accumulated Number of years Annual Interest Rate The periodic deposit is: l DESCRIPTION This worksheet calculates the deposit per period needed to accumulate some future amount. $100,000 10 9.00% $6,582.01 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Rate to Meet a Goal Financial Goal Number of Years Until Goal Achievement Annual Deposit to Achieve Goal Deposit Made at: Beginning of Period The annual rate of return needed is: l DESCRIPTION This calculator computes the annual rate of return needed to achieve a financial goal at some year in the future. $28,000 12 $1,500 End of Period 6.63% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Real Rate of Return Rate of Return Inflation Rate Marginal Tax Rate The real rate of return is: l DESCRIPTION Use this calculator to determine the real rate of return. The real rate of return takes into account both inflation and taxes. It's the rate of return after subtracting the taxes owed on the return and the loss in purchasing power as a result of an increase in the Consumer Price Index (CPI). 6.00% 4.00% 28.00% 0.32% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Holding Period Return Current Income Capital Gain (or loss) Purchase Price The holding period return is: l DESCRIPTION This calculator determines the total return earned from holding an investment for a period of time. $10.00 $8.00 $100.00 18.00% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 After Tax Return Taxable Return (%) Marginal Tax Rate The after tax return is: l DESCRIPTION Use this calculator to determine the after tax return on an investment. The taxable return is the taxable annual yield from the investment while the marginal tax rate is that of the investor. 9% 15% 7.65% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Taxable Equivalent Rate Tax Free Return (%) Marginal Tax Rate The taxable equivalent rate is: l DESCRIPTION Use this calculator to convert a tax free rate of return to a taxable one. This is useful when comparing the return of a municipal bond to that of a CD, T-bill, or any other taxable investment. 7.65% 15.00% 9.00% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Effective Annual Yield on Investment Contract Rate (Nominal Rate) Frequency of Compounding (Choose One): Annually Semi-Annually Quarterly Monthly 6% The effective annual yield on investment is: l 6.09% DESCRIPTION Use this calculator to convert the nominal or stated yield of an investment to its actual yield, assuming a particular frequency of compounding. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Yield to Maturity Current Bond Price Par Value of Bond Coupon Rate Years to Maturity The yield to maturity is: l DESCRIPTION Use this calculator to approximate the annual yield for a bond, if held to its maturity date. The calculation takes into account any gain to be realized from a discount and any loss attributed to a premium. $1,040 $1,000 6.000% 16 5.637% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Expected Return (CAPM) (Capital Asset Pricing Model) Risk Free Rate of Return Beta Coefficient Return on Market Portfolio The expected rate of return is: l DESCRIPTION Use this calculation to estimate the expected rate of return on a particular stock (equity) investment. This expected rate of return calculation is based on the Capital Asset Pricing Model. The risk free rate of return is the expected return on a riskless investment -- such as a Treasury Bill. The Beta coefficient is a statistic that is calculated and published for publicly traded stocks and is available from services such as Value Line Investment Survey. The return on the market portfolio is the expected rate of return you could achieve if you invested in the entire stock market. 7.94% 1.21 13.30% 14.43% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Net Present Value Initial Investment Discount Rate Years 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Cash Flows $28,000 $12,000 $10,000 $10,000 $10,000 $45,000 10% The net present value is: l DESCRIPTION This worksheet calculates the Net Present Value of an investment. It is designed to work for any investment with up to 15 years of cash flow. $9,931 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Internal Rate of Return Years 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Initial Investment --> Cash Flows ($45,000) $28,000 $12,000 $10,000 $10,000 $10,000 The internal rate of return is: l DESCRIPTION This worksheet calculates the internal rate of return (IRR) of an investment. The initial investment should be entered as a negative number since it is an outflow of cash. 21.65% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Payback Period Years 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 The payback period is: l DESCRIPTION This worksheet calculates the payback period. The payback period is the number of periods (usually years) that it takes to recover the initial investment from the operating cash flows. Initial Investment --> Cash Flows ($45,000) $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $40,000 $6,000 6.975 Initial Investment 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1,000 1,000 1,000 1,000 1,000 1,000 40,000 6,000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 $45,000 1,000 2,000 3,000 4,000 5,000 6,000 46,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 52,000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 6 6000 46000 40000 $39,000 0.975 6.975 This finds the year that is equal to or less than the initial investment This looks up the amount accumulated for the year above This is the accumulation for the next year This is the cash flow for the year in which payback is achieved Payback File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Annualized Net Present Value Discount Rate Number of years Years 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 10.00% 6 Cash Flows ($85,000) $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 Initial Investment enter as negative --> The net present value is: The annualized NPV is: l $17,285 $3,969 DESCRIPTION This worksheet calculates the Annualized Net Present Value (ANPV). The ANPV makes it possible to compare projects with different life spans by converting the Net Present Value into an amount per year. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Initial Investment Cost of new asset Installation costs After-tax proceeds from sale of old asset Tax on sale of present machine Change in net working The initial investment is: l DESCRIPTION This worksheet calculates the initial investment -- the relevant cash outflow required at time zero to implement a proposed long-term investment. $380,000 $20,000 $280,000 $84,160 $17,000 $221,160 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Lease Payment MSRP (sticker price) Capitalized Cost (leasing price) Cap Cost Reduction (down payment) Lease Term (number of months) Residual Factor (percentage of MSRP: see 1) Money Factor (converted interest rate: see 2) The depreciation fee is: The lease fee is: The monthly lease payment is: l DESCRIPTION This calculator uses a formula that is utilized by car dealers and leasing companies to calculate a monthly lease payment on a new automobile. (1) Note: Since the residual factor is determined by the leasing company, you should attempt to get the actual value if possible. As a rule of thumb, residual value can be estimated as follows: .65 for 2 years .57 for 3 years .49 for 4 years .41 for 5 years The above factors are conservative estimates for new vehicles with relatively low depreciation rates. (2) Note: Since the Money factor is determined by the leasing company, attempt to get the actual factor. You can estimate it by dividing the current new car loan rate by 2400. $20,000 $18,500 $1,000 24 65.00% 0.00329 $187.50 $100.35 $287.85 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Affordable Automobile Monthly Payment you can Afford Loan Term (Years) Annual Percentage Rate Down Payment The price of the car you can afford is: l DESCRIPTION Use this calculator to determine the price of an automobile that you can afford. Begin by entering the monthly payment that suits your budget. You may want to consider the rule of thumb that your monthly installment payments should not exceed 15-20% of your monthly take home pay. $295 4 8.00% $1,500 $13,584 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Simple Interest Loan Payment Loan Principal Amount Annual Interest Rate Loan Period in Years KEY FIGURES The monthly payment is: The annual loan payments are: The interest over the term of the loan is: The sum of all payments is: l DESCRIPTION Calculates the monthly loan payment necessary to amortize a simple interest loan and other key loan figures. $165,000 7.50% 30 $1,154 $13,844 $250,332 $415,332 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Add-On Interest Payment Loan Principal Amount Annual Interest Rate Loan Period in Years KEY FIGURES The interest over the term of the loan is: The monthly payment is: The sum of all payments is: l DESCRIPTION This calculates the monthly payment and key figures for an add-on interest loan. $5,000 11.00% 4 $2,200 $150 $7,200 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Loan Pay-off Amount Monthly Payment Annual Interest Rate Number of Payments Already Made Loan Period in Years The pay-off amount is: l DESCRIPTION This calculator helps you determine the amount of principal that remains on a loan so that you can pay off or refinance the loan balance. $1,182.08 7.75% 13 30 $163,426 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Loan Consolidation Debts to be Paid Off with New Loan: Auto Loans Credit Cards Home Improvement Vacation Loans Other Loans Annual Interest Rate Loan Period in Years The consolidation loan amount is: The monthly payment is: l DESCRIPTION Use this calculator to determine the loan needed to consolidate all your consumer loans into one loan and the monthly payment required on that consolidation loan. $10,000 $6,000 $3,000 $5,000 $3,000 7.50% 5 $27,000 $541 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Refinance Calculator New Loan Principal Amount Annual Interest Rate Loan Period in Years Current Monthly Payment Points on the Refinance Loan Other Estimated Closing Costs KEY FIGURES The new monthly payment is: The monthly savings is: The number of months to break-even is: $165,000 7.50% 30 $1,300.00 2 $2,000.00 l $1,153.70 $146.30 36 DESCRIPTION Use this calculator to determine if a refinancing of a mortgage makes sense. The number of months to break-even should be compared to your estimate as to how long you will stay in the house. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Balloon Payment Loan Principal Amount Annual Interest Rate Amortization Period in Years Years Till Balloon Payment KEY FIGURES The monthly payment is: The balloon payment is: l DESCRIPTION Use this calculator to compute the monthly payment and final (balloon) payment on a balloon payment loan. $165,000 7.50% 30 5 $1,153.70 $156,118 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Bi-Weekly Loan Loan Principal Amount Annual Interest Rate Loan Period in Years KEY FIGURES The annual loan payments are: The bi-weekly payments are: The interest over the term of the loan is: The sum of all payments is: l DESCRIPTION Use this calculator to compute a bi-weekly payment loan -- 26 payments per year. $100,000 8.00% 30 $8,801.52 $338.52 $164,046 $264,046 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Home Mortgage Affordability Monthly Take-Home Pay Gross Annual Income Monthly Property Taxes Monthly Home Owner's Insurance Down Payment Term (years) of mortgage Interest Rate The affordable mortgage amount is: The affordable home cost (35%) is: The affordable home cost (2.5 x Income) is: l DESCRIPTION This calculator determines the affordable mortgage and home cost under two rules of thumb: 35% rule and 2 1/2 times gross income rule. The 35% rule assumes that the borrower cannot afford monthly housing payments (Mortgage, Insurance, & Taxes) in excess of 35% of monthly net take-home pay. The 2 1/2 times gross income rule assumes that the maximum house you can afford is 2 1/2 times your gross annual income. $2,095 $30,000 $100 $50 $20,000 30 13.00% $52,726 $72,726 $75,000 $110.62 583.25 5.272557 52725.57 $72,726 File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Home Equity Loan Affordability Borrower's Gross Monthly Income Maximum % of Home Value Bank will Lend Minimum Monthly Payment as a % of Line Bank's Total Expenses (Affordability) Ratio Value of Home First Mortgage Information: First Mortgage Balance Monthly Payment Property Taxes (annual) Homeowner's Insurance (annual) Total Current Balances $10,000 $4,000 80% 1.50% 40% $175,000 $50,000 $500 $2,000 $400 Total Monthly Payments $550 $125,000 $90,000 $1,600 $43,333 Other Consumer Debts Totals for All Consumer Debts The home equity is: The credit line (ignoring affordability) is: The affordable total monthly payments are: The credit line for which you qualify is: l DESCRIPTION Use this calculator to determine the home equity loan or line of credit for which you qualify. File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008 Personal Debt Safety Ratio Monthly Take-home Pay Enter total monthly payments for: Credit Card Payments Education Loan Payments Automobile Loan Payments Automobile Lease Payments Home Equity Loan Payments Other Consumer Loan Payments The personal debt ratio is: l DESCRIPTION This calculator determines your personal debt ratio. As a rule of thumb, the total monthly consumer debt payments should not exceed 20% of your monthly take-home pay. $3,000 $100 $100 $200 $200 $250 $30 29.33% File: 5db43d00-1fa6-4cff-aaaf-148fc4b3a571.xls Copyright © 1997 KMT Software, Inc. Printed: 8/12/2008