Evaluating the Management of Short-term Funds

Based on their short-term investment policy, the treasurer can effectively manage the short-term funds, including short-term investments, borrowings, etc.

There are sophisticated treasury management software available to do this. A treasury manager based on his needs, size of the funds, and complexity in the portfolio may decide to use a treasury software or simply do so using a spreadsheet software such as excel. For most small operations, excel sheets suffice. These spreadsheets can then be used for effective evaluation of the funds management in terms of effective yields on the investments, and the costs of borrowing.

There are a few things that must be kept in mind while maintaining this data, and generating performance reports.

  1. Record both the short-term investments and the borrowings
  2. Express the returns on investments as bond equivalent yields so that yields from different instruments can be compared.
  3. Calculate weighted average returns from the entire portfolio using investment amounts as the weights.
  4. Follow a consistent format

The following table shows a sample short-term funds performance report:

SecurityDealer/BankAmount ($ ‘000)WeightYieldMaturity
T-billsXYZ Bank50,00050%4%90 days
Commercial PaperAlpha Co.25,00025%5%45 days
Certificate of DepositLi Bank25,00025%5.5%30 days

Weighted average yield: 4.625%

Benchmark yield: 4.5%

The treasurer will have a benchmark against which he will compare his fund’s performance. In this example, the fund has performed better than the benchmark.

Related Downloads

Membership
Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.
I WANT TO JOIN
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Saylient AI Logo

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.