Financial Modeling Bootcamp: Model all 3 Financial Stmts

Project income by breaking revenue into segments with exact or rough breakouts, forecast each segment by year, then derive gross profit margin and expenses as a percent of sales.

Project income statement metrics by forecasting revenue growth, calculating gross profit margin, and modeling expenses as a percent of sales using three-year averages and blue-labeled conservative assumptions.

Compute straight line depreciation for asset purchases using cost, salvage value, and a six-year life, project five years, and link the depreciation schedule to the balance sheet.

learn to project property, plant and equipment by starting with the prior period balance, adding capital expenditures, and subtracting depreciation to derive ending PP&E and accumulated depreciation.

Model goodwill and other intangibles, allocate assets and liabilities to explain the 50 million value, and forecast annual amortization of 1.7 million.

Forecast the debt schedule by building total payments from quarterly interest and principal amortization, using notes with fixed payments and interest rates from the financial statements.

Learn to build an automated debt amortization schedule in Excel using SUMIFS to sum annual interest and principal, align with yearly cash flows, and model debt instruments up to three.

Calculate stockholder's equity for a private company by carrying forward common stock and accumulated earnings, net income minus dividends, then perform model check and link to the cash flow statement.

Tie the balance sheet to the cash flow statement and income statement, handle circular references as a normal part of modeling, and estimate interest income on cash and short-term investments.

Perform a sensitivity analysis of free cash flow using a data table to test varying sales growth and gross margins and assess the fixed charge coverage ratio.

Sensitize the fixed charge coverage ratio through data tables and scenario analysis to test loan covenants and optimize gross profit margins.

Celebrate completing the course and master core financial modeling items, including depreciation and amortization schedules. Review the solution workbook with tables and the organization schedule, and explore free resources online.