BendDAO is the first NFT liquidity protocol supporting instant NFT-backed loans, Collateral Listing, and NFT Down Payment. The seamless experience of down payment, borrowing, and listing creates a perfect closed loop for users, a one-stop NFT liquidity solution.

In this bounty we were asked to build a comprehensive balance sheet dashboard for BendDAO.

I calculated number of borrowers and repayers, volume of borrows and repays, avg utilization rate, depositit and withdraw transaction, reserve volume and also collateral by collection in 2022:

In the above charts, you can see daily and total number of borrowers and repayers.

In total, number of repayers is about 3 times bigger than borrowers.

The last borrow transaction was on July 17th.

Number of borrowers was always less than repayers except in 7 days.

Number of users who did repay transaction, had 3 big spikes from beggining of 2022, which was on May, June and August.

In the above charts, you can see daily and total number of borrow and repay transactions(actions).

In total, number of repay transactions is about 8 times bigger than borrow transactions.

The last borrow transaction was on July 17th.

Number of borrows was always less than repay transactions except in 7 days.

Number of repay transactions had 3 big spikes from beggining of 2022, which was on May, June and August.

Trend of repay and borrow transactions is very similar to the trend of number of borrowers and repayers chart.

Total ETH volume of repays, is about 7 times more than the volume of borrows.

The trend of this chart, is very similar to the trend of number of borrowers and repayers.

In average, each repayer, repaid 40.99 ETH and each borrower borrowed 19.12 ETH in average.

Above chart shows average ETH volume of repay and borrow transactions.

which means that in total, each repay transaction had the average volume of 10.19 ETH and each borrow transaction had the average volume of 11.33 ETH.

Utilization rate was very volatile since beggining of 2022. which means that the share of a pool which was loaned had been changing a lot during time.

The highest share of pools was loaned on May during Luna crash, then we see that whenever the market experienced a big crash, utilization rate increased again and in ranging days of the market, this parameter decresed again.

In the above charts, you can see the daily number of deposit and withdraw transactions and users and also the volume of their transactions in each day of 2022.

number of users and their transactions had a very similar trend. They have three big spikes in May, June and August.

The ETH volume of deposit and withdrawals looks different and that is becauase of the changes in the price if ETH maybe. It ranged below 20 K ETH in most of the days(except 14 days), but in the recent weeks and getting closer to the Merge date, volume of deposits increased sharply.

deposit volume - withdraw volume shows the reserve amount of each day which I showed in the below chart:

As said before, amount of deposits was more than withdraws in recent weeks and you can see that how the reserve amount in recent weeks was positive in most of the days and increased sharply in recent day also.

Amount of deposits and withdraws was very close to each other until April 20th which you can see that the reserve volume was very low too.

In the below charts I showed the collaterals for each collections:

Mutant collection had the highest number of users and collaterals. Bored Ape was in the second rank.

As you can see, from April 20th number of collaterals and users who did them increased sharply until May 3, for all of the collections, but after that date, this number decreased for all of the collections.