Create a investment ledger in excel

  • Posted:
  • Proposals: 1
  • Remote
  • #533839
  • Awarded
Rundie D.
has already sent a proposal.
  • 0


Experience Level: Intermediate
Estimated project duration: less than 1 week
Industry: Business
Description of excel work: To create a investment ledger template in excel to capture the following:
- Investment holdings in equity and bonds.
- Template must allow user to update current market value and compute and capture the unrealised gain or losses from revaluation
- Template must allow user to update currency code and compute and capture the unrealised gain or loss in forex
- Template to allow user to capture movements in investment holdings (purchase, sales and redemption) and compute the realised gain or loss from the divestment
- Template to compute the accrued interest for bonds, amortisation/accretion of bonds.
- The excel template should split the ledger in different excel worksheet for bonds (1 worksheet per currency) and equities (1 worksheet per currency)
Extra notes:

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.