Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative.
· 21.01.2024 · 18:09:09 ··· ··· Sunday ·· 7 (0)
David Johnk Financial Income statement calculations in Excel.
It involves calculating various financial metrics such as gross profits, EBITDA, Net Income, EBT, and Depreciation expense.
0:00 Intro
0:30 Problem intro
1:40 Calculate gross profits
1:50 Calculate EBITDA
2:30 Solve for Net Income
2:45 Solve for EBT using algebra
3:40 Solve for EBT using Excel Goal Seek
5:44 Solve for Depreciation expense
· 01.01.1970 · 01:00:00 ···
0**##
· 01.01.1970 · 01:00:00 ···
# · 01.01.1970 · 01:00:00 ···
* · 01.01.1970 · 01:00:00 ···
* · 01.01.1970 · 01:00:00 ···
********
