시작하기무료로 시작하기

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로 하는 Financial Modeling

강의 보기

연습 안내

  • 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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작