Time to complete: 45 minutes
Difficulty: intermediate
I really liked how practical this challenge was. I needed some help with the formulas and if statements, but other than that it went well!
TVM Challenge Solution.xlsx (86.2 KB)
Time: 40 mins
Rating: Beginner/Intermediate
TechHub Challenge .xlsx (15.2 KB)
25 minutes
I decided to do a payment a year as that seemed more relevant to me.
Tech Hub Training Solution.xlsx (13.4 KB)
Time to Complete 30 mins
Level: Intermediate
Some of this was straight forward and a review for me, but some of the functions were more complex and new to me. I enjoyed learning!
Great challenge
Time: 25 minutes
Excel Challenge.xlsx (54.5 KB)
Time : 30 minutes
Intermediate
This was a very fun refresher!
Client-MayaS.xlsx (10.2 KB)
Great challenge, enjoyed learning about the PMT function on Excel.
Time to complete: 25 minutes
Level: Beginner
My solution:
Mishra, Ojas_Techhub PMT Challenge.xlsx (63.1 KB)
Time to complete: 30 minutes
Level: Beginner
A good problem! I loved doing this practice.
Challenge Time Value of Money.xlsx (28.7 KB)
My solution to this problem is simple. Just needs someone to change the their age and their current retirement savings to find how much to save to reach retirement goal.
Time Value of Money PMT sheet.xlsx (9.4 KB)
Time to complete: 40 min
Difficulty: Intermediate
112 - Excel - TVM with PMT.xlsx (39.7 KB)
Time: 20 minutes
Level: Beginner
Fun little project that is relevant to everyone, regardless of profession. Hardest part for me was figuring out how to format the table, but the math and formulas were pretty straightforward. If you are an accounting or finance major, the formulas should be familiar.
Time Value of Money Solutions.xlsx (12.8 KB)
I misread PMT fxn definition (0 vs 1), would have saved me time for sure! It’s good review for all levels.
tech hub challenge.xlsx (53.8 KB)
Time: 35 minutes
Level: Intermediate
I enjoyed doing this as it gave me a much needed refresher on certain excel features!
EYARC Excel.xlsx (75.1 KB)
Time to Complete: 35-45 min
Level: Beginner
This was a fun, straight forward little project! Spent some extra time formatting and adjusting the formulas to be universally applicable as an additional challenge for myself. Good review of some basic finance and excel functions!
TechHub Excel Challenge 112.xlsx (95.2 KB)
TVM_PMT_Challenge.xlsx (44.5 KB)
This was a really cool project to do! It was definitely good review of basic finance topics, and is easily applicable and useful to our own lives.
Time to complete: 30
Rating: Intermediate
This was a nice refresher on TVM and creating annuity tables!
TechHub TVM.xlsx (19.7 KB)
Time: 30 minutes
Level: Beginner
Excel 112 Challenge.xlsx (64.2 KB)
1 Like
Time: 45 minutes
Level: Intermediate
TVM Practice Excel workbook.xlsx (66.5 KB)
It took me a good amount of time to complete the assignment, and I needed quite a bit of help to get the correct outputs, but it is basic coding and understanding really only a few functions. Knowing shortcuts sped up this process quite a bit.
1 Like
Challenge_112.xlsx (827.2 KB)
This was an interesting challenge. I struggled to get the table correct, but I think I got it.
Time to Complete: 40 Minutes
Level: Intermediate
Notes: The hardest part of this project is figuring out exactly how to format everything. The TVM is relatively simple when you format everything correctly.
Challenge 112.xlsx (11.7 KB)