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)
Attached are my solutions. Gotta love stumbling to remember the most basic thing from Finance 201 with Brau

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)
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)
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.
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)