Results 1 to 8 of 8

Financial Analysis

Threaded View

  1. #1
    Registered User
    Join Date
    07-04-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Financial Analysis

    Hello fellow forum members,

    I am comparing the returns of several fixed-income funds and since their inception (founding) dates differ, I have columns where some have over 300 values while others have a mere 30.

    I need to do the following equation for every column (from A2:A300:
    = (1+(A2/100))*(1+(A3/100))...etc...(1+(A299/100))*(1+(A300/100))

    I tried to do the first 50 manually, but the forumula ended up being too long.
    Would the fixed-income funds that were only recently established (i.e. only have values for A260:A300) screw up any equation because of blank fields?

    Please see the excel file for the problems I am having (marked in orange)

    Any help is greatly appreciated - just spent 2 hrs googling and it seems most people have problems with basics and not 'complex' equations such as the ones above.

    Have a good weekend & thanks in advance!
    msrlg
    Attached Files Attached Files
    Last edited by msrlg; 07-08-2009 at 02:03 AM.

Thread Information

Users Browsing this Thread

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

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