Excel Financial Spreadsheet Creation

Job ID: 31884480

Budget: ₹600 – ₹800 INR

I need a spreadsheet created that tracks gain of 1 financial account and applies those gains, in proportion to the smaller, separate accounts that are within that one large account.

In other words, I need a spreadsheet that will track the overall ROI of 1 large account and apply those ROI's to each individual account that is pooled together to make up that large account.

I have attached the spreadsheet I am using, but something is off and it is overly complicated. I need you to use that as a rough template but edit it so that I only have to do data entry on the 1 large account final numbers. Please use the attached spreadsheet as a ROUGH template.