14|EXCEL – Bond Fun(d)

Time to Complete: 10 minutes
Rating: Beginner
Challenge14_Bond_Fun(d).xlsx (10.2 KB)

Challenge14_Bond_Fun(d).xlsx (10.2 KB)

5 minutes to complete

Time To Complete: 10 Minutes
Difficulty: Easy
See Solution Below

1 Like

Great practice with the PV function in excel and a good reminder of determining premiums and discounts on bonds. abs functions was also useful to make any value positive.

Challenge14_Bond_Fun(d).xlsx (10.2 KB)

time 10 min
easy

Time: 5 Min
Difficulty: Easy

Challenge14_Bond_Fun(d).xlsx (10.2 KB)

Time to complete: 10 min
Difficulty: beginner
It was fun working with financial functions!
Solution:
Challenge14_Bond_Fun(d).xlsx (10.2 KB)

Rating: Easy
Time: 10 minutes
I liked learning how to do this in excel!

1 Like

Time to Complete: 7 Min
Rating: Easy
MP.Challenge14_Bond_Fun(d).xlsx (10.2 KB)

Time to complete: 10 minutes
Difficulty: Easy

Time: 15
Level: Beginner
Challenge14_Bond_Fun(d).xlsx (9.6 KB)


Good review of PV

Fun challenge. Good refresher of PV in excel!

Time to complete: 10 mins
Difficulty: Easy
Solution:
Challenge14_Bond_Fun(d).xlsx (10.2 KB)

Time to Complete: 10 minutes
Level: Beginner