must solve the following exercises: DOITONEXCEL

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

Problem $3$:

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 constant yearly payments $($so$,$ French method of amortization$)$ during the next $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 $4$:

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 constant monthly payments $($so$,$ French method of amortization$)$ during the next $5$ years.

How much money you$$ll have to pay back to the bank?

Draw and fill the repayment table

Problem $5$:

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 constant monthly payments $($so$,$ French method of amortization$)$ during the next $5$ years. You also agree with the bank that you$$ll not pay anything during the first $12$ months, so you$$ll start paying it back in month $13.$ In addition, after having done $12$ payments $($so$,$ after month $24),$ you amortize $20,000$ in advance, and you decide to keep the maturity as originally scheduled and reduce the amount of each remaining payment.

How much money you$$ll have to pay back to the bank every month?

Draw and fill the repayment table