Build a Monthly Budgeting & Forecasting Model in Excel

Поделиться
HTML-код
  • Опубликовано: 3 фев 2025

Комментарии • 69

  • @KenjiExplains
    @KenjiExplains  2 месяца назад +6

    🚀 Take the Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course

    • @amarmanhas8432
      @amarmanhas8432 2 месяца назад +1

      Hi Kenji . Any Black Friday Sales we can assume ? As it is currently very expensive

  • @mohammadshafeeq3471
    @mohammadshafeeq3471 2 месяца назад +12

    We need more FP&A related videos like this ❤

  • @willemvandenberg5263
    @willemvandenberg5263 3 дня назад

    Good stuff man! Wish I had discovered your channel sooner

  • @IvanCortinas_ES
    @IvanCortinas_ES Месяц назад +1

    Superb tutorial, Kenji. Thank you.

  • @rumeeburu3648
    @rumeeburu3648 2 месяца назад +5

    Yaaay, my video is up. Time to learn!!!

  • @schubertpeter79
    @schubertpeter79 2 месяца назад

    You never disappoint Kenji! well done once again!

  • @Mohaaabdalle
    @Mohaaabdalle 2 месяца назад +1

    Finally U uploaded as U promised. Thanks for sharing such a good video. Please continue to upload finance videos using Microsoft excel.

  • @ahmedsafwan2184
    @ahmedsafwan2184 2 месяца назад +1

    i can't find enough words to xpress my gratitude and appreciation god bless you

  • @WebFanNY
    @WebFanNY 2 месяца назад +1

    Thanks for the video tutorial ❤, it looks flexible enough to use it as a structure for a little project. Im making an Excel population forecast for a sci fi book. Excel is not just for analysts but helps in writing projects too.

  • @arbazahmad7177
    @arbazahmad7177 2 месяца назад +1

    Excellent... thanks for sharing 🎉

  • @camlex6310
    @camlex6310 2 месяца назад

    Great video!! Thanks Kenji

  • @tanveerabbas3271
    @tanveerabbas3271 2 месяца назад

    great video kenji❤

  • @rafayhussain4171
    @rafayhussain4171 2 месяца назад

    Keep Growing sir!

    • @KenjiExplains
      @KenjiExplains  2 месяца назад +1

      Thank you! All the best to you too :)

  • @awonusitemitope422
    @awonusitemitope422 2 месяца назад

    Many thanks and well done.

  • @bubuA08
    @bubuA08 2 месяца назад

    learnt two really cool functions here; forecast and choose. I;m going to test to see how much forecast function in excel differs from CAGR. and it also feels like choose could replace lookup functions as well, at least in similar scenarios. really helpful video. thanks!

  • @c25d
    @c25d Месяц назад

    Excellent video as always. One recommendation: you should add some interpretation at the end of the videos. One the budget table has been finished, what actions could be made based on they data.
    That would be great

    • @KenjiExplains
      @KenjiExplains  Месяц назад

      thank you for the feedback, very valuable for me to know :)

  • @antoniop.3586
    @antoniop.3586 2 месяца назад

    Thank you very much!!

  • @shivam-hv8il
    @shivam-hv8il 7 дней назад

    Make a detailed video on FP&A role . What skills are needed

  • @alexandrunegru5534
    @alexandrunegru5534 2 месяца назад +3

    You should create one about order import from selling channels import and automatization and if you know something about power automate desktop.thank you

  • @sivaprakash8518
    @sivaprakash8518 2 месяца назад +1

    Please make a inventory management with invoice

  • @simyu04a.47
    @simyu04a.47 2 месяца назад

    Same way we can do for quarter as well by considering last date of quarters ?❤❤

  • @RohitThakur-en7qw
    @RohitThakur-en7qw 10 дней назад

    Hey Kenji why you use (Pre Tax income = Operating Income - other income/expenses) it will be Pre Tax income = Operating Income + other income/expenses) instead right?

  • @DathyGonzales
    @DathyGonzales Месяц назад

    Hi! Can you please create a forecast inventory & sales for this for template. thank you

  • @htunkyawlinn6883
    @htunkyawlinn6883 2 месяца назад

    Could you please share the excel file? Thank you so much for your guidance.

  • @م--ريم-ش1ص
    @م--ريم-ش1ص Месяц назад

    If you please we need to know more about how to calculate Wacc

  • @willzinner8813
    @willzinner8813 2 месяца назад

    Hi sir do more finance videos please

  • @MichaelReibke
    @MichaelReibke 2 месяца назад

    Cool

  • @gopinathsindhe1201
    @gopinathsindhe1201 2 месяца назад

    Hello, we are not able to see the formula for the January forecast even if we expand to full screen

  • @singatakberpura
    @singatakberpura 2 месяца назад

    Thank you Kenji

  • @LuisPérez-43
    @LuisPérez-43 2 месяца назад +34

    Hallelujah!!! I’m favored and blessed with $60,000 every week! Now I can afford anything and also support the work of God and the church.

    • @GrinterFicht
      @GrinterFicht 2 месяца назад

      Oh really? Tell me more!

    • @LuisPérez-43
      @LuisPérez-43 2 месяца назад +1

      This is what Melissa Jonas Richard does, she has changed my life.

    • @LuisPérez-43
      @LuisPérez-43 2 месяца назад

      After raising up to 60k trading with her, I bought a new house and car here in the US and also paid for my son’s (Oscar) surgery. Glory to God.shalom.

    • @GrinterFicht
      @GrinterFicht 2 месяца назад

      what’s her contact information?

    • @LarryPrestonvv
      @LarryPrestonvv 2 месяца назад

      Who is Melissa Jonas Richard?

  • @CovertOps1
    @CovertOps1 2 месяца назад

    ❤❤❤

  • @ahmedsafwan2184
    @ahmedsafwan2184 2 месяца назад

    please is there a sample sheet in excel can you sahre it to practice thank you

    • @KenjiExplains
      @KenjiExplains  2 месяца назад +1

      should be in the description :)

  • @KenleighPanjo
    @KenleighPanjo 2 месяца назад

    For base forecast - Jan 2025, using the same formula, mine comes to 27,820. How is that possible. Same formula, same data range.

  • @cbristol4906
    @cbristol4906 25 дней назад

    I don't understand why you use marketing expense divide by customer acquisition cost to get the amount for units sold. Can anyone explain please?

    • @cesarakrojas
      @cesarakrojas 18 дней назад +1

      Total amount spent on marketing efforts to acquire customers / Cost of acquiring a single customer (that leads to a unit sold) = Total units sold

    • @cbristol4906
      @cbristol4906 2 дня назад

      ​@@cesarakrojas got it. Thanks

  • @nyx1342
    @nyx1342 2 месяца назад

    Hey, I am 15 and I am very interested in to finance. Do you think I will understand your course as I lack in knowledge in this field? And my English isn’t that good to.

    • @KenjiExplains
      @KenjiExplains  2 месяца назад +1

      It's hard to say as "English isn't that good" is a bit vague. Overall, if you can understand these videos OK, then it should be alright. In terms of age, you're definitely among the younger students, but you wouldn't be the first high school student to take our courses!

  • @KaserBall
    @KaserBall 12 дней назад

    anybody else getting negative values when expanding the base forecast scenario , tried multiple times still getting negative values

  • @esthermbwambo7227
    @esthermbwambo7227 Месяц назад

    What if there is no historical figure😢

  • @jerkchicken508
    @jerkchicken508 2 месяца назад +1

    Would have really come in handy if this was uploaded earlier; I failed miserably in my Excel interview test for a Junior FP&A role lol