+ Reply to Thread
Results 1 to 2 of 2

Calculate interest on investment

  1. 07-25-2020, 12:59 AM #1
    grcshekar
    grcshekar is offline
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    346

    Calculate interest on investment

    Hi ,

    Ref to enclosed screen shot, can you please help with excel formula for same in Excel 2010
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 07-25-2020, 01:22 AM #2
    grcshekar
    grcshekar is offline
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    346

    Re: Calculate interest on investment

    =round(g16*(1+5.5%/4)^(4*1.21644),0)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IPMT: Investment interest calculated as negative value
    By Equals43 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2016, 07:53 PM
  2. What % of interest do i need to double investment in 4 years?
    By fixfax12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-26-2013, 11:58 AM
  3. Formula to calculate interest earned on an investment and formula to auto insert dates
    By jmord888 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2013, 02:28 PM
  4. Need to calculate 10% or 20% on investment form depending on interest rate in col C
    By hbasten in forum Excel General
    Replies: 5
    Last Post: 05-25-2009, 04:36 PM
  5. Compound Interest with Annual Investment
    By kmham in forum Excel General
    Replies: 1
    Last Post: 02-12-2007, 07:35 PM
  6. [SOLVED] How to use IPMT and PPMT to compute Interest and Investment paymen
    By William in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2006, 08:45 AM
  7. Interest Earned on Investment w/Daily Compounding
    By Liz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1