Using Solver to Optimize NPV When Capital is Constrained

Опубликовано: 28 Ноябрь 2022
на канале: Edspira
6,084
91

In this video I’m going to show you how to use Solver to determine which projects to accept when capital is constrained. So let’s say your company has 20 different projects it could do, and each of these projects has an NPV greater than zero.

Now in theory, a company should accept all positive-NPV projects. But here’s the problem: accepting all 20 projects would require an upfront investment of $3.775 million, and the company only has $2.5 million in cash.

Thus, we need to choose which of these 20 projects to accept. In short, we need to find the combination of projects that results in the highest total NPV, and Solver can help us do this.

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
*  / 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...
Spotify: https://open.spotify.com/show/4WaNTqV...
Website: https://www.edspira.com/podcast-2/

GET TAX TIPS ON TIKTOK
  / prof_mclaughlin  

ACCESS INDEX OF VIDEOS
https://www.edspira.com/index

CONNECT WITH EDSPIRA
Facebook:   / edspira  
Instagram:   / edspiradotcom  
LinkedIn:   / edspira  

CONNECT WITH MICHAEL
Twitter:   / prof_mclaughlin  
LinkedIn:   / prof-michael-mclaughlin  

ABOUT EDSPIRA AND ITS CREATOR
https://www.edspira.com/about/
https://michaelmclaughlin.com


Смотрите видео Using Solver to Optimize NPV When Capital is Constrained онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Edspira 28 Ноябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 6,084 раз и оно понравилось 91 людям.