• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Financial Functions

Excel ACCRINT Function

Excel ACCRINT Function

June 30, 2013 by Mynda Treacy

The Excel ACCRINT function returns the accrued interest for a security that pays interest periodically. The Syntax is: ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) The arguments can be explained as: issue - the issue date of the security. first_interest - the first date interest will be paid. settlement - the settlement date of …

Read moreExcel ACCRINT Function
Invest $x at 4.75% for 5 Years to Make $15,000

Invest $x at 4.75% for 5 Years to Make $15,000

April 10, 2012 by Mynda Treacy

I received an email from Stacey a few weeks ago asking: “Which formula would I use to find the initial investment amount required to have $15,000 at the end of 5 years, if my bank pays 4.75% interest, compounded monthly?” The answer is the PV Function. =PV(4.75%/12,60,0,-15000,0) =$11,834.50 Excel’s PV Function PV Function Syntax =PV(rate,nper,pmt,[fv],[type]) …

Read moreInvest $x at 4.75% for 5 Years to Make $15,000
Calculate How Long to Make $1m with NPER

Calculate How Long to Make $1m with NPER

March 7, 2012 by Mynda Treacy

James wrote to me and asked: if he buys shares worth $2000 and gets 4% return, how many times does he need to reinvest all of his capital before he makes $1m. Of course James was quick to point out that this scenario doesn’t take into account loosing on any of his trades. Reasonable I …

Read moreCalculate How Long to Make $1m with NPER
How to Calculate Interest on Savings in Excel

How to Calculate Interest on Savings in Excel

April 1, 2011 by Mynda Treacy

Ever had a spare $10,000 to put in a term deposit? If you did you might wonder what it would be worth at the end of 2 years at an interest rate of 6% compounded monthly. It’s not as simple as =$10,000 x (1+.06 x 2)…although this will get you close. But if you’re a …

Read moreHow to Calculate Interest on Savings in Excel

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.