Tag Conditional Formatting

Loan Amortization with Microsoft Excel

This is the first of a two-part tutorial on amortization schedules. In this tutorial we will see how to create an amortization schedule for a fixed-rate loan using Microsoft Excel and other spreadsheets (the next part shows how to handle extra principal payments and also includes a sample spreadsheet using this same example data). Almost all of this tutorial also…

Create Time Value of Money Tables in Excel

Virtually every finance textbook has at the back, a series of tables that contain multipliers that can be used to easily calculate present or future values without the need for a financial calculator. In recent years these tables have given way to financial calculators, but they are still used by some professors and on some professional exams. This tutorial will…