Discover how you can advance your career with classes in front end, back end, and full stack development. Learn about the various career opportunities available in these fields and how the right training can prepare you for success.
Key Insights
- Classes in front end, back end, and full stack development can significantly enhance your skills and open up numerous career opportunities.
- Front end development focuses on the user interface and user experience, making it an essential aspect of any digital product or service.
- Back end development, on the other hand, deals with the server-side of applications, ensuring that the system, application, and server are working smoothly together.
- Full stack development combines both front end and back end development, providing a comprehensive understanding of the entire web development process.
- Various training programs and courses are available to help you gain the necessary skills and knowledge in these areas.
- With the right training, you can pursue careers in various fields such as software development, web design, database administration, and more.
Video Transcription:
Full Video Transcript
So we completed step number one, filling up historical line items for income statement and balance sheet, and now we're getting to step number two: completing the cash flow statement for historical years. Let's go ahead and do that.
Cash flow statement includes cash from operations, cash from investing activities, and cash from financing activities of the company. Operating cash flow includes net income as a cash inflow, depreciation and amortization as cash inflow as well because it's a non-cash expense, and changes in working capital.
Building Cash from Operations
Let's go ahead and start with cash from operations line items. Net income I can find in the income statement I just built in row 16. My depreciation and amortization I can find also in the income statement in this model in row 10. And to find out changes in working capital, I need to complete my supporting schedules down below. Let's go ahead and do that as well.
To find change in net working capital, I would take accounts receivables, inventory, and accounts payable, calculate net working capital as a sum of accounts receivable and inventory minus accounts payable, and calculate change in net working capital year after year.
Linking Working Capital Components
So my accounts receivables I can find in my balance sheet above. I already completed it, it's row number 21. Inventory is in row 22, so all I need to do is fill down with Ctrl+D. And I can check with Ctrl+[ if I grabbed the right line item. Yes, it's inventory. F5 function, Enter to jump back. I check that I linked the right cell here, so it's all good.
Now I'm gonna go and grab accounts payable, also in the balance sheet I already filled, and that will be in row 27 of the balance sheet. Perfect. Now I can calculate net working capital as a sum of accounts receivable and inventory minus my accounts payable. Now I want to fill it all to the right for all historical years and calculate change in net working capital, which is net working capital for the current year minus net working capital for the previous year. Beautiful.
Completing the Working Capital Section
I'm going to fill it to the right as well for historical years, and now I have a change in net working capital that I can fill for my cash flow statement right here. Remember, I want changes in working capital here being negative as it's my cash outflow, so I'm gonna put a minus sign here and then grab my calculation of change in net working capital. Amazing.
Now I can calculate cash from operations as a sum of all the above. Alt+= and fill all these numbers and line items to the right for all historical years. Great job.
Cash from Investing Activities
Next is cash from investing activities. Here it includes capital expenditures, which is my cash outflow. That's why it's negative. So all I need to do is click Alt+= and fill that formula to the right. Perfect.
Cash from Financing Activities
Next is my cash from financing activities. It includes issuance and repayment of debt, dividends to common stockholders, and issuance and repayment of equity. A combination of those line items would be my cash from financing activities. So with Alt+= I'm gonna sum it up, and with Ctrl+R fill it to the right.
Calculating Net Change in Cash
Last action I want to do here is to calculate my net increase or decrease in cash by summing my cash from operations, cash from investing activities, and financing activities, and filling it all to the right for all historical years.
Great job! Here we just completed the cash flow statement for historical years, and now we are going to get to step number three to complete our assumptions for historical years. Here for the value drivers we picked...
