Can someone help me solve this in excel?

Managers at your Bank are expecting some adverse movements in the financial market that might force your Bank to liquidate some of its securities holdings. Your Bank management team needs to have an insight regarding the liquidity index

Managers at your Bank are expecting some adverse movements in the financial market that might force your Bank to liquidate some of its securities holdings. Your Bank management team needs to have an insight regarding the liquidity index and hence, your team is expected to prepare a report regarding that. A B D E 1,386,500 1,250,050 657,000 590,300 1,600,800 Value of the position t=0 1,280,000 1,080,000 578,000 496,000 1,585,000 t=1 1,300,000 1,190,000 600,000 530,200 1,600,000 A B C D E 30.00% 70.00% Weight Scenario I Scenario II Scenario III 60.00% 40.00% 50.00% 50.00% Managers at your Bank are expecting some adverse movements in the financial market that might force your Bank to liquidate some of its securities holdings. Your Bank management team needs to have an insight regarding the liquidity index and hence, your team is expected to prepare a report regarding that. A B D E 1,386,500 1,250,050 657,000 590,300 1,600,800 Value of the position t=0 1,280,000 1,080,000 578,000 496,000 1,585,000 t=1 1,300,000 1,190,000 600,000 530,200 1,600,000 A B C D E 30.00% 70.00% Weight Scenario I Scenario II Scenario III 60.00% 40.00% 50.00% 50.00%