Create a investment ledger in excel
- Posted:
- Proposals: 1
- Remote
- #533839
- PRE-FUNDED
- Awarded
has already sent a proposal. Description
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:
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
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.