Categories
Resources for Accountants

How the Gift Tax Works | U.S. Tax [Video]

Here’s how the gift tax works:If you give someone a gift, any amount exceeding $15,000 is considered a taxable gift. However, you also get a lifetime exemption of $11.7 million.Thus, let’s say you give someone a gift of $215,000:• The first $15,000 is excluded • The next $200,000 reduces your lifetime exemption to from $11.7 to $11.5 millionThus, you don’t pay any tax because the amount over $15,000 reduced your lifetime exclusion. However:• When the lifetime exclusion goes down, this decreases the exemption your estate gets when you die. Thus, gifts over $15,000 could end up causing you to get hit with estate tax, depending on the value of your estate• If the lifetime exemption reaches zero, any gifts over $15,000 will incur gift taxNow, if you do make a gift exceeding $15,000 you need to file Form 709 (the gift tax return) on or before April 15th of the year following the gift.And if both you and your spouse make a gift, you each need to file a separate Form 709.You might also be subject to gift tax at the state level depending on where you live.— 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

Categories
Resources for Accountants

LOOKUP Function in Excel – Overview, Formula, Step by Step Tutorial [Video]

LOOKUP Function in Excel – In this video on the LOOKUP function in Excel, we’ll go over how to use the LOOKUP function in Excel and also understand how it differs from the VLOOKUP function. A practical LOOKUP calculation example will be used to illustrate this.LOOKUP Function in Excel——————————————–The LOOKUP function checks for a value in a range (which can be a single row or single column) and returns a corresponding LOOKUP from the same position of another range (single row or single column). The corresponding LOOKUP is a piece of information related to the value being searched.LOOKUP Excel Formula——————————————–=lookup(lookup_value, lookup_vector, [result_vector])Arguments in LOOKUP Function:——————————————–Lookup value: This is the value that you want to searchLookup vector: This is the row or column in which you wish to search the value. To achieve accurate results, it should be sorted alphabetically or in ascending order.Result vector: This is the row or column region from which you want the output to be returned. The returned output is in the same position as the “lookup value.”——————————————————————————————To know more about the LOOKUP Function, you can go to this link: https://www.wallstreetmojo.com/lookup-excel-function/ ——————————————————————————————Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo

Categories
Resources for Accountants

Controller Dashboard: One KPI Dashboard To Run A Business Part 1 [Video]

One of my previous CEOs used to hate reading financial statements 🤯 which forced me to always give him KPIs.After 68 hours of research and development, I am proud to share with you my free video (and product link below) for the “Controller’s KPI Dashboard”.If you know me, you know I hate doing repetitive tasks. The idea is to automate the process of updating the template with data from the balance sheet and income statement. Get My “Controller KPI Dashboard” Template & Mini-course, with the most important P&L and Balance Sheet KPIs:https://thefincontroller.com/p/controller-kpi-dashboard-one-kpi-dashboard-to-run-a-businessMy Other 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

Categories
Resources for Accountants

The Liquidity Gap | Asset Liability Management [Video]

Changes in interest rates can affect the bank’s profit and equity value when assets and liabilities are not properly matched, but this probably won’t cause the bank to become insolvent. Improperly matching the maturities of cash flows (the cash flow gap discussed earlier) could drive the bank to insolvency, but this risk can be managed with planning. A risk that is more difficult to plan for is a liquidity crisis. What if one or more of the bank’s funding sources were to suddenly become unavailable?Before the financial crisis, liquidity risk was treated as part of cash management. But during the financial crisis, banks learned that liquidity problems could be catastrophic. Banks had not experienced problems with liquidity for years, as they could easily raise capital from securitization and through short-term lending in the repo market. But when those sources of funding dried up, some banks were ruined. Now banks have dedicated staff that analyze hypothetical scenarios to assess the bank’s liquidity gap. These staff monitor early warning indicators that could predict a liquidity event, such as credit rating downgrades, increases in default rates, difficulty issuing debt, etc. They also develop a contingency funding plan with steps for obtaining replacement funding should a liquidity event occur.— 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

Categories
Resources for Accountants

AVERAGE Function in Excel – Overview, Formula, Step by Step Tutorial [Video]

AVERAGE Function in Excel – In this tutorial, we’ll go over the best way to find the average in an Excel data set using the ‘Average’ formula.How to use AVERAGE Function in Excel?——————————————–In Excel, the AVERAGE function calculates the arithmetic mean of a series of numeric data. This formula belongs to the Statistical Functions category.AVERAGE Excel Formula:——————————————–=AVERAGE(number 1, [number 2]…)Where,number 1 – This is the required number and the number for which the average is calculated.[number 2], [number 3], .. [number n] – These numbers are optional and can be entered as numbers, named ranges, ranges, or numeric values in cell references. —————————————————————————————–To know more about the AVERAGE Function, you can go to this link: https://www.wallstreetmojo.com/average-function-in-excel/——————————————————————————————Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo

Categories
Resources for Accountants

The Cash Flow Gap | Asset Liability Management [Video]

When the maturities of assets and liabilities aren’t matched, the bank could experience a cash flow shortfall. For example, let’s say a bank uses short-term borrowing (a one-year note) to finance long-term assets (30-year loans) because short-term borrowing generally costs less than long-term borrowing. However, this presents a problem: the one-year note will need to be repaid before the bank collects the principal from the 30-year loans. If the bank can roll over the short-term debt, it can continue to finance the 30-year loans. But what if the bank can’t roll over the debt when it comes due, and the bank can’t find an alternative source of funds? The bank wouldn’t have cash to repay the debt (since the loan principal is still outstanding) and would run out of cash. This mismatch between asset and liability cash flows is called the cash flow gap (it’s also known as the maturity gap).To avoid this outcome, banks try to match asset and liability positions so there are always sufficient funds to cover short-term liabilities that mature. — 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

Categories
Resources for Accountants

The Duration Gap | Asset Liability Management [Video]

With the earning gap, we saw that changes in interest rates could affect the bank’s profit. But changes in interest rates can also affect the value of the bank’s equity. This is because changes in interest rates:• Affect floating-rate and fixed-rate instruments in different ways, with the value of fixed-rate instruments usually being more sensitive to changes in interest rates• Affect long-term and short-term instruments in different ways, with the value of long-term instruments usually being more sensitive to changes in interest ratesA bank can measure the sensitivity of a financial instrument by calculating its duration. The bank can then try to minimize the duration gap, which is the difference between the duration of the bank’s financial assets and the duration of the bank’s financial liabilities. Reducing the duration gap will mitigate the effect of changing interest rates on the value of the bank. — 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

Categories
Resources for Accountants

The Earning Gap | Asset Liability Management [Video]

Mismatches between a bank’s source of funds (liabilities) and use of funds (assets) can affect the bank’s profit. This is best explained with an example.Imagine a bank with one asset and one liability:• The asset is a fixed-rate loan with an interest rate of 5%• The liability is a floating-rate note with an interest rate of 2%Thus, the bank has a net interest margin of 3%. But what if the interest rate on the floating-rate note increases to 2.2%? The bank’s net interest margin will shrink to 2.8%. This occurred because we had a mismatch: a fixed-rate asset and a floating-rate liability. Here’s an example of a different kind of mismatch.Imagine a bank with one asset and one liability:• The asset is a fixed-rate loan with an interest rate of 5%• The liability is a fixed-rate note with an interest rate of 2%The bank again has a net interest margin of 3%. But what if the fixed-rate loan has a term of 30 years, while the fixed-rate note has a term of 6 months? If interest rates rise, the bank’s net interest margin will decrease when it repays the note at the end of 6 months and obtains new financing at the higher rate. If the bank obtained new financing at a rate of 2.4%, then it’s net interest margin would be 2.6%. Again, the bank suffered from a mismatch problem. This time, the mismatch occurred because the bank funded a long-term asset with a short-term liability.It’s difficult to solve the mismatch problem. A local bank that focuses on conventional mortgages might have assets that are primarily fixed-rate mortgages and liabilities that are primarily floating-rate savings accounts. A bank could reduce this risk by entering into an interest rate swap. Alternatively, a bank might have fixed-rate assets that reset monthly and floating-rate liabilities that reset quarterly. If interest rates are declining, the interest rate earned on assets will reset faster and reduce the net interest margin. To estimate the effect of interest rate changes, banks compare the principals of assets and liabilities that are repriced during a period.Banks then try to reduce this earning gap, which is the difference between rate-sensitive and rate-sensitive liabilities.— 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

Categories
Resources for Accountants

What is Asset Liability Management in Banking? [Video]

A bank is a financial intermediary that collects funds from depositors and lends the funds to others at a higher rate than it pays to depositors (this is the net interest margin). Historically, you could calculate a bank’s profit as follows:interest earned from borrowers – interest paid to depositors = bank profitTo increase profit, banks focused on funding their activities at the lowest possible cost.But the banking industry has changed significantly.Loans used to account for nearly all of a bank’s revenue; today, banks generate additional income from investments in securities, speculation with derivatives, and other sources. While deposits used to be the primary source of funds, banks now obtain funds with short- and long-term borrowing, securitizations, and collateralized borrowings. These changes brought new types of risk. Unfortunately, many banks failed to manage these risks, and some banks became insolvent or required a bailout during the 2008 financial crisis. The banking industry has evolved, however, and banks now manage these risks with asset-liability management (ALM). ALM is the process of matching assets and liabilities to manage risk; specifically, to protect against adverse changes to the bank’s profit, firm value, and liquidity. Banks carry out ALM by optimizing the following gaps:• The earning gap• The duration gap• The cash flow gap• The liquidity gap— 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

Categories
Resources for Accountants

How Cryptocurrency is Taxed in the U.S. [Video]

The IRS now asks whether you sold, received, or exchanged any virtual currency on the first page of the 1040. And the IRS has sent letters to people who haven’t reported income from crypto transactions.Here are the tax rules: Cryptocurrency is property, so it’s taxed when you have a realizable event. This means:o You sold it for U.S. dollarso You exchanged it for another cryptocurrencyo You exchanged it for goods/servicesThus, if you buy crypto and the value goes up, but you don’t sell or exchange it, you don’t owe any tax. But if you do sell it or exchange it, you’ll have a capital gain or loss.o What you received, minus what you paid, is your gain or losso Thus, if you paid $30,000 and sell for $35,000 you’ve got a $5,000 capital gaino That gets reported on IRS Form 8949Now if you mine cryptocurrency, or receive it as payment for doing a job, that’s different.o The value of the cryptocurrency you receive in that case would be reported as self-employment income. It would be taxed when you receive ito If the value of the crypto you received later changes and you sell/exchange it, you would then have a capital gain or loss— 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