Business Infographics on LinkedIn: The Finance for Non-financial Staff Cheat Sheet Credits to Nevena… | 36 comments (2024)

Excel Dynamic ArraysCredits to Mynda Treacy, follow her for more Excel content.------Here's the original post:Excel Dynamic Arrays Cheat SheetHave you explored the powerful capabilities of Excel's Dynamic Arrays? Covering the purpose, syntax and an example of each function, including:- FILTER: Returns a range filtered on criteria you define.- UNIQUE: Returns unique values from a range or array.- SORT: Sorts a range or array based on a column index.- SORTBY: Sorts a range or array based on the values in a corresponding array[s].- SEQUENCE: Returns a list of sequential numbers- RANDARRAY: Returns an array of random numbers- # OPERATOR: Used to reference the entire spill range of a dynamic array.-# SPILL! ERROR: Occurs when there is not enough space for a dynamic array to spill its results.-------Follow Business Infographics to learn from the best visuals.

54

Profit & Loss Account Cheat SheetCredits toNevena Miskovic, follow her for more useful cheat sheets.------Here's the original post:The Profit & Loss Account Cheat Sheet!!All essential P&L Elements across one page.Learn crucial principles and considerations of P&L in one place.👉𝗛𝗲𝗿𝗲 𝗶𝘀 𝘄𝗵𝗮𝘁 𝘁𝗵𝗲 𝗣&𝗟 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁 𝗜𝗻𝗰𝗹𝘂𝗱𝗲𝘀:→ 4 usual types of P&L→ Relation between P&L and other FS→ Definitions of revenues and expenses→ Recognition criteria for revenues by IFRS→ Revenue types→ Revenue breakdowns→ Expense breakdowns→ Revenue forecast tips→ Cost forecast tips→ P&L Ratios→ Example of non-operating expenses→ EBITDA calculation→ Vertical P&L analysis→ Horizontal P&L analysis-------🛎️ Want to develop your f𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗺𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝘀𝗸𝗶𝗹𝗹𝘀?Start with Bojan and Nevena’s Masterclass:https://lnkd.in/ewVWf_5b𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻?💠 6 Hours of video course sessions💠 35 lessons divided in 5 modules💠 10+ Languages video course subtitle💠 50+ finance modeling sheets, editable in Excel💠 330 pages of PDF finance modeling instructions💠 30+ Pieces of actionable content: visuals, handbooks.💠 Assumptions, accuracy validation and consistency checks💠 3 statements monthly and annually planning excel model💠 Advanced platform interface, tracking notes and progress-------FollowBusiness Infographicsto learn from the best visuals.

292

2 Comments

How to NegotiateCredits toChristopher Rocas, follow him for more impactful infographics.------Here is the original post:Negotiation is the highest ROI skill.Learn from the best colleges in the world:𝘠𝘰𝘶 𝘥𝘰𝘯'𝘵 𝘨𝘦𝘵 𝘸𝘩𝘢𝘵 𝘺𝘰𝘶 𝘥𝘦𝘴𝘦𝘳𝘷𝘦.𝘠𝘰𝘶 𝘨𝘦𝘵 𝘸𝘩𝘢𝘵 𝘺𝘰𝘶 𝘯𝘦𝘨𝘰𝘵𝘪𝘢𝘵𝘦.- 𝘋𝘳. 𝘊𝘩𝘦𝘴𝘵𝘦𝘳 𝘓. 𝘒𝘢𝘳𝘳𝘢𝘴𝘴------Follow Business Infographics to learn from the best visuals.

1,602

26 Comments

How to analyze an income statementCredits to Pieter Slegers, follow him for more practical finance content.------Here's the original post:How to analyze an income statement1️⃣ What is an income statement?- An income statement is also called a profit and loss account- It shows the company's revenue and expenses over a certain period- The income statement provides you with a lot of insights as it tells you how much revenue is translated into net income, the efficiency of management, and much more2️⃣ Revenue- For a company, it all starts with its revenue or sales- Revenue is the money a company receives from selling its products and/or services3️⃣ Costs Of Goods Sold (COGS)- Shows you all the costs a company makes to produce its products and/or services4️⃣ Gross Profit- The profit a business makes after subtracting all the costs that are related to manufacturing and selling its products or services- Gross profit = Revenue – COGS5️⃣ Operating Expenses (OPEX)- All the expenses a company makes to run its daily operations6️⃣ Operating Income- Operating income = Gross profit – OPEX- The operating income shows you how much money a company earns from its normal business activities7️⃣ Non-operating Income- Income and expenses that aren’t related to the normal business activities8️⃣ Income Before Taxes- Income before taxes = operating income – non-operating income and expenses- Tells you how much profit the company has made before taxes9️⃣ Net Income- The bottom line or net income of an income statement shows you how much money the company has made after subtracting all costs and taxes- Net income is also known as ‘earnings’ or ‘profit’- Net income = income before taxes - taxes-------🛎️ Want to learn how to 𝗮𝗻𝗮𝗹𝘆𝘇𝗲 𝗙𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗦𝘁𝗮𝘁𝗲𝗺𝗲𝗻𝘁𝘀 𝗹𝗶𝗸𝗲 𝗮 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹:Start with Compounding Quality's Financial Analysis Course: https://lnkd.in/d8QFADVW-------Follow Business Infographics to learn from the best visuals.

536

6 Comments

10-Technique Cheat Sheet for ProductivityCredits to Ronnie H. Kinsey, MBA, follow him for more practical cheat sheets.------Here's the original post:The bad news: Time flies.The good news: You're the pilot.(h/t Michael Altschuler)Time is your most precious resource.Yet, how often do you find it slipping away?In today's world, using time well is more than a skill.It's a necessity.That's why I've curated a 10-technique cheat sheet.It's designed to fit into any lifestyle, any career.You get all the best time management tools:🕐 Time Blocking - Master your schedule.🕑 Flowtime Technique - Work with your own rhythm.🕒 1-3-5 Rule - Simplify your to-do list.🕓 2-Min Rule - Tackle small tasks instantly.🕔 18-Min Plan - Strategize daily.🕕 GTD Method - Organize and execute.🕖 Eisenhower Technique - Prioritize wisely.🕗 Task Batching - Group and conquer.🕘 Eat the Frog - Start with the tough stuff.🕙 80/20 Rule - Focus on what truly matters.So. Many. Techniques.The beauty lies in its versatility.Mix, match, or focus on just one.Find what resonates with you and embrace it.It's time to take control.To turn hours into accomplishmentsAnd days into successes.-------Follow Business Infographics to learn from the best visuals.

539

9 Comments

24 TOP FINANCIAL FORMULASCredits to Bojan Radojicic, follow him for more valuable finance content.------Here's the original post:24 TOP FINANCIAL FORMULAS1. Beta coefficient2. Cash flow from operating activities3. Discounting factor4. Cash flow - CF5. Equity projection6. Free cash flow7. Cost of equity8. Discounted cash flow9. Compound Annual Growth Rate10. Capitalization rate11. Equity value12. Internal rate of return13. WACC14. Compounded Annually Formula15. Terminal value16. Present value - PV17. Economic value added18. Return on invested capital ROIC19. Return on capital engaged ROCE20. Break-even point21. Price-earnings ratio22. Degree of Financial Leverage23. Free cash flow rate24. Net present value-------🛎️ Want to develop your 𝗳𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗺𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝘀𝗸𝗶𝗹𝗹𝘀?Start with Bojan’s Masterclass: https://lnkd.in/ewVWf_5b𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻?💠 6 Hours of video course sessions💠 35 lessons divided in 5 modules💠 10+ Languages video course subtitle💠 50+ finance modeling sheets, editable in Excel💠 330 pages of PDF finance modeling instructions💠 30+ Pieces of actionable content: visuals, handbooks.💠 Assumptions, accuracy validation and consistency checks💠 3 statements monthly and annually planning excel model💠 Advanced platform interface, tracking notes and progress-------Follow Business Infographics to learn from the best visuals.

711

8 Comments

Leadership Transitions at Different Stages of Business GrowthCredits to Chris Tottman, follow him for more valuable content.------Here's the original post:Are you leading a growing business?Discover the leadership transitions vital for each stage of growth 🚀As a founder, you must identify where you are in your business journey.Then, adapt your leadership style accordingly.Here are the key leadership transitions to consider:🌱 Start-up stageIn the START-UP phase, you're the Brave Warrior.Here, it's all about being single-minded, brimming with personal confidence, and thriving on adrenaline.Your day? An animated whirlwind of activity, moving mountains with sheer will.But beware, for this intensity can sometimes morph into impatience and intolerance.🚧 Scale-up stageTransitioning to SCALE-UP, you embody the Considered Architect.This phase demands a calm, systems-oriented approach.You're the planner, the unflappable strategist, meticulously crafting every move.A high EQ leader, you foster a harmonious and effective team.However, the risk?Getting too bogged down in details, losing sight of the bigger picture.👑 Grown-up stageIn the GROWN-UP phase, you ascend as the Wise Monarch.Your role transcends mere management; you're a visionary, a strategist, a beacon of inspiration.With a commanding presence, you're politically astute, adept at future-proofing the business.But even monarchs have their follies - a tendency towards arrogance or detachment from ground realities.- - - -Remember:This is not just a transformation; it's a revelation.It requires introspection, adaptability, and a deep understanding of not just your business, but also of yourself.-------Follow Business Infographics to learn from the best visuals.

301

7 Comments

Six Balance Sheet LimitationsCredits to Nathan Liao, CMA Coach, follow him for more accounting & finance content.------Here's the original post:Six Balance Sheet LimitationsIncrease your financial acumen 👇The Balance Sheet is a crucial financial statementBut it's not the be-all and end-allSix reasons why, including examples:1. Snapshot in Time:The balance sheet is a snapshot of a company’s financial position at a single point in time. It doesn't capture the nuances of cash flow throughout the year.Example: Your balance sheet might show ample cash on hand, but what if a major vendor payment is due tomorrow?2. Book Value ≠ Market Value:Assets and liabilities, including company equity, are often listed at their book values, which may not reflect their market value.Example: A company's shares might be trading at $50 on the stock market, while their book value per share according to the balance sheet is only $30.3. Intangible Assets Missing:Things like brand recognition, human capital, or company culture, which are crucial to success, don't get a line on the balance sheet.Example: A strong brand or skilled workforce isn't represented.4. Historical Costs:Historical costs can distort true asset value, potentially misleading stakeholders.Example: A piece of land purchased 20 years ago will be recorded at its cost price, not its current appreciated value.5. Estimations and Judgments:Accounting often involves judgments and estimates, which could change over time, affecting asset and liability valuations.Example: The useful life of an asset is often an educated guess.6. Lack of Risk Insight:The balance sheet doesn’t differentiate between 'good' and 'bad' liabilities or provide risk context.Example: Two companies may have similar debt levels, but different risk exposures.—---------------What does it mean for financial analysis?Treat it as a starting point, not a conclusionIntegrate it with other financial statementsAnd you’ll get a 360-degree view-------Follow Business Infographics to learn from the best visuals.

170

5 Comments

Everything you can do in PowerPointCredits toSoufyan Hamid, follow him for more practical content.------Here's the original post:This post contains EVERYTHING you can do in Powerpoint 👇I asked some months ago and PowerPoint remains the # 1 tool …and for good reasons- It's part of the Microsoft Office Suite (so compatible with Excel)- It has features nowhere else available (rehearsal coach,...)- You can work with it offlineSo let's go through the main tabs together🏠 HomeThe motherbase where you can select how you paste (pretty useful with pictures) but can also go further with direct access to SmartArt (helloNicolas Boucher) and Arrange options (aligning, ordering,...)↘️ InsertBasically, everything you could insert:Images (from computer but also from stock, clipboard or from search engines)Shapes and Icons (don't use bullet points anymore)Media (video and audio)📹 Transition and AnimationUseful but also risky if you let your creativity take the leadUse them carefully and only when it makes sense (list, or engagement of the audience)💻 Slide ShowToo often underestimated, this the place where you'll find everything you need to prepare your presentationRehearse with a coach to get feedback on your performanceRecord and use timings to assess your delivery🔎 ViewSlide Master is THE tool to make your slides look the same throughout your presentation.Instead of copying-pasting your company logo in each slide, use this feature instead--------That’s about everything you can do in PowerPoint…but there’s so much more and I only have 3,000 characters here.What would you add?-------🛎️ Want to develop your 𝗳𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝘀𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴 𝘀𝗸𝗶𝗹𝗹𝘀:Start with Soufyan's Financial Storytelling Program Online: https://lnkd.in/g7yBnrJKMaster the art of financial storytelling with a 4-step tested and approved approach.-------Follow Business Infographics to learn from the best visuals.

481

4 Comments

Master Your Personal GrowthCredits to Kevin Box🚀, follow him for more insightful content.------Here's the original post:Troubling statistic from the Talent Mobility Research Report...Over 40% of organizations said they do not provide mentoring as part of their employee support system. 😟One reason cited was that companies feel that employee education and career development falls on the shoulders of the employee.These Organizations do not foster a personal growth mindset for it's employee base.This line of thinking is stifling career growth and causing employees to seek better outcomes elsewhere.Another studyfound that companies promoted employees who were:💠Mentors - six times more often, and💠Mentees- five timesmore often then those not involved in mentoring.If employees are moving up the career ladder faster with mentorship, then mentors must be a valuable asset to the organization.In this Fuel Your Growth Cheat Sheet, we explore the benefits of having a mentor...including:1/ The Impact of a Mentor2/ The Mentor's Model-------Follow Business Infographics to learn from the best visuals.

464

3 Comments