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
S) Barkley and James cannot attend training during the exercise. They must attend before 4 May or after 25 May. Identify the con
KengaRu [80]

Answer:

Revealed by

Explanation:

The revealed by is the concept that is applied in the case when the classification of the derivatives for the new document is inbuilt and get the authorized source for classification into a new document plus the same is to not seen in the source document

Therefore the concept i.e used to determine the classification of derivatives is revealed by concept

4 0
3 years ago
A company has an opening stock of 6,000 units of output. The production planned for the current period is 24,000 units and expec
Orlov [11]

Answer:

Explanation:

                                                Last year           Current year

Selling Price                      10                         10

Varaible Price                5                         6

Contribution Margin               5                               4

Break even is the point where total cost is equal to total revenue mean no profit and loss.

company earns the contribution margin after covering the variable cost, now only fix cost remains for break even.

Break Even using FIFO method :  first In first out system

Fix Cost                                                                            =     86000

contribution from opening units(6000*5)                            =     30000

Remaining Fix cost that should be Covered from

current year products                                                            =     56000

 

Units to be sold for break-even ( 56000/4)   = 14000

so we have break even units   6000+14000 = 20000

Fix cost                              = -86000

Opening 6000*5              = 30000

Current   14000*4             = 56000

Profit                                   = 0

Break Even using LIFO method : Last in first out

Fix Cost                                                                            =     86000

Break even =  Fix Cost / Contribution margin

Break even =  86000/4 =21500

current production is 24000 which is higher than break even units so we can cover the fix cost from current year production because company is using lifo method. we do not need opening units for the break even.

4 0
3 years ago
_____ is the element in the promotional mix of a marketing plan that evaluates the public’s attitudes, identifies issues that ma
kotykmax [81]

Answer: Public Relations

Explanation: The elements of a promotional marketing mix are the resources an organisation engages in its marketing promotion. They are:

Advertising, public relations, sales promotion, direct marketing and personal selling.

The above listed elements have there unique effect on the sales if an organisation.

Advertising is used to create an awareness of the product to the consumer using all forms of advertising such as radio jingle television advert, billboards etc.

Public relations is used to find out the effect of the products in the market and also to get feedbacks from consumer which will enable mgt to plan on ways to correct any issue observed.

Sales promotions are ways of giving to the consumers fee products as rewards for loyalty

Direct marketing is the use of marketing officers that will speak to consumers personally and try convincing them to try the products

Personal selling is the act of selling the products one on one to customers

3 0
4 years ago
2.1: A debit is A : a decrease to an account. B : an entry on the left side of an account. C : an entry on the right side of an
Luba_88 [7]

Answer:

B : an entry on the left side of an account.

Explanation:

There are two terms i.e debit and credit.  

The accounts that reported as an expense, losses, assets are recorded in the left-hand side of an account as it contains the debit balance.

While the account reported as a revenue, gains, liabilities & stockholder equity are recorded in the right-hand side of an account as it contains the credit balance.

7 0
3 years ago
Anastasia was trying to decide which investment plan would be best over 10 years. Bank A was offering 8.5% simple interest on he
mario62 [17]

Answer: Bank B is the better investment. In 10 years, her $2,000 will grow to $4,317.85, and with bank A, her $2,000 will grow to $3,700.

Explanation:

Bank A was offering 8.5% simple interest. $2000 with 8.5% simple interest. = A = P(1 + rt)

A = 2000(1+(0.085*10))

= 2000(1+0.85)

= 2000(1.85)

= 3,700

Bank B was offering 8% compounded annually

= A = P(1+r/n)^nt

A= 2000(1+8%/1)^1*10

A= 2000(1+0.08)^10

A= 2000(1.08)^10

A= 2000*2.1589

= 4,317.85

8 0
4 years ago
Read 2 more answers
Other questions:
  • What is meant by a viable business idea?
    12·1 answer
  • Stark Company's most recent balance sheet reported total assets of $1.82 million, total liabilities of $0.84 million, and total
    5·1 answer
  • Which of the following happens when a company goes public
    13·2 answers
  • Gator Corporation manufactures several types of accessories. For the year, the gloves and mittens line had sales of $489,000, va
    9·1 answer
  • Harry and Meghan have considered starting their own business but are concerned about the possibility of losing even their person
    15·1 answer
  • Explain migration of population in economics.<br> pls its urgent
    9·1 answer
  • Smashed Pumpkins Co. paid $88 in dividends and $526 in interest over the past year. The company increased retained earnings by $
    7·1 answer
  • The gaming commission is introducing a new lottery game called Infinite Progresso. The winner of the Infinite Progresso jackpot
    5·1 answer
  • Identify which method of overcoming objections did you use for each Boomerang. Question, Superior
    15·1 answer
  • If the effective annual yield on a bond is equal to the bondʹs coupon rate, the bond will have a market value that is
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!