Solve detailly on excel with formulas 

UIBS SR United International Business Schools EUROPEAN college for liberal studies WORKING CAPITAL MANAGEMENT GROUP ASSIGNMENT For this Group Assignment, worth 25% of the final mark, the students, in groups of 3 (average) must solve the following exercises: Problem 1: You go to the bank and borrow 100,000. The interest rate is a 6%, and you agree with the bank that you'll pay that loan back in one single payment after 5 years. How much money you'll have to pay back to the bank after those 5 years? Draw and fill the repayment table Problem 2: You go to the bank and borrow 100,000. The interest rate is a 6%, and you agree with the bank that you'll pay the interests generated at the end of every period (year), and that you'll pay the principal of the loan at the end of the maturity period. How much money you'll have to pay back to the bank after those 5 years? Draw and fill the repayment table