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
Categories
Resources for Accountants

How to Start and Fund Your Own Business [Video]

Embarking on the journey of starting and funding your own business is akin to setting sail on uncharted waters. It's a thrilling yet daunting endeavor that demands a blend of creativity, strategy, and financial acumen. In today's dynamic business landscape, where innovation and disruption reign supreme, the allure of entrepreneurship beckons individuals eager to carve their own path and leave a mark on the world. However, navigating the complexities of business ownership requires careful planning, unwavering commitment, and access to adequate funding. This guide aims to illuminate the path ahead, offering a roadmap for aspiring entrepreneurs to transform their vision into a tangible business reality.

Categories
Resources for Accountants

What are the different types of Hedge Accounting models? [Video]

Bob will help you "close the GAAP" on what the different types of hedge accounting models are and when to use them. Check out his quick video explanation here! If you are interested in learning more, explore our eLearning courses on our GAAP Dynamics Learning Library: ASC 815: Hedge Accounting (Course Collection): https://www.gaapdynamics.com/product/asc-815-hedge-accounting/ Financial Instruments: Hedge Accounting Under IFRS 9: https://www.gaapdynamics.com/product/financial-instruments-hedge-accounting-under-ifrs-9/#collection-cards

Categories
Resources for Accountants

Application of ASC 805 [Video]

This is the introductory video for the third course of the three-part Business Combinations eLearning series. Now that you are familiar with the basic accounting rules and certain ASC 805 advanced issues, this course will apply that knowledge by walking through an example acquisition and requiring you to identify the proper accounting treatment. Take the course: https://www.gaapdynamics.com/product/business-combinations-application-of-asc-805/ Buy all three courses and save! https://www.gaapdynamics.com/product/asc-805-business-combinations/ Learn more about GAAP Dynamics: https://www.gaapdynamics.com/ Check out our other online courses on the GAAP Dynamics Learning Library: https://www.gaapdynamics.com/individual-learning/ Subscribe to GAAP Dynamics to see more videos like these!

Categories
Resources for Accountants

How to Calculate the Right-of-use Asset [Video]

When the lessee capitalizes a lease, it doesn’t just record a liability; it also records a right-of-use asset. At the commencement of the lease, the right-of-use asset is calculated as follows:Initial measurement of lease liability + lease prepayments + initial direct costs + costs to dismantle/remove the asset or restore the site - lease incentives received from the lessor = right-of-use asset The right-of-use asset is then recorded on the lessee's statement of financial position and depreciated over the lease term.— Edspira is the creation of Michael McLaughlin, who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education accessible to all people.— SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS* http://eepurl.com/dIaa5z— 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/ — CONNECT WITH EDSPIRA* Website: https://www.edspira.com* Blog: https://www.edspira.com/blog/ * Facebook page: https://www.facebook.com/Edspira* Facebook group: https://www.facebook.com/groups/561316587899818//* Reddit: https://www.reddit.com/r/edspira* LinkedIn: https://www.linkedin.com/company/edspira— CONNECT WITH MICHAEL* Website: http://www.MichaelMcLaughlin.com* LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin * Twitter: https://www.twitter.com/Prof_McLaughlin* Facebook: https://www.facebook.com/prof.michael.mclaughlin* Snapchat: https://www.snapchat.com/add/prof_mclaughlin*Twitch: https://twitch.tv/prof_mclaughlin * Instagram: https://www.instagram.com/prof_mclaughlin*TikTok: https://www.tiktok.com/@prof_mclaughlin