investments

  1. L

    Hi i need some help for my assignment on savings/investments!!

    Im really new to Excel and I do not know how to start on this assignment.. Anyone knows how to do this? Im not concered about the influence diagram.
  2. M

    Combine data in columns (A-Current portfolio, B-buys, C-sells, Result-resulting portfolio)

    Hi all, I have a series of current investments in columns (fields = InvestmentName, Units, Value). I then have a series of newly acquired investments in columns (fields = InvestmentName, Units, Value). These may be additions to the current investments or new investments. I then have a series...
  3. K

    Reconciling Brokerage/Managed Fund Investment statements to books with journal entry in Excel

    Hello. I am using an investment tracking Excel spreadshee. that is supposed to result in a perfectly balanced journal entry, once all the information from the statement is entered. I am always having a difference. I am also having to add GLs for things like Accrued Interest on Bonds, where the...
  4. X

    Look up for value of a text field

    Hi, I have a balance sheet simplified like below. <tbody> A B C D E F G H Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Cash 44 41 92 225 72 386 362 Cash equivalents 51 0 1 322 40 83 0 Short-term investments </tbody> I would like to look for value of...
  5. A

    Group together cells with common words

    I have a long list of following cells. e.g. cell A111: 9.03% XYZ investments Ltd. MD(23/06/2019) A451: 7.52% ABC industries ltd.MD (12/02/2020) A600: 8.56% XYZ investments Ltd. MD(45/05/2030) A750: 7.52% ABC industries ltd.MD (12/02/2025) and so...
  6. L

    Index & Match Multiple Criteria

    I apologise in advance if this is a confusing post! At the moment I have a table of different investments in column A and in the columns adjacent I have the percentage allocation to each risk profile. The simplified table below should explain better. <tbody> Investment Low Risk Cautious...
  7. M

    ModelOff 2014 - starts 25th October!

    Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...
  8. V

    Excel Solution for MIC/Investment Manager

    We have looked at several mortgage software solutions for our company, but none have one essential ability that we need. We are currently running on a manual spreadsheet solution, and are wondering if we can automate certain aspects of it. We are a financier that lends out money to commercial...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top