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