Projecting the 3 Financial Statements: The Balance Sheet

[@lisamccray6481]

Very practical information. Awesome video. Thank you. More please.

[@financialmodeling]

Thanks for watching!

[@s8glow]

Thank you for making these! They're very helpful in keeping the knowledge fresh in my head. Please keep making them!

[@financialmodeling]

s8glow Thanks for watching!

[@xiyang9726]

Thank you for saving my midterms haha!

[@financialmodeling]

Thanks for watching!

[@ajityadav7555]

I'm learning a lot from Your videos Thank u guys.....Love from India!

[@financialmodeling]

Thanks for watching!

[@anthonypeltier4039]

great video, as always 😺

[@hetaljoshi5832]

Really insightful. Thank you.

[@financialmodeling]

Thanks for watching!

[@TinaRayMusic]

Thanks for making this! I think the most confusing thing to do is the interest expense projection on the income statement. Also, days payables/receivables confuse me as well.

[@financialmodeling]

+Tina Ray The interest expense is actually easy, just multiply the rate by the beginning or average debt balance. Days Payable and Receivable are not that confusing if you understand it's really just a way of expressing AR as a % of Revenue or AP as a % of COGS or operating expenses.

[@sadri4242]

Very good video. So professional.

[@financialmodeling]

+Sadri Essafi Thanks for watching!

[@tuckebarry]

Thanks a lot! Very informative. :) God bless.

[@financialmodeling]

Tony Cipriani Thanks for watching!

[@antonykalfayan4204]

thanks for sharing. I have two related questions to this video 1) I know that changes in balance sheet items should be shown in the cashflow statement. What if when looking at the historical values I have from annual reports, the changes in B/S isn't what the CFS shows. 2) what if I have other smaller B/S items that are company specific. What if I want to project those. How do I treat them?

[@financialmodeling]

1) Yes, this is a common issue. See the Change in WC video. The short answer is, ignore it and move on with the projections and for the Working Capital line items, focus on projecting the BS versions by linking them to the IS. 2) Make them percentages of revenue or expenses.

[@danjire7605]

It is an important lecture that help me a lot. Thank you. May I request one thing that doesn't cost you nothing and will be more beneficial to me. Should you share the excel case study you've used in this video ?

[@financialmodeling]

This one's not available, but there are plenty of other example 3-statement models if you look around this channel or do a search.

[@albertml3693]

Great

[@financialmodeling]

Thanks for watching!

[@sanchita4189]

Thank you!!

[@financialmodeling]

Thanks for watching!

[@jasonlin2492]

Thank you for the video :) I have a few queries in mind. I am currently trying to project working capital in offline retail industry that is similar to Walmart (not this huge retailer) and i'm new to financial modelling. I should link AP to COGS? As the company owes the supplier for inventories. Another questions is that, for retail business their prepaid expenses are Rent for new outlets, insurance, and bulk order of supplies. Should i link these items to OPEX? As these items are needed for running the business daily.

[@financialmodeling]

If it's a retailer, yes, link AP to COGS. Yes, link Prepaid Expenses to Operating Expenses.

[@saifulisfree]

Hey Brian! I learned so much from your videos. I had a specific video request bout a concept. I understand SE + Liabilties = Assets and a balance sheet must always balance. But when you project things into the future, or decide to keep things constant, or even zero them out, how do the future projections still balance? Because if you're projecting higher numbers for one thing on the liabilities side how is it countered on the assets side? It always remained a mystery to me.

[@financialmodeling]

+saifulisfree It balances because Cash and Equity act as balancers. Net Income flows into Equity, along with a few other items such as Dividends. And then Cash at the bottom of the Cash Flow Statement reflects *all* the changes to Balance Sheet items, since the changes are all shown somewhere on the CFS. So when cash flows into the top line on the Assets side, it automatically reflects everything that has changed on the Balance Sheet, which keeps it in balance.

[@ahmad1557989]

very helpful .... keep posting nice posts

[@financialmodeling]

+Ahmad Shaheen Thanks for watching!

[@5jabicanadian]

I am preparing normalized financial statements just before I start preparing different schecules and projections. Thank you

[@lucasamorim5506]

What about CapEx? Should i just link it to change in revenue? Thanks in advance

[@financialmodeling]

That is one approach, yes. Just depends on how much information you have and how much time you want to spend on projecting that one item.

[@dbsk06]

5:26 company spend in advance of growth eg retailer. Change in wc will be negative as a % of change in revenue Company get extra money as result of its growth Eg subscription business Change in WC will be positive as a % of revenue

[@CH-sj4dr]

What forumula do you use to create the check "ok!" for when both sides of the BS balance?

[@financialmodeling]

Custom number formats in Excel... go to Ctrl + 1 and then Custom. You enter what you want for positives, negatives, 0, and text.

[@5jabicanadian]

while preparing normalized balance sheet, I took some non recurring items out of balance sheet and now my balance sheet for that particular year does not matches. it that okay for normalized balance sheet or does it still should match? by matching I mean A=L+E

[@financialmodeling]

+Jeff Singh Saini You should not be "normalizing" a Balance Sheet. You can consolidate it and simplify it, but you have to make sure that the Total Assets figure still equals what it was on the original Balance Sheet. So go back and look at your analysis again and make sure that you NEVER delete items. You can combine items, but you can't delete them.

[@5jabicanadian]

+Mergers & Inquisitions / Breaking Into Wall Street thank you for the feedback. I have put back the item that was under current assets (it was asset held for sale so I though I should take it out as it is non-recurring item). So do we just "normalize" the income statement only? and leave balance sheet and cash flow as it is under the original financial statements?

[@financialmodeling]

+Jeff Singh Saini Yes. Consolidate and simplify the BS and CFS but do not remove items entirely.

[@5jabicanadian]

+Mergers & Inquisitions / Breaking Into Wall Street thank you sir :) appreciate it.

[@giovannicongiatu1880]

Can I have the excel model? Thanks!!

[@financialmodeling]

It's not available for this one, but you can find similar 3-statement models in the channel.

[@MsNancy45]

Would be happy if you could share me the excel file.

[@financialmodeling]

Luisa Lui Thanks for your feedback. We don't make this file available, but you can find similar files elsewhere here.