Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
The Budgeting Checklist!!Some of important budgeting checks and insights in one place.Hope this can help you improve your knowledge in preparation of company budget.๐ ๐๐ฒ๐น๐ฝ ๐บ๐ฒ ๐๐ต๐ฎ๐ฟ๐ฒ ๐๐ต๐ถ๐ ๐ฒ๐๐๐ฒ๐ป๐๐ถ๐ฎ๐น ๐ฐ๐ต๐ฒ๐ฐ๐ธ๐ ๐๐ถ๐๐ต ๐๐ต๐ถ๐ ๐๐ฅ๐๐ ๐๐ต๐ฒ๐ฐ๐ธ๐น๐ถ๐๐.๐ ๐ ๐ ๐๐ถ๐ธ๐ฒ, ๐ฆ๐ต๐ฎ๐ฟ๐ฒ ๐ฎ๐ป๐ฑ ๐๐ผ๐บ๐บ๐ฒ๐ป๐ ๐๐ผ ๐๐ต๐ถ๐ ๐ฝ๐ผ๐๐ ๐ฐ๐ฎ๐ป ๐ฟ๐ฒ๐ฎ๐ฐ๐ต ๐ฝ๐ฟ๐ผ๐ณ๐ฒ๐๐๐ถ๐ผ๐ป๐ฎ๐น๐ ๐๐ต๐ผ ๐๐ฎ๐ป๐ ๐๐ผ ๐น๐ฒ๐ฎ๐ฟ๐ป ๐บ๐ผ๐ฟ๐ฒ ๐ฎ๐ฏ๐ผ๐๐ ๐ฝ๐น๐ฎ๐ป๐ป๐ถ๐ป๐ด ๐ฎ๐ป๐ฑ ๐ฝ๐ฒ๐ฟ๐ณ๐ผ๐ฟ๐บ๐ถ๐ป๐ด ๐ผ๐ณ ๐ฏ๐๐ฑ๐ด๐ฒ๐.๐๐ผ ๐๐ผ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ฒ ๐ฑ๐ผ๐๐ป๐น๐ผ๐ฎ๐ฑ๐ฎ๐ฏ๐น๐ฒ ๐ฃ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ผ๐ป?๐ ๐๐ผ๐บ๐บ๐ฒ๐ป๐ ๐๐ต๐ถ๐ ๐ฝ๐ผ๐๐ ๐ถ๐ป ๐ ๐๐ถ๐น๐น ๐๐ต๐ฎ๐ฟ๐ฒ ๐ฑ๐ผ๐๐ป๐น๐ผ๐ฎ๐ฑ ๐น๐ถ๐ป๐ธ. ๐ก๐ผ ๐๐ผ๐๐ฟ ๐ฒ๐บ๐ฎ๐ถ๐น ๐ฟ๐ฒ๐พ๐๐ถ๐ฟ๐ฒ๐ฑ.๐งฟ ๐๐ฒ๐ฟ๐ฒ ๐ถ๐ ๐๐ต๐ฎ๐ ๐๐ต๐ฒ ๐๐๐ฑ๐ด๐ฒ๐๐ถ๐ป๐ด ๐๐ต๐ฒ๐ฐ๐ธ๐น๐ถ๐๐ ๐๐ป๐ฐ๐น๐๐ฑ๐ฒ๐:โถ๏ธ General checksโถ๏ธ Sales / Revenuesโถ๏ธ Variable costs / Cost of goods soldโถ๏ธ Fixed costsโถ๏ธ Headcount, payroll and employee benefitsโถ๏ธ Operating expensesโถ๏ธ Tax and Customsโถ๏ธ Loans and interest expenses โถ๏ธ CAPEXโถ๏ธ Cash flow budgetingโถ๏ธ Net working capitalโถ๏ธ Final check, reconciliation and approvalsI miss something? Let me know what you would add.๐๐ฒ๐น๐ฝ ๐บ๐ฒ ๐๐ฝ๐ฟ๐ฒ๐ฎ๐ฑ ๐๐ต๐ถ๐ ๐๐ฅ๐๐ ๐๐ต๐ฒ๐ฐ๐ธ๐น๐ถ๐๐ ๐๐ผ ๐ต๐ฒ๐น๐ฝ ๐ผ๐๐ต๐ฒ๐ฟ๐.๐ ๐๐ถ๐ธ๐ฒ, ๐๐ผ๐บ๐บ๐ฒ๐ป๐, ๐ฅ๐ฒ๐ฝ๐ผ๐๐.-------------------------I am @Bojan Radojicic Senior Partner in finance & tax international firm.โ ๐๐ผ๐น๐น๐ผ๐ ๐บ๐ฒ for more finance, accounting, reporting, M&A, IFRS and valuation ๐๐ฅ๐๐ ๐ฟ๐ฒ๐๐ผ๐๐ฟ๐ฐ๐ฒ๐.Ring the ๐ at the right of my profile and don't miss my new posts. I post each morning at 9AM (CET)#valuations #budget #budgeting #entrepreneur #cfo
395
79 Comments
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
8mo
- Report this comment
Thank you for your support and interest. You can download the Excel version at this link: https://www.wtsserbia.com/en/blog-en/budgeting-checklist/
2Reactions 3Reactions
MOHAMED DOUKOURE
Comptable
8mo
- Report this comment
mohameddoukoure048@gmail.com
1Reaction
Sohail Minhaj
CEO
8mo
- Report this comment
its really help me. pl send the pdf at microninvest@gmail.com
1Reaction
Josรฉ (Juni) Gonzรกlez Saavedra
CEO en Ops Yellow Group
8mo
- Report this comment
Yes, thanks for sharing.
1Reaction
LANDRY BECANTY BROU
Contrรดleur financier chez Tongon Sa Barrick Gold
8mo
- Report this comment
Thanks to share
1Reaction
CHARLES MACEDO
Analyst of Projects, Costs and Finance
8mo
- Report this comment
Please share PDF. Thanks
1Reaction
Shingai Dumba
Audit Supervisor at Deloitte Zimbabwe
8mo
- Report this comment
please share
1Reaction
Tony Haddad
Founder, Technica International
8mo
- Report this comment
Just in time. We are Reviewing our budgeting procedure. Pls send link to download. Thanks
1Reaction
Thomas Emerald White Scale-To-Exit Specialist
I invest in and work with businesses to grow and prepare for sale | Business turnarounds | Mergers & Acquisitions
8mo
- Report this comment
Thank you Bojan. Please share the pdf
1Reaction
To view or add a comment, sign in
More Relevant Posts
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
Why DCF is game changer in finance for 2024. Download link: https://lnkd.in/dwfkGZMyKnowing the ๐๐๐ method is essential for those looking to grow their career in:- corporate finance, - investment banking, - equity research, - corporate development and - similar fields Why is that?โถ๏ธ DCF helps decision-makers assess the value of an investment, merger, acquisition, or any project.โถ๏ธ The DCF method can be applied to a wide variety of scenariosโถ๏ธ DCF requires a understanding of a company's financials, industry, competitionโถ๏ธ DCF knowledge increase your credibility among peers and managersโถ๏ธ DCF model requires from you to analyse growth rates, discount rates, capital structure, etc.๐ฆ๐ต๐ผ๐ฟ๐๐น๐ ๐ฝ๐ฟ๐ผ๐ฐ๐ฒ๐๐ ๐ผ๐ณ ๐๐๐ ๐บ๐ฒ๐๐ต๐ผ๐ฑ ๐ถ๐:1. 3 Statement model2. Calculate free cash flows based on projections3. Calculate discounted rate4. Determine long term cash flow growth rate5. Calculate terminal value6. Calculate of DCF for both projected period and terminal period7. Calculate enterprise value8. Calculate equity value.9. Perform sensitivity analysis~~~~~~~~~This model is core of my ๐๐ผ๐ฟ๐ฝ๐ผ๐ฟ๐ฎ๐๐ฒ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ ๐ ๐ผ๐ฑ๐ฒ๐น๐ถ๐ป๐ด ๐ฃ๐ฎ๐ฐ๐ธ๐ฎ๐ด๐ฒ.If you want to grow your career and business with these must have skills, you can download my package here๐ https://lnkd.in/dwfkGZMyUse Women's Day Special Offer -60% OFF to my Masterclass! The offer ends at Sunday EOD
175
6 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
๐๐ผ ๐๐ผ๐ ๐ธ๐ป๐ผ๐ ๐๐ต๐ ๐๐ฉ๐ ๐ถ๐ ๐๐ต๐ฒ ๐บ๐ผ๐๐ ๐ถ๐บ๐ฝ๐ผ๐ฟ๐๐ฎ๐ป๐ ๐ถ๐ป๐ฑ๐ถ๐ฐ๐๐ผ๐ฟ? If you ask me, EVA is a key metric in finance because it measures ๐ง๐ต๐ฒ ๐๐ฎ๐น๐๐ฒ ๐ฎ ๐ฝ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐ ๐ฐ๐ฟ๐ฒ๐ฎ๐๐ฒ๐ ๐ฏ๐ฒ๐๐ผ๐ป๐ฑ ๐๐ต๐ฒ ๐ฟ๐ฒ๐พ๐๐ถ๐ฟ๐ฒ๐ฑ ๐ฟ๐ฒ๐๐๐ฟ๐ป ๐ผ๐ป ๐ถ๐๐ ๐ฐ๐ฎ๐ฝ๐ถ๐๐ฎ๐น. It's essentially a measure of a company's financial performance based on the residual wealth calculated by deducting its cost of capital from its operating profit, adjusted for taxes on a cash basis.๐๐ฉ๐ ๐๐๐ฎ๐ฏ๐ถ๐น๐ถ๐๐โ Focus on value creationโ Incorporates cost of capitalโ Decision-making toolโ Long-term perspectiveโ Alignment with shareholder interests๐๐ผ๐ ๐๐ผ ๐ฐ๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ฒ1๏ธโฃ Net operating profit after tax = Sales โ all operating expenses โ corporate income tax2๏ธโฃ Invested capital : Capital expenditures + increase in net working capital3๏ธโฃ Calculate cost of capital (WACC)4๏ธโฃ EVA=Net Operating Profit After Taxes (NOPAT)โ(Capital Employed ร WACC) where WACC๐๐ผ๐ ๐๐ผ ๐ถ๐ป๐๐ฒ๐ฟ๐ฝ๐ฟ๐ฒ๐โ EVA is calculated for each year. โ With exception of first year in each of the following years, EVA is positive, which means Company made profit beyond the cost of capital on this project in each year. โ In case EVA is negative, it means that project profit is not sufficient to cover the costs of capital._____________________๐ EVA model is a part of only one modeling cluster in my finance modeling course. Follow all 35 lessons and 50 modeling spreadsheets:https://lnkd.in/dZwwg6WjUse Women's Day Special Offer -60% OFF to my Masterclass! The offer ends at Sunday EODGood Luck!
558
43 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
Imagine you own a delicious bakery, "Brenda's Bread Basket." Business is good, but you want to know: 1. ๐๐ข๐ฏ ๐ ๐ข๐ง๐ง๐ฐ๐ณ๐ฅ ๐ต๐ฐ ๐ฆ๐น๐ฑ๐ข๐ฏ๐ฅ? 2. ๐๐ช๐ญ๐ญ ๐ ๐ฉ๐ข๐ท๐ฆ ๐ฆ๐ฏ๐ฐ๐ถ๐จ๐ฉ ๐ค๐ข๐ด๐ฉ ๐ฐ๐ฏ ๐ฉ๐ข๐ฏ๐ฅ ๐ต๐ฐ ๐ฃ๐ถ๐บ ๐ฏ๐ฆ๐ธ ๐ฆ๐ฒ๐ถ๐ช๐ฑ๐ฎ๐ฆ๐ฏ๐ต? 3. ๐๐ฉ๐ข๐ต ๐ธ๐ช๐ญ๐ญ ๐ฎ๐บ ๐ฑ๐ณ๐ฐ๐ง๐ช๐ต๐ด ๐ญ๐ฐ๐ฐ๐ฌ ๐ญ๐ช๐ฌ๐ฆ ๐ฏ๐ฆ๐น๐ต ๐บ๐ฆ๐ข๐ณ?๐๐ฒ๐ฟ๐ฒ'๐ ๐๐ต๐ฒ๐ฟ๐ฒ ๐๐ต๐ฒ ๐บ๐ฎ๐ด๐ถ๐ฐ ๐ผ๐ณ ๐ฏ ๐๐๐ฎ๐๐ฒ๐บ๐ฒ๐ป๐ ๐ฝ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐๐ถ๐ผ๐ป๐ ๐ฐ๐ผ๐บ๐ฒ๐ ๐ถ๐ป! โก๏ธ Chapter 1:Your Bakery's Profit PotentialThis chapter forecasts how much money your bakery will bring in from selling bread, pastries, and coffee (revenue) and how much you'll spend on ingredients, rent, and staff (expenses). Will your projected revenue exceed your expenses, resulting in a profit and how much?๐๐ ๐ฎ๐บ๐ฝ๐น๐ฒ: ๐ ๐ฐ๐ถ ๐ฎ๐ช๐จ๐ฉ๐ต ๐ฑ๐ณ๐ฐ๐ซ๐ฆ๐ค๐ต ๐ข 10% ๐ช๐ฏ๐ค๐ณ๐ฆ๐ข๐ด๐ฆ ๐ช๐ฏ ๐ด๐ข๐ญ๐ฆ๐ด ๐ฏ๐ฆ๐น๐ต ๐บ๐ฆ๐ข๐ณ, ๐ญ๐ฆ๐ข๐ฅ๐ช๐ฏ๐จ ๐ต๐ฐ ๐ฉ๐ช๐จ๐ฉ๐ฆ๐ณ ๐ณ๐ฆ๐ท๐ฆ๐ฏ๐ถ๐ฆ. ๐๐ถ๐ต ๐ช๐ง ๐บ๐ฐ๐ถ ๐ข๐ญ๐ด๐ฐ ๐ฑ๐ญ๐ข๐ฏ ๐ต๐ฐ ๐ฉ๐ช๐ณ๐ฆ ๐ข๐ฏ ๐ฆ๐น๐ต๐ณ๐ข ๐ฃ๐ข๐ฌ๐ฆ๐ณ, ๐บ๐ฐ๐ถ๐ณ ๐ฆ๐น๐ฑ๐ฆ๐ฏ๐ด๐ฆ๐ด ๐ฎ๐ช๐จ๐ฉ๐ต ๐ณ๐ช๐ด๐ฆ ๐ต๐ฐ๐ฐ. ๐๐ฏ๐ข๐ญ๐บ๐ป๐ช๐ฏ๐จ ๐ต๐ฉ๐ช๐ด ๐ฉ๐ฆ๐ญ๐ฑ๐ด ๐บ๐ฐ๐ถ ๐ด๐ฆ๐ฆ ๐ช๐ง ๐ต๐ฉ๐ฆ ๐ฆ๐น๐ต๐ณ๐ข ๐ด๐ข๐ญ๐ฆ๐ด ๐ธ๐ช๐ญ๐ญ ๐ค๐ฐ๐ท๐ฆ๐ณ ๐ต๐ฉ๐ฆ ๐ข๐ฅ๐ฅ๐ฆ๐ฅ ๐ค๐ฐ๐ด๐ต.โก๏ธ Chapter 2:A Snapshot of Your Bakery's WealthThink of this as a picture of your bakery's finances at a specific future date. It shows what you'll own (assets) like ovens and flour, what you'll owe (liabilities) like rent payments, and how much money you'll have reinvested in the business (owner's equity).โก๏ธ Chapter 3:Your Bakery's Cash Flow Rhythm๐ ๐ฐ๐ถ ๐ฎ๐ช๐จ๐ฉ๐ต ๐ฑ๐ณ๐ฐ๐ซ๐ฆ๐ค๐ต ๐ด๐ต๐ณ๐ฐ๐ฏ๐จ ๐ค๐ข๐ด๐ฉ ๐ง๐ญ๐ฐ๐ธ ๐ง๐ณ๐ฐ๐ฎ ๐ด๐ข๐ญ๐ฆ๐ด, ๐ข๐ญ๐ญ๐ฐ๐ธ๐ช๐ฏ๐จ ๐บ๐ฐ๐ถ ๐ต๐ฐ ๐ช๐ฏ๐ท๐ฆ๐ด๐ต ๐ช๐ฏ ๐ต๐ฉ๐ข๐ต ๐ฏ๐ฆ๐ธ ๐ฐ๐ท๐ฆ๐ฏ (๐ฑ๐ฐ๐ด๐ช๐ต๐ช๐ท๐ฆ ๐ค๐ข๐ด๐ฉ ๐ง๐ญ๐ฐ๐ธ ๐ง๐ณ๐ฐ๐ฎ ๐ฐ๐ฑ๐ฆ๐ณ๐ข๐ต๐ช๐ฐ๐ฏ๐ด). ๐๐ฉ๐ช๐ด ๐ฉ๐ฆ๐ญ๐ฑ๐ด ๐บ๐ฐ๐ถ ๐ด๐ฆ๐ฆ ๐ช๐ง ๐บ๐ฐ๐ถ ๐ค๐ข๐ฏ ๐ณ๐ฆ๐ข๐ญ๐ช๐ด๐ต๐ช๐ค๐ข๐ญ๐ญ๐บ ๐ข๐ง๐ง๐ฐ๐ณ๐ฅ ๐ต๐ฉ๐ฆ ๐ฑ๐ถ๐ณ๐ค๐ฉ๐ข๐ด๐ฆ ๐ธ๐ช๐ต๐ฉ๐ฐ๐ถ๐ต ๐ฏ๐ฆ๐ฆ๐ฅ๐ช๐ฏ๐จ ๐ข ๐ญ๐ฐ๐ข๐ฏ.~~~~~~~~By reading these 3 financial "chapters" together, you can gain a powerful understanding of your bakery's :๐ฝ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐๐ฒ๐ฑ ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐ต๐ฒ๐ฎ๐น๐๐ต. This empowers you to make informed decisions for a sweeter future!~~~~~~~~๐Build your model โ Ensure sustainable growth โ Improve your income. Start with these lessons:https://lnkd.in/dcrCTxBz๐ช๐ต๐ฎ๐ ๐ถ๐ ๐ถ๐ป?๐ 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/dcrCTxBz
388
22 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
Why inventory planning at each level is important:๐ฅ๐ฎ๐ ๐ ๐ฎ๐๐ฒ๐ฟ๐ถ๐ฎ๐น๐โข Prevents production delaysโข Avoids overstocking.โข Helps keep the right amount on hand.๐ช๐ผ๐ฟ๐ธ-๐๐ป-๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฒ๐๐ (๐ช๐๐ฃ)โข Identifies bottlenecks.โข Helps to streamline the production process and reduce waste.๐๐ถ๐ป๐ถ๐๐ต๐ฒ๐ฑ ๐๐ผ๐ผ๐ฑ๐โข Meets customer demand.โข Prevents stockouts.๐ง๐ต๐ถ๐ ๐ถ๐ ๐๐๐ฒ๐ฝ ๐ฏ๐ ๐๐๐ฒ๐ฝ ๐ด๐๐ถ๐ฑ๐ฒ:โ Split inventories to 3 levels: Raw materials, WIP and Finished Goodsโ Cost of material is associated with Raw material planning, COGS is associated with WIP and FG planningโ Input historical figures of cost of material and COGS and inventoriesโ Calculate days on hand for each type of inventoriesโ Input forecast of cost for material and COGSโ Make best estimate for each type of DOHs for next periodโ Calculate inventories level based on formulas~~~~~~~~As part of working capital inventory planning is only one of the topics in my ๐๐ผ๐ฟ๐ฝ๐ผ๐ฟ๐ฎ๐๐ฒ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ ๐ ๐ผ๐ฑ๐ฒ๐น๐ถ๐ป๐ด ๐ฃ๐ฎ๐ฐ๐ธ๐ฎ๐ด๐ฒ.๐๐ฒ๐ฎ๐ฟ๐ป ๐บ๐ผ๐ฟ๐ฒ ๐ฎ๐ป๐ฑ ๐ฐ๐ต๐ฒ๐ฐ๐ธ ๐๐ต๐ฒ ๐ผ๐๐ต๐ฒ๐ฟ ๐น๐ฒ๐๐๐ผ๐ป๐.๐ https://lnkd.in/eN3Y_bzUUse Women's Day Special Offer -60% OFF to my Masterclass! The offer ends at Sunday EOD
59
5 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
Want more cash flow?This is a pre-lesson and good foundation for the magical formula of cash flow increase.Let's forecast NWC~~~~~~~๐๐ป๐ฝ๐๐๐ ๐ฎ๐ป๐ฑ ๐ฎ๐๐๐ฒ๐๐๐บ๐ฒ๐ป๐:Sales - historical dataSales - forecastCogs (or inventory turnover) - historical dataCogs - forecastDays sales outstanding - historical dataDays sales outstanding- forecastDays inventory outstanding - historical dataDays inventory outstanding- forecastDays payable outstanding - historical dataDays payable outstanding- forecast~~~~~~๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐:Apply a formula for calculation of:Account receivables (AR)Inventory (I)Account payables (AP)~~~~~~๐๐บ๐ฝ๐ฎ๐ฐ๐ ๐ผ๐ณ ๐ณ๐๐๐๐ฟ๐ฒ ๐ฐ๐ฎ๐๐ต ๐ณ๐น๐ผ๐AR increase = CF negative impact (decrease)I Increase = CF negative impact (decrease)AP increase = CF positive impact (increase)~~~~~~๐ Use my ๐๐ผ๐ฟ๐ฝ๐ผ๐ฟ๐ฎ๐๐ฒ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ ๐ ๐ผ๐ฑ๐ฒ๐น๐ถ๐ป๐ด ๐ฃ๐ฎ๐ฐ๐ธ๐ฎ๐ด๐ฒ and start improving your cash flows and financial health today ๐https://lnkd.in/dtcNgp47
567
27 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
Top excel functions for financial modelers.But, remember!!๐๐ ๐ฐ๐ฒ๐น ๐๐ฆ ๐ก๐ข๐ง ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ ๐บ๐ผ๐ฑ๐ฒ๐น๐ถ๐ป๐ด. That is just a tool that can help us transfer our strategic thoughts into sheets. And sometimes it can help a lot. When it come to the excel functions, this is my choice:IF FV PV IRR NPVPMTSUMRATE XNPVSUMIF STDEV MATCH VLOOKUPCOUNTIF IFERRORAVERAGECUMIPMT EOMONTH CUMPRINC INDEX & MATCH~~~~~~~ ๐ If you are readyto transform your career with finance modeling skills start with these 35 lessons and 50+ modeling spreadsheets: ๐ช๐ต๐ฎ๐ ๐ถ๐ ๐ถ๐ป?๐ 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/daWyvX6r๐ฃ๐ฟ๐ถ๐ฐ๐ฒ? Likebusiness lunch for three.
298
18 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
Building a three-statement model that just won't reconcile? You're not alone. But the solution might be closer than you think. ๐จ๐ป๐ฑ๐ฒ๐ฟ๐๐๐ฎ๐ป๐ฑ๐ถ๐ป๐ด ๐ฎ๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐ฝ๐ฟ๐ถ๐ป๐ฐ๐ถ๐ฝ๐น๐ฒ๐ ๐ถ๐ ๐๐ต๐ฒ ๐บ๐ถ๐๐๐ถ๐ป๐ด ๐ฝ๐ถ๐ฒ๐ฐ๐ฒ ๐๐ผ ๐๐ป๐น๐ผ๐ฐ๐ธ๐ถ๐ป๐ด ๐ฟ๐ผ๐ฏ๐๐๐ ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐บ๐ผ๐ฑ๐ฒ๐น๐!Financial statements aren't isolated entities. They work together like a well-oiled machine. Achange in revenue (income statement) impacts your cash flow (cash flow statement) and asset levels (balance sheet). Accounting knowledge equips you to build these crucial connections within your model, ensuring it reflects the true financial picture.โก๏ธ ๐๐ฒ๐ฟ๐ฒ'๐ ๐ต๐ผ๐ ๐ฎ๐ฐ๐ฐ๐ผ๐๐ป๐๐ถ๐ป๐ด ๐ธ๐ป๐ผ๐๐น๐ฒ๐ฑ๐ด๐ฒ ๐ฒ๐บ๐ฝ๐ผ๐๐ฒ๐ฟ๐ ๐๐ผ๐๐ฟ ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐บ๐ผ๐ฑ๐ฒ๐น๐ถ๐ป๐ด:๐๐ผ๐ป๐ป๐ฒ๐ฐ๐๐ ๐๐ต๐ฒ ๐๐ผ๐๐: You'll understand how seemingly separate transactions ripple through all three statements. For example, increased sales lead to higher accounts receivable and ultimately impact your cash flow.๐ ๐ฎ๐ถ๐ป๐๐ฎ๐ถ๐ป๐ ๐๐ฐ๐ฐ๐๐ฟ๐ฎ๐ฐ๐: Accounting principles guide you in setting up formulas and relationships, preventing nonsensical outputs and ensuring a model that makes sense.~~~~~~~~~~~๐Ready to take your financial modeling skills to the next level? Start here: ๐ https://lnkd.in/dGZmHGfxP.S.What's your biggest challenge when building financial models? Share your thoughts in the comments!
670
28 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
Don't miss these very essential calculations and concepts. This Cheat Sheet show the impactful financial model and how to learn essentials of corporate finance. Learn crucial finance principles given through real example and calculations. ๐ ๐๐ฒ๐น๐ฝ ๐บ๐ฒ ๐๐ต๐ฎ๐ฟ๐ฒ ๐๐ต๐ถ๐ ๐ฐ๐ผ๐ฟ๐ฝ๐ผ๐ฟ๐ฎ๐๐ฒ ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ ๐ถ๐ป๐๐ถ๐ด๐ต๐๐ ๐๐ถ๐๐ต ๐๐ต๐ถ๐ ๐๐ฅ๐๐ ๐๐ต๐ฒ๐ฎ๐ ๐ฆ๐ต๐ฒ๐ฒ๐.๐ ๐ ๐ ๐๐ถ๐ธ๐ฒ, ๐ฆ๐ต๐ฎ๐ฟ๐ฒ ๐ฎ๐ป๐ฑ ๐๐ผ๐บ๐บ๐ฒ๐ป๐ ๐๐ผ ๐๐ต๐ถ๐ ๐ฝ๐ผ๐๐ ๐ฐ๐ฎ๐ป ๐ฟ๐ฒ๐ฎ๐ฐ๐ต ๐ฝ๐ฟ๐ผ๐ณ๐ฒ๐๐๐ถ๐ผ๐ป๐ฎ๐น๐ ๐๐ต๐ผ ๐๐ฎ๐ป๐ ๐๐ผ ๐น๐ฒ๐ฎ๐ฟ๐ป ๐บ๐ผ๐ฟ๐ฒ ๐ฎ๐ฏ๐ผ๐๐ ๐ฐ๐ผ๐ฟ๐ฝ๐ผ๐ฟ๐ฎ๐๐ฒ ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ, ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐๐๐ฎ๐๐ฒ๐บ๐ฒ๐ป๐๐, ๐ฎ๐ป๐ฎ๐น๐๐๐ถ๐ ๐ฎ๐ป๐ฑ ๐ฟ๐ฒ๐ฝ๐ผ๐ฟ๐๐ถ๐ป๐ด.๐๐ผ ๐๐ผ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ฒ ๐ฑ๐ผ๐๐ป๐น๐ผ๐ฎ๐ฑ๐ฎ๐ฏ๐น๐ฒ ๐ฃ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ผ๐ป?๐ ๐๐ผ๐บ๐บ๐ฒ๐ป๐ ๐๐ต๐ถ๐ ๐ฝ๐ผ๐๐ ๐ผ๐ฟ ๐๐ ๐บ๐ฒ๐ ๐๐ถ๐น๐น ๐๐ต๐ฎ๐ฟ๐ฒ ๐ฑ๐ผ๐๐ป๐น๐ผ๐ฎ๐ฑ ๐น๐ถ๐ป๐ธ.๐งฟ ๐ช๐ต๐ฎ๐ ๐ถ๐ ๐ถ๐ป๐น๐ฐ๐๐ฑ๐ฒ๐ฑโถ๏ธ Get started withFinancial statement presentationโข Balance sheetโข Profit and loss accountโข Cash flow statement (indirect method)โถ๏ธ Historical ratio analysisโข Liquidity ratiosโข Profitability ratiosโข Activity / efficiency ratiosโข Ratios of financial structureโถ๏ธ Revenue forecastโถ๏ธ COGS forecastโถ๏ธ Fixed and variable overhead cost forecastโถ๏ธ Net working capital forecastโข DSO calculationโข DPO calculationโข DIO calculationโข Account receivable forecastโข Account payable forecastโข Inventories forecastโถ๏ธ CAPEX forecastโข Forecast of tangible and intangible assetsโข Forecast of depreciation and amortizationโถ๏ธ Financial liabilities forecastโถ๏ธ Balance sheet forecastโถ๏ธ P&L forecastโถ๏ธ Cash flow statement forecastโถ๏ธ Breakeven forecastโถ๏ธ Vertical P&L analysisโถ๏ธ Horizontal P&L analysisโถ๏ธ Weighted average cost of capital (WACC) forecastโถ๏ธ Valuation based on discounted cash flowsI missed something? Let me what to add and I will approach this in new version.--------------------------๐ Life in finance is busy. Deadlines, tons of spreadsheets, management pressure lead to chronic stress. I specialize in helping finance pros avoid chaos and focus on what matters. Start with building sustainable financial model:๐https://lnkd.in/dkA2qcKN
281
40 Comments
Like CommentTo view or add a comment, sign in
-
Bojan Radojicic
Finance Modeling Coach. Helping Finance Pros Make More Money with Impactful Finance Models & Trainings.
- Report this post
A dollar today is worth more than a dollar tomorrow. This concept, known as the time value of money (TVM), is crucial for making informed financial decisions.Why is TVM important?โก๏ธ๐๐ข๐ณ๐ฏ๐ช๐ฏ๐จ ๐๐ฐ๐ต๐ฆ๐ฏ๐ต๐ช๐ข๐ญMoney can grow through investments, generating interest or returns over time. A dollar invested today can be worth more in the future due to this growth potential.โก๏ธ๐๐ฏ๐ง๐ญ๐ข๐ต๐ช๐ฐ๐ฏInflation erodes purchasing power. A dollar received later buys less than a dollar received today due to rising prices.โก๏ธ๐๐ฑ๐ฑ๐ฐ๐ณ๐ต๐ถ๐ฏ๐ช๐ต๐บ ๐๐ฐ๐ด๐ตEvery financial decision involves an opportunity cost. Choosing one option means sacrificing the potential benefits of another. TVM helps compare options by considering the timing of cash flows.๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐ฝ๐ฟ๐ผ๐ณ๐ฒ๐๐๐ถ๐ผ๐ป๐ฎ๐น๐ ๐น๐ฒ๐๐ฒ๐ฟ๐ฎ๐ด๐ฒ ๐ง๐ฉ๐ ๐ถ๐ป ๐๐ฎ๐ฟ๐ถ๐ผ๐๐ ๐๐ฎ๐๐:๐๐ป๐๐ฒ๐๐๐บ๐ฒ๐ป๐ ๐๐ป๐ฎ๐น๐๐๐ถ๐TVM helps assess the true value of future cash flows from an investment, allowing for informed decisions about which opportunities to pursue.๐๐ผ๐ฎ๐ป ๐๐๐ฎ๐น๐๐ฎ๐๐ถ๐ผ๐ปWhen evaluating loans, TVM helps determine the true cost of borrowing, considering interest repayments and the time value of money.๐ฅ๐ฒ๐๐ถ๐ฟ๐ฒ๐บ๐ฒ๐ป๐ ๐ฃ๐น๐ฎ๐ป๐ป๐ถ๐ป๐ดTVM is crucial for calculating future retirement needs and setting appropriate savings goals to ensure financial security.~~~~~~~~~~๐ PS. "You can't predict the future, but you can create it" P. Drucker. Use my ๐๐ผ๐ฟ๐ฝ๐ผ๐ฟ๐ฎ๐๐ฒ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ฒ ๐ ๐ผ๐ฑ๐ฒ๐น๐ถ๐ป๐ด ๐ฃ๐ฎ๐ฐ๐ธ๐ฎ๐ด๐ฒ and start creating your financial health today: ๐https://lnkd.in/dAmbWbTD
949
23 Comments
Like CommentTo view or add a comment, sign in
161,293 followers
- 1,479 Posts
- 16 Articles
View Profile
FollowMore from this author
- Best Time Tracking Software Solutions for Maximum Productivity and Profitability in 2024 Bojan Radojicic 3w
- WTS Srbija u potrazi za novim ฤlanovima tima Bojan Radojicic 5y
- WTS Trening : Sastavljanje poreskog bilansa Bojan Radojicic 6y
Explore topics
- Sales
- Marketing
- Business Administration
- HR Management
- Content Management
- Engineering
- Soft Skills
- See All