# 227|EXCEL – Finance Function (NPV, IRR, and PV) **URL:** \ **Category:** Challenges\ **Created:** [May 21, 2024, 8:47pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715 "2024-05-21T20:47:13Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Dallin\_Gardner](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/dallin_gardner/32/5553_2.png) [@Dallin\_Gardner](https://www.techhub.training/u/Dallin_Gardner)\ **Post date:** [May 21, 2024, 8:47pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/1 "2024-05-21T20:47:13Z")
_BYU Student Author_: @Dallin_Gardner _Reviewers_: @Jimmy_Han, @Benjamin_Lau _Estimated Time to Solve:_ 10 minutes We provide the solution to this challenge using: - Excel Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138). **Overview** You are a head financial analyst of [SmartHome.Co](http://SmartHome.Co) about to head into a strategy meeting later today. You have been asked to prepare some basic financial analysis to help decide what the next steps of growth in the company are. The company is trying to decide whether to expand within an existing region of the company or to expand by opening a new region. Use the ratio functions to determine which project will be more profitable and then use additional functions to determine how the company will finance the more profitable project. **Instructions** 1. Use the data given in order to find the projected Internal Rate of Return (IRR) and the Net Present Value (NPV). This will help us determine the projects profitablilty based on the cash flows for the next 6 years. 2. Once you have found the values for these two financial indicators, select the project with the highest IRR. If the IRR is the same, or if the is less than 0.1% difference, select the project with the highest NPV. 3. Input the initial outlay (the year 0 negative cash flow) of the project into the next sheet 4. Input the information given about the bonds into the appropriate cells 5. Use the PV function to find the present Value of the bonds 6. Take out the commission to find the net value, and then calculate how many bonds will need to be sold to cover the costs of the project and unexpected costs rounded up to the nearest whole number **Data Files** - [Challenge227\_Data](https://byu.box.com/shared/static/06dxln9f66txfzrtpiimpm3r6ieadr1e) > **Suggestions and Hints** > > Use the =RoundUp function to avoid hardcoding the number of bonds to sell **Solution** - [Challenge227\_Solution](https://byu.box.com/shared/static/zvcanphiob9basn7sbq5wyrtvwzu5pfo) - _Solution Video:_ [Challenge 227|EXCEL - Finance Functions (NPV, IRR, and PV)](https://youtu.be/NMbuOAaxyZ0) ---
**Author:** ![Henry\_Chen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/henry_chen/32/6979_2.png) [@Henry\_Chen](https://www.techhub.training/u/Henry_Chen)\ **Post date:** [March 4, 2025, 7:09pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/2 "2025-03-04T19:09:34Z")
[Challenge 227 Henry.xlsx](https://www.techhub.training/uploads/short-url/sKMkzv2HzP7qzUOO7av85l7ULUh.xlsx) (14.8 KB) ---
**Author:** ![Genevieve\_Nichols](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/genevieve_nichols/32/7442_2.png) [@Genevieve\_Nichols](https://www.techhub.training/u/Genevieve_Nichols)\ **Post date:** [March 5, 2025, 1:09am UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/3 "2025-03-05T01:09:45Z")
1. Existing region: IRR-5.47% NPV-$1,048,427.37 New Region: IRR-5.48% NPV-$2,000,000 2. New Region 3. ($2,000,000) 4. DONE 5. $922.44 6. $982.52, $2,000,000, 2,036 ---
**Author:** ![Skyla\_Rigg](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/skyla_rigg/32/7224_2.png) [@Skyla\_Rigg](https://www.techhub.training/u/Skyla_Rigg)\ **Post date:** [March 5, 2025, 1:52am UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/5 "2025-03-05T01:52:03Z")
[Challenge227.xlsx](https://www.techhub.training/uploads/short-url/eHNPOeLLf6pukC7SaQQNcjxGibU.xlsx) (14.7 KB) This was a fun challenge! Time: 20 mins Level: Intermediate ---
**Author:** ![Elizabeth\_Bisel](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/elizabeth_bisel/32/7449_2.png) [@Elizabeth\_Bisel](https://www.techhub.training/u/Elizabeth_Bisel)\ **Post date:** [March 5, 2025, 5:18pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/6 "2025-03-05T17:18:10Z")
Time to complete: 15 minutes Difficulty: medium [Challenge227\_Data.xlsx](https://www.techhub.training/uploads/short-url/4EzhAo2Xea0RLycBHD56XCDUdHv.xlsx) (14.8 KB) ---
**Author:** ![Kathryn\_Thompson\_Whi](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kathryn_thompson_whi/32/7373_2.png) [@Kathryn\_Thompson\_Whi](https://www.techhub.training/u/Kathryn_Thompson_Whi)\ **Post date:** [March 5, 2025, 6:20pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/7 "2025-03-05T18:20:55Z")
Time to complete: 25 mins Difficulty: Medium [Challenge227.xlsx](https://www.techhub.training/uploads/short-url/tbHxB4sX6AhKWNq55QVbDhZ5m0K.xlsx) (14.7 KB) ---
**Author:** ![Seth\_Davis](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/seth_davis/32/7494_2.png) [@Seth\_Davis](https://www.techhub.training/u/Seth_Davis)\ **Post date:** [March 5, 2025, 7:17pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/8 "2025-03-05T19:17:14Z")
Time to Complete: 20 mins Difficulty: Easy [Challenge227\_Data\_SETH.xlsx](https://www.techhub.training/uploads/short-url/pXpc7S5yXBdgKaShaz1a2KTqyM5.xlsx) (14.9 KB) ---
**Author:** ![Elizabeth\_Bowers](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/elizabeth_bowers/32/7479_2.png) [@Elizabeth\_Bowers](https://www.techhub.training/u/Elizabeth_Bowers)\ **Post date:** [March 5, 2025, 7:25pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/9 "2025-03-05T19:25:51Z")
Time to Complete: 20 Minutes Difficulty: Easy My answers: 1. Existing: IRR 5.47%, NPV $48,427.37; New: IRR 5.48%, NPV $38,072.62 2. I chose Existing 3. (1,000,000) 4. PV was $922.44 5. With commission gone, $982.52 6. Needed Bonds: 1018 ---
**Author:** ![Kameron\_K\_Sakamoto](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kameron_k_sakamoto/32/7391_2.png) [@Kameron\_K\_Sakamoto](https://www.techhub.training/u/Kameron_K_Sakamoto)\ **Post date:** [March 5, 2025, 7:28pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/10 "2025-03-05T19:28:20Z")
Time: 20 mins Level: Intermediate [Sakamoto, Kameron, Challenge 227.xlsx](https://www.techhub.training/uploads/short-url/7YFHU8oy2J2t2ArSeSHsYXTSvPM.xlsx) (14.8 KB) ---
**Author:** ![Mackay\_Roberts](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mackay_roberts/32/7453_2.png) [@Mackay\_Roberts](https://www.techhub.training/u/Mackay_Roberts)\ **Post date:** [March 5, 2025, 7:58pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/11 "2025-03-05T19:58:10Z")
Time to complete: 15 minutes Difficulty: Medium [Challenge227\_Data.xlsx](https://www.techhub.training/uploads/short-url/pUeHVSPaT5s7Csm0Z0tPEZD6p4T.xlsx) (14.8 KB) ---
**Author:** ![Lily\_Flint](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/lily_flint/32/7541_2.png) [@Lily\_Flint](https://www.techhub.training/u/Lily_Flint)\ **Post date:** [March 5, 2025, 8:26pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/12 "2025-03-05T20:26:30Z")
[Challenge227\_Data.xlsx](https://www.techhub.training/uploads/short-url/nXA7NQjuLFgYDt9qlzMOQl7BEvp.xlsx) (14.8 KB) Time to complete: 15 minutes Level: Beginner ---
**Author:** ![Matthew\_Herrod](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/matthew_herrod/32/7593_2.png) [@Matthew\_Herrod](https://www.techhub.training/u/Matthew_Herrod)\ **Post date:** [March 5, 2025, 8:31pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/13 "2025-03-05T20:31:57Z")
Time to Complete: 15 minutes Rating: Beginner [Challenge227\_Data.xlsx](https://www.techhub.training/uploads/short-url/4SyRqNRsGdUVtIWycmdMGN8NBZX.xlsx) (14.8 KB) ---
**Author:** ![Steven\_Ramirez1](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/steven_ramirez1/32/7512_2.png) [@Steven\_Ramirez1](https://www.techhub.training/u/Steven_Ramirez1)\ **Post date:** [March 5, 2025, 8:49pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/14 "2025-03-05T20:49:19Z")
Time:18 Mins Level: Intermediate [Challenge227\_Data\_Steven\_Ramirez.xlsx](https://www.techhub.training/uploads/short-url/tenl62Y0ZPgIXdzfaQ16l3WJFSE.xlsx) (15.8 KB) ---
**Author:** ![braydenlwhite](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/braydenlwhite/32/6963_2.png) [@braydenlwhite](https://www.techhub.training/u/braydenlwhite)\ **Post date:** [March 5, 2025, 10:07pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/15 "2025-03-05T22:07:08Z")
Time to complete: 15 minutes Rating: Beginner [Challenge227\_Data.xlsx](https://www.techhub.training/uploads/short-url/2CbON0kqtNc3vcKeeFieBC6O6zS.xlsx) (14.9 KB) ---
**Author:** ![Eison\_Deng](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/eison_deng/32/6921_2.png) [@Eison\_Deng](https://www.techhub.training/u/Eison_Deng)\ **Post date:** [March 5, 2025, 11:05pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/16 "2025-03-05T23:05:11Z")
Time to complete: 15 minutes Difficulty: medium [Challenge227\_Data D.xlsx](https://www.techhub.training/uploads/short-url/rSurXZN5MgmNDqAohzZjbXOthDH.xlsx) (14.8 KB) ---
**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 5, 2025, 11:34pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/17 "2025-03-05T23:34:02Z")
Time: 15 min Difficulty: Medium [Challenge227\_DataRK.xlsx](https://www.techhub.training/uploads/short-url/76uGsL6eGrpzq42MU2xUTsZdh9E.xlsx) (14.8 KB) ---
**Author:** ![Charlie\_Canady](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/charlie_canady/32/7412_2.png) [@Charlie\_Canady](https://www.techhub.training/u/Charlie_Canady)\ **Post date:** [March 5, 2025, 11:36pm UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/18 "2025-03-05T23:36:44Z")
Time: 15 Min Dif: Easy [Challenge227\_Data.xlsx](https://www.techhub.training/uploads/short-url/1xV6wWnUlZZtWCvLZMJSVwOqyhw.xlsx) (14.0 KB) ---
**Author:** ![John\_Colton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/john_colton/32/7033_2.png) [@John\_Colton](https://www.techhub.training/u/John_Colton)\ **Post date:** [March 6, 2025, 12:06am UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/19 "2025-03-06T00:06:00Z")
Difficulty: Intermediate Time: 20 mins [Challenge227\_Data\_Johnny.xlsx](https://www.techhub.training/uploads/short-url/eX3OzHvM8u46VoWgouQti9nsm8i.xlsx) (14.8 KB) ---
**Author:** ![Morgan\_Parker](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/morgan_parker/32/7511_2.png) [@Morgan\_Parker](https://www.techhub.training/u/Morgan_Parker)\ **Post date:** [March 6, 2025, 12:18am UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/20 "2025-03-06T00:18:47Z")
Time to complete: 20 min Level: Intermediate [Challenge227\_Data\_MorganParker.xlsx](https://www.techhub.training/uploads/short-url/6nxavaE3uBqURxxZ5g9d1W0cD25.xlsx) (21.4 KB) ---
**Author:** ![Jessica\_Bertolio](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jessica_bertolio/32/7535_2.png) [@Jessica\_Bertolio](https://www.techhub.training/u/Jessica_Bertolio)\ **Post date:** [March 6, 2025, 12:30am UTC](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715/21 "2025-03-06T00:30:16Z")
Time to Complete: 25 Rating: Easy [Challenge227\_DataDONE.xlsx](https://www.techhub.training/uploads/short-url/f3zEgtKVGoqlahGQHqIkfhaaX4C.xlsx) (14.8 KB) [Next page](https://www.techhub.training/t/227-excel-finance-function-npv-irr-and-pv/2715.md?page=2)