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
The selection process in a high-involvement management organization involves selecting new hires based upon:
kherson [118]
<span>we will explore the recruiting process used by human resource managers to review applications, test and interview candidates, perform reference checks and request health checks.The hiring process is the process of reviewing applications, selecting the right candidates to interview, testing candidates, choosing between candidates to make the hiring decision and performing various pre-employment tests and checks</span>
7 0
4 years ago
Keith Inc. has 4 product lines: sour cream, ice cream, yogurt, and butter. Demand of individual products is not affected by chan
aleksley [76]

There will be decrease in profit if dropping of sour cream. So that means Keith Inc would lose $4,000.00

3 0
4 years ago
Read 2 more answers
f the unemployment rate is 8 percent, this means: a. 8 percent of the population is unemployed. b. 8 percent of the population o
hodyreva [135]

Answer:

c. 8 percent of the labor force is unemployed.

Explanation:

<em>The Unemployment Rate measures the percentage of the total labor force that is unemployed while actively seeking employment during the previous month</em>. If the unemployment rate is 8 percent, this means 8 percent of the labor force is unemployed. That also means, <u>out of all the people actively seeking employment during the previous month, 8 percent are still unemployed or jobless.</u>

3 0
3 years ago
A firm has three different production facilities, all of which produce the same product.. While reviewing the firm's cost data,
Valentin [98]

<u>Joshua is right because fixed costs are unavoidable but marginal costs are not.</u>

<u>Explanation</u>:

Decision making plays an important role while considering the development of the organization. The officials in the company should act smartly in making decisions during crucial situation.

<u>Marginal cost </u>is the cost added to the total cost while producing additional units. <u>Fixed cost </u>is the cost of the product that does not change with the increase or decrease in the quantity of the products.

In the above scenario, Jasmine and Joshua were discussing about the cost of the products that are produced in their manufacturing plants. They were discussing about the marginal cost and fixed cost.

6 0
3 years ago
The trial balance of Woods Company includes the following balance sheet accounts. Identify the accounts that might require adjus
White raven [17]

Answer:

Woods Company

Accounts Requiring Adjustment, Type of Adjusting Entry, and the Related Account:

 Account                         Type of Adjustment           Related Account

a) Account receivable  Accrued revenue              Service revenue

b) Prepaid insurance  Prepaid expense              Insurance expense

c) Equipment                   Not required                      Not required  

d) Accumulated depreciation Accrued expense       Depreciation expense

e) Notes Payable             Not required                      Not required

f) Interest Payable          Accrued expense              Interest expense

g) Unearned service revenue Unearned revenue Service revenue

Explanation:

End of period adjustments are made to accounts in order to bring them in line with the accrual concept and matching principle of accounting.  These principles require that expenses and revenues for the period are matched in order to determine the appropriate profit generated for the period.  The implication is that transactions are recorded when they are incurred and not when cash is exchanged.  For example, if rent expense is incurred for the year and payment is made in the following year, the expense must be recognized in the current year.  The same applies to revenue.

4 0
3 years ago
Other questions:
  • A farmer sells $25,000 worth of apples to individuals who take them home to eat, $50,000 worth of apples to a company that uses
    6·1 answer
  • The team wanted to prevent customers from mistakenly choosing the hottest hot sauce and risking injury.Which of the following wo
    12·1 answer
  • Daryl is the founder of a successful smartphone application. He is detail-oriented and has high expectations of his employees. H
    11·2 answers
  • Individuals and companies respond to incentives in order to allocate their scarce resources in ways that provide the __________
    12·2 answers
  • against the foregoing background obtain any road road traffic policy and demonstrate your understanding of that particular polic
    10·1 answer
  • When potential capital investments of different size are​ compared
    7·1 answer
  • The formula Nequalspplus0.02p models the new​ population, N, of a town with current population p if the town is expecting popula
    11·1 answer
  • Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly fina
    11·1 answer
  • You are given the following information for Bowie Pizza Co.: Sales = $64,000; Costs = $30,700; Addition to retained earnings = $
    15·1 answer
  • On september 30, 2018, grover began preparing a trial balance worksheet. Which step occurs immediately after he prepares the inc
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!