Tracking Compounded Investment Returns

See how different investment books look like with a database like approach that feeds into 10 year summaries. Report individually or consolidated.

, , ,
, , ,

1. Goes out 10 years.
2. Track up to 20 members.
3. Up to 500 total investors across 20 members.
4. User enters transactions by date into the database rows, and those are then tracked on 10 year daily summaries that also track $ return based on input and compound the $ return annually. Summaries pull from the member/investor entries so make sure they match what you have in assumptions.
5. You have a consolidated summary that toggles between monthly/annual.
6. Visual that displays interest by day for 10 years for consolidated, member, investor.

Layout and Flow

There are 3 main tabs. The first is the investor tab where you pick which investor you want to report on. Their relevant deposits/withdrawals/$ returns will then populate the sheet. Second tab is for members. It tracks their activity based on individual member id’s. Third is consolidated. This tracks all transactions across the book.

You can apply different rate of returns for individual investors, members, and the consolidated book.

Also, each tab has a query function where you can enter any two dates and the total $ return will calculate per accruals during that date.

A running balance by day applies to the summaries.


Write a Review

500 character(s) remaining