Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Human Resource Function Audit

Authors: Peter Reilly, Marie Strebler, Polly Kettley

1st Edition

0955970776, 978-0955970771

More Books

Students also viewed these Accounting questions