Welcome 😊

Thanks a lot, I am glad you enjoy the content! 😊

If you want to calculate the deferred considerations till the end, absolutely. I didn't do it, since we only needed the resulting data up to the last year in our model, CY2027

Hey Brandon, thanks for the comment! I wouldn't say it's common, it's really up to how you want to model things. And the way you model usually comes from the amount of data you have. To be honest, unless it's a specific acquisition, what I've seen most of the time is just slapping an arbitrary number for acquisitions per year. At the end of the day, it's all quite unknown if you don't have specific acquisition targets in mind, so many people prefer not to spend time modeling it.

Hey Brandon, thanks for the comment. A full CAPEX forecast might be an interesting video to make, I'll think about it. Let me know if there's something specific you'd like to get out from such a tutorial. Thanks!

Hey Brandon, thanks a lot for the positive comment, it means a lot! 😊 You can download the article in PDF from the course materials on Gumroad. Or you can see it here: magnimetrics.com/cash-conversion-cycle-analysis/

Thank you so much! 😊 I'm thrilled you enjoyed it! 🙌

I seem to have answered from another account I didn't know I had 😅 But yeah, thanks a lot for the positive comment!

It really depends on how you have your Chart of Accounts set up. If you have Cost of Sales booked on the Debit side of the Sales account, taking Net Turnover will give you only the Gross margin. Then you'll have to take Credit Turnover for income accounts and Debit for expense accounts. If you don't have cost and sales in the same accounts, taking Net TO is usually faster and better. Especially if you work with a software that doesn't allow negative Debits/Credits and shows any decreases of an account on the Credit side (as QuickBooks does), then Net TO is much better.

Thanks, Arslan, I'm glad you found it helpful! 😊

Hey here, thanks for the comment! 😊 I'm not sure I understand the question - if you want to track the actual cash flows, you wouldn't rely on an ageing analysis, as it is something we use at a certain point, so it's a snapshot, not an overview of continuous cash flows. One way to track the changes is to create an ageing analysis periodically and calculate the changes. However, this becomes a bit tricky, as apart from new invoices and settled ones, you also have jumps from category to category which pollute the overall picture. However, if you have an export of sales you can adjust the change by adding back the sales amount for each customer and be left only with the settlement as a change. Your buckets analysis won't work that well, but you'll know the overall movement and the current categories. As for tracking consecutive transactions per each customer, you can either analyze this on a per customer basis (which won't give you the full AR picture), or you can perhaps export all AR journal entries and summarize new sales/settlements per customer per day/week/month (whatever works). In my opinion, however, this should be something done separately from the ageing analysis. The AR ageing analysis, in my view, is a cash position analysis showing how well we are managing receivables and helping us identify potential issues with collectability, not a running analysis of specific customer balances and settlements. Not sure if this answers your question, but I hope it's helpful 😅

@@MintyAnalyst There is a need to capture the flows of AR from one bucket to another one so one can apply Markov Chain with absorbing states to the aging of AR to set-up bad debt reserves for financial reporting.

Hi Brandon, glad you like them! 😊

Hey, hanks for the comment, I'm happy you like the videos! 😊

You can check the sample file in this article I wrote back in the day: magnimetrics.com/accounts-receivable-aging-report-in-excel/

Hey, thanks a lot! Glad it was helpful! 😊

It's part of an Excel add-in I am developing (which has much more features now than you saw in the video!). You can check it out here: mintyanalyst.gumroad.com/l/minty-tools-for-excel

You can see all my free templates here: mintyanalyst.gumroad.com/

Thanks for the comment, happy it was helpful 😊

Ctr + D copies down the first selected cell in each column, and Ctrl + R does the same to the right.

Hey, thanks a lot, happy it is helpful! 😊

Thanks Arslan, happy if it was helpful 😊

thanks for sharing your feedback 😊 hopefully, I've gotten better over the 3.5 years since uploading this video 😅

hey, thanks for the high praise! 😊 I remember putting a lot of effort into this one, so I'm happy to hear it was useful!

Hey, I think I will, at least for now. There are three things I usually focus around - business, no-code, and Excel. However, finance is part of business and I haven't explored a lot of concepts there, so I am definitely planning on doing so.

Hey, sorry to hear that. Are you downloading the file from the Gumroad product page? Can you let me know which file you are referring to exactly? Thanks!

Yes it is.

@@510tuber “Yes it is” is not going to cut it. Remarkable calls it a “full size” keyboard but that’s been disputed by lots of users and potential buyers. There’s an ample amount of information available in online and YT reviews that prove otherwise. You can also see plainly that it is quite a bit smaller than a standard laptop keyboard. There are videos on YT showing overlays. This is, at best, 80% full sized keyboard.

Yes, it's not a full size keyboard, at the very least it doesn't have all the keys. BUT it's comparable in size to smaller laptops, and it's so well-built that it took me literally minutes to get used to it.

@@MintyAnalyst Good to know

Thanks, glad you liked it 😊

Yes, it is essentially a web app, they no longer offer native exports.

Thanks for the great comment! 😊 If you check out my channel, I actually have a 4.5 hour course on building a full financial model. Here's a link to the playlist: kzbin.info/aero/PLAwVMydA44DFAKG1Ow71sUobV9b1_iLKF

In my experience, account numbers are always unique, so using a simple vlookup/xlookup shouldn't be a problem. Or do you mean something else?

Hey Alex, glad you liked it! 😊

Hey Joey, thanks for sharing this important bit of information. Hadn't thought to check it on my company computer, so thanks for sharing!

It is definitely tiny, even for my wife's smaller hands. But it still types amazingly!

@@MintyAnalyst I just got the keyboard yesterday and I agree . It’s small but the keys are just at the right depth and they are clicky enough to be super satisfying . I am having a great time . I have been typing on it for like. 6 hours so far today. Very happy with my purchase !

Glad you like it. Kinda sucks we just got those and now there's a new remarkable with all new accessories, but it is what it is I guess 😅

@@MintyAnalyst enjoy what you have! Don’t worry about what you don’t! There’s always something next time!

@@Drivenby honestly, I don't care about the larger display or the color screen of the new remarkable, but the backlight is a game-changer, I've dreamt about it since I got the rm2 😅

Hey, thanks for the warning! I don't remember having such a screw in this paperwhite... however, I don't know where it is (it ended up breaking again and I replaced it) so I can't check for it.

Thanks, means a lot! The tool is called Excalidraw and it's completely free if you store projects locally (excalidraw.com/)

Unfortunately, I have no experience in retail, so nothing valuable to share, apart from reading online and regurgitating the same content, which makes little sense.

Glad it was helpful! 😊

I would assume they follow a similar approach. Perhaps, in a more complex scenario (e.g. a large public company), you will have a lot more analytical dimensions within accounts, so you might have to export various breakdowns and additional data to build the FS. However, the largest companies I've worked with (way smaller than Amazon, but in the hundreds of millions in revenue) have had automations in their ERPs where a combination of predefined mappings and strict journal entry controls resulted in the FS being pretty much automatically populated (with the exception of some disclosures and more specialized adjustments). However, the concept of mapping a detailed breakdown to a more aggregated view is always the same. Hope this helps 😊

If you copy-paste my scenario, leave the short generic prompts, and publish the first generation with zero editing, then it's exactly that. BUT, if you spend the time to craft the right prompts, and then spend the time to review and edit the generated text, I don't think it's spam, it's just a great time-saving tool.

@@MintyAnalyst Very much disagree, but that hardly matters.

@Charles-yq8vv I get what you mean, but at the end of the day, AI is here to stay, so we either adapt or we get left behind

@@MintyAnalyst The reality is that AI-generated content simply isn't very useful in at least most B2B marketing programs. You need to be much sharper, better targeted, and informative that AI is capable of. It'll frankly never get there. Not sure about B2C, it may be different.

Thank you! Cheers! 😊

Glad it was helpful! 😊

Glad it was helpful! 😊

Quite annoying in this one, I agree... but time has passed, I've gotten better (or at least I hope so!)

Hi, not sure what is happening, perhaps you mistyped the formula, or forgot/added another - sign? It shouldn't come out negative in this scenario.

Heh, thanks! 😊

just start from the step where the outline is being fed to the AI. You can save your outline in Google Docs or Sheets and load it from there, the same way we are adding a topic in the beginning here.

@@MintyAnalyst Sweet, that makes perfect sense now that you have explained it.

Well, it takes a lot of pre-work and prompt fine-tuning, but once you have those, it's literally one click 🧑‍💻

You have such fields as pre-defined options in Airtable. Add them there, and they will auto-populate and auto-update.

@@MintyAnalyst thanks. I have paste my problem i am solving can you please help me with that?

@@hammadyounas2688 not sure what you mean, where have you posted it?

@@MintyAnalyst you have replied there. My problem of proposal writing.

I've faced similar issues, so I know what you mean... AI is not always good in the generations. For my scenarios, I either review generations manually, or I have another ChatGPT prompt that asks the AI to review and let me know if it looks good. I give it a few examples of good generations and ask it to respond Yes/No if the generation looks okay. You can then save this Yes/No and use it to mark the ones that need further work. I hope this helps 😊

@@MintyAnalyst great can you help me with that? Basically i have column in airtable in which i write please modify the response of prompt 5. But i am unable to update the results. Can i share my example and blueprint, i am stuck in this problem. if you have any linkedin Id?

If there's a more generic question you have, you can ask it here, where others may benefit from the discussion. Other than that, unfortunately, I won't be able to review your blueprint and provide detailed help.

@@MintyAnalyst ohh but here i am unable to attached image and other things.

@@MintyAnalyst let me explain the whole . I have airtable in which i am generating whole sales propsal. I have 10 columns for prompt like prompt 1 prompt 2 ,,,, prompt 10 . In which i am writting instruction for chatGPT to generate specific section like intruction background etc. I have succesfully create whole sales proposal. But one issue i am facing that if user review manually and in Column ' Need revision ' he write generate response of prompt 3 again. Then how can i generate that response and update it with already created sales proposal.