Investment Decision Making and Optimization

Hi

I'm looking for some one who is able to do up a report (excel included) for a multiple objective decision making/optimisation problem.

It is an investment decision making question. Financing Company (FC) is looking to finance a trade between Supplier A and Buyer B. FC will conduct Receiveable Financing, that's to finance Supplier A's  Account Receivable (AR) to Buyer B.

That means that FC will pay Supplier A upfront once they have proven that the shipment of goods have been sent. Then Buyer B will make payment directly to FC according to the payment terms.

To onboard, what usually happens is that Supplier A and Buyer B will submit their financial statements to verify that they have the capabilities to return the money. In the event that Buyer B does not return money to fc, then fc will have legal capacity to collect the money from supplier a.

The problem to solve here, is
1. What financials should be looked at to determine whether Supplier A and Buyer B have the capacity to pay back?
2. Have an adjustable threshold so that FC can adjust it based on their risk appetite.


3. There are now other trades going on, fc has a limit of us$100 million dollars, how can fc optimise its profits based on the best set of trades to finance in?

note: fc charges 8% p.a. To finance a trade. FC has a cost of fund of 6% p.a. That needs to be paid to their fund stakeholders.