1answer.
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
andre [41]
3 years ago
10

A new graduate has taken a job with an annual salary of ​$60,000. She expects her salary to go up by​ 2.5% each year for the fir

st five years. Her starting salary is stored in cell A4 of an Excel​ worksheet, and the salary increase rate is stored in cell B4. Construct a table with years 1 through 5 in cells​ A6:A10 and her salary in cells​ B6:B10. Write the formula for her salary in year 2​ (in cell​ B7) that can be copied and pasted correctly in cells B8 through B10.
Enter the formula you used in cell B7 ______.
Business
1 answer:
Nataly_w [17]3 years ago
7 0

Answer:

=B6*(1+$B$4)

Explanation:

Note: See the attached excel file for the table constructed as directed by the question.

The cell B6 for the salary in Year 1 is obtained by simply typing =A4*(1+B4) in cell B6; where,

A4 = Annual salary = $60,000

1 = 100%

B4 = Annual percentage salary increase = 2.5%

The cell B7 for the salary in Year 2 is obtained by simply typing =B6*(1+$B$4) in cell B7; where,

B6 = Salary in Year 2

$B$4 = Annual percentage salary increase in which the two dollar signs is obtained by placing the mouse cursor on B4 and then press F4 in order to lock the B4 for the rest of the years = 2.5%

Note that $B$4 allows 2.5% to be multiplied by salary in the previous years for each successive years 2 to 5.

By copying and pasting =B6*(1+$B$4), it will automatically changed to =B7*(1+$B$4), =B8*(1+$B$4), and =B9*(1+$B$4) to obtain salaries in years 3 to 5 respectively.

Therefore, the formula used in cell B7 is =B6*(1+$B$4).

Download xlsx
You might be interested in
Which of the following expressions is correct?
sp2606 [1]

Answer:

The correct answer is option B.

Explanation:

Average Total cost refers to the average cost it takes to produce one unit of the product.

It is arrived at by:

1) Determining all the costs ( variable and fixed costs) and summing them all.

Total Costs= Variable costs + Fixed Costs

2) Determining the total number of the units produced.

Therefore to establish the total average cost you will have to divide the total cost( Variable and  Fixed) with the total number of units produced.

Total Average Costs = Total cost ( variable+ fixed)/ Total units of output.

7 0
3 years ago
What is the importance of TNC for developing countries?.
Volgvan

Transnational Corporations (TNCs) have been discovered to serve international economies by acquiring multinational managerial, technical, and behavioral skills and resources, and they have made significant contributions to the economic development processes of many developed and developing countries.

What impact do TNCs have on underdeveloped countries?

Concerns about the environment - TNCs can harm the atmosphere, water, and land. Many developing countries have less stringent pollution laws than developed countries.

Why are multinational firms crucial in a country's development?

They not only bring technological advancements, but also organizational structures. Other companies can raise their management levels because national standards rise once corporations begin operating in this country. Another role can be seen in the increased circulation of money in the economy.

Learn more about Transnational Corporations (TNCs)  to visit this link

brainly.com/question/4328180

#SPJ4

8 0
1 year ago
Arturo is a sales manager for the bratney companies, a company that manufactures equipment used in the processing of grains and
Paraphin [41]

The decision must be made under conditions of <u>uncertainty/ambiguity</u> because the goal is clear but the numbers that will be used to calculate the number of sales reps will not be clear until the year is actually over.

5 0
3 years ago
Consumers have described apple's products as imaginative and up-to-date. the brand is also considered daring, changing the tradi
hoa [83]

Apple can best be described as having brand competence. he attributes represented by this brand personality are intelligence, success, reliability, and expertise. Apple is known for innovative products, reliability, and expertise in the field.

7 0
3 years ago
Finding operating and free cash flows Consider the following balance sheets and selected data from the income statement of Keith
Reil [10]

Answer:

a. NOPAT = EBIT * (1-t)

NOPAT = $2,700 * (1-0.40)

NOPAT = $1,620

b. OCF = NOPAT + Depreciation

OCF = $1,620 + $1,600

OCF = $3,220

c. FCF = Net fixed asset investment - Net current asset investment

FCF = $3,320 - $1,400 -  $1,400

FCF = $420

Note:

Net fixed asset investment = Change in net fixed assets + depreciation

= ($14,800- $ 15,000) + $1,600

= $1,400

Net current asset investment = Change in current assets - Change in accounts payable and accurals

= ($8,200 - $6,800) - {($1,600 + $200) - ($1,500 - $300)}

= $1,400

d. FCF is meaningful as it shows that OCF is able to cover Operating expenses as well as Investment in Fixed and Current Assets

4 0
3 years ago
Other questions:
  • Tax rates that place more of a burden on low-and middle-income taxpayers than on wealthier taxpayers are called ______________.
    6·1 answer
  • What is the differende between wants and needs?
    9·2 answers
  • Where did the framers meet to draft the constitution
    13·1 answer
  • Indicate what components of GDP (if any) each of the following transactions would affect. Check all that apply.
    7·1 answer
  • If a business person wants to get information about a special product to a wide variety people across a large geographic range,
    7·1 answer
  • If the elderly consume the same market basket as other people, then Social Security would have an uncertain impact on their stan
    12·1 answer
  • A marketing strategy consists of the selection and analysis of a target market and a. the examination of potential market region
    10·2 answers
  • What are the characteristics of economic globalization​
    7·2 answers
  • What are the two types of required insurance coverage to comply with florida's no-fault law?
    11·1 answer
  • A full account of an event or series of events, usually told in chronological order, is called a:_______
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!