開始使用免費開始

Create the sum values

After formatting the financial numbers, you will now want to update the bolded rows with formulas to create sums for the income statement.

You can use the =sum() formula to add up each subsection for Income, EBIT, and Earnings. Remember from the slides that each section includes the total from the previous section. Therefore, EBIT is the sum of Gross Operating Income, Selling & Administraiton, Depreciation, and Other Income/Expenses.

本練習屬於課程

在 Google Sheets 進行財務建模

檢視課程

練習說明

  • Add formulas in B8, B13, B17, B20, and B23.
  • Use the =sum() function to create these formulas.
  • Each sum includes the numbers in that section, plus any row total above it.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習