answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Alex
2 years ago
15

You owe $8,000 in student loans and would like to pay it all off with your commissions. Use Goal Seek to determine the amount yo

u must sell (cell G5) in order for cell G3 (your commission) to equal $8,000 so you can fully pay off your student loans
Business
1 answer:
shutvik [7]2 years ago
3 0

Answer:

If we select G3 cell in the spreadsheet the limit will be set to $10,000

Explanation:

Goal seeking is technique used in Excel to calculate the input value that will give out the current output value. It can be used for trial or logical means. This can be referred to as what if analysis or back solving technique. In the current problem the cell G3 has the value of $8,000 that is owed as a student loan. We select the Goal seek in excel, set cell as G3 and set limit as $10,000.

You might be interested in
Netflix is an internet television network that currently boasts the worldâs largest paying membership (Source: 2015 Netflix inve
Darya [45]

Answer:

As this example illustrates, companies like Netflix must engage in <u>ONGOING STRATEGIC PLANNING</u> to remain relevant and competitive in the ever-changing environment of technology advancements, social trends, and legal regulations.

Explanation:

When a company develops a strategic plan, management is setting the business direction of the company. This means setting up a long term plan for the company to follow, but strategic plans cannot be fixed.

Strategic planning must always be an ongoing and fluid process, since markets are not static, nor your competitors will just sit around waiting for you to decide what to do. Your competition will constantly try to find ways to increase their market and lower yours, so you must respond accordingly.

In this case, Disney last year launched their own online service and that is going to be tough for Netflix, but if it isn't Disney, ti would be some other company.

4 0
2 years ago
Read 2 more answers
Why are some modular constructions exempt from the rule that buildings must be built from the ground up?
boyakko [2]
The best and most correct answer among the choices provided by the question is the second choice. Modular constructions exempt from the rule that buildings must be built from the ground up because they change regularly so they are not fixed to the ground like traditional structures.I hope my answer has come to your help. God bless and have a nice day ahead!
5 0
2 years ago
Sam's Gardening Centers has multiple stores in the northeastern United States. Sam's is considering investing in an "online" sto
NNADVOKAT [17]

Answer:

The answer is:

A), C), & D)

Explanation:

  1. An online shop means Sam's will now be able to reach a national customer base
  2. To enable Sam's reach all the customers that will now demand for its services, it will require a distribution service once it goes online
  3. With an online business come the need for online advertisement.

Cheers!

7 0
2 years ago
Robert Wilkins has prepared the following list of statements about process cost accounting. Identify each statement as true or f
Alex17521 [72]

Answer:

Identification of True or False Statements:

1. Process cost systems are used to apply costs to similar products that are mass-produced in a continuous fashion.

A. True

2. A process cost system is used when each finished unit is indistinguishable from another.

A. True

3. Companies that produce soft drinks, movies, and computer chips would all use process cost accounting.

A. True

4. In a process cost system, costs are tracked by individual jobs.select between

False

5.Job order costing and process costing track different manufacturing cost elements.

B. False

6. Both job order costing and process costing account for direct materials, direct labor, and manufacturing overhead.

A. True

7. Costs flow through the accounts in the same basic way for both job order costing and process costing.

A. True

8. In a process cost system, only one work in process account is used.

A. True

9. In a process cost system, costs are summarized in a job cost sheet.

B. False

10. In a process cost system, the unit cost is total manufacturing costs for the period divided by the equivalent units produced during the period.

A. True

Explanation:

A process costing system is a method of collecting and assigning manufacturing costs to the units produced.  It is used by companies that produce similar or identical units of product in batches employing a consistent process. The unit cost is arrived at by averaging units produced to the total cost of the process.

5 0
2 years ago
Good Investments Company forecasts a $2.44 dividend for 2017, $2.62 dividend for 2018 and a $2.77 dividend for 2019 for Mountain
Ivan

Answer:

c.$29.37

Explanation:

First and foremost, it should be borne in mind that  the intrinsic value of Mountain Vacations Corporation is the present value of its future dividends for the forecast period(2017-2019) plus the present value of dividend terminal value beyond the forecast period as shown thus:

Year 1 (2017) dividend $2.44

Year 2 (2018) dividend $2.62

Year 3  (2019) dividend $2.77

the terminal value of dividend=expected dividend per year after 2019/ cost of equity capital

expected dividend per year after 2019= $2.94

cost of equity capital =7%

terminal value=$2.94 /7%=$42.00

PV of future dividend=dividend/(1+cost of equity capital)^n

n is the year in which the future dividend is expected, it is 1 for 2017, 2 for 2018 , 3 for 2019 dividend and the terminal value(since the  terminal value is already stated in 2019 terms)

intrinsic value of share=$2.44/(1+7%)^1+$2.62/(1+7%)^2+$2.77/(1+7%)^3+$42.00/(1+7%)^3

the intrinsic value of share=$41.11

It is obvious that the options are not correct

The question's inputs are wrong

2017 dividend should have been $1.74

2018 dividend should have been $1.87

2019  dividend should have been $1.98

dividend beyond 2019 should have been $2.10

terminal value=$2.10/7%=$30.00

intrinsic value of share=$1.74/(1+7%)^1+$1.87/(1+7%)^2+$1.98/(1+7%)^3+$30.00/(1+7%)^3

intrinsic value of share=$29.36(closest to c.$29.37)

6 0
2 years ago
Other questions:
  • On January 10, 2017, a man in Lebanon, Virginia, frustrated with the DMV bureaucracy, paid his DMV bill with 300,000 pennies tha
    12·1 answer
  • When Rosalyn comes into the office, she speaks to no one, shuts her door, and is rarely seen again until lunch. She supervises a
    5·1 answer
  • What is the present value of $12,350 to be received 4 years from today if the discount rate is 5 percent?
    14·1 answer
  • An art student spends all of her income on pencils and drawing pads. The student currently buys 30 pencils at $1 each and 10 pad
    15·1 answer
  • Excavation, Inc., uses explosives to prepare land for construction projects. Strict liability is imposed on this activity becaus
    15·1 answer
  • A canned soup manufacturer has prepared questionnaires for its employees and customers. The questions are about how the people v
    7·1 answer
  • Nathan works as an accountant for a mid-sized retail store. He has just completed a trial balance that resulted in no unexpected
    14·1 answer
  • ________ CRM includes customer-facing applications such as tools for sales force automation, call center and customer service su
    14·1 answer
  • Jordan (single, age 30), a real estate broker (self-employed), had the following income and expenses:
    12·1 answer
  • óscar’s firm operates in a rapidly changing industry. he often must apply his excellent ________ to assess problems and develop
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!