+ Reply to Thread
Results 1 to 2 of 2

Calculate interest on investment

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    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

  2. #2
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Re: Calculate interest on investment

    =round(g16*(1+5.5%/4)^(4*1.21644),0)

+ Reply to 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. Replies: 1
    Last Post: 02-02-2013, 02:28 PM
  4. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1