IDEA for Intern: Tie all company assets back to open bank or financing loans. What are their balances left?

Hire an intern to go through the fixed assets and tie them back to any open bank or finance company loans. Prepare schedule of 1.) original cost, 2.) accumulated depreciation, 3.) net book value,  4.) open loan value.    Later you may want to have a market value added to this listing.