Often we are asked what calculator should be used to solve a particular problem. Below, we've arranged commonly asked questions into groups, and then we suggest the most appropriate calculator to solve the problem.

## The Most Commonly Asked Questions

**Q.** We are a lender. Do you have software for calculating a mortgage or loan payoff amount?

**Q.** I've lent some money and now the borrower is paying me back irregularly. Do you have a loan management program that will allow me to record the payments as I receive them and show the balance due?

**Q.** I've borrowed some money and now the lender says I owe them more than I think I owe them. Do you have a program that will calculate the loan balance?

A. __Yes, to all three questions__. The *C-Value! Program for Windows* will do what you want. You can also try the online Ultimate Financial Calculator. It too calculates loan payoff amounts, but you'll not be able to save your entries. However, you will be able to see if C-Value! will meet your needs as the two calculators have the same capabilities. I've prepared this detail loan payoff tutorial showing you how you can use the *Ultimate Financial Calculator* to __track any loan and calculate the balance__.

**Q.** How do I calculate my annualized rate of return (or the gross return for that matter) on my stock, option, bond and/or mutual fund investments?

A. Use the Internal Rate of Return (IRR) Calculator. Click on the calculator's Help button for a specific discussion of how to setup this calculation.

**Q.** How do I plan financially for my retirement, a college education or any other large expense?

A. Three answers and they are all free calculators. Depending on your exact needs you should try the Online Ultimate Investment Calculator (optionally allows for taxes, inflation and fees), the Online Ultimate Financial Calculator (supports irregular investing) and the Online Retirement Calculator.

## General Financial Planning

**Q.** I just received a $100.00 a week raise. How much will it be worth if I save $60 of it each week after 10 years?

**Q.** My child will be going to college in 12 years. What will I need to save quarterly so that I have the money when I need it?

A. Payment Required Calculator. Also note that the Annuity Schedule has a goal planning feature.

**Q.** One investment is quoting me an 'Effective Annual Rate' and another is quoting me the 'Nominal Rate'. Which is the better deal?

A. Use the Equivalent Rate Calculator. in *SolveIT!*.

**Q.** I invested $10,000 in the stock market. I sold the stocks in one transaction for $23,687 after 27 months. What was my annual rate of return?

A. Either Return on Investment (ROI) or Internal Rate of Return (IRR).

**Q.** I lent my nephew $45,000 so that he can start a small business. After a year he will start paying me back $1,067.17 for 48 months. (I'll forgo any interest on the money during the first year.) What is my rate of return.

A. Internal Rate of Return Calculator.

Further explanation: The rate of return is not equal to the interest rate charged on the loan in this case. The Uncle calculated the monthly payment based upon a $45,000 loan at 6.5% paid in 48 periods. However, he was willing to wait one year for the first payment. Therefore there is a year where no interest is being earned on the money.

**Q.** I need to make a 9% return on my investments to meet my financial goals. I can buy a single family home for cash at $200,000. I plan to rent it for 10 years at $6,000 year (what a bargain!) and then sell it for $220,000. Will I be earning 9% on my investment?

A. *Net Present Value Calculator*.

Note that this investment does not meet the investor's requirements as the NPV is negative.

**Q.** A settlement has been offered in a civil court case. The plaintiff can receive either $150,000 as a lump sum or $20,000 for 8 years followed by $10,000 for another 5 years. Which offer should be accepted base on the total return?

A. *Present Value of a Series Schedule*

**Q.** I'm going to be retiring in 20 years. I believe that I can save $1,000 every other month now and in 5 years increase that to $1,200 every other month. Then finally in 10 years I will be able to save $2,000 every other month. What will this series of deposits be worth after 5 years, after 10 years and at the end of the 20 years? What happens to my savings if interest rates change during the 20 years?

**Q.** Once I retire, how long will the savings from the above last me if I want to withdrawal $2,500 a month and I think that I'll be earning 8% on the money? How much will I have after 10 years?

**Q.** I run a small retail business and I need to borrow $50,000 for 70 days to finance my extra inventory for the end of year shopping season. What will the interest charge be, assuming that I can borrow the money at 11.5%?

A. *Compound/Simple Interest Calculator*

**Q.** In today's dollars, I project that I will need $2,000 a month to live on in 20 years once I retire. Assuming that there 3% inflation for the next 5 years and then it increases slightly to 4% for the next 15 years, what amount will I need to equal the purchasing power of the $2,000 in 20 years? (The answer may surprise you.)

**Q.** How much am I worth today?

## General Business Questions

**Q.** Our small business is considering launching a new product. How many of the items do we have to sell to recover our costs?

A. Use the *Break Even Point Adviser* in the *SolveIT!* program.

**Q.** Should we lease our office furniture or finance it? How will depreciation impact this analysis?

A. Use the *Lease vs Buy Adviser* in the *SolveIT!* program.

## Loan Planning

**Q.** One mortgage company is offering me a loan for $150,000 at 8.5% with 0 points. Another mortgage company is offering me a loan for the same amount at 8% but it has 3 points payable up front. Which is the most advantageous loan? Is the answer to this question impacted if I decide to only live in the home for 5 years (thus possibly not recouping the cost of the points)?

A. Use the *Loan Comparison Adviser* in *SolveIT!*.

**Q.** If I wanted to see how much interest I can save on a loan if I make an extra $100 a month principal payment, what calculator should I use?

A. *Accelerated Payment Calculator*.

**Q.** What if I want to make an occasional (random) extra payment toward a loan, how much will I save?

**Q.** I need to give my clients a Regulation Z APR Disclosure Statement. Can I do this?

A. Yes. Once again, use *C-Value!* or *SolveIT!*.

**Q.** How much money can I borrow if I can pay $1,250 a month and the rate is 6.5%?

A. *Loan Calculator* or if you want to have control over the starting date use the *amortization schedule*

**Q.** My husband and I have had our eyes on this home. The price has just been dropped to $375,000. Can we afford this?

A. *Affordable House Calculator* and *Budget Calculator*

**If we didn't answer your question, feel free to ask it below**.

## Tima Ebell Anderson says:

Greetings,

We like your web site and the ease of using the calculator and its completeness in the output it produces, especially for your loan amoritization calculator. My question is if I began my payment schedule in 2019 and run it for say 60 months does the calculations for payments take into account that 2020 is a leap year with 29 days in February rather than 28?

## Karl says:

Thank you. The answer to your question is, it depends. It depends on the compounding method selected. If you select a compounding frequency based on either weeks or months, then the answer is now. That’s because all months are assumed to be the same length. However, if you select either daily or exact date / simple compound (or continuous) then the answer is yes. These frequencies use exact day counts.

## Norman Rabek says:

Do C-Value and SolveIT have automatic updates and bug repairs? Do they require an annual payment or are they a one time purchase?

## Karl says:

I’m not sure by what you mean by "automatic" exactly. If either is upgraded, a user would have to download and install the update. So I guess you would not call that automatic.

The price you see $49 / $69 respectively, is a one time charge for the current major version 2.x / 6.x. Updates within the major version are free. When I make a major release, 3.0 / 7.0, those upgrades will most certainly not be free. What will they cost? I have no idea. Prices are set until an update is completed.

## pankaj says:

I m thinking of investing Rs.2.5 million for the next 6 years . and concerned company will pay me back around 23 million. which calculator ishould use calculate my annual return.

## Karl says:

Is this one investment, and then you wait 6 years, or are their additional investments? If there are additional investments and you want to know your rate-of-return, use this IRR calculator. If there is a single investment, you use the IRR calculator for a single investment too, but the ROI calculator is a bit less involved and it is designed explicitly for one-time-investments.

## Patrick Allossery says:

Hi, below is a list of calculators that I require for a financial services website (WordPress) in Canada. You already offer a few calculators that match my list, but I’m looking to acquire/have made a full set. Do you take custom orders? If so, can you contact me to discuss?

Looking forward to hearing back from you,

Patrick

Life Insurance

• Life Insurance Calculator

Retirement Planning Tools

• RRSP Calculator

• RRSP Illustrator

• RRSP Loan Planner

• RIF/LIF/LRIF Calculator

Education

• RESP Calculator

Investment Planning

• Investment & Regular Deposits

• Investment & Regular Withdrawal

• Advantage of Early Investing

• Registered VS Non-Registered Investing

Mortgages

• Mortgage Qualifier

## Karl says:

Thank you for contacting me. I replied to your email address.

## Robin Rickerson says:

The balloon calculator won’t let me set up a monthly schedule that shows $0 amount paid for the first 23 months but adding interest accrued onto the principal amount with month 24 starting a payment that would amortize $63,750 over 120 months and simple interest. With a balloon payment due month 60. Please help….again these are the terms of the loan:

$63,750 loan amount

Starts 2/26/2021

Simple interest at 6%

10 year amortization

1st payment not due until month 24

Balloon payment due month 60

## Karl says:

Thank you for clarifying. I assume that you are setting the "First Payment Due" date to the date it’s due in month 24?

The terms of your loan has what we call an "initial long period," that is, it’s longer than the month which is normally between payments.

The issue you have is how to account for the interest that is accruing. This calculator has 4 options to give users full control. Please see this setting below the dates:

"Long Period Options?:"

You can even have it so there is no interest accrued. But I doubt if the lender would like that.

If you don’t see how the setting work, you can go to this page. Scroll down and the setting are explained.

## Steve K says:

I want a tool that will help me allocate money. I want to find cases where it really does make sense to pay off a mortgage rather than invest in stocks. For the NASDAQ, I want a 10% chance that it will go down and stay below 70% of its current values for 5 years or more, a 40% chance of it treading water, and 50% chance of it going up 10-20% a year, which it seems to have done forever. So, if someone has $100K and they don’t pay of a $50K mortgage, but instead put $100K in a wide variety of stocks, bonds, and real estate, they may be taking a great risk. I want to quantify that in a way I can explain.

## Karl says:

Sounds like an interesting model. Unfortunately, I don’t have anything that will do what you want.

## Steve K says:

My friend has $500K and a $100K mortgage at 4.5% (ideas are accurate, details are changed for privacy). With closing costs of $2K to get a mortgage loan at 3%, my suggestion is that he pay off the mortgage clear and then invest the rest in dividend and value stocks split with S&P 500 and technology, in other words, a diversified portfolio. I am making this suggestion because my friend is not financially literate and a dive of 20-50% in tech stocks would ruin him without these two hedges (paying off the mortgage and diversified investing. If I run your investment tool twice, I can generate scenarios for a rising and fall market. I can run it two more times (total of 4) to account for closing or not of the mortgage. I realize that people think of the money freed up by a mortgage as nearly free money, but that is not necessarily so.

## Janet says:

Need an amortization schedule that I can calculate number of months to pay off balance. I know loan amount, interest rate, and payment amount. I’d like to compare how many months it take to payoff if I should make a lump sum.

## Karl says:

Have you tried this amortization schedule?

Enter "0" for "Number of Payments", and that’s what the calculator will calculate.

## Gerald GIOVANELLI says:

I need a calculator to calculate the rate of return on an investment which pays monthly dividends (DRIP) which are not fixed amounts and also to which I periodocally add additionall cash sums at any time.

I am thinking of the IRR calculator.

Will that do the job or can you make a suggestion?

## Karl says:

The IRR calculator is a good choice.

You can also use the Ultimate Financial Calculator on this site. You can set the UFC for an investment cash flow, and under Settings, select Analytics and turn on IRR. The calculated IRR will appear in the report header. You might like the UFC because of its reports and it is easier, in my opinion, to add and repeat cash flows. It will take more time to learn, however.

## Gerald GIOVANELLI says:

Thank you for your prompt reply.

I think I would like to have the IRR calculator.

What is the cost and is there a monthly or annual fee?

How do I purchase it?

## Karl says:

You’re welcome. Even better, there’s nothing to buy, and there’s no fee for the IRR calculator. Please use it as much as you like.

## Gerald GIOVANELLI says:

Hi Karl,

Thanks again

I am embarrassed to ask this but I don’t seem to see where the present market value can be entered other than the lower section where the calculations have been made and it does not allow any entrees.

Can you please help me?

## Karl says:

No problem. The "Initial Investment" is the present value. You’ll enter the amount and all other additional investments as a negative number, and then all paybacks, dividends, etc. as a positive value. Enter the final value (perhaps current value) on a date you pick for ending value or sale as a positive number. Click on the calculator’s help button for some more details.