Please attach screenshots of Excel so that I can learn too. Thank you. :) You can use interest rate of your own choice wehere missing.

Write debt repayment plans, use given data. You are given debt size, number of payments per year = p, m = how many times interest is calculated, n = number of years, i = annual interest rate, j nominal interest rate (it is given, if not - you can choose).

1. Debt = 450 000. Each year is paid $25 000 of principal, the rest in the last year. n=12, i=6%

2. Debt 180 000. Equal payments: n=6, m=4, p =2.

Write fund formation plans, use given data. You are given debt size, number of payments per year = p, m = how many times interest is calculated, n = number of years (choose interest rates: i, g; a, and q).

Variant one :

1. Debt = 410 000. Equal deposits. n=5, p=4, m=2

2. Debt = 420 000. Geometric progression: n=10.

Variant two:

1. Debt = 100 000. Equal deposits. n=5, p=4, m=2

2. Debt = 120 000. Geometric progression: n=10.