Thursday, March 20, 2025
Linkedin
Linkedin
Home Formulas & Functions Financial Functions

Financial Functions

    Worksheet functions that deal with the time value of money.

    Latest
    As inflation rises, so do mortgage interest rates—causing house prices to fall. Here's how Excel's PV function can help you estimate what you new house price will be.

    Here’s How Inflation Could Affect the Value of Your Home

    Financial Functions Charley Kyd - 0
    November 5, 2021 Inflation is rising in the U.S. And that made me wonder how a higher rate of inflation could affect the price of...
    To calculate the correct growth rate for your data you need to be clear about what you want your growth rate to signify. Here's how to work it out.

    How to Calculate BOTH Types of Compound Growth Rates in Excel

    Financial Functions Charley Kyd - 0
    If you search the web to learn how to calculate a compound growth rate in Excel, you’ll likely find instructions for calculating only one...
    The Internal Rate of Return calculation has very real problems, no matter where it's calculated. But with its MIRR function, Excel could offer a solution.

    How Excel’s MIRR Function Can Fix the IRR Function

    Financial Functions Charley Kyd - 0
    The calculation of an Internal Rate of Return is very appealing...at first glance. When you know the IRR of a prospective investment, you seem to...
    Here's how to set up Future- and Present-Value formulas that allow compounding by using an interest rate and referencing cash flows and their dates.

    Find Future and Present Values from Scheduled Cash Flows in Excel

    Financial Functions Charley Kyd - 0
    "I would like a Future Value command similar to the XIRR and XNPV functions, which allow compounding by using an interest rate and referencing...
    The Rule of 72 is a guesstimate of how long it will take an investment at a specific interest rate to double in value. But how accurate is it? Ask Excel.

    Excel and the Rule of 72

    Financial Functions Charley Kyd - 0
    I recently learned that my son—who's an avid amateur investor—had never heard of the Rule of 72. The rule of 72, I texted him, says...
    Both IPMT and ISPMT return the interest payment for a given period for a loan or investment. But Microsoft's help topics haven't made their differences clear. Here's what you need to know about these two financial functions.

    How to Create Even-Payment and Straight-Line Amortization Tables in Excel

    Financial Functions Charley Kyd - 0
    When you borrow money for a fixed period with periodic payments, you could have two types of loans: even-payment or straight-line. Microsoft recognizes those loan...
    Most loans and many investments are annuities, which are payments made at fixed intervals over time. Here's how to use Excel to calculate any of the five key unknowns for any annuity.

    Excel’s Five Annuity Functions

    Financial Functions Charley Kyd - 0
    “Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
    Mortgage lenders give you many options for your interest rate and amortization period. This workbook helps you to choose from among them.

    Compare Loan Payment Options in Excel

    Financial Functions Charley Kyd - 0
    When you’re comparing your payment options for mortgage loans, your choices can be overwhelming... When in St. Ives, I found a home, Then looked at seven...
    Term loans can have a variety of repayment periods, interest rates, amortizing methods, and so on. Here's how to calculate amortization schedules for the two most common types of amortizing loans.

    How to Use Excel Formulas to Calculate a Term-Loan Amortization Schedule

    Financial Functions Charley Kyd - 0
    "How do I calculate cumulative principal and interest for term loans? I have scoured the web for a function that will perform this task,...
    Load more

    Latest Articles

    Excel Flowbook Revolution

    Getting Radical with Excel

    Excel Data Plumbing Revolution Charley Kyd - 0
    It's time to think about Excel in a radical new way—when we use it to work with business or economic data. It's time, in fact,...
    Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

    How Fast Is Too Fast?

    Accounting & Finance Charley Kyd - 0
    (Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...

    How to Smooth Data by Using the TREND Function

    Aggregation Functions Charley Kyd - 0
    Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.