Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please show what formula was used in goal seek.

please show what formula was used in goal seek. A...

50.1K

Verified Solution

Question

Accounting

please show what formula was used in goal seek. image
image
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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Suppose your company needs to raise $55 million and you want to issue 25-year bonds for...

Finance
Q

Discuss the impact of public (government) and private controls on long term care.

Biology
Q

.Read the following scenario and answer the question in 5-10 sentences. You work for a soda shop...

General Management
Q

1- What are the various factors which affect personality development of an ind ividual? 2-Do you think it...

General Management
Q

Express the quadratic in vertex form YOU DO ROUND 1 y x 16x 71

Geometry
Q

Use traces to sketch the surface If an answer does not exist enter DNE Select...

Calculus
Q

Integrate the function f over the given region.f(x, y)=x/3+y/4 over the trapezoidal region bounded by...

Algebra
Q

13 Find the sum of the arithmetic series if a 81 a26 19 and n...

Algebra
Q

Torino Company has 2,400 shares of $10 par value, 4.5% cumulative and nonparticipating preferred stock...

Accounting
Q

ANSWERS AND SOLUTIONS PLEASE!! Kadta Waterworks is a private water company,...

Accounting
Q

Select nt Paragrah Styles Editing Vio Sentity Editor GENERAL JOURNAL khang Wei Dumplings and she...

Accounting
Q

Data concerning three of the activity cost pools of Salcido LLC, a legal firm, have...

Accounting