A company’s data of year wise profit is provided; you have to find out how much profit the company should earn in year 2022 to get total profit of 25000? Use goal seek to solve this problem. Show all formulas used in Excel Take the screen shot of the goal seek window when display result. Year Profit 2019 5000 2000 6000 2021 7000 2022 Total Profit 18000
A company’s data of year wise profit is provided; you have to find out how much profit the company should earn in year 2022 to get total profit of 25000? Use goal seek to solve this problem. Show all formulas used in Excel Take the screen shot of the goal seek window when display result. Year Profit 2019 5000 2000 6000 2021 7000 2022 Total Profit 18000
Chapter4: Preparing And Using Financial Statements
Section: Chapter Questions
Problem 1bM
Related questions
Question
A company’s data of year wise profit is provided; you have to find out how much profit the company should earn in year 2022 to get total profit of 25000?
Use goal seek to solve this problem.
Show all formulas used in Excel
Take the screen shot of the goal seek window when display result.
Year | Profit |
2019 | 5000 |
2000 | 6000 |
2021 | 7000 |
2022 | |
Total Profit | 18000 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,