Create a SQL Query with joining a one to many relationship

I have a MS SQL database that has 2 tables. One is an index table and the other is multiple transactions. I need a efficient joint that will pull the two table together with the max date from the transaction table with the index table, The attached file has the data and table structure. The Index table is the Grant table and the transaction table is the Grant Funding table. I have the data and the expected output in the attached file.