Resources

Excel 101

  • Remove duplicates
  • Sumif
  • Vlookup
  • pivot-table

All about Taxes

 

Accounting and Financial Calculators

BUSINESS PLANNING

Break-even Point
This allows you to determine the number of units to be sold to generate a profit. Also, this allows you to see the profit you will have at each sales volume level.

Commercial Loan
This allows you to see if you qualify for a new commercial loan by evaluating your debt service coverage.

Cash flow
This allows you to determine the cash flow generated by your business.

Working Capital
This allows you in determining your working capital needs for the next year.

Profit Margin
This allows you to determine the selling price for your products to achieve a desired profit margin.

Lease vs. Buy
This allows you to make a decision whether to lease or buy a certain property or equipment.

Financial Ratios
This allows you to compute for financial ratios. Financial ratios are tools that will help you evaluate the performance and current standing of your business. There are 10 different financial ratios in areas such as solvency, liquidity, operational efficiency and profitability.

Inventory Analysis
This allows you to determine how much inventory you should hold, and when you should place inventory orders.

Business Valuation
This allows you to create a possible market valuation for your business by determining how much your future cash flow is worth today.

 

PERSONAL FINANCE

Home Budget Analyzer
This allows you to control your budget by monitoring where your money is going.

Should My Spouse Work? Calculator
This allows you to help you see the financial impact of adding, or removing, a spouse’s income to your household.

Savings Calculator
This allows you to determine what it will take for you to reach your savings goal. Enter in your savings plan and view graphically your financial results.

Debt Consolidation Financial Calculator
This allows you to determine if debt consolidation is right for you.

Accelerate Debt Payoff
This allows you to calculator can show you how to accelerate your debt payoff.

Credit Card Pay Off
This allows you to find the best repayment options to pay off your credit card balance.

 

STUDENT SAVINGS

Savings Planner
This allows you to help develop and fine tune your education savings plan.

Budget Calculator
This allows you to analyze your budget as a full-time student. This calculator is specifically designed to help students understand their expenses and income while attending a university, college or other full-time educational institution.

 

RETIREMENT

Retirement Planner
This allows you to create your retirement plan.

Cost of Delaying Savings
This allows you to show how much postponing your retirement savings plan can really cost you.

Retirement Income
This allows you to determine how much monthly income your retirement savings may provide you in your retirement.

Retired Millionaire
This allows you to determine what it takes to save one million pesos? Enter in your current savings plan and view graphically your financial results for each year until you retire!

 

ESTATE PLANNING

This allows you to know your potential estate tax liability. Estate tax planning is very important to preserving your wealth for future generations.

 

HOME MORTGAGE

Rent vs. Buy
This allows you to determine which option is best – rent or buy. It takes more than looking at your mortgage payment to answer this question. This allows you to weed through the fees, taxes, and monthly payments to help you make a good financial decision.

Mortgage Qualifier
This allows you to go through the process of finding out how much you can borrow.

Mortgage Refinance Analyzer
This allows you to determine whether it is better to refinance your mortgage. This allows you to find out how much money you’ll save and how long it will take to breakeven on a mortgage refinance.

Mortgage Reduction Analyzer
This allows you to save thousands of pesos in interest by increasing your monthly payment. This allows you to find out how much sooner you will pay off your mortgage by making extra payments.

 

CAR LOAN

Auto Loan Analyzer
This allows you to determine how much car you can afford to buy based on your desired monthly payment.

Auto Loan vs. Home Equity Loan
This allows you to find out how much you can save if you opt for home equity loans rather than car loans. The former often have lower interest rates than auto loans and the interest may be tax deductible.

Auto Lease vs. Buy Analyzer

This allows you to determine whether leasing a car is better than buying your car.

 

LOAN

Loan Prequalification Calculator
This allows you to determine your ability to qualify for a loan. Although it does not guarantee you will qualify for your new loan, it is a good check point to see if it is within your means.

Loan Amortization Calculator
This allows you to calculate your loan amount after entering your desired payment, or enter in the loan amount and it will calculate your monthly payment. This allows you to examine your principal balances by payment, total of all payments made, and total interest paid. Press the report button to see a monthly payment schedule.

Loan Comparison Calculator
This allows you to sort through the monthly payments, fees and other costs associated with getting a new loan. By comparing these important variables side by side, this calculator can help you pick the loan that works best for you.

Alternative Payment Frequencies
This allows you to determine your payment or loan amount for different payment frequencies. You can make payments weekly, bi-weekly, semi-monthly, monthly, bi-monthly, quarterly, semi-annually or annually. You can then examine your principal balances by payment, total of all payments made, and total interest paid.

 

Follow

Get every new post delivered to your Inbox

Join other followers: