Corporate Finance Learning® on LinkedIn: 7 Excel models to demystify a valuation of any startup. No guesswork and… (2024)

I made my first business plan model in 2008. But each year, or each month, there is some new ideas how to improve, how to make it simple for everybody. Now I have super simple project evaluation model. 📉 𝗛𝗲𝗿𝗲 𝗶𝘀 𝘄𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻𝗰𝗹𝘂𝗱𝗲𝗱:𝗜𝗻𝘀𝘁𝗿𝘂𝗰𝘁𝗶𝗼𝗻𝘀• How to input data in model• Abbreviations used𝗙𝗿𝗲𝗲 𝗰𝗮𝘀𝗵 𝗳𝗹𝗼𝘄 𝗽𝗿𝗼𝗷𝗲𝗰𝘁𝗶𝗼𝗻 (𝗲𝗰𝗼𝗻𝗼𝗺𝗶𝗰 𝗳𝗹𝗼𝘄)• Sales• Terminal flow• COGS• OPEX• CAPEX• Net working capital• Interest and financial expenses• Corporate taxes• Cumulative project free cash flow𝗪𝗔𝗔𝗖 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻 𝘀𝗵𝗲𝗲𝘁 𝗡𝗲𝘁 𝗽𝗿𝗲𝘀𝗲𝗻𝘁 𝘃𝗮𝗹𝘂𝗲• Total inflows• Total outflows• Discount factor• NPV calculation𝗜𝗥𝗥 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻𝗘𝗩𝗔 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗼𝗻 𝘀𝗵𝗲𝗲𝘁• NOPLAT• Invested capital• WAAC• EVA___________________I provide a lot resources for FREE and enjoy when one million people read this. But I need to earn something as well. So, this model is not FREE. Cost of model - like a lunch for 3 if you are in Athens, or like 4 pieces of cake if you are in Singapore (but before inflation). LIMITED TIME OFFER.𝗗𝗼𝘄𝗻𝗹𝗼𝗮𝗱 𝗹𝗶𝗻𝗸:https://lnkd.in/dzC5RXrp𝗢𝗥Take it through my full 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗙𝗶𝗻𝗮𝗻𝗰𝗲 𝗠𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝗣𝗮𝗰𝗸:👇https://lnkd.in/dBnXhtN8PS. If you think my project evaluation model could be a great fit for you, send me a in a direct message, and let's chat about how we can work together!

65

Steps to Creating the Perfect Finance Chart! Credits to Soufyan Hamid, follow him for more finance insights!~~~~~~~~~𝙃𝙚𝙧𝙚'𝙨 𝙩𝙝𝙚 𝙤𝙧𝙞𝙜𝙞𝙣𝙖𝙡 𝙥𝙤𝙨𝙩:Build your sexy charts in ExcelAll the steps for the major graphs for FinanceIf you take the default Excel Charts, there is one truthThey aren't sexy at all and don't show anything- colours are not aligned with your company's- they don't highlight the main points- the look like they were made in 1998So I customize them to make sure it can be used for visualsAnd with that, I don't need those expensive and tough tools like PowerBI or TableauAnd let's be honest, 99,99% of the finance professionals in the world still prefer to work with Excel, right?So there you go, 4 main charts used- Line Chart- Bar Chart- Pie Chart (yes yes, pie charts, no matter what Paul Barnhurst, The FPandA Guy or Anders Liu-Lindberg think)- Waterfall Chart (this one in two versions)If you're happy, you might as well print it and hang it on your office wallFor that, take the high-resolution version (see link in the first comment)And tell your friends and colleagues about it 😉~~~~~~~~~Prove the value of your work to the executives and increase your visibility.Access here:https://lnkd.in/dbkQmK5m~~~~~~~~~

268

6 Comments

𝗧𝗬𝗣𝗘𝗦 𝗢𝗙𝗖𝗢𝗦𝗧𝗦--------------𝗗𝗶𝗿𝗲𝗰𝘁 Can be traced directly and specifically to a particular cost object (like a product, project, or department)VS𝗜𝗻𝗱𝗶𝗿𝗲𝗰𝘁Costs not directly tied to a specific project, product, or activity, but necessary for the overall operation---------------𝗙𝗶𝘅𝗲𝗱 Costs that remain constant regardless of the volume of production or level of activityVS𝗩𝗮𝗿𝗶𝗮𝗯𝗹𝗲Costs that change directly in proportion to the volume of production or level of activity---------------𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗻𝗴Costs associated with the primary activities of the business in producing goods or providing servicesVS𝗡𝗼𝗻-𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗻𝗴Costs associated with peripheral or incidental activities, not directly tied to the main business operations--------------𝗖𝘂𝗿𝗿𝗲𝗻𝘁The costs that a business incurs during a specific period. Relates to current or very recent transactionsVS𝗛𝗶𝘀𝘁𝗼𝗿𝗶𝗰𝗮𝗹The original monetary value of an asset or the cost at which an item was purchased in the past---------------𝗔𝗰𝘁𝘂𝗮𝗹The genuine expenses that a business incurs during a specific period; Based on actual transactions and eventsVS𝗕𝘂𝗱𝗴𝗲𝘁𝗲𝗱The projected costs that a business anticipates or plans to incur during a specific period; Based on forecasts, planning, and historical data;---------------𝗢𝗻 𝗰𝗮𝘀𝗵 𝗯𝗮𝘀𝗶𝘀Recognizes costs when cash is physically paid or received; VS𝗔𝗰𝗰𝗿𝘂𝗮𝗹𝘀Recognizes costs when incurred, not when cash is exchanged_______________________________Ready of new level of your finance career?📌 Grab my 50+ finance models and 35 lessons in my 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗙𝗶𝗻𝗮𝗻𝗰𝗲 𝗠𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝗣𝗮𝗰𝗸𝗮𝗴𝗲 and start creating your financial health today :👉 https://lnkd.in/d2QhAcJg#finance #education #coaching #development #careergrowth

178

2 Comments

The Discounted Cash Flow Cheat Sheet.All essential DCF facts in one place.𝗛𝗲𝗹𝗽 𝗺𝗲 𝘀𝗽𝗿𝗲𝗮𝗱 𝘁𝗵𝗶𝘀 𝗯𝗮𝘀𝗶𝗰𝘀 𝗼𝗳 𝗗𝗖𝗙 𝗺𝗲𝘁𝗵𝗼𝗱𝗼𝗹𝗼𝗴𝘆. 👍 Like, Share and Comment so this post can reach professionals who want to learn more about discounted cash flow. Here is what Discounted Cash Flo Cheat Sheet includes:• DCF Essentials• DCF Formula• DCF pros and cons• Steps to make DCF• CF forecast short model• DCF short valuation model• WAAC calculation• Forecast basics• Sensitivity analysis• Terminal value formula• NWCFollow me for more FEE finance, cash flow, accounting, reporting, M&A, IFRS and valuation resources. ~~~~~~~~~DCF is the most important part of our Finance Modeling Course𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻?💠 35 Lessons 💠 6 Hours of video course 💠 10+ Languages subtitle💠 50+ Editable Excel modeling sheets💠 330 pages of PDF finance modeling instructions 💠 30+ Pieces of actionable visuals and handbooks🛎️ Check more here : https://lnkd.in/d3FBeCjP#cashflow #finance #accounting #valuations

169

2 Comments

Variable Costs VS Fixed Cost!Understanding the distinction between variable and fixed costs is crucial for cost analysis, budgeting, pricing decisions, and overall financial planning within a business.𝗛𝗲𝗹𝗽 𝗺𝗲 𝘀𝗵𝗮𝗿𝗲 𝘁𝗵𝗶𝘀 Variable Costs VS Fixed Cost 𝗙𝗥𝗘𝗘 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁.👍 👍 👍 𝗟𝗶𝗸𝗲, 𝗦𝗵𝗮𝗿𝗲 𝗮𝗻𝗱 𝗖𝗼𝗺𝗺𝗲𝗻𝘁 𝘀𝗼 𝘁𝗵𝗶𝘀 𝗽𝗼𝘀𝘁 𝗰𝗮𝗻 𝗿𝗲𝗮𝗰𝗵 𝗽𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹𝘀 𝘄𝗵𝗼 𝘄𝗮𝗻𝘁 𝘁𝗼 𝗹𝗲𝗮𝗿𝗻 𝗺𝗼𝗿𝗲 𝗮𝗯𝗼𝘂𝘁 Variable and Fixed Costs.▶️ 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻𝗰𝗹𝘂𝗱𝗲𝗱 𝗶𝗻 𝘁𝗵𝗶𝘀 𝘀𝗵𝗼𝗿𝘁 𝗰𝗼𝗺𝗽𝗮𝗿𝗶𝘀𝗼𝗻 𝗴𝘂𝗶𝗱𝗲:• Definitions• Examples• Behavior• Predictability• Control• Risk Management• Cost Structure• and moreDid I miss something? Let me know what you would add, and I will approach that in the new version.👉 𝗟𝗶𝗸𝗲, 𝗖𝗼𝗺𝗺𝗲𝗻𝘁, 𝗥𝗲𝗽𝗼𝘀𝘁.-------------------------📌 "You can't predict the future, but you can create it" P. Drucker. Use my 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗙𝗶𝗻𝗮𝗻𝗰𝗲 Modeling Package and start creating your financial health today.https://lnkd.in/dpQ6K4Fb

174

1 Comment

This is our selection of FP&A Dream 100 topics to learn in 2024. We divided these 100 topic or lessons to learn into 10 clusters:1. Planning & Forecasting2. Budgeting3. Analysis4. Management reporting5. Communication6. Modeling7. KPIs8. Strategic9. Tools & AI10. Scenario analysis________________________________📌Many of those terms are not only explained but also incorporated in finance models in our 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗙𝗶𝗻𝗮𝗻𝗰𝗲 𝗠𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀👉 https://lnkd.in/dFhjqc8k𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻?💠 6 Hours of video course sessions 💠 50+ finance modeling sheets, editable in Excel💠 330 pages of PDF finance modeling instructions 💠 30+ Pieces of actionable content: visuals, handbooks.PS. Use Christmas 60% off, until 5th of January.

69

1 Comment

The IAS 38 - Intangible Assets Cheat Sheet!! All essential intangible asset accounting principles and insights in one place.Let’s your IFRS knowledge begin here.Start collecting my IFRS/IAS resources.🧿 𝗛𝗲𝗿𝗲 𝗶𝘀 𝘄𝗵𝗮𝘁 𝘁𝗵𝗲 𝗜𝗔𝗦 𝟯𝟴 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁 𝗜𝗻𝗰𝗹𝘂𝗱𝗲𝘀:▶️ Definitions▶️ IP Types▶️ Initial recognition ▶️ Recognition criteria▶️ List items when standard is no applied to▶️ Examples of directly attributable costs▶️ Examples of expenditures that are not capitalized to IP▶️ Measurement after recognition▶️ Research phasis expenditures recognition ▶️ Development phase expenditures recognition ▶️ Examples▶️ Disclosures and more~~~~~~~~~+ 𝗥𝗲𝗽𝗼𝘀𝘁: Let your followers learn about intangibles accounting + 𝗖𝗼𝗺𝗺𝗲𝗻𝘁: Your thoughts? Or tell me what IFRS topics I should post about -------------------------Master IFRS with this comprehensive bundle of materials 👉 https://lnkd.in/dm8maix5

195

4 Comments

Cost budgeting HANDBOOK. 𝗪𝗮𝗻𝘁 𝘁𝗵𝗶𝘀 𝗵𝗮𝗻𝗱𝗯𝗼𝗼𝗸? Free Download in PDF: https://lnkd.in/d8aBuFa5What is included? 1️⃣ 𝗜𝗺𝗽𝗼𝗿𝘁𝗮𝗻𝘁 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀 𝗼𝗳 𝗰𝗼𝘀𝘁𝘀, 2️⃣ 𝗕𝘂𝗱𝗴𝗲𝘁𝗶𝗻𝗴 𝗮𝘀𝘀𝘂𝗺𝗽𝘁𝗶𝗼𝗻𝘀,3️⃣ 𝗧𝗶𝗽𝘀 𝗵𝗼𝘄 𝘁𝗼 𝗯𝘂𝗱𝗴𝗲𝘁 𝗮𝗻𝗱 𝘄𝗵𝗲𝗿𝗲 𝘁𝗼 𝗳𝗶𝗻𝗱 𝗱𝗮𝘁𝗮 𝗳𝗼𝗿 𝗯𝘂𝗱𝗴𝗲𝘁𝗶𝗻𝗴. 𝗗𝗜𝗥𝗘𝗖𝗧 𝗖𝗢𝗦𝗧𝗦Cost of goods sold / raw materialElectricity and fuel costsDirect LaborConsultantsRepairs & Maintenance𝗢𝗩𝗘𝗥𝗛𝗘𝗔𝗗 𝗖𝗢𝗦𝗧𝗦Overhead LaborDepreciation and AmortizationUtilitiesTelephoneEquipment RentalRepairs & MaintenanceShortagesWrite offsConsultantsImpairments account receivablesImpairments of inventory𝗦𝗔𝗟𝗘𝗦 𝗚𝗘𝗡𝗘𝗥𝗔𝗟 𝗔𝗡𝗗 𝗔𝗗𝗠𝗜𝗡𝗜𝗦𝗧𝗥𝗔𝗧𝗜𝗢𝗡 𝗖𝗢𝗦𝗧𝗦SG&A LaborBonusesMarketing and advertising costsRentUtilitiesEquipment RentalOffice SuppliesTravelConsultantsLegal & AccountingInsuranceLicensesR&DInterest expensesCorporate taxes--------------------------------📌 𝗕𝘂𝗱𝗴𝗲𝘁𝗶𝗻𝗴 𝗺𝗼𝗱𝗲𝗹 is only one model in my 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗳𝗶𝗻𝗮𝗻𝗰𝗲 𝗺𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝗽𝗮𝗰𝗸. Look the others:https://lnkd.in/ddpssf6h

192

1 Comment

🚀 STRATEGIC FINANCE HANDBOOK𝗪𝗮𝗻𝘁 𝘁𝗵𝗶𝘀 𝗵𝗮𝗻𝗱𝗯𝗼𝗼𝗸 𝗶𝗻 𝗣𝗗𝗙 𝗵𝗶𝗴𝗵 𝗿𝗲𝘀𝗼𝗹𝘂𝘁𝗶𝗼𝗻? Download here: https://lnkd.in/dUh8W43Y📙 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻:𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 (𝗗𝗲𝗽𝗮𝗿𝘁𝗺𝗲𝗻𝘁) 𝗔𝗳𝗳𝗲𝗰𝘁𝗲𝗱→ FP&A→ Treasury→ Tax→ Compliance→ IT→ Accounting→ Security→ Controlling→ ESG→ Risk→ Audit𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲𝘀WHAT→ Talent management→ Data Overload→ Regulatory and Compliance pressures→ Technological Disruption→ Evolving Business Models𝗔 𝗡𝗲𝘄 𝗣𝗮𝗿𝗮𝗱𝗶𝗴𝗺→ Advanced data processing and analysis→ Digitalization and automation (AI)→ Leadership and people orientation→ Scenario planning→ Investment in relationships→ Regulatory and ESG compliance𝗞𝗲𝘆 𝗣𝗶𝗹𝗹𝗮𝗿𝘀→ Planning→ Risk Management→ Ensuring Roi...see full content in my handbook. 𝗟𝗲𝗮𝘃𝗲 "𝗳𝗶𝗻𝗮𝗻𝗰𝗲" 𝗶𝗻 𝗰𝗼𝗺𝗺𝗲𝗻𝘁 𝗼𝗿 𝗗𝗠 𝗺𝗲 𝘄𝗶𝘁𝗵 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗳𝗶𝗻𝗮𝗻𝗰𝗲. ____________________📌 If you want to upgrade your career in finance, start with our Corporate Finance Masterclass:https://lnkd.in/dbMK3GWi

148

3 Comments

𝗦𝗔𝗟𝗔𝗥𝗜𝗘𝗦 & 𝗛𝗘𝗔𝗗𝗖𝗢𝗨𝗡𝗧 𝗙𝗢𝗥𝗘𝗖𝗔𝗦𝗧𝗜𝗡𝗚 is a must because:1. Plan and allocation the resources effectively2. Enables competitive compensation to retain top talent.3. Aligns salary costs with business objectives.4. Reduces unexpected financial burdens.5. Ensures compensation matches industry standards.6. Aligns pay with performance and productivity measures.7. Prioritizes departments or roles needing financial attention.8. Allows for proactive responses to changing economic conditions.📰 𝗛𝗲𝗿𝗲 𝗮𝗿𝗲 𝗺𝘆 𝗳𝗮𝘃𝗼𝘂𝗿𝗶𝘁𝗲 𝘀𝘁𝗲𝗽𝘀 𝘁𝗼 𝗰𝗿𝗲𝗮𝘁𝗲 𝗮 𝗺𝗼𝗱𝗲𝗹:→ List all employees and their positions → Split between direct and indirect workers→ Leave empty lines for new employees and fill expected annual costs→ Input the baseline for further projection that includes• base salary for previous • current period, • bonus, • annual costs estimate. → Estimate annual salary growth rate→ Head count number projection – COUNTIF function applied→ Input the total costs of salaries from the official books, and make sure the data is matching. → Input estimated time engaged per year. For example, if you plan to employ one person in July 2024 this is 50% of total working hours in 2024. → The model will automatically calculate the costs based on pervious inputs. ___________________________📌 If you want our full Corporate Finance Modeling Package, I suggest to check this:💠 35 Lessons 💠 6 Hours of video course 💠 10+ Languages subtitle💠 50+ Editable Excel modeling sheets💠 330 pages of PDF finance modeling instructions 💠 30+ Pieces of actionable visuals and handbookshttps://lnkd.in/dvV5awBk

194

5 Comments