Palisades interview question

Pretty difficult excel test about weighted LTV ratio calculation, payment string manipulation, and SQL queries.