Evaluating bids

Investment Decision Making and Optimization

Published on the August 23, 2019 in Finance & Management

About this project

Less than USD 50


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.

Category Finance & Management
Subcategory Strategic planning
What do you need? For an idea or early startup
Is this a project or a position? Project
Required availability As needed

Deadline: Not specified

Skills needed

Microsoft Excel Financial Analysis Management

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!