3 Statement Financial Modeling: Step 1

Setting Up the Historical Income Statement

Gain insights into how specific classes can shape your career path in the front end, back end, and full stack fields. Discover how these areas intersect and the unique opportunities each presents in the job market.

Key Insights

  • Classes focused on front end, back end, and full stack development provide skills applicable to various career paths in the tech industry.
  • Prospective students can choose to specialize in one area or gain a comprehensive understanding of all three.
  • Front end classes focus on creating user interfaces and improving user experience, making them ideal for those interested in the visual aspect of websites.
  • Back end classes delve into server, application, and database interaction, presenting opportunities for careers in systems and server management.
  • Full stack courses offer a combination of front end and back end education, ideal for those wishing to understand the complete web development process.
  • These classes can be pivotal in shaping one's career path, providing the necessary skills to excel in specific tech industry roles.
Financial Modeling Bootcamp: Live & Hands-on, In NYC or Online, Learn From Experts, Free Retake, Small Class Sizes,  1-on-1 Bonus Training. Named a Top Bootcamp by Forbes, Fortune, & Time Out. Noble Desktop. Learn More.

Play video

Video Transcription:

Full Video Transcript

So let's go ahead and complete our three statement model following step by step. The very first step, as we discussed, is to derive historical information from the financial statements of the company and calculate the totals. Let's go ahead and do that. We already filled up historical information for the company for you. All we need to do is calculate the totals.

Income Statement Calculations

Let's do it for income statement first. My gross profit will be revenue minus cost of goods sold. I like the formula and I'm going to fill it to the right with Ctrl+R shortcut. My total expenses I'm going to sum up all the line items above, such as selling general and administrative expenses, research and development expenses, depreciation and amortization, and interest expenses. To calculate that total I used Alt+Equals shortcut. Beautiful.

Let's fill it to the right and calculate my income before income taxes, which is my gross profit minus total expenses. Again filling it to the right and going to the line item net income, which is my income before income taxes minus provision for income taxes. Great job, we just calculated all the totals for income statement and completed it.

Balance Sheet Asset and Liability Calculations

Now we are going into the balance sheet calculations and first we will calculate total assets. My assets listed here are cash, accounts receivable, inventory, and property plant and equipment. I'm going to sum it up with Alt+Equals and fill it to the right. For my liabilities, accounts payable and debt will be summed up. And next the sum of my equity capital and retained earnings will give me shareholders equity.

Verifying the Balance Sheet

Next step is to calculate total liabilities plus shareholders equity and check if my balance sheet is balancing, meaning that total assets equal total liabilities and shareholders equity. I'm going to use the formula total assets minus total liabilities and shareholders equity, which should give me zero if the balance sheet is balancing.

Let's go ahead and check it. I have the zero for the first historical year. I'm going to fill the formula to the right and I can see that my balance sheet is balancing for all historical years. Great job. Now I can move to step number two and fill up my cash flow statement.

Learn more in these courses

How to Learn Financial Modeling

Master financial modeling with hands-on training. Financial modeling is a technique for predicting the financial performance of a business or other type of institution over time using real-world data.

Yelp Facebook LinkedIn YouTube Twitter Instagram