Quant Question (using Excel COUNTIF)

daven9947
Example.xlsx

Sheet1

Chen Chen
Rate of return Max of total funds avalible Max of total funds alocated alllocations
Auto Loans 0.08
Furniture Loans 0.1
Other Secured Loans 0.11
Signature Load 0.12 0.1
Risk-Free Securities 0.09 0.3
Fubds available 2000000
Allocation
Auto Loans 630000
Furniture Loans 170000
Other Secured Loans 460000
Signature Load 140000
Risk-Free Securities 600000
Total 2000000
Total Loans 1400000
Furniture and Other Secured 630000
Other secured and Signature 600000
Return 188800
So, the projected total annual return is $188800