Categories
Resources for Accountants

How to Calculate IRR in Excel [Video]

In this video I’m going to show you how to calculate the internal rate of return for a project in Excel. So I’ve got 6 projects here. For each project, there’s a single cash outflow at the beginning of the project (year 0). This is followed by a series of cash inflows. Now to calculate the IRR of a project, just type =IRR and highlight the series of cash flows. Excel gives you the option to guess the IRR; if you don’t enter anything, it guesses 0.1 (or 10%) until it finds the rate that makes the project’s NPV equal to zero. Now you can see that the IRR for project 1 is 6.73%. This is the time-adjusted, annual rate of return for that project. Dragging the fill handle to the right shows you the IRR for each of the other projects. Now if the company’s hurdle rate was 20%, …

Watch/Read More
Categories
Resources for Accountants

Cheap Car Insurance for Young Drivers | Plus, ‘Trick’ to Lower Your Car Insurance [Video]

In this video we're diving into a topic that's on the minds of many young drivers out there – 'Cheap Car Insurance for Young Drivers.' We know how important it is to find affordable coverage while ensuring you're still well-protected on the road. So, whether you're a new driver or you know someone who is, stick around because we've got some valuable tips to share with you."

Categories
Resources for Accountants

Tax on a Free Car? [Video]

If you win a free car, do you have to pay tax on it?Yes.In 2016 a high school senior won a Jeep Renegade for getting all A’s and B’s, but the IRS said she had to pay income tax for receiving the car.In 2004 Oprah Winfrey gave all 276 members of her audience a free car, and everyone got hit with a tax bill.§ 74 of the tax code says prizes and awards are taxable income.Thus, if you win a free car, the IRS will treat the fair market value of the car as taxable income. — 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 accessible to all people.— 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* http://eepurl.com/dIaa5z— HIRE MICHAEL MCLAUGHLIN, PHD, CPA * https://michaelmclaughlin.com/hire-me — 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/

Categories
Resources for Accountants

10 Best Job Interview Tips for 2022 | How to Prepare for a Job Interview [Video]

In this video you’ll discover the 10 best tips for job interview success. Job interviews in many organizations are getting sophisticated these days. Psychological tests, role plays, and challenges to one's "quick intelligence" and street smarts, are often part of the package. While it's impossible to anticipate everything you may encounter, here are ten tips that will help you negotiate the interview process successfully.For more free business guides, templates and tools, visit us at: https://www.bizmove.com/