Bond Portfolio Interest Calculation Manager
Budget: €30 – €250 EUR
I'm in need of an Excel VBA expert who can help accurately calculate the annual interest and face value payments of my bond portfolio, which comprises only plain vanilla fixed rate bonds, with coupon freuquency either 1 or 2 (annual / semiannual).
I need to be able to perform thos cashflow rollout regularly in case my portfolio composition changes. Ideally there is a button to click and Excel will start the rollout.
Key tasks include:
- Calculating the correct cash flow dates based on maturity date with VBA. This is the most difficult piece. I would like to have all cash flow dates of all bonds in the portfolio in one top row and the relevant cashflows below ( i.e. if there are 20 bonds in the pf, there should be one date row and 20 interest/ maturity cf rows.
- Determining precise interest amounts. Walk in the park I would say if you are able to do step one. FVxCpnxCpnFrequency
Ideal freelancers will have experience in dealing with bonds and a solid understanding of their interest calculation details. Proficiency VBA and portfolio management is essential.
I need to be able to perform thos cashflow rollout regularly in case my portfolio composition changes. Ideally there is a button to click and Excel will start the rollout.
Key tasks include:
- Calculating the correct cash flow dates based on maturity date with VBA. This is the most difficult piece. I would like to have all cash flow dates of all bonds in the portfolio in one top row and the relevant cashflows below ( i.e. if there are 20 bonds in the pf, there should be one date row and 20 interest/ maturity cf rows.
- Determining precise interest amounts. Walk in the park I would say if you are able to do step one. FVxCpnxCpnFrequency
Ideal freelancers will have experience in dealing with bonds and a solid understanding of their interest calculation details. Proficiency VBA and portfolio management is essential.