WHAT ARE THE EXCEL FORMULAS FOR THE TABLE?

2) Stratification Table (2 points) Given the mortgage loan portfolio in the table below, please build a table describing the number of loans and balance breakdown by Loan type. Note: Show all formulas and/or calculations used, if any Loan ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Loan Type AS DI SA SA AS DI AS DI DI SL SA DI DI SL Region CAMPANIA CALABRIA SICILIA LOMBARDIA PUGLIA VENETO LOMBARDIA ABRUZZO MOLISE PIEMONTE LOMBARDIA PUGLIA PUGLIA PIEMONTE Loan Balance Interest rate Final Maturity 75,807 3.8% 2006 3,470 2.1% 2018 1,105 3.3% 2008 109,988 7.1% 2009 2,369 2.7% 2008 39,399 4.4% 2016 39,727 3.2% 2011 3,526 7.3% 2008 202,330 4.6% 2016 102,369 6.9% 2013 172,199 4.3% 2019 35.303 5.6% 2008 66,441 7.3% 2014 25,805 4.2% 2016