A B C D 1 Type Amount Return 2 Automobileloans 0.07 3 Furnitureloans 0.09 4 Othersecuredloans 0.1 5 Signatureloans 0.11 6 Riskfreesecurities 0.08 7 8 Totalreturn =SUMPRODUCT(B2:B6,C2:C6) 9 10 Constraints: 11 =SUM(B2:B6) = 2200000 12 =B6 <= =0.3*C11 13 =B5 <= =0.1*(B2+B3+B4+B5) 14 =B4+B5 <= =B6 We will now solve the above using the solver function of excel and the solution that we het is: Type Amount Return Automobileloans 0 7% Furnitureloans 1,800,000 9% Othersecuredloans 0 10% Signatureloans 200,000 11% Riskfreesecurities 200,000 8% Totalreturn 200,000 Constraints: 2,200,000.00 2,200,000.00 200,000.00 <= 660,000.00 200,000.00 <= 200,000.00 200,000.00 <= 200,000.00