Explore the potential of a career in front end, back end, or full stack development with classes tailored to your specific needs. Learn about the different programming languages, tools, and technologies that fuel these careers and how you can get started on your path to success.
Key Insights
- The video highlights various classes that provide training for front end, back end, and full stack development.
- These classes cover a wide range of programming languages including but not limited to JavaScript, Python, and Ruby.
- Training is also provided on essential tools and technologies used in these areas of development, such as HTML, CSS, and databases.
- Both standalone classes and comprehensive certificate programs are available, offering flexibility for different learning needs and career goals.
- The video suggests that these classes could be beneficial for those looking to start or advance their careers in web and app development.
- Importantly, the video emphasizes the growing demand for skilled developers and the promising career opportunities in this field.
Explore this video tutorial on building a 3-statement financial model in Excel, walking through the key inputs, formulas, and assumptions for this step of the analysis.
Video Transcription:
Full Video Transcript
When filling up balance sheet forecasted years, we will leave cash blank for now. After we complete the cash flow statement and calculate closing cash balance, we will link this closing cash balance back to the balance sheet, and then our balance sheet will be balanced right here. But for now, we will leave it blank and we'll come back to it in the very final step when building the three statement model.
Accounts Receivables and Inventory Calculations
So let's go ahead and start with accounts receivables. We do have our days receivables in our assumptions in the row. I will multiply it by my revenue in my income statement in row 4 and divide by 365 days a year. I'm basically converting the formula for days receivables to calculate accounts receivables here.
Inventory follows the same logic. I'm gonna find days inventory in my assumptions below in row 71, multiplied by my cost of goods sold in my income statement in row 5, and divided by 365 days a year. For PP&E ending balance, I'm gonna go ahead into my supporting schedules all the way down in row 90 and grab PP&E ending balance from here. Trusting the steps here, and then my total assets already calculated in the previous year. I will just fill this formula to the right so it will be flowing correctly.
Liabilities and Debt Schedule
Let's go ahead and fill liabilities line items here. As for accounts payables, I will find days payables down below in my assumptions row 72, multiplied by cost of goods sold in my income statement row 5, and divide it by 365 days a year. My debt I will find again all the way down below in my debt schedule in supporting schedules I've built before. I will find it in row 95, perfect. And for total liabilities, I will take the formula from the previous year.
Equity and Retained Earnings
As for equity capital, I'm gonna take equity capital for the previous year and plus my assumption in row 76 right here for equity issued or repaid. My retained earnings ending balance I also calculated in my supporting schedules all the way down in row 101 right here, retained earnings ending balance. For shareholders equity and total liabilities and equity, I'm gonna steal the formulas to the right as well as my check for the balance sheet being balanced.
Completing the Forecasted Period
Obviously our balance sheet will not balance for now because we did not complete cash and some other line items in the cash flow statements that are crucial for us to complete. So now I'm going to fill it all the way to the right to cell O, and I will use the trick with the Go To window again. O20 in my reference cell, Shift Enter, Ctrl R, and my balance sheet for the forecasted period is ready for now. We will complete it totally after finishing the cash flow statement in the following step.
