Explore the pathways to successful careers in web development and design through comprehensive classes and training. Understand the fundamental skills required in front end, back end and full stack development to excel in your professional journey.
Key Insights
- Web development and design are expansive fields that offer plentiful career opportunities.
- Understanding the basics of front end, back end and full stack development is crucial for aspiring developers.
- Web development involves coding and programming that enables website functionality according to client needs.
- Web design is concerned with the aesthetic aspects of a website along with its usability.
- There are several classes, bootcamps, and certificate programs available to equip individuals with essential web development and design skills.
- Continuous learning and skill enhancement is the key to success in these evolving fields.
Video Transcription:
Full Video Transcript
We just completed step three by calculating historical value drivers. Now it's time to make assumptions for the forecasted years for these value drivers. When you make assumptions for the forecasted period in a three statement model, you want to take into consideration historical values, information in the MD&A and footnotes sections of the company's financial statements, and possibly do research for the industry. In addition to that, the assumptions we will determine in our model will drive the forecast for all three of our main financial statements above.
Calculating Average Historical Values for Assumptions
For simplicity and teaching purposes here, I will just take an average of the historical years for value drivers to make assumptions for my first forecasted period, 2021. So here in cell J62, I'm going to put an average formula for the previous four years. I like the formula, and I'm going to fill the formula down.
You can see that I have a break here between ranges I would like to highlight, so I'm going to use Shift plus F8 shortcut to grab several non-contiguous ranges. After that, I want to use F2 function in cell J62, then Control Enter to fill only the formulas down but not the format. Great job.
Applying Flatline Assumptions for Future Years
Now for the rest of the forecasted period, I want to assume that all of my value drivers will be the same for 2022, 2023, 2024, 2025, and 2026 as for 2021. So I'm going to use flatline here. I built the formula that cell K62 equals the previous year value in cell J62, and I will fill it down and right with Control R and Control D for the first one.
Then I will copy the formula and paste the formula only for cell K70 using Control Alt V, then F for formulas only, because F is underlined here in the Paste Special window. Enter, so my formula is inserted and I can fill it down and right as well for the next value drivers below. Great job.
Moving to Supporting Schedules
Step number four is completed, and now step number five would be to complete supporting schedules for the forecasted period.
