# 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:** 13\ **Page:** 4
**Author:** ![Jake\_Lewis](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jake_lewis/32/7474_2.png) [@Jake\_Lewis](https://www.techhub.training/u/Jake_Lewis)\ **Post date:** [March 11, 2025, 4:25pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/61 "2025-03-11T16:25:29Z")
[Excel112.xlsx](https://www.techhub.training/uploads/short-url/5PVFZxP2MJsN18otWmiUb6gPkT9.xlsx) (70.7 KB) ---
**Author:** ![Andrew\_Wells](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/andrew_wells/32/7399_2.png) [@Andrew\_Wells](https://www.techhub.training/u/Andrew_Wells)\ **Post date:** [March 11, 2025, 11:55pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/62 "2025-03-11T23:55:55Z")
Time: 1 hour Difficulty: Medium The difficult part was for sure the table. ![Screen Shot 2025-03-11 at 5.54.33 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/e/e963aa78b50af26d3179f820f8ac1c9bfc298c1e.jpeg) ---
**Author:** ![Eliza\_Simister](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/eliza_simister/32/7284_2.png) [@Eliza\_Simister](https://www.techhub.training/u/Eliza_Simister)\ **Post date:** [March 12, 2025, 2:48am UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/63 "2025-03-12T02:48:42Z")
Time to Complete: 40 mins Difficulty: Intermediate It was fun to try but took me awhile to figure out. I had to refresh myself on multiple formulas plus how to end them at a specific point. [challenge112.xlsx](https://www.techhub.training/uploads/short-url/5OJlCDmui4mkluvKJVPYB7jbUVZ.xlsx) (159.3 KB) ---
**Author:** ![Grace\_Jeppson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/grace_jeppson/32/7046_2.png) [@Grace\_Jeppson](https://www.techhub.training/u/Grace_Jeppson)\ **Post date:** [March 12, 2025, 4:30am UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/64 "2025-03-12T04:30:56Z")
Time to Complete: 40 minutes Level: Intermediate Solution: [Challenge 112.xlsx](https://www.techhub.training/uploads/short-url/hFYrBE6x38lZSycTr6WCM52cmfi.xlsx) (414.0 KB) ---
**Author:** ![Adam\_Schofield](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/adam_schofield/32/7629_2.png) [@Adam\_Schofield](https://www.techhub.training/u/Adam_Schofield)\ **Post date:** [March 12, 2025, 3:37pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/65 "2025-03-12T15:37:32Z")
![Screenshot 2025-03-12 at 9.36.47 AM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/7/76e85a477cb0772f6b2134d48cf4e0d941c07f7d.png) Good challenge and reminder of VBA and Macros. I added some other inputs to make it even more useful for me personally ---
**Author:** ![Seager\_Bogden](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/seager_bogden/32/7517_2.png) [@Seager\_Bogden](https://www.techhub.training/u/Seager_Bogden)\ **Post date:** [March 12, 2025, 5:26pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/66 "2025-03-12T17:26:33Z")
[excel\_solution.xlsx](https://www.techhub.training/uploads/short-url/ohz3mGiPMzmnAINWdaT4LjwEMRl.xlsx) (36.7 KB) ---
**Author:** ![Easton\_Edwards](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/easton_edwards/32/7508_2.png) [@Easton\_Edwards](https://www.techhub.training/u/Easton_Edwards)\ **Post date:** [March 12, 2025, 11:10pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/67 "2025-03-12T23:10:46Z")
Time to Complete: 45 minutes Level: Intermediate Solution: [TVM with PMT.xlsx](https://www.techhub.training/uploads/short-url/ApKZkp8wqFo3zoSwprrRtQc6cKT.xlsx) (53.0 KB) ---
**Author:** ![Caden\_Anderson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/caden_anderson/32/7526_2.png) [@Caden\_Anderson](https://www.techhub.training/u/Caden_Anderson)\ **Post date:** [March 12, 2025, 11:13pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/68 "2025-03-12T23:13:04Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/368d55f620aad18e22a9de49f390b6265c0ff300.png) difficulty easy time to complete 10 minutes ---
**Author:** ![James\_Cardon](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/james_cardon/32/7550_2.png) [@James\_Cardon](https://www.techhub.training/u/James_Cardon)\ **Post date:** [March 13, 2025, 2:47am UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/69 "2025-03-13T02:47:09Z")
Time to complete: 40 minutes Rating: intermediate [TechHub Challenge 112.xlsx](https://www.techhub.training/uploads/short-url/bKyM9MY1zvO33oQGuFGciWB1F1v.xlsx) (113.8 KB) ---
**Author:** ![Jacob\_Critchfield](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jacob_critchfield/32/7561_2.png) [@Jacob\_Critchfield](https://www.techhub.training/u/Jacob_Critchfield)\ **Post date:** [March 13, 2025, 4:31am UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/70 "2025-03-13T04:31:23Z")
Time to Complete: 45 min Difficulty: Intermediate [Excel 112.xlsx](https://www.techhub.training/uploads/short-url/8OfaAAacu3IXnn11i2IWCUNTuFY.xlsx) (72.5 KB) ---
**Author:** ![Luke\_Austin](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/luke_austin/32/7287_2.png) [@Luke\_Austin](https://www.techhub.training/u/Luke_Austin)\ **Post date:** [March 13, 2025, 8:01am UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/71 "2025-03-13T08:01:31Z")
Time to complete: 15 minutes Difficulty: Easy Solution: See attached file [~$Challenge 112- TVM.xlsx](https://www.techhub.training/uploads/short-url/vg5hWOg9HlPCQrheAWNVociLTA.xlsx) (165 Bytes) ---
**Author:** ![Ryan\_Knapp](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/ryan_knapp/32/7571_2.png) [@Ryan\_Knapp](https://www.techhub.training/u/Ryan_Knapp)\ **Post date:** [March 13, 2025, 3:17pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/72 "2025-03-13T15:17:42Z")
Time to Complete: 30 min Rating: Intermediate [excelpmt.xlsx](https://www.techhub.training/uploads/short-url/c76DoYGg7MD01TbuyIM4yctwmOu.xlsx) (33.4 KB) ---
**Author:** ![David\_Fox](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/david_fox/32/7089_2.png) [@David\_Fox](https://www.techhub.training/u/David_Fox)\ **Post date:** [March 13, 2025, 5:41pm UTC](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158/73 "2025-03-13T17:41:03Z")
Time to complete 20 min Difficulty: Beginner [Previous page](https://www.techhub.training/t/112-excel-time-value-of-money-with-pmt/2158.md?page=3)