SOLUTION: Auburn Career Center Income Statement for Lemonade Co Worksheet

Attached.

Question 1
Input:
Input your age:
Input your younger sibling’s age:
Question
Can you vote for president?
For how many years have you been eligible to vote?
Are both me and my younger sibling eligible to vote?

25,0
17,0
Answer
Yes
7,0
No

IF Formula
Input:
Input expected company revenue:
Input actual company revenue:

300,0
400,0

Input expected company EBITDA:
Input actual company EBITDA:

50,0
60,0

Question
Did the company exceed revenue expectations?
Did the company exceed both revenue and EBITDA expectations?

IFERROR – is “NM”
Net earnings
Shares outstanding
Earnings per share (EPS)

Answer
Ye…