---

Задание 1:
=-20000+4800/(1+13%)^(168/365)+5400/(1+13%)^(255/365)+5700/(1+13%)^(369/365)+6200/(1+13%)^(454/365)

Задание 2a:
=200000/(1+8%)^1+200000/(1+8%)^2+300000/(1+8%)^3+300000/(1+8%)^4

Задание 2b:
=200000/(1+8%)^1+200000/(1+8%)^2+600000/(1+8%)^3+600000/(1+8%)^4

Ставка для 2c:
=(1+8%)/(1+4%)-1

Задание 2c:
=200000/(1+((1+8%)/(1+4%)-1))^1+200000/(1+((1+8%)/(1+4%)-1))^2+300000/(1+((1+8%)/(1+4%)-1))^3+300000/(1+((1+8%)/(1+4%)-1))^4