Using Solver to Optimize NPV When Capital is Constrained [Video]
►
Categories
Resources for Accountants

Using Solver to Optimize NPV When Capital is Constrained [Video]

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 *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

FTX Infinite Money Diagram | Accounting and Collapse Explained [Video]
►
Categories
Resources for Accountants

FTX Infinite Money Diagram | Accounting and Collapse Explained [Video]

In this video I cover the Accounting & Audit issues with FTX’s Collapse In a nutshell, FTX used its sister company Alameda in these illegal ways:FTX lent Alameda its made-up crypto “FTT”, which Alameda used to borrow money against (free money with a worthless collateral)!Alameda was a major customer of FTX’s FTT token, helping FTX prop up it’s fair market value!!Get 30% discount on the Controller Academy:https://thefincontroller.com/p/controller-academy?coupon_code=30OFFCOURSE&product_id=4244216(link includes discount, but the promo code is ‘30offcourse’)My Fraud Playlist:https://www.youtube.com/watch?v=SMT5v5zT5KQ&list=PLKzobJwkGwKHVxJPekcn5kskPvgcK258zJoin me on Patreon and ask me your questions:https://www.patreon.com/TheFinController——————————My other best selling courses:🔥Take 30% off when you enroll in my online course “Night Before the Accounting Interview Guide” including All Levels Q&A🔥:https://thefincontroller.com/p/the-night-before-your-accounting-interview-course-for-all-levels?coupon_code=30OFFCOURSE📈Get My “Controller KPI Dashboard” (Excel + Course) with the most important P&L and Balance Sheet KPIs:​https://thefincontroller.com/p/controller-kpi-dashboard-one-kpi-dashboard-to-run-a-business​———————————————————————Hang Out with me on social media:📸 https://www.instagram.com/the_financial_controller/📱https://www.tiktok.com/@thefinancialcontroller🙋🏼‍♂️https://www.facebook.com/groups/780732429036886/?source_id=101273467885666DISCLAIMER: Links included in this description might be affiliate links. If you happen to purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!All views expressed on my channel are mine alone. Not intended as financial or professional advice

  • Tags
Uptick rule: Easy explanation [Video]
►
Categories
Resources for Accountants

Uptick rule: Easy explanation [Video]

In this video, you will learn about the uptick rule.#uptickrule #stockmarket #wallstreetmojo #shortselling #circuitbreakerChapters:00:00 – Introduction00:42 – What is the uptick rule?01:36 – Features of rule 20102:13 – How does the uptick rule work?03:40 – ConclusionWhat is the uptick rule?The uptick rule is also referred to as the plus tick rule. It restricts stocks from being shorted at a lower price than their last traded price.For a trader to short the stock as per the uptick rule, they can do so only after the stock has moved at least one tick up, and then they can short it.(Explained in detail in the video)Features of rule 201Circuit breakerDuration of restrictionSecurities coveredImplementationHow does the uptick rule work?The SEC got rule 201 in place to stop the market from crashing if the price declines too much.In short, its main aim is to maintain market stability and protect the confidence of investors in case the market gets attacked by sellers.We have taken an example in the video to understand better how the rule would come into play.So check out the example part in the video.This was all about the uptick rule. Subscribe to the channel, and don’t forget to give this video a like.==========================================================================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
Take or pay Contract Clause: Part 2 [Video]
►
Categories
Resources for Accountants

Take or pay Contract Clause: Part 2 [Video]

In this video, you will learn some details about the take or pay contractual clause.Chapters:00:00 – Introduction00:32 – Benefits01:56 – Risks02:33 – Negotiation of take or pay clause03:38 – ConclusionBenefitsIf the buyer rejects the good, the seller gets paid, and they are free to sell the goods to other buyers. So, it’s a win for them.The take or pay clause also makes it easier for sellers to get financing from banks to fulfill the order as they have payment guarantees.On the other hand, the buyer also gets benefitted from the take or pay clause as they get the goods for long-term at a fixed rate.(Explained in detail in the video)RisksThe contracts that involve such clauses are often long-term contracts. So in case, there’s a drastic change in the future, like Brexit, a pandemic, or anything else, the contracts may not be beneficial to the parties.In such scenarios, the parties may choose to terminate the contract, or they may renegotiate the terms.The risk here is that this has to be done by both parties and not just by one.Negotiation of take or pay clauseHere are some conditions under which renegotiations can happen:Force Majeure Clause (Act of God)Price Clause (Escalation Clause)Review Clause (Renegotiations)This was all about the topic of the take or pay clause. Subscribe to the channel so that you don’t miss out on our content, and don’t forget to give this video a like.==========================================================================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
How to Calculate Net Present Value in Excel [Video]
►
Categories
Resources for Accountants

How to Calculate Net Present Value in Excel [Video]

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

  • Tags
Take or pay Contract Clause: Introduction [Video]
►
Categories
Resources for Accountants

Take or pay Contract Clause: Introduction [Video]

In this video, you will get introduced to a contractual clause known as taking or pay.#takeorpay #contractualclause #wallstreetmojo #contracts #clausesChapters:00:00 – Introduction00:42 – What is take or pay?01:58 – Working of the take or pay clause02:30 – Example03:53 – ConclusionWhat is take or pay?The take or pay clause basically stipulates a buyer takes the goods from the seller in exchange for the pre-determined amount. They must pay a fine if they refuse to take the goods.So what this contractual clause does is that it protects sellers in case the buyer refuses to honor the terms of the contract.It wouldn’t be fair if the seller spends all the time, money, and effort to get the goods ready, and then the buyer refuses to take delivery, and the seller will have to bear the costs.(Explained in detail in the video)Working of the take or pay clauseThe take or pay clause basically derives its name from the terms of the contract:Either take the delivery, orPay a fine if you don’t want the deliverySuch clauses are mostly used in contracts in the energy, oil, mineral, natural gas, and coal industries that require significant seller investments.ExampleWe have taken a hypothetical example in the video to give you a better understanding of the topic.So make sure you watch the example part in the video.This was all about take or pay in this introductory video. Look out for the second part. So don’t forget to subscribe to the channel.==========================================================================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
Recency bias: Easy explanation [Video]
►
Categories
Resources for Accountants

Recency bias: Easy explanation [Video]

In this video, you will learn about a psychological bias known as recency bias and its application in finance.Chapters:00:00- Introduction00:35 – What is recency bias?01:44 – Example02:40 – How to overcome recency bias?04:50 – ConclusionWhat is recency bias?Recency bias is psychological or cognitive because people tend to make decisions based on recent events.(Explained in detail in the video)It leads to people frequently making emotional decisions based on recent or short-term events, and they neglect the bigger picture.The bias stems from how humans would rely on short-term memory to make sense of real-time events and how easy it is for people to believe that recent events influence future outcomes.(Explained in detail in the video)ExampleThe 2000 dotcom bubble was caused by people following the herd mentality and investing in internet companies.Everyone thought that since the stocks were going up, they would continue to increase. But, unfortunately, everyone fell for the recency bias, and we know what happened in the end.(Explained in detail in the video)How to overcome recency bias?Understand the marketsHave clear financial goalsBuild a strong portfolioHire a financial advisorHave a positive attitude(Explained in detail in the video)==========================================================================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
Technical Q&A (TIS) Section 250: Ethics [Video]
►
Categories
Resources for Accountants

Technical Q&A (TIS) Section 250: Ethics [Video]

Close Captioning has been auto-generated.The AICPA has issued 3 new questions and answers (https://us.aicpa.org/content/dam/aicpa/interestareas/professionalethics/resources/tools/downloadabledocuments/ethics-qa-section-250-02-04.pdf) around the implementation of the new Information System Services interpretation which will be effective in January 2023. The interpretation has been delayed twice—first due to COVID and then due to concerns around implementation. AICPA staff members recently met with concerned individuals to better understand the concerns and the Q&As address some of the larger concerns noted.Do you believe these Q&As will help reduce concerns over implementation?Watch all A&A Today videos at https://www.youtube.com/playlist?list=PLzz2wvHsZ2DNJ64dEWyHTq5BcvI1RALA-____________________________________________________________Subscribe for More CPA Video Updates https://www.youtube.com/user/WashingtonCPAs CONNECT WITH US: WSCPA https://www.wscpa.org FACEBOOK https://www.facebook.com/WashingtonCPAs LINKEDIN https://www.linkedin.com/company/353584 TWITTER https://twitter.com/WashingtonCPAs INSTAGRAM https://www.instagram.com/washingtoncpas/

  • Tags
Consolidated Accounting under IFRS 10 [Video]
►
Categories
Resources for Accountants

Consolidated Accounting under IFRS 10 [Video]

Consolidated financial statements are financial statements that present the assets, liabilities, equity, income, expenses, and cash flows of a parent and its subsidiaries as those of a single economic entity. In this CPE eligible, eLearning course, you will learn about the process of consolidation including specific procedures to be performed to properly present parents and subsidiaries as one combined group in accordance with IFRS 10.Take our self-study eLearning course here: Coming soonLearn more about GAAP Dynamics: https://www.gaapdynamics.com/Check out our other online courses on the Revolution: https://revolution.gaapdynamics.com/learn/catalogSubscribe to GAAP Dynamics to see more videos like this!

  • Tags