Tracking Compounded Investment Returns

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.

 

Industry , , ,
Summary See how different investment books look like with a database like approach that feeds into 10 year summaries. Report individually or consolidated.
Screenshots / Pictures


Use Cases , , ,

Write a Review

Get these templates too for a discount!

Price: $225.00

This is a combined collection of Excel and Google Sheets financial model templates for Accounting and related uses, such as: tracking, inventory management, budget vs. actual, break-even analysis, payment schedule, P&L tracker, etc. The bundle…

Add to wish list
Add to cart Excluding 7.7% tax

Price: $200.00

This is a collection of financial model templates for Real Estate businesses and its related sectors. The models included in this bundle are the following (all Excel models): Joint Venture / WaterFall Real Estate Financial…

Add to wish list
Add to cart Excluding 7.7% tax