14|EXCEL – Bond Fun(d)

Here’s my solution!
This was a great review of the present value function and bonds
Challenge14_Bond_Fun(d).xlsx (10.2 KB)

I got the right answers! Great to have a bond refresher.
Challenge14_Bond_Fun(d).xlsx (9.6 KB)


Here’s my solution! This was a good refresher of the present value formula!


Attached are my solutions. Gotta love stumbling to remember the most basic thing from Finance 201 with Brau :wink:

Challenge14_Bond_Fun(d).xlsx (10.2 KB)

That was a great review of Time Value!

Challenge14_Bond_Fund.xlsx (10.2 KB)

Here is my solution! It was a great reminder of the basic financial functions in Excel.

Here’s my solution to this challenge. It was a nice refresher on how to use the PV function on excel rather than just a calculator.
Challenge14_BondFun(d)_Wilson.xlsx (10.2 KB)

1 Like

Here is my solution to this challenge. I enjoyed being able to revisit TVM and bonds!

1 Like

Here is my solution.
Challenge14_Bond_Fun(d).xlsx (10.2 KB)


I had a really fun time reviewing my bonds skills. I did not realize Excel had a TVM Calculator. Very grateful to have learned this.

challenge 11 5.xlsx (10.2 KB)

Good little challenge to help with applying present value to excel. It was a good refresher.

This was a fun challenge! I’m learning about PV of bonds in Financial Accounting right now, so it was relevant and useful practice. I’m good at TVM calculations with my calculator, but not Excel. It was a risk-free (ba dum crash) way to get more practice using Excel to do the calculations!

Challenge14_Bond_Fun(d)_Semadeni.xlsx (10.2 KB)

I had a great time doing this project for the SONA lab study. I learned even more about how to do TVM calculations inside of EXCEL!

Challenge14_Bond_Fun(d).xlsx (10.2 KB)

Here’s my solution! This was a good refresher of how to do TVM formulas in Excel. Thanks for the fun challenge.


Here is my solution! Finance feels like a distant dream so this was a good refresher.

1 Like

Challenge14_Bond_Fun(d).xlsx (10.2 KB)
Here is my solution. It took me a minute to remember to adjust values depending on payments for year; thanks for the practice and reminder!

I definitely went through a little too fast and missed the different number of payments per year. However, I still got a pretty close answer because of the way the numbers matched up. I fixed it though and got it right.

Challenge14_Bond_Fun(d).xlsx (10.2 KB)