112|EXCEL – Time Value of Money with PMT

Time to complete: 45 minutes
Difficulty: Intermediate
This was a great challenge for Excel practice!
TechHub - TVM Challenge.xlsx (49.8 KB)

Time to Complete: 30 Mins
Rating: Intermediate
Challenge112.xlsx (46.2 KB)

Time to complete: 30 minutes
Level: Beginner
I completed this challenge at a basic level, but tried to challenge myself by making the table vertical based on month.
Present Value Table.xlsx (54.6 KB)

Tech Hub Challenge 112 Excel.xlsx (71.8 KB)
Took around 45 minutes to complete. Great Challenge!

Time to complete: 45 minutes
IF statements were a little challenging
Overall fun exercise!
Irons-excelchallenge.xlsx (26.3 KB)

Excel exercise.xlsx (33.3 KB)

Took me about 25 mintues, thought it was a good refresher!

TechHubWorkBook.xlsx (46.4 KB)

TechHub.xlsx (15.1 KB)
Took me about 30 minutes I thought it was very difficult.

Time to complete: 30 minutes
Challenge level: Intermediate
Some parts were difficult, overall good exercise
TechHub PMT Challenge.xlsx (16.9 KB)

Time to Complete: 30 Mins
Level of Difficulty: Intermediate
I thought this was a great lesson with some cool financial metrics involved. I’ll be using this template to start planning out my retirement!

Techzone assignment.xlsx (11.8 KB)

Time to Complete: 30 minutes
Level: Intermediate
ExcelChallenge112.xlsx (82.2 KB)

Time to Complete: 30 minutes
Challenge Level: Intermediate

I found this challenge to be a great exercise for learning the ins-and-outs of TVM functions in Excel. I also thought it was good practice for using if statements as well.

When I come back to this challenge, I plan to implement VBA controls to make the functionality more exciting!

tech hub challenge.xlsx (970.3 KB)

Time: 50 minutes
Level: Intermediate
I got to learn more about excel functions and improved some of my basic excel skills.
Calculator_Retirement.xlsx (89.9 KB)

Time to Complete: 45 minutes
Rating: Intermediate

This challenge helped me work on my Excel skills and learn new shortcuts.
Excel Challenge 112.xlsx (54.7 KB)

30 Minutes
Level: Beginner
This problem helped me refresh some excel skills and functions.
112TVMProblem_TechHub_Hoffman,Cole.xlsx (55.1 KB)

1 Like

Time to complete: 30 minutes
Difficulty: 6/10
This was a fun challenge with TVM and PMT function in excel!
112.Excel.TVM.Challenge.xlsx (12.9 KB)

Time to Complete: 45 minutes
Level: Intermediate
Hi All,
It did take me a little longer to complete this than I was expecting but it was a great practice. Once you get the hang of the formulas, it was easy to complete. What a great practice challenge!
Joshua Joseph Challege 112 TechHub.xlsx (59.0 KB)

Time to complete: 20 minutes
Level: Intermediate

Time: 30 Mins
Level: Easy
TechHubFile.xlsx (9.7 KB)