Financial modeling using Excel
5:44
Пікірлер
@TavernsnWyverns
@TavernsnWyverns 11 сағат бұрын
Saved me a lot of work and with a quick and simple explanation. Thank you.
@Hoctienganh2018
@Hoctienganh2018 2 күн бұрын
Hi master, could you explain to me why we plant cost in T 24 in the minute 10:30th equals 60,000? However, we have the plant cost = 600,000. Is the plant cost = 60,000 its value in a year?
@kadianscott1709
@kadianscott1709 2 күн бұрын
Thank you !!!
@mihailwarsavski8849
@mihailwarsavski8849 4 күн бұрын
Hey man, I just wanna say I appreciate you making this video. I have an exam in one month and I am about 10 chapters behind 💀💀 in short I haven’t learned a single thing yet and only done 6 short practice questions from the introductory chapter. I will be forever grateful if this helps me pass. I look forward to learning. Btw any tips? 😅 I am cooked
@LearnAccountingFinance
@LearnAccountingFinance 4 күн бұрын
10 chapters behind? You must up to alot of fun 😉 What course are you taking? Do you have access to past exams. That is usually the best source when preparing for exams. Thanks for the comment.
@SBCEmployment
@SBCEmployment 5 күн бұрын
Thank you very much
@LearnAccountingFinance
@LearnAccountingFinance 4 күн бұрын
You're welcome!
@saravanaprabhu3931
@saravanaprabhu3931 7 күн бұрын
Thanks
@chrisorwoba9866
@chrisorwoba9866 7 күн бұрын
Quite informative. Thank you.
@Hoctienganh2018
@Hoctienganh2018 8 күн бұрын
Good morning Master, could you explain to me what formula is in R7?
@LearnAccountingFinance
@LearnAccountingFinance 7 күн бұрын
:) A little hard for me to remember. Could you timestamp the moment in video you are referring to. Thanks
@Hoctienganh2018
@Hoctienganh2018 7 күн бұрын
@@LearnAccountingFinance I'm sorry to make you awkward. The formula I want to ask is at the minute 8th - R7 cell
@LearnAccountingFinance
@LearnAccountingFinance 6 күн бұрын
@@Hoctienganh2018 Oh OK. Look at 08:19. This is the Original Cost of the Fixed asset minus accumulated depreciation which is equal to Net book value. Every month, depreciation is recorded to allocate cost of Fixed assets to P&L over the useful life of asset. The Formula calculates the current book value after accumulated depreciation is deducted from the original cost of asset. In short, the formula is "Original cost - Accumulated depreciation"
@ragulragul50
@ragulragul50 8 күн бұрын
Superb explanation 🎉
@LearnAccountingFinance
@LearnAccountingFinance 8 күн бұрын
Thank you!
@ShabanaBeegam-tl9vd
@ShabanaBeegam-tl9vd 9 күн бұрын
Hai sir, Could you please provide me your mail id I would like to ask for a help.
@LearnAccountingFinance
@LearnAccountingFinance 9 күн бұрын
Hello Shabana. You can reach me at [email protected]
@worldofrelaxationmusic8960
@worldofrelaxationmusic8960 9 күн бұрын
How to get the excel file you used?
@HiHi-ek1dd
@HiHi-ek1dd 11 күн бұрын
Ty
@LearnAccountingFinance
@LearnAccountingFinance 8 күн бұрын
You are welcome!
@robsolf
@robsolf 11 күн бұрын
Sweet and simple instruction. Thank you!!!
@JamesBond-qg5gx
@JamesBond-qg5gx 11 күн бұрын
I am struggling to sort a table same as your last sort procedure by standard margin but it doesn’t sort. I need highest to lowest value of standard margin without any other sort
@Hoctienganh2018
@Hoctienganh2018 12 күн бұрын
Could you tell me why in the table of minutes 20th interest expense is a debit but not a credit?. I thought that the decrease in assets was a credit
@Hoctienganh2018
@Hoctienganh2018 11 күн бұрын
Oh, now I can understand that expenses are a part of debit in the first video you have shared before 🥰
@kabeerbhatti1540
@kabeerbhatti1540 13 күн бұрын
Great, keep it up sir
@LearnAccountingFinance
@LearnAccountingFinance 12 күн бұрын
Thanks dear
@PaulineKayuni
@PaulineKayuni 14 күн бұрын
Thanks so much this has been a refresher course for me😊
@LearnAccountingFinance
@LearnAccountingFinance 14 күн бұрын
You are welcome!
@ytubesdra8103
@ytubesdra8103 18 күн бұрын
Thank you so much for the IDEA (Increase will Debit Expense and Assets).
@MeleMelelo
@MeleMelelo 18 күн бұрын
Thank you for saving my time! Subscribed!
@VJ_ExplorerUAE
@VJ_ExplorerUAE 19 күн бұрын
very clear and detailed presentation
@LearnAccountingFinance
@LearnAccountingFinance 19 күн бұрын
Thanks!
@shabushabu1727
@shabushabu1727 20 күн бұрын
Hai it would be even helper for students if you could show practical example in excel, tally, or any softwares used in the companies because there would be many student who still require practical example in software like me. Could you please provide that class which would be really helpful for real world work?
@DivineAtheistWannabe
@DivineAtheistWannabe 21 күн бұрын
Haven't worked in Accounting in a while. Came to this video as a refresher. This video is more useful than my university degree.
@hafizarifmurnal
@hafizarifmurnal 21 күн бұрын
Wonderful, masterkey for accounting
@LearnAccountingFinance
@LearnAccountingFinance 21 күн бұрын
Yes. The key is in your hand ✋️ :)
@Hoctienganh2018
@Hoctienganh2018 22 күн бұрын
Could you tell me why in the 2 entries (first and second entries) we match sales and cash/cost of sales and inventory?
@LearnAccountingFinance
@LearnAccountingFinance 19 күн бұрын
All accounting transactions are summarized into financial statements such as income statement, balance sheet and cash flow. The matching principle of accounting ensures that expenses are recorded in the same period (matched) as the related revenues. For example, if you record sales on Oct 31, and cost of sales on Nov 1st, the income statement for the month of October will reflect sales without any costs, and hence overstate the profit, while the income statement for the month of November will only reflect the costs and understate profit. That's why matching requires that sales and cost of sales for the same transaction are recorded at roughly the same time (or at least the same reporting period).
@idayichingovo3135
@idayichingovo3135 22 күн бұрын
Thank you, very straight forward
@LearnAccountingFinance
@LearnAccountingFinance 17 күн бұрын
You're welcome.
@deepm7487
@deepm7487 23 күн бұрын
Great explanation
@LearnAccountingFinance
@LearnAccountingFinance 17 күн бұрын
thanks
@debasreekar4185
@debasreekar4185 23 күн бұрын
In ledger account. Why sales account is negative?
@LearnAccountingFinance
@LearnAccountingFinance 23 күн бұрын
Most accounting systems show debit amounts as a positive number and credit amounts as a negative number. So, if you see a negative number against an account in such systems, this just shows that the balance is net credit. For revenue and income, this is the default position and what you expect to see.
@yousifdaif2038
@yousifdaif2038 23 күн бұрын
Dude you saved my life work ❤️
@LearnAccountingFinance
@LearnAccountingFinance 23 күн бұрын
Glad I could help 😉
@rafaelasantana7695
@rafaelasantana7695 24 күн бұрын
Easy to understand, very very well explained! Tks for sharing it
@LearnAccountingFinance
@LearnAccountingFinance 19 күн бұрын
Thank you ❤️
@rosihantu1
@rosihantu1 24 күн бұрын
thank you
@anupam_pandit_001
@anupam_pandit_001 26 күн бұрын
PLEASE MAKE A COURSE FINANCIAL MODELLING AND VALUATION FREE
@utrucceh
@utrucceh 28 күн бұрын
Very usefull
@LearnAccountingFinance
@LearnAccountingFinance 4 күн бұрын
Thanks.
@kamenriderkabuto224
@kamenriderkabuto224 28 күн бұрын
your calculation of Volume diff by product seems to be wrong.
@Data_and_Dollars
@Data_and_Dollars 29 күн бұрын
I went to KZbin and searched for the video "Financial Accounting for Beginners" I watched multiple videos and after spending half an hour I found your video and I love it. Your video is really best for me, first I like your video and save it in my playlist then start watching. Thank You for creating this video. Love from Inda💌
@LearnAccountingFinance
@LearnAccountingFinance 29 күн бұрын
Glad it was helpful! thank you @lesstravelboy
@jeremiahisamo6915
@jeremiahisamo6915 Ай бұрын
Well explained n summarized. I understood clearly. Thanks for this video
@LearnAccountingFinance
@LearnAccountingFinance 29 күн бұрын
Glad to hear that
@EddyMaip
@EddyMaip Ай бұрын
Can you learn me about types of jounral
@mostafashehata3094
@mostafashehata3094 Ай бұрын
How do I get the power point that used in this presentation!
@LearnAccountingFinance
@LearnAccountingFinance Ай бұрын
Download presentation and Excel files here: www.udemy.com/course/accounting-crash-course-for-busy-individuals/?couponCode=8512F315F3E1AECC7EB2
@ChantayHopkins
@ChantayHopkins Ай бұрын
Always good to study and be ready
@premchawariya6464
@premchawariya6464 Ай бұрын
🍀³³³
@Hoctienganh2018
@Hoctienganh2018 Ай бұрын
Hi, I'm a fresher, Could you please tell me what "past event" is?
@LearnAccountingFinance
@LearnAccountingFinance Ай бұрын
Hello. Past events are events or transaction that have already occurred and can include any transactions like sales, purchases, loan agreements, payments, expenses etc
@Hoctienganh2018
@Hoctienganh2018 Ай бұрын
@@LearnAccountingFinance Thanks so much
@PradeepMohanan-q2l
@PradeepMohanan-q2l Ай бұрын
Great presentation, helpful.
@vinisilva3879
@vinisilva3879 Ай бұрын
Greetings from Brazil!! Is still this course available for buying, and if it is, how could I obtain it from Brazil? Man you rocked!
@LearnAccountingFinance
@LearnAccountingFinance Ай бұрын
Thank you. Yes this course is still available at varianceanalysis.thinkific.com
@ammusrinivasan3095
@ammusrinivasan3095 Ай бұрын
Thank you for explanation
@emiliopalma9272
@emiliopalma9272 Ай бұрын
This channel is my new addiction. ❤
@aden_1811
@aden_1811 Ай бұрын
Another way which help me to remember double entry rules are DEAD (Debit expense, asset, drawing) and CLIC (Credit liability, income, capital) when they are increased, and reverse the debit and credit when they are decreased. ie. Debit liability, income and capital. Credit expense, asset and drawing
@LearnAccountingFinance
@LearnAccountingFinance Ай бұрын
That's a good one too
@Elitecontractorservices
@Elitecontractorservices Ай бұрын
Excelent Class well done and keep your great work 💯
@LearnAccountingFinance
@LearnAccountingFinance Ай бұрын
Thanks
@kellychan3023
@kellychan3023 Ай бұрын
Quick, simple, concise. Exactly what I needed!
@aelevy
@aelevy Ай бұрын
I am about to take my exam #1 for an accounting course for college and man you do a way better job explaining the fundamentals then my professor! thank you so much for keeping a consistant and solid pace and disecting each core part of the basics of accounting. You are really boosting my confidence in taking the exam!
@LearnAccountingFinance
@LearnAccountingFinance Ай бұрын
Thanks a lot and good luck with the exam.
@Prince__-of1si
@Prince__-of1si Ай бұрын
I'm in college and they literally teach all this in 1-2 years..... You managed to teach us this in few hours, I got good grades in my exams...... Schools and colleges are literally scam they can teach things quickly but they want to make as much money as they can that's the reason why they keep students for that long
@LearnAccountingFinance
@LearnAccountingFinance Ай бұрын
Thanks for sharing your experience. I agree with you. We do not really need to take that long to learn the basics and essential information. Sometimes, it's actually counter productive. But hey! you got good grades and well done for taking this course. 👏 Am I invited to the party? 🥳