# 112|EXCEL – Time Value of Money with PMT **URL:** \ **Category:** Challenges\ **Tags:** excel, beginner, financial, time-value-of-money, savings, retirement, pmt\ **Created:** [January 24, 2024, 5:18am UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158 "2024-01-24T05:18:52Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Kyra\_Smith](https://avatars.discourse-cdn.com/v4/letter/k/aca169/32.png) [@Kyra\_Smith](https://www.techhub.training/u/Kyra_Smith)\ **Post date:** [June 28, 2024, 2:55pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/21 "2024-06-28T14:55:06Z")
Time to complete: 45 minutes Difficulty: Intermediate This was a great challenge for Excel practice! [TechHub - TVM Challenge.xlsx](https://www.techhub.training/uploads/short-url/w1LIoRsNo2UsQmmv4uG6JDxvT7a.xlsx) (49.8 KB) ---
**Author:** ![Gage\_Katzenell-Hall](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@Gage\_Katzenell-Hall](https://www.techhub.training/u/Gage_Katzenell-Hall)\ **Post date:** [June 28, 2024, 3:14pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/22 "2024-06-28T15:14:44Z")
Time to Complete: 30 Mins Rating: Intermediate [Challenge112.xlsx](https://www.techhub.training/uploads/short-url/rcz7lzWhLBIdyTJ5IOc13caYHVo.xlsx) (46.2 KB) ---
**Author:** ![Frank\_Russo](https://avatars.discourse-cdn.com/v4/letter/f/a4c791/32.png) [@Frank\_Russo](https://www.techhub.training/u/Frank_Russo)\ **Post date:** [June 28, 2024, 3:21pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/23 "2024-06-28T15:21:06Z")
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](https://www.techhub.training/uploads/short-url/tx4tyKcJkV5EoOD0L2od29CfIO6.xlsx) (54.6 KB) ---
**Author:** ![Matthew\_Culbert](https://avatars.discourse-cdn.com/v4/letter/m/c0e974/32.png) [@Matthew\_Culbert](https://www.techhub.training/u/Matthew_Culbert)\ **Post date:** [June 28, 2024, 3:32pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/24 "2024-06-28T15:32:45Z")
[Tech Hub Challenge 112 Excel.xlsx](https://www.techhub.training/uploads/short-url/8Zr2rn126LWNA34CumvWAbF6WkV.xlsx) (71.8 KB) Took around 45 minutes to complete. Great Challenge! ---
**Author:** ![Kaitlyn\_Irons](https://avatars.discourse-cdn.com/v4/letter/k/e47c2d/32.png) [@Kaitlyn\_Irons](https://www.techhub.training/u/Kaitlyn_Irons)\ **Post date:** [June 28, 2024, 3:55pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/25 "2024-06-28T15:55:45Z")
Time to complete: 45 minutes IF statements were a little challenging Overall fun exercise! [Irons-excelchallenge.xlsx](https://www.techhub.training/uploads/short-url/3NLl1KgIfrJS7S1nObn2gYtdR4e.xlsx) (26.3 KB) ---
**Author:** ![Josh\_Robinson](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@Josh\_Robinson](https://www.techhub.training/u/Josh_Robinson)\ **Post date:** [June 28, 2024, 3:57pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/26 "2024-06-28T15:57:41Z")
[Excel exercise.xlsx](https://www.techhub.training/uploads/short-url/nt3ycu5EnzdM8RRNMbsUmtkW5pX.xlsx) (33.3 KB) ---
**Author:** ![Danny\_McGrath](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@Danny\_McGrath](https://www.techhub.training/u/Danny_McGrath)\ **Post date:** [June 28, 2024, 4:14pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/27 "2024-06-28T16:14:13Z")
Took me about 25 mintues, thought it was a good refresher! [TechHubWorkBook.xlsx](https://www.techhub.training/uploads/short-url/4z6xkp2ZaFM3yZgduSELN0WoeOj.xlsx) (46.4 KB) ---
**Author:** ![Kevin\_Mowrey](https://avatars.discourse-cdn.com/v4/letter/k/3d9bf3/32.png) [@Kevin\_Mowrey](https://www.techhub.training/u/Kevin_Mowrey)\ **Post date:** [June 28, 2024, 4:35pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/28 "2024-06-28T16:35:08Z")
[TechHub.xlsx](https://www.techhub.training/uploads/short-url/tjf3ykU4kor6FYFZi5GgydYE43H.xlsx) (15.1 KB) Took me about 30 minutes I thought it was very difficult. ---
**Author:** ![Dylan\_Stroze](https://avatars.discourse-cdn.com/v4/letter/d/cc9497/32.png) [@Dylan\_Stroze](https://www.techhub.training/u/Dylan_Stroze)\ **Post date:** [June 28, 2024, 5:04pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/29 "2024-06-28T17:04:16Z")
Time to complete: 30 minutes Challenge level: Intermediate Some parts were difficult, overall good exercise [TechHub PMT Challenge.xlsx](https://www.techhub.training/uploads/short-url/aiwg6Fihm6WPGnlqEiMOc11Ybqe.xlsx) (16.9 KB) ---
**Author:** ![Jared\_DeMott](https://avatars.discourse-cdn.com/v4/letter/j/6f9a4e/32.png) [@Jared\_DeMott](https://www.techhub.training/u/Jared_DeMott)\ **Post date:** [June 28, 2024, 5:38pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/30 "2024-06-28T17:38:48Z")
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! ---
**Author:** ![Nate\_Frankel](https://avatars.discourse-cdn.com/v4/letter/n/ee59a6/32.png) [@Nate\_Frankel](https://www.techhub.training/u/Nate_Frankel)\ **Post date:** [June 28, 2024, 5:53pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/31 "2024-06-28T17:53:23Z")
[Techzone assignment.xlsx](https://www.techhub.training/uploads/short-url/ucrORxkAtVAbPZM68mT2YJvNDjD.xlsx) (11.8 KB) ---
**Author:** ![winstonyuhm](https://avatars.discourse-cdn.com/v4/letter/w/c4cdca/32.png) [@winstonyuhm](https://www.techhub.training/u/winstonyuhm)\ **Post date:** [June 28, 2024, 6:17pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/32 "2024-06-28T18:17:03Z")
Time to Complete: 30 minutes Level: Intermediate [ExcelChallenge112.xlsx](https://www.techhub.training/uploads/short-url/s16A71IWsBDszgnoDP3DYQrYRc3.xlsx) (82.2 KB) ---
**Author:** ![Ayesha\_Zahory](https://avatars.discourse-cdn.com/v4/letter/a/a698b9/32.png) [@Ayesha\_Zahory](https://www.techhub.training/u/Ayesha_Zahory)\ **Post date:** [June 28, 2024, 6:35pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/33 "2024-06-28T18:35:47Z")
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](https://www.techhub.training/uploads/short-url/7S8T7UT4JyHOnXJlyOboEvHnuy2.xlsx) (970.3 KB) ---
**Author:** ![MaxBoho](https://avatars.discourse-cdn.com/v4/letter/m/ea5d25/32.png) [@MaxBoho](https://www.techhub.training/u/MaxBoho)\ **Post date:** [June 28, 2024, 6:35pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/34 "2024-06-28T18:35:48Z")
Time: 50 minutes Level: Intermediate I got to learn more about excel functions and improved some of my basic excel skills. [Calculator\_Retirement.xlsx](https://www.techhub.training/uploads/short-url/wN2tUUu2gzx4phHnNpaiG4HnYlW.xlsx) (89.9 KB) ---
**Author:** ![Sarah\_Donnellan](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@Sarah\_Donnellan](https://www.techhub.training/u/Sarah_Donnellan)\ **Post date:** [June 28, 2024, 7:02pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/35 "2024-06-28T19:02:56Z")
Time to Complete: 45 minutes Rating: Intermediate This challenge helped me work on my Excel skills and learn new shortcuts. [Excel Challenge 112.xlsx](https://www.techhub.training/uploads/short-url/rwueb9uYk8VLhjOfy0fmswlBY2e.xlsx) (54.7 KB) ---
**Author:** ![Cole\_Hoffman](https://avatars.discourse-cdn.com/v4/letter/c/7feea3/32.png) [@Cole\_Hoffman](https://www.techhub.training/u/Cole_Hoffman)\ **Post date:** [June 28, 2024, 7:28pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/36 "2024-06-28T19:28:11Z")
30 Minutes Level: Beginner This problem helped me refresh some excel skills and functions. [112TVMProblem\_TechHub\_Hoffman,Cole.xlsx](https://www.techhub.training/uploads/short-url/aBGypMzg4LcIfZrE0yugdN3H7Nn.xlsx) (55.1 KB) ---
**Author:** ![Sandra\_Molitor](https://avatars.discourse-cdn.com/v4/letter/s/b5e925/32.png) [@Sandra\_Molitor](https://www.techhub.training/u/Sandra_Molitor)\ **Post date:** [June 28, 2024, 7:29pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/37 "2024-06-28T19:29:48Z")
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](https://www.techhub.training/uploads/short-url/1cjPhTGCysNZbSHeGeO6MPfvbP0.xlsx) (12.9 KB) ---
**Author:** ![Joshua\_Joseph](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@Joshua\_Joseph](https://www.techhub.training/u/Joshua_Joseph)\ **Post date:** [June 28, 2024, 7:37pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/38 "2024-06-28T19:37:49Z")
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](https://www.techhub.training/uploads/short-url/wdpxoHajHzHKHiFJ2LQGOcCGW1V.xlsx) (59.0 KB) ---
**Author:** ![Katie\_Ferguson](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@Katie\_Ferguson](https://www.techhub.training/u/Katie_Ferguson)\ **Post date:** [June 28, 2024, 7:49pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/39 "2024-06-28T19:49:07Z")
Time to complete: 20 minutes Level: Intermediate ![Techhub Challenge](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/b/b3b7eb6424a296efc2bc7c6dd7317d2a0e4435e8.jpeg) ---
**Author:** ![Mason\_Pagano](https://avatars.discourse-cdn.com/v4/letter/m/c57346/32.png) [@Mason\_Pagano](https://www.techhub.training/u/Mason_Pagano)\ **Post date:** [June 28, 2024, 8:05pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/40 "2024-06-28T20:05:33Z")
Time: 30 Mins Level: Easy [TechHubFile.xlsx](https://www.techhub.training/uploads/short-url/ljjgKC2TlcmEYS140knJqeo75ZJ.xlsx) (9.7 KB) [Previous page](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158.md?page=1) [Next page](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158.md?page=3)