Categories
Resources for Accountants

How to Calculate Net Present Value in Excel [Video]

How to Calculate Net Present Value in Excel

In this video I’m going to show you how to calculate the NPV (or net present value) of a project in Excel. So I’ve got 20 different projects here with a series of cash flows. Cash outflows are in parentheses, while the cash inflows aren’t. There’s an initial cash outflow in period 0 and then a series of cash flows occurring at the end of each year for 5 years.

To calculate the NPV of a project, we’re going to use Excel’s NPV function. So type =NPV and then select the discount rate. I’m going to anchor the discount rate so I’ll be able to drag down the formula and calculate the NPV of each of the 20 projects. You can also type in the discount rate directly; in this case, you’d type in 0.09.

Next, highlight the future cash flows. Now you might be tempted to highlight all the project’s cash flows, but don’t do it. You only highlight the cash flows that occur after period 0.
So why isn’t the cash outflow that occurs today included in the values? It’s because the NPV function assumes cash flows occur at the end of each period. If the initial cash flow occurs today, then it doesn’t occur at the end of the period and thus shouldn’t be part of the NPV function.

But don’t worry, we will account for the cash flow in period 0 separately. After you close the parentheses, add the cash flow from period 0 and hit “Enter.” Thus, the cash outflow that occurs today is still part of the project’s NPV, it’s just not part of the values we enter for NPV function.

Now you can see the NPV for Project 1, which is $28,345. To see the NPV for the other 19 projects, just click the fill handle and drag and it down.

Now the NPV function assumes the cash flows occurred at the end of each period and that the cash flows were periodic. But what if the cash flows weren’t equally spaced out?

For example, what if we had a project with nonperiodic cash flows like this? We have one cash flow occurring on May 6, one occurring February 19, and so forth. We shouldn’t use the NPV function here because the cash flows don’t occur at regular intervals. Instead, we should use the XNPV function. Just type =XNPV, enter the discount rate, select the range of values, and select the dates, and you can see that the NPV of this project is $713. Note that I included the first cash flow in the XNPV function; this is different from the NPV function where we had to deal with the upfront cash flow separately.
—
Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world.
—
SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS:
• A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING
• A 44-PAGE GUIDE TO U.S. TAXATION
• A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS
• MANY MORE FREE PDF GUIDES AND SPREADSHEETS
* http://eepurl.com/dIaa5z
—
SUPPORT EDSPIRA ON PATREON
*https://www.patreon.com/prof_mclaughlin
—
GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT
* https://edspira.thinkific.com
—
LISTEN TO THE SCHEME PODCAST
* Apple Podcasts: https://podcasts.apple.com/us/podcast/scheme/id1522352725
* Spotify: https://open.spotify.com/show/4WaNTqVFxISHlgcSWNT1kc
* Website: https://www.edspira.com/podcast-2/
—
GET TAX TIPS ON TIKTOK
* https://www.tiktok.com/@prof_mclaughlin
—
ACCESS INDEX OF VIDEOS
* https://www.edspira.com/index
—
CONNECT WITH EDSPIRA
* Facebook: https://www.facebook.com/Edspira
* Instagram: https://www.instagram.com/edspiradotcom
* LinkedIn: https://www.linkedin.com/company/edspira
—
CONNECT WITH MICHAEL
* Twitter: https://www.twitter.com/Prof_McLaughlin
* LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin
—
ABOUT EDSPIRA AND ITS CREATOR
* https://www.edspira.com/about/
* https://michaelmclaughlin.com

Watch/Read More
  • Tags

Most Popular Posts Today

All about Stock halt- Easy Explaination- Part 1 [Video]
►
Categories
Resources for Accountants

All about Stock halt- Easy Explaination- Part 1 [Video]

In this video, you will learn about stock halt, its rules, and how it is triggered.#stockhalt #stockmarket #wallstreetmojo #stockexchange #regulatorChapters:00:00 – Introduction00:35 – What is the stock halt?01:29 – Rules02:17 – Triggers of stock halt02:48 – ConclusionWhat is the stock halt?A stock halt is a scenario where the exchange halts trading in a particular stock for some time.It may be done when a regulatory action is imposed, important news is being anticipated, or a particular stock is just being bought or sold excessively.(Explained in detail in the video)RulesWhen a stock is halted for trading, it is coded with an identification number like T1, T2, T5, H10, etc.When the situation arises for halting trading in a particular stock, the exchange announces a halt to all brokers.Triggers of stock haltIf the stock price fluctuates up and down due to high volatility, then the exchange will either halt the trading, or the circuit breakers will be activated.Trading halts have been put into place so that a select group of individuals with significant capital does not manipulate prices to their whims and fancies.This will be all for this video. Subscribe to the channel, like the video, and share it with others.==========================================================================Subscribe to Our Channel –Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/Facebook https://www.facebook.com/wallstreetmojoInstagram https://www.instagram.com/wallstreetmojoofficial/Twitter https://twitter.com/wallstreetmojo

  • Tags

Most Popular This Week

5 Best Sports Betting Apps ★ 2022 | Online Sports Betting Tips [Video]
►
Categories
Resources for Accountants

5 Best Sports Betting Apps ★ 2022 | Online Sports Betting Tips [Video]

Discover the best 5 sports betting sites and apps. Here’re our picks for the 5 best sports betting sites, apps and sportbooks: 1. Bovada (bonus: $750): https://record.revenuenetwork.com/_4FiJyM5mQu397H-d5Ks7MGNd7ZgqdRLk/1/ 2. BetUS (Bonus: up to $2500): https://record.revmasters.com/_GDJId2cL3emhvo5nC3tZQ2Nd7ZgqdRLk/1/ 3. XBet (Bonus: up to $500): https://record.webpartners.co/_pI3eS84syUppj9fKdCJ9umNd7ZgqdRLk/1/ 4. BUSR (Bonus: up to $1000): https://record.webpartners.co/_pI3eS84syUrYGgllr3Vm5GNd7ZgqdRLk/1/ 5. MyBookie (Bonus: double first deposit): https://record.webpartners.co/_pI3eS84syUo-tw2NZ2I77WNd7ZgqdRLk/1/One of the most critical factors in sports betting success is finding the right sportsbook to bet at. Problem is, there are so many of them. It’s easy to lose time scanning the net for sports betting sites, time which could be better spent winning a few bucks on tonight’s game. Now, to help you quickly find the betting site best suited to your needs, we have tried and evaluated dozens of sites to come up with a list of 5 top sports betting sites. The above are our picks for the 5 best sports betting sites, apps, and sportsbooks. Note that we may earn a small commission from some of the links at no additional cost to you to help support this channel.

  • Tags
Cheap Car Insurance for Young Drivers | Plus, ‘Trick’ to Lower Your Car Insurance [Video]
►
Categories
Resources for Accountants

Cheap Car Insurance for Young Drivers | Plus, ‘Trick’ to Lower Your Car Insurance [Video]

In this video we're diving into a topic that's on the minds of many young drivers out there – 'Cheap Car Insurance for Young Drivers.' We know how important it is to find affordable coverage while ensuring you're still well-protected on the road. So, whether you're a new driver or you know someone who is, stick around because we've got some valuable tips to share with you."

  • Tags