Using the formula of solver in excel ( please screenshots step by step of the number that were put in the solver to get the new amounts)

determining the new amounts

and the adjustments

ps solver appears in excel in data at the right end

Project 2 Portfolio Analysis Bank Banco Industrial Banco Centroamericano Corp Financiera Nacional Banco de Construccin Banco Nacional Banco del Pacfico TOTAL Amount 706 000 000 692 000 000 495 000 000 200 000 000 692 613 000 75 000 000 2 860 613 000 Rate 6,86% 6,21% 4,92% 5,58% 4,93% 5,77% You are the Investment Portfolio Manager and one of your responsibilities is to comply with the Investment Policy for the fund's resources. A recent Financial Audit found that the portfolio was not complying with the Internal Investment policy's cap (25%) As the party responsible you must submit a proposal to adjust the portfolio to comply with the cap. Liquid funds 150 000 000 With the information supplied: Build a model to determine the Fund's compliance with the investment cap. Determine the total size of the portfolio and the size of the cap. Prepare a proposal to adjust the portfolio taking into consideration the Liquid funds that should also be invested in fixed-rate assets. Project 2 Portfolio Analysis Bank Banco Industrial Banco Centroamericano Corp Financiera Nacional Banco de Construccin Banco Nacional Banco del Pacfico TOTAL Amount 706 000 000 692 000 000 495 000 000 200 000 000 692 613 000 75 000 000 2 860 613 000 Rate 6,86% 6,21% 4,92% 5,58% 4,93% 5,77% You are the Investment Portfolio Manager and one of your responsibilities is to comply with the Investment Policy for the fund's resources. A recent Financial Audit found that the portfolio was not complying with the Internal Investment policy's cap (25%) As the party responsible you must submit a proposal to adjust the portfolio to comply with the cap. Liquid funds 150 000 000 With the information supplied: Build a model to determine the Fund's compliance with the investment cap. Determine the total size of the portfolio and the size of the cap. Prepare a proposal to adjust the portfolio taking into consideration the Liquid funds that should also be invested in fixed-rate assets