Gain insights into the wide array of classes and careers in web development, focusing on specific areas such as front end, back end, and full stack development. Learn about the various training programs, bootcamps, and certificate programs that can pave your path to a flourishing career in the tech industry.
Key Insights
- The tech industry offers a variety of careers in web development, including front end, back end, and full stack development.
- Various courses and training programs are available to equip you with the skills and knowledge you need in the field.
- Bootcamps and certificate programs offer in-depth training in specific web development areas.
- Front end development focuses on user interface and user experience, while back end development deals with server-side applications and databases.
- Full stack development, on the other hand, combines both front end and back end development skills.
- Choosing a specific area to specialize in depends largely on your interests and career goals in the tech industry.
Video Transcription:
Full Video Transcript
And we are at our last final step of building a three statement model. We will fill up the cash flow statement, calculate closing cash balance, link this closing cash balance to the balance sheet in the first line item, and we will see and check if our balance sheet is balancing. If yes, then our model is correct and we are good to go.
Operating Cash Flow Components
So let's start with operating cash flow. Net income line item in our cash flow statement—I can find my net income in my income statement in row 16. My depreciation and amortization I can find again in the income statement in the row.
As for changes in working capital, I'm going to go ahead to my supporting schedules and find change in net working capital in row 84. And remember, I want to convert the sign, so I put minus J. So that would be my cash outflow in my cash flow statement. And for cash from operations, I will fill the formula from the previous year.
Investing and Financing Activities
My capital expenditures I will find down below in my assumptions in row 73, and I remember that I want my CapEx in the cash flow statement being negative—it's my cash outflow—so I put a minus sign before linking the cell. Cash from investing activities, stealing the formula from the previous year.
And going into calculating financing cash flow: issuance and repayment of debt I'm going to find down below in my assumptions in row 74. And please notice that debt issuance and repayment, dividends to common stockholders, and equity issued and repaid are going one after another, as well as here in my cash flow statement. So all I need to do here is grab that formula and with Ctrl+D fill it down. And now for cash from financing totals, I will just steal the formula from the previous historical years.
Completing the Cash Flow Statement
Now I want to fill all this formula for all forecasted years, so I'm going to use F5, go to window, and highlight all the way to the cell O41. O41 in my reference line, Shift+Enter, Ctrl+R, and my cash flow statement is completed.
Calculating Closing Cash Balance
Next, I'm going to calculate my closing cash balance. Cash balance for the last historical year I will find above in row 20 in my balance sheet—it's given to me as a historical number. And then my opening cash balance will be equal to my closing cash balance. And my net increase or decrease in cash I already calculated in the previous cell—remember, it's cash from operations, investing, and financing activities. So my closing cash balance will be a sum of the two items above. Beautiful, I like that, and I'm going to fill it to the right all the way with Ctrl+R. Great job.
Final Balance Sheet Link and Model Verification
The very last step is link cash to my cash flow statement. Equals—I'm going to grab my cash closing balance I just calculated in row 58, and I'm going to fill it all the way to the right. And you can notice and congratulate us with our balance sheet being balanced. The model is successfully completed.
