All Industries, Financial Services, General Excel Financial Models, Investment, Real Estate

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 the 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, and 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. The second tab is for members. It tracks their activity based on individual member IDs. The 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.