Shore Group Associates interview question

Financial Analysis related, Excel, Gaap