224|EXCEL – Bonds, James Bonds

Time to Complete: 25 min
Rating: Beginner
Solutions
Steven And Deborah: $199.84
Emily Johnson: $200.94
William Brown: $100.56


Here’s my solution:

Steven & Deborah: 199.84
Emily Johnson: 200.94
William Brown: 100.56



Time to complete: 30 min
Level: Intermediate

Steven and Deborah Johnson: $199.84
Emily Johnson: $200.94
William Brown: $100.56

Time to Complete: 25 minutes
Rating: Beginner
Solution:

  1. Steven/Deborah: 199.84
  2. Emily Johnson 200.94
  3. William Brown 100.56

Time to complete: 20 minutes
Difficulty: Easy
Solution: See below

  1. Steven and Deborah Johnson Have a total PV of $199.84 as of 9-30-2040

  1. Emily Johnson has a total PV of $200.94 as of 3-31-2065

  1. William Brown has a total PV of $100.56 as of 12-31-2060

Time to Complete: 20-30 minutes
Rating: Beginner sort of, but intermediate if you don’t know how to use pivot tables

Solution:
Steven and Deborah: 199.84 (2 bonds)
Emily Johnson: 200.94 (2 bonds)
William Brown: 100.56 (1 bond)

Steven and deborah = $199.84
William - $100.56
Emily - $200.94

Time to Complete: 25 minutes
Difficulty: Beginner
Solutions:
Steven and Deborah Johnson: Total = $199.84
Emily Johnson: $200.94
William Brown: $100.56

Time to Complete: 20 minutes
Rating: Beginner
Solution:
Steven and Deborah: $199.84375 - 2 bonds
Emily Johnson: $200.9375 - 2 bonds
William Brown: $100.5625 - 1 bond

Time: 15 Minutes, Difficulty: 4/10 Solution:
Steven and Deborah Johnson: 199.84
Emily Johnson: 200.94
William Brown: 100.56

Time to Complete: 25 Minutes
Level: Beginning
It wasn’t too hard, but a great thought exercise to review pivot tables!

Steven and Deborah Johnson: 99.62 and 100.21
Emily Johnson: 200.93
William Brown: 110.56

This Took me about 10 minutes to complete.
Difficulty was beginner.
Solution:
Money that will be available by the specified date for each person is
Steven Johnson $100.22
Deborah Johnson $99.63
Total for Deborah and Steven Johnsons is $199.85

Emily Johnson: $200.94

William Brown: $100.56

Time To complete: 20 minutes
Rating: Intermediate

Steven & Deborah Johnson: 199.84
Emily Johnson: 200.94
William Brown: 100.56

~15 Minutes to complete
Beginner
Enjoyed the Pivot Table practice!

Time to complete : 35-40 mins
Level: It’s probably intermediate to me but with more practice I feel it would become more easy !

Steven and Deborah Johnsone =199.84
Emily Johnson= 200.94
William Brown = 100.56

Time to complete: 30 min
Rating: Beginner
Solutions:
Steven and Deborah Johnson: $199.84
Emily Johnson: $200.94
William Brown: $100.56

Cragun Bastian
15 min
easy

Deborah and Steven Johnson 199
Emily Johnson 200
William Brown 100

time to complete: 30 minutes
Steven and Deborah Johnson: 100.22 and 99.63
Emily Johnson: 200.94
William Brown: 100.56

Time To Complete: 20 minutes
Difficulty: Beginner

Steven and Deborah Johnson - $199.84
Emily Johnson - $200.94
William Brown - $100.56