![Index Match Function in Excel – Step by Step [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_212_0_0jpg.jpg)
Index Match Function in Excel ————————————————-In this video on Index Match in Excel, we’ll go through how to combine Index and Match formulas in Excel and how these formulas can work together to serve as a powerful alternative to VLOOKUP. This will be demonstrated using a practical Index Match calculation example.How to Use Index Match Functions in Excel?——————————————–The INDEX function returns the row number result, while the MATCH function returns the position of the lookup value in the array. This combination of the INDEX MATCH Excel Function is particularly beneficial in addressing VLOOKUP’s key limitations: it cannot be used to search the table from left to right. The INDEX MATCH Function, on the other hand, can easily achieve this goal.Index Match Excel Formulas——————————————–=index(array, row_num, [column_num])=match(lookup_value, lookup_array, [match_type])Arguments in Index Function:——————————————–Array: It denotes the column or array from where the value is needed.Row Number: This specifies the row in the given array from which the result is required.Arguments in Match Function:——————————————–Lookup Value: It denotes the lookup value to be searched in the lookup array.Lookup Array: It denotes the array or range of cells from which the lookup value is to be searched.Match Type: This decides the kind of result we need. We can provide the values 1, 0, or -1 depending on the type of match. For an exact match, we can provide “0”.To know more about the Index Match Function, you can go to this link: – https://www.wallstreetmojo.com/index-match-function-in-excel/Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe – https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1
![CPA vs. CMA Certificate | What Are The Differences and How To Choose [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_209_0_0jpg.jpg)
If you are trying to decide whether to pursue a career as a CPA (Certified Public Accountant) or a CMA (Certified Management Accountant), this video will help you decide by considering the following factors:1) Your personality type..are you an introvert?2) Do you plan to move across counties in the future?3) Do you want to own your own practice?4) Is your end goal becoming a CFO?My Best-Selling Products:Get My “Night Before the Accounting Interview Guide” including All Levels Q&A:https://thefincontroller.com/p/the-night-before-your-accounting-interview-guide-for-all-levels📈 Get $25 off MY ONLINE COURSE ON FINANCIAL METRICS (code: Save25)https://thefincontroller.com/p/learn-financial-metrics-kpis/?product_id=2659754&coupon_code=SAVE25&preview=logged_outMy Recommended Products (I will only share what I love ❤ here)⚪️ 🧠 Roger CPA Review Course (get 50% off): https://www.uworld.com/productreferral.aspx?ukey=8lzsxx2bT8qzYRxekeTKyWQ3d3d⚪️ 📚 Learning//SkillShare (get 2 weeks free): https://www.skillshare.com/r/profile/Bill-Hanna/7521537My Recommended Finance & Accounting Books 📚+🧠=💥⚪️ Auditing: https://amzn.to/361wJhZ⚪️ Forensic Accounting: https://amzn.to/2G6t9bo⚪️ Introduction to Finance: https://amzn.to/2ExgUEA⚪️ Introduction to Managerial Accounting: https://amzn.to/33SEyE4———————————————————————Hang Out with me on social media:📱https://www.tiktok.com/@thefinancialcontroller🙋🏼♂️https://www.facebook.com/groups/780732429036886/?source_id=101273467885666📸 https://www.instagram.com/the_financial_controller/DISCLAIMER: 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
![How to make a GIF using Adobe Photoshop [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_206_0_0jpg.jpg)
GIFs are a great way to add eye-catching movement to a social media post, or to add personality to a blog post on your website. GIFs are also a unique and efficient way to demonstrate a process or set of instructions within your eLearning module. Learn how to make a custom GIF with us using Adobe Photoshop in this short instructional video!See our full blog post here: https://www.gaapdynamics.com/insights/blog/how-to-make-a-custom-gif-using-photoshopLearn more about GAAP Dynamics: https://www.gaapdynamics.com/ Check out our other online courses on the Revolution: https://revolution.gaapdynamics.com/catalog Subscribe to GAAP Dynamics to see more videos like these!
![How I Saved Hundreds on My Car Insurance | Easy Way to Locate the Best Car Insurance Rate [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_203_0_0jpg.jpg)
Here’s the free service we use to discover the cheapest car insurance rate that is available to us: (toll-free) at 1-855-981-7528. This is a free by phone service that specializes in locating the cheapest car insurance rates. They perform the tedious task of shopping around, and present you with the cheapest auto insurance provider for your location. We call this service every year before our car insurance expires. It allows us to discover whether there is a cheaper car insurance rate than ours, and has saved us lots of money over the years.
![AICPA Town Hall Series – June 24 Edition [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_200_0_0jpg.jpg)
AICPA Town Hall Series – June 24 Edition
![IFRS 16 Lessee Accounting Example 2 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_197_0_0jpg.jpg)
This video shows how the lessee should account for a lease under IFRS 16 when the expected residual value of the asset is lower than the guaranteed residual value. In this situation, the lessee is expecting to make a payment at the end of the lease to compensate the lessor for the different between the guaranteed residual value and the asset’s actual residual value. The lessee must therefore discount this expected payment to its present value and include it when calculating the lease liability. — 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
![How to Calculate the Right-of-use Asset [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_194_0_0jpg.jpg)
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
![IFRS 16 Lessee Accounting Example 1 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_191_0_0jpg.jpg)
This video shows how the lessee should account for a lease under IFRS 16 when the expected residual value of the asset is higher than the guaranteed residual value. — 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
![How to Calculate the Right-of-use Asset | IFRS 16 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_188_0_0jpg.jpg)
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 assetThe 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
![Changes to the CPA Exam 2024 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_185_0_0jpg.jpg)
The format of the CPA exam is changing significantly in 2024. The exam will have three core sections that everyone is required to pass:o Accountingo Auditingo TaxTechnology will be emphasized in all three of the core sections.In addition, CPA candidates will be required to pass one of the following disciplines:o Tax compliance and planningo Information systems and controlso Business analysis and reportingThus, to become a CPA, you’ll need to pass all 3 core sections and one discipline section. — 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
![The Effect of the Residual Value on the Lease Liability | Lessee | IFRS 16 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_182_0_0jpg.jpg)
The residual value only affects the calculation of the lease liability when: a) the lease contains a guaranteed residual value and b) the lessee’s expected residual value is lower than the guaranteed residual value This makes sense; if the lessee has guaranteed that the residual value will be $10,000 but believes the residual value will only be $6,000 then the lessee should anticipate a cash payment of $4,000 (to cover the difference). This shortfall is considered a final lease payment, so it is discounted to its present value and included in the lease liability.If the lessee expects the residual value to be higher than the guaranteed residual value, then the lessee doesn’t anticipate making a payment. In that case, the residual value has no effect on the lease liability. If the lessee has not made any guarantees at all concerning the residual value, then the lessee isn’t responsible for declines in the residual value and there is no effect on the lease liability.— 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
![How to Calculate the Lease Liability | Lessee | IFRS 16 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_179_0_0jpg.jpg)
The lease liability is calculated as the present value of the lease payments. Three things are required to calculate the present value of the lease payments:1. The amount of each lease payment2. The lease term3. The discount rateLease payments include: (a) fixed or variable payments(b) amounts payable under a residual value guarantee(c) the bargain purchase priceWhen it comes to the discount rate, the lessee should use the lessor’s implicit interest rate. If the lessee doesn’t know the lessor’s implicit interest rate, the lessee should use the lessee’s incremental borrowing rate as the discount rate.— 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