Bojan Radojicic

Month end close!!! How to make it efficient and safe?

Even you have monthly closing check lists, it can be always subject of improvement. Maybe you get some new ideas based on this list. I hope so.

Here is my favorite simple monthly closing procedures.

👍 𝐋𝐢𝐤𝐞, 𝐒𝐡𝐚𝐫𝐞 𝐚𝐧𝐝 𝐂𝐨𝐦𝐦𝐞𝐧𝐭 𝐬𝐨 𝐭𝐡𝐢𝐬 𝐩𝐨𝐬𝐭 𝐜𝐚𝐧 𝐫𝐞𝐚𝐜𝐡 𝐞𝐯𝐞𝐫𝐲𝐨𝐧𝐞 𝐰𝐡𝐨 𝐧𝐞𝐞𝐝𝐬 it!

Do like to get downloadable PDF version? (Checklist will be free until July 5).

👉 𝐋𝐢𝐤𝐞, 𝐂𝐨𝐦𝐦𝐞𝐧𝐭, 𝐑𝐞𝐩𝐨𝐬𝐭


The month end close procedure is the compass that guides us towards financial clarity and ensures that all financial transactions are properly recorded, reconciled, and reported.

🗺️💡 It helps us identify errors, uncover discrepancies, and mitigate potential risks. ⚠️🔒

➕ 𝗙𝗼𝗹𝗹𝗼𝘄 𝗺𝗲 𝗳𝗼𝗿 𝗺𝗼𝗿𝗲 𝗙𝗘𝗘 𝗳𝗶𝗻𝗮𝗻𝗰𝗲, 𝗰𝗮𝘀𝗵 𝗳𝗹𝗼𝘄, 𝗮𝗰𝗰𝗼𝘂𝗻𝘁𝗶𝗻𝗴, 𝗿𝗲𝗽𝗼𝗿𝘁𝗶𝗻𝗴, 𝗠&𝗔, 𝗜𝗙𝗥𝗦 𝗮𝗻𝗱 𝘃𝗮𝗹𝘂𝗮𝘁𝗶𝗼𝗻 𝗿𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀.

#cashflow #finance #accounting #valuations #controlling

Pivot Tables in Excel: The Secret Weapon for Finance Pros

If you're in FP&A, accounting, or data analysis and still not using PivotTables to their full potential—you’re leaving hours (and insights) on the table.

Here’s why PivotTables are essential in finance:

✅ Instantly summarize massive datasets
✅ Slice and dice by dimensions (time, categories, regions)
✅ Spot trends and performance shifts in seconds
✅ Automate reporting without building formulas from scratch

💡 Beyond the basics, these features take your analysis to the next level:

🔹 Refresh with one click
🔹 Add slicers & timelines for dynamic filtering
🔹 Create PivotCharts to visualize directly
🔹 Use Fields, Items & Sets for advanced calculations
🔹 Reorganize data on the fly with Grouping and Field Settings

I compiled all these tips into a visual reference guide to help you navigate every PivotTable option available.

👉 Want the high-res file? Drop a comment and I’ll DM it to you.

P.S. If you enjoy this kind of content, check out my full FP&A modeling program with 70+ Excel templates and 10h of walkthroughs at bojanfin.com

Someone once said: a deal dies 20 times. Here’s what could happen:

❌ The first time, when the seller is unhappy with the non-binding offer and sees no room for improvement.

❌ The second time, when the seller realizes how much they still need to remain involved in the company they are selling.

❌ The third time, when the seller receives an unfavorable non-competition clause.

❌ The fourth time, when the seller is dissatisfied with the proposed deal structure, the initial payment, or the earnout.

❌ The fifth time, when the seller changes their mind due to emotional reasons.

𝗔𝗻𝗱 𝘄𝗵𝗮𝘁 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝗯𝘂𝘆𝗲𝗿? 𝗢𝗵, 𝘁𝗵𝗲𝗿𝗲 𝗰𝗼𝘂𝗹𝗱 𝗯𝗲 𝗮 𝗺𝗶𝗹𝗹𝗶𝗼𝗻 𝗿𝗲𝗮𝘀𝗼𝗻𝘀 𝘁𝗼 𝘄𝗮𝗹𝗸 𝗮𝘄𝗮𝘆:

👉 findings from due diligence,
👉 quality of earnings issues,
👉 financing challenges,
👉 cultural differences,
👉 integration risks,
👉 people and management at the target company,
👉 and more.

Anyway, this is a process [see below] you have to go through to get a deal done. At each step, there are numerous deal breakers.

What, in your opinion, are some interesting reasons for backing out of an acquisition, whether from the buyer’s or seller’s perspective?

P.S. I’m Bojan, and I write about corporate finance.

If you want this poster in high res just comment MA or DM me.

Cheers!

7 Excel models to demystify a valuation of any startup.
No guesswork and bias.

𝗦𝘁𝗮𝗿𝘁𝘂𝗽 𝗳𝗼𝘂𝗻𝗱𝗲𝗿𝘀: fueled by passion, innovation, and big dreams.

But amidst all the creativity and enthusiasm, there's a critical aspect that often takes center stage:

Startup Valuation! 💼

Understanding the value of a startup is more than just a number.

It's a strategic compass that guides your fundraising efforts, informs investment decisions, and shapes your company's trajectory.

Here's why startup valuation is a crucial piece of the puzzle:

1️⃣ Fundraising and Investment Decisions
2️⃣ Equity Allocation and Employee Incentives
3️⃣ Strategic Growth Planning
4️⃣ Acquisitions and Partnerships

Why do you need these 7 models?


🔹 𝗧𝗶𝗺𝗲-𝗦𝗮𝘃𝗶𝗻𝗴 𝗮𝗻𝗱 𝗨𝘀𝗲𝗿-𝗙𝗿𝗶𝗲𝗻𝗱𝗹𝘆
Valuation calculators streamline the valuation process, saving you valuable time and effort.

🔹 𝗗𝗮𝘁𝗮-𝗗𝗿𝗶𝘃𝗲𝗻 𝗗𝗲𝗰𝗶𝘀𝗶𝗼𝗻 𝗠𝗮𝗸𝗶𝗻𝗴:
These calculators are built on robust algorithms, taking into account critical financial data. This helps you to avoid guesswork and bias.

🔹 𝗘𝗱𝘂𝗰𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗧𝗼𝗼𝗹:
By understanding the factors that influence your startup's value, you'll gain a deeper comprehension of your business's strengths and areas for improvement.

🔹 𝗖𝗼𝗻𝗳𝗶𝗱𝗲𝗻𝗰𝗲 𝗶𝗻 𝗡𝗲𝗴𝗼𝘁𝗶𝗮𝘁𝗶𝗼𝗻𝘀: Armed with a well-informed valuation estimate, you can confidently negotiate with investors or potential partners, knowing that your offer is grounded in data and market realities.


𝗪𝗛𝗔𝗧 𝗜𝗦 𝗜N𝗖𝗟𝗨𝗗𝗘𝗗 𝗜𝗡 𝗧𝗛𝗜𝗦 𝗘𝗫𝗖𝗘𝗟 𝗠𝗢𝗗𝗘𝗟:

• 7 methods: explanation of when the method is appropriate to use and valuation calculation under given assumptions
  
• Discounted cash flow method
  
• Valuation by multiple (EBITDA or Revenue/ARR)
  
• Comparable companies method
  
• Replacement cost method
  
• Net book value method

• Berkus method

• Venture capital method
  
• Summary of all methods results

𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗟𝗜𝗡𝗞:  https://lnkd.in/dWjXSa5J

The model is given with minimal cost for a limited period of time.

OR

Use my Corporate Finance Modeling Package and start creating your financial health today:  https://lnkd.in/dZwwg6Wj


#Entrepreneurship #TechStartups #StartupLife #startup

Understanding IRR (Internal Rate of Return)

𝗪𝗵𝗮𝘁 𝗶𝘀 𝗜𝗥𝗥?

👉 Definition
The internal rate of return is the discount rate that makes the net present value (NPV) of all cash flows from the project equal to zero.

👉 Estimation
IRR is the estimated rate of growth an investment is expected to generate.
Investment Indicator: When the IRR is higher than the required rate of return, it indicates a favorable investment opportunity.


𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝗨𝘀𝗶𝗻𝗴 𝗘𝘅𝗰𝗲𝗹:

List your cash flows in a rows. The first value should be the initial investment (a negative number), followed by the series of net cash inflows or outflows for each period.

then apply IRR formula:

=IRR(G7:K7)

Where:

G7: Sum for total present value of outflows (use minus value)
H7-K11: Total inflows in row


𝗗𝗶𝘀𝗮𝗱𝘃𝗮𝗻𝘁𝗮𝗴𝗲𝘀 𝗼𝗳 𝗜𝗥𝗥:

❌ IRR does not directly account for the cost of capital.
❌ Multiple IRRs can exist for non-conventional cash flows.
❌ IRR does not differentiate between projects with different cash flow timings.

𝗜𝗥𝗥 𝘃𝘀. 𝗫𝗜𝗥𝗥:

IRR: Assumes cash flows occur at regular intervals (e.g., monthly, annually).

XIRR: Handles cash flows at irregular intervals and requires actual dates for each cash flow.

~~~~~~~~~~~~~

Project evaluation is a key of my Finance Modeling Pack. Look all lessons and excel models available here:

👉 https://lnkd.in/dZwwg6Wj
.

Don't think about valuation until you read this!

In nutshell there is 𝟯 𝘃𝗮𝗹𝘂𝗮𝘁𝗶𝗼𝗻 𝗮𝗽𝗽𝗿𝗼𝗮𝗰𝗵𝗲𝘀.

Let me present a key difference between them.

______________________

+ 𝗥𝗲𝗽𝗼𝘀𝘁: Let your followers learn about valuation approach.

+ 𝗖𝗼𝗺𝗺𝗲𝗻𝘁: Your thoughts? Or tell me what I missed or should post about?

_______________________

PS. “Why not have a look at my 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗙𝗶𝗻𝗮𝗻𝗰𝗲 𝗠𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝗣𝗮𝗰𝗸𝗮𝗴𝗲 and level up your valuation skills today?: 👉 https://lnkd.in/dZwwg6Wj

How I Built a Complete Microsoft DCF Model Using Only AI

Want to see the future of financial modeling?
I just ran a full DCF analysis of Microsoft using nothing but ChatGPT + Perplexity.

Here’s the exact step-by-step process I used:

🔹 Prompt 1: Analyze Microsoft’s financial statements (growth, margins, efficiency, FCF, CapEx…)
✅ Result: Comprehensive overview with segment insights

🔹 Prompt 2: Find expert & Wall Street growth forecasts
✅ Result: Analyst consensus (Morgan Stanley, etc.)

🔹 Prompt 3: Build a 10-year FCF projection with my assumptions
✅ Result: Detailed forecast

🔹 Prompt 4: Calculate WACC
✅ Result: ~10% (cross-checked in Perplexity)

🔹 Prompt 5: Run full DCF valuation (enterprise + equity)
✅ Result: ~$2T equity value, implied share price ~$266

📊 The Numbers:

Market cap today: ~$3T
AI DCF valuation: ~$2T
Share price gap: ~$266 vs ~$500

⚡ Game-changer moment:
With one prompt, I got a sensitivity analysis that showed exactly which assumptions (growth, margins, WACC) would close the valuation gap.
What once required hours of Excel modeling was now instant.

This isn’t job displacement. It’s job evolution.
AI handles the technical execution — but strategic thinking, assumptions, and interpretation remain 100% human.

👉 Would you trust AI for valuations — or do you still prefer traditional models?

Interested in how AI can revolutionize finance?

Join my LIVE Masterclass on September 16th to learn how to leverage AI in financial modeling. You’ll get the chance to ask me anything live!

👉 Register here: https://luma.com/452qfb28

See you live! Let’s take finance to the next level with AI! 💡📊