O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating loan terms using Excel

Loan-calculation information is an important financial function when dealing with customer payment information. Excel provides built-in functionality for calculating loan terms including payments, principal, and so on. However, Excel requires the information to be entered into a worksheet.

In this recipe, you will learn how to create a standalone application that can be used as a loan calculator for calculating loan terms to be used elsewhere within the Excel workbook.

How to do it...

We will begin by adding a UserForm to the current worksheet that will prompt the user for the parameters of the loan:

  1. From within an Excel worksheet, press Alt + F11 on your keyboard to open the visual basic editor (VBE).
  2. Once open, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required