Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show what formula was used in goal seek. A B E 3 4 5 6 7 8 9 10 11 12 13 14 D
please show what formula was used in goal seek. A B E 3 4 5 6 7 8 9 10 11 12 13 14 D Income Statement We Love Plants Inc For the year ended December 31 Particulars Details Amount Revenues Home Plant care revenue 197 329 Office Plant care revenue 65.545 Total Revenue 262.874 5 On 16 17 18 19 20 21 22 Expenses Salaries expense Payroll tax expense Rent expense Utilities expense Insurance expense Advertising expense Automobile expense Supplies expense Misc expense Total expense 72.488 9,803 7.800 1,377 7.300 23.103 35,292 24.550 8.500 182.913 23 Pretax income Income Tax expense 79.961 15,992 24 25 26 27 28 29 30 Net Income 63.969 N N N EPS 1.601 (0) Assume that the Expenses remain the same. Use Goal Seek to determine the Total Revenues required for the company to earn $2.00 per share. Save the worksheet under a different name
please show what formula was used in goal seek.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started