![Line Chart in Excel – How to Create? (Step by Step) [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_250_0_0jpg.jpg)
Line Chart in Excel———————————————————————————————–In this video, we’ll go over how to create a line chart in Excel and understand how it can be used to display trend graphs from time to time. This will be demonstrated using a practical line chart example.What is a Line Graph in Excel?————————————————Excel provides a plethora of chart types for displaying data in a graphical style. The most common and often used chart is the line chart. A line chart or graph is used to show changes over time. Therefore, we can represent the most typical data (daily, weekly, monthly, yearly) by creating a line chart in excel.Line charts can be created in a range of categories in Excel, including:• 2D Line Charts• 2D Stacked Line Charts• 3D Line ChartsHow to create a Line Chart in Excel?———————————————————–The following are steps to create a Line Chart in Excel:Step #1 – Choose the data in the excel sheet for which you want to make a Line ChartStep #2 – Go to Insert MenuStep #3 – Select Charts TabStep #3 – Select Line Charts SymbolStep #4 – Select the customized line chart as per your requirement—————————————————————————————-To know more about Line Chart in excel, you can go to this link here:-https://www.wallstreetmojo.com/line-graphs-charts-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
![Why Cash Accounting is MISLEADING!! Accrual vs. Cash Accounting Explained [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_245_0_0jpg.jpg)
Cash Accounting is an over-simplified method of Accounting and often used by small businesses. The proper GAAP-accepted method is the Accrual Accounting. In this video we dive into an example business, examine its transactions, record the journal entries, and then see the IMPACT Cash Accounting has on the presentation of the Income Statement as proof it’s a misleading method of Accounting.Link to purchase a MORE EXPANDED version of the file shown in the video (highly recommend it for students and professionals):https://thefincontroller.com/p/accrual-vs-cash-accounting-guideMy 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
![Banking Industry Fundamentals: Loans [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_242_0_0jpg.jpg)
This is the introductory video to our self-study eLearning course “Banking Industry Fundamentals: Loans.” Check it out here: https://revolution.gaapdynamics.com/courses/banking-industry-fundamentals-loansWhat does a bank do with all the money it receives from deposit holders? Quite often, it makes loans! There are lots of different types of loans, such as commercial, residential mortgage, auto, agricultural, and construction just to name a few. Some loans are held by a bank until maturity and some are sold after origination. Some are purchased outright, rather than being underwritten by the bank itself. All of these situations have unique accounting considerations under ASC 310 which you will learn about in this course!Learn 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!
![Professional Liability Insurance Explained | Management & Business Concepts [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_239_0_0jpg.jpg)
Discover what is Professional Liability Insurance.Get Business Related Freebies: Free books from Amazon, any topic. Business, Fiction and Nonfiction:https://www.bizmove.com/free-books-online/ Video guides to improve your management skills:https://www.bizmove.com/business-management-course/ 300 free business and management guides:https://www.bizmove.com/small-business-encyclopedia/ Free business templates and tools:https://www.bizmove.com/tools/ Free management skills books:https://www.bizmove.com/books/management-skills-books.htm Free downloadable business plan template:https://www.bizmove.com/business-gifts.htm Free starting a business books:https://www.bizmove.com/books/starting-a-business-books.htm A comprehensive resource of free management and business related stuff:https://www.bizmove.com/******************Don’t forget to subscribe so you don’t miss any of our videos, we upload regularly.******************
![Daily Compound Interest (Formula) | Step by Step Calculation with Examples [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_236_0_0jpg.jpg)
In this video on Daily Compound Interest, here we discuss how to calculate daily compound interest along with its formula and practical examples.𝐖𝐡𝐚𝐭 𝐢𝐬 𝐃𝐚𝐢𝐥𝐲 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐈𝐧𝐭𝐞𝐫𝐞𝐬𝐭?———————————————————-Daily compounded interest means interest is accumulated on a daily basis and is calculated by charging interest on the principal plus interest earned on a daily basis and hence is higher than interest compounded on a monthly / quarterly basis due to high compounding frequency.𝐃𝐚𝐢𝐥𝐲 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐈𝐧𝐭𝐞𝐫𝐞𝐬𝐭 𝐅𝐨𝐫𝐦𝐮𝐥𝐚———————————————————–A=(P (1+r/n)^(nt)) – P𝐃𝐚𝐢𝐥𝐲 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐈𝐧𝐭𝐞𝐫𝐞𝐬𝐭 𝐄𝐱𝐚𝐦𝐩𝐥𝐞———————————————————–The bank borrows a total of $5000 where the interest rate is 7% and the balance is borrowed for a term of 3 years. Let’s figure out how much the bank will measure the compounded interest on the loan provided.From above given data we get,Principle = $5000, Annual Interest = 7%, N = 365, Time(years) = 3By using above formula we get,=($5000*(1+7/365)^(365*3))-$5000= 1168.27To know more about the 𝐃𝐚𝐢𝐥𝐲 𝐂𝐨𝐦𝐩𝐨𝐮𝐧𝐝 𝐈𝐧𝐭𝐞𝐫𝐞𝐬𝐭, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/daily-compound-interest/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
![5 Advanced Financial Analyst Interview Questions [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_233_0_0jpg.jpg)
Switching gears to Advanced Financial Analyst Interview Questions from my experience as a corporate controller. Here are the questions we going to cover here:If you could choose one financial metric to assess a stock, what would it be?Why is EBITDA an important metric/value?How can you explain solvency?What factors do you need to consider before taking out a loan?Which financial statement do you refer to in order to monitor whether the company has enough cash to pay off current Liab.?Entry Level Financial Analyst Interview Questions: https://youtu.be/zwUoVnnaM_wFinancial Analyst Behavioral Interview Questions: https://youtu.be/aPIboJu6lpQMy 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
![Derivatives: Embedded Derivatives [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_230_0_0jpg.jpg)
This is the introductory video to our self-study eLearning course “Derivatives: Embedded Derivatives.” Check it out here: https://revolution.gaapdynamics.com/courses/derivatives-embedded-derivativesEmbedded derivatives are derivatives that are combined with other contracts (host instruments) to make a hybrid instrument. ASC 815 has specific rules relating to identifying embedded derivatives and determining whether they should be separated (bifurcated) from the host instrument. Our 1-hour online eLearning course provides an in-depth understanding of the accounting for embedded derivatives under ASC 815. After introducing embedded derivatives, and the concepts of host and hybrid instruments, this course provides the learner with the 3-step consideration when determining whether an embedded derivative needs to be separated (i.e. bifurcated) from the host. Learners get to apply their knowledge to various class examples and case studies. The course concludes with a look at “real-life” financial statements and the presentation and disclosures related to these instruments.Learn 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!
![Yale Attitude Change Approach Explained | Management & Business Concepts [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_227_0_0jpg.jpg)
Discover what is Yale Attitude Change Approach.Get Business Related Freebies: Free books from Amazon, any topic. Business, Fiction and Nonfiction:https://www.bizmove.com/free-books-online/ Video guides to improve your management skills:https://www.bizmove.com/business-management-course/ 300 free business and management guides:https://www.bizmove.com/small-business-encyclopedia/ Free business templates and tools:https://www.bizmove.com/tools/ Free management skills books:https://www.bizmove.com/books/management-skills-books.htm Free downloadable business plan template:https://www.bizmove.com/business-gifts.htm Free starting a business books:https://www.bizmove.com/books/starting-a-business-books.htm A comprehensive resource of free management and business related stuff:https://www.bizmove.com/******************Don’t forget to subscribe so you don’t miss any of our videos, we upload regularly.******************
![High Growth Tech Startup Opportunity? Victory Square Technologies CGO Interview (CSE:VST) [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_224_0_0jpg.jpg)
In this video on Written Down Value Method, here we discuss how to calculate written down value (WDV) Depreciation along with practical examples and detail explanation.𝐖𝐡𝐚𝐭 𝐢𝐬 𝐖𝐫𝐢𝐭𝐭𝐞𝐧 𝐃𝐨𝐰𝐧 𝐕𝐚𝐥𝐮𝐞 𝐌𝐞𝐭𝐡𝐨𝐝?——————————————————————–Written Down Value method is a depreciation technique which applies a constant rate of depreciation to the net book value of the assets each year thus recognizing more depreciation expenses in the early years of the asset’s life and less depreciation in the later years of the asset’s life.𝐖𝐫𝐢𝐭𝐭𝐞𝐧 𝐃𝐨𝐰𝐧 𝐕𝐚𝐥𝐮𝐞 𝐌𝐞𝐭𝐡𝐨𝐝 𝐅𝐨𝐫𝐦𝐮𝐥𝐚———————————————————————Written Down Value Method = (Cost of Asset – Salvage Value of the Asset) * Rate of Depreciation (in %)𝐖𝐫𝐢𝐭𝐭𝐞𝐧 𝐃𝐨𝐰𝐧 𝐕𝐚𝐥𝐮𝐞 𝐌𝐞𝐭𝐡𝐨𝐝 𝐄𝐱𝐚𝐦𝐩𝐥𝐞———————————————————————ABC Company purchased a $14,000 Machinery with a 3 year useful life and a residual value of $3,000. Depreciation rates are 18%.Calculation of written down value (WDV) of depreciation using above formula can be done as follows –Depreciation = ($14,000 – $3,000) * 18%Depreciation = $1,980Calculation at end of the year can be done as follows –Value at End of Year = ($14,000 – $3,000) – $1,980Value at End of Year = 9,020Similarly, we can do the calculation as shown above for year 2 and 3.To know more about the 𝐖𝐫𝐢𝐭𝐭𝐞𝐧 𝐃𝐨𝐰𝐧 𝐕𝐚𝐥𝐮𝐞 𝐌𝐞𝐭𝐡𝐨𝐝, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/written-down-value-method/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
![CFO vs. Controller | What Are The Differences In Terms Of Tasks, Pay & Education [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_221_0_0jpg.jpg)
Reaching a CFO position is a great goal to have if you are in Finance. CFO stands for Chief Financial Officer, which means you’ll be sitting with the executive team and making decisions that will impact the entire company. My role however is a corporate controller, which means that the CFO is my boss and we have different job descriptions. A friend of mine once told me that he thought a controller is a mini CFO, which was kind of a hilarious thought. But this got me wondering: Do people really think that a controller is a mini version of a CFO?What are the differences in the job description between a controller and a CFO?Is becoming a controller a good stepping stone into getting a role as a CFO?What is a typical career trajectory that leads to a CFO role? What is the earning potential for both a controller and 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
![Inventory: Overview of ASC 330 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_218_0_0jpg.jpg)
This is the introductory video to our self-study eLearning course “Inventory: Overview of ASC 330.” Check it out here: https://revolution.gaapdynamics.com/courses/inventory-overview-of-asc-330This module covers the principles of inventory, including classification, cost inclusions, measurement, exchanges, and presentation and disclosures. Many companies have inventory on their books. Inventory is a portion of their business assets that will be (or already are) ready for resale. This one-hour eLearning module provides an overview of ASC 330 and discusses what is included in inventory cost, including how to calculate total cost, the measurement and remeasurement principles applied to inventory, and accounting for inventory exchanges.Learn 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 to Start an Online Business 2021 | Step-By-Step Guide and Dozens of Free Online Business Tools [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/06/mp_215_0_0jpg.jpg)
Discover How to Start an Online Business in 2021. Step-By-Step Guide and Free Tools for Starting an Online Business. You get access to dozens of books, guides, worksheets, tools, software programs, videos, downloadable business plans, templates, checklists, spreadsheets, and much more. All free of charge and no strings attached.———————————————-Small Business Freebies for Starting an Online Business:———————————————- Free Business Books From Amazon, Covering Various Business Management Topics.https://www.bizmove.com/free-books-online/business-free-amazon-books.htm Free Books for Starting and Marketing an Online Business:https://www.bizmove.com/books/internet-marketing-books.htm A Huge Collection of Free Small Business Tools. Including: Business Plans, Worksheets, Spreadsheets, Checklists, Templates, Software, and More. Covering All Aspects of Starting and Managing a Small Business:https://www.bizmove.com/tools/ Video Guides To Improve Your Management Skills:https://www.bizmove.com/business-management-course/ 300 Free Business and Management Guides:https://www.bizmove.com/small-business-encyclopedia/ Free Books to Improve your Management Skills:https://www.bizmove.com/books/management-skills-books.htm Free Downloadable Business Plan Template, and Business Management Software:https://www.bizmove.com/business-gifts.htm Free Books for Starting a Business:https://www.bizmove.com/books/starting-a-business-books.htm A Comprehensive Resource of Free Management And Business Related Stuff:https://www.bizmove.com/******************Don’t forget to subscribe so you don’t miss any of our videos, we upload regularly.******************