# Financial

## A collection of 8 posts

Create an ordered database of financial data on Excel using Pandas
13 March 2022
The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. This page contains many easy to follow PMT examples. PMT examples Consider a
04 November 2020
The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment. Net Present Value For example, project
01 November 2020
Use the IRR function in Excel to calculate a project’s internal rate of return. The internal rate of return is the discount rate that makes the net present value equal to
31 October 2020
This example teaches you how to compare loans with different durations in Excel. 1. First, we calculate the monthly payment on a loan with an annual interest rate of 6%, a 20-year duration
31 October 2020
This example teaches you how to calculate the future value of an investment or the present value of an annuity. Tip: when working with financial functions in Excel, always ask yourself the question,
31 October 2020
Excel offers five different depreciation functions. We consider an asset with an initial cost of \$10,000, a salvage value (residual value) of \$1000 and a useful life of 10 periods (years). Below
30 October 2020
What’s compound interest and what’s the formula for compound interest in Excel? This example gives you the answers to these questions. 1. Assume you put \$100 into a bank.
29 October 2020