开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习