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
Gelneren [198K]
3 years ago
10

Suppose that you deposit? $10,000 in an account that pays? 6% interest and you want to know how much will be in your account at

the end of 10 years. To solve this problem in Microsoft? Excel, you would use which of the following Excel? formulas?
=FV?(.06,10,0,10000)

B.

?=PV?(.06,10,0,10000)

C.

?=PV?(.06,10000,0,10)

D.

?=FV?(.06,10000,0,10)
Business
1 answer:
dimaraw [331]3 years ago
3 0

Answer:

B.    =PV(.06,10,0,10000)

Explanation:

In MS Excel the formula of Present value re is as  "=PV( rate, nper, pmt, [fv] )".

PV = Present value

rate = Interest rate= 6% = 0.06

nper = number of periods  = 10

pmt = payment made each period = 0 in this scenario

fv = future value = 10,000

So, according to the formula the correct sequence is =PV(.06,10,0,10000)

which is correctly mentioned in option B.

You might be interested in
A visual of a map color-coded to indicate states' rates of consumer debt is an example of
AleksAgata [21]
A cosmograph simply because that is not what any of the other graphs look like. D is the only one that can take the shape of a state.
6 0
2 years ago
Read 2 more answers
When pete mills went to withdraw $5,000 from the nationwide fidelity mutual fund, he was informed that the fund would charge 5 p
ki77a [65]
250$ is 5% of $5000
5000 \times .05 = 250
3 0
2 years ago
The two most likely benefits realized from utilizing enterprise systems are improvements in ________. availability of informatio
Mazyrski [523]

Answer: availability of information and increased interaction throughout the organization

Explanation: An enterprise systems is described as an integrated suite of business applications for virtually every  department, process, and industry, that allows companies and organizations to integrate information across  operations on a company-wide basis by the use of one large database and as a result, there is an upward increase in the availability of information which leads to increased interaction across departments, processes, and industries throughout the organization.

6 0
2 years ago
Tom Johnson Manufacturing intends to increase capacity through the addition of new equipment. Two vendors have presented proposa
lilavasa [31]

Answer:

For 8,500 units, proposal A provides a higher income ($3,000).

Explanation:

Giving the following information:

Proposal A:

Fixed cost= $50,000

Unitary cost= $12

Proposal B:

Fixed cost= $70,000

Unitary cost= $10

<u>We need to choose the proposal with the higher income if 8,500 units are produced.</u>

Proposal A:

Net income= 8,500*(20 - 12) - 50,000

Net income= $18,000

Proposal B:

Net income= 8,500*(20 - 10) - 70,000

Net income= $15,000

For 8,500 units, proposal A provides a higher income ($3,000).

7 0
3 years ago
The following data are extracted from the stockholders' equity section of the balance sheet of Guthrie Corporation: 12/31/19 12/
Inessa [10]

Answer:

$14,800

Explanation:

We will get the Net Income by preparing Trial-account of Retained earnings.

                        Retained earnings

Cash dividend     $7,500       Beginning balance  $50,000

Stock dividend    $5,000       Net Income              $14,800 (Balance figure)

Ending balance   <u>$52,300</u>                                       <u>              </u>

Total                     <u>$64,800</u>                                       <u>$64,800</u>

7 0
2 years ago
Other questions:
  • Since many people have trouble programming their dvd​ players, an electronics company has developed what it hopes will be easier
    14·1 answer
  • Janelle manages a small pharmacy in Dallas, Texas. Recently, she started an initiative to help give low-income individuals steep
    9·1 answer
  • Employees who flourish report less stress and more organizational commitment and job satisfaction. they perform better, and are
    7·1 answer
  • The manufacturing costs of Mocha Industries for three months of the year are as follows: Total Cost Production April $63,100 1,1
    7·1 answer
  • During the announcement of the merger between Body Metal and​ Shimmer, the two CEOs neglected to mention that to avoid​ duplicat
    12·1 answer
  • Best Deals, Inc. has 10 units in ending merchandise inventory on December 31. The units were purchased in November for $160 each
    6·1 answer
  • A researcher would like to study the average amount of debt owed by retired people in the United States. What could be an exampl
    6·1 answer
  • Are you kfc? Bc your finger-licking good &lt;33
    7·2 answers
  • Who benefits from deducting the amount paid in state income tax from their income for purposes of computing federal income tax?
    14·1 answer
  • what feature increases the high skim value of the activity report? justified right margins bullet points indented paragraphs wha
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!