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
Luebke Incorporated has provided the following data for the month of November. The balance in the Finished Goods inventory accou
vodka [1.7K]

Answer: $‭238,800‬

Explanation:

Adjusted Cost of Goods for November = Beginning Finished good inventory + Cost of goods manufactured  - Ending Finished goods inventory - Overapplied Overheads

Overapplied Overhead = Overhead applied - Actual Overhead

= 60,400 - 56,800

= $3,600

Adjusted Cost of Goods for November = 58,000 + 215,000 - 30,600 - 3,600

= $‭238,800‬

8 0
3 years ago
Suppose a new car company sought to enter the rental car market, and Enterprise, Avis and Hertz responded by offering rentals ve
Anni [7]

Answer: The problem of this plan is that their income will not be able to break even, because their cost price will be grater than the selling price. Which may cause the new company to wind up

Explanation: break even is a point where the cost price is equal to the selling price. This means that profit nor loss were not made.

Because Avis and Hertz are offering rentals at a prices below average variable cost, the company may not be able to meet up with capital for production of more cars, and this will cause them to wind up.

For a new company, it is always advisable to keep it's selling price a little bit above or the same with it's cost Price, because the strength not any business is the ability to produce more to fill the space of scarcity.

3 0
2 years ago
To record a customer's check in full payment for a sale that was made the prior month, the company should debit the ____________
bearhunter [10]

To record a customer's check in full payment for a sale that was made the prior month, the company should debit the payable cash account.

<h3>Payable cash account</h3>

Based on the information given the appropriate journal entry to record a customer's check in full payment for a sale is:

Journal entry

Debit Payable Cash account

Credit Sales accounts

(To record customer's check in full payment)

Inconclusion to record a customer's check in full payment for a sale that was made the prior month, the company should debit the payable cash account.

Learn more about payable cash account here:brainly.com/question/4656883

6 0
2 years ago
The income statement and selected balance sheet information for Direct Products Company for the year ended December 31 are prese
tamaranim1 [39]

Answer:

The answer is attached;

Explanation:

Download xlsx
5 0
2 years ago
The next dividend payment by Dizzle, Inc., will be $2.48 per share. The dividends are anticipated to maintain a growth rate of 4
Juliette [100K]

Answer:

Cost of equity   = 10.7%

Explanation:

<em>According to the dividend valuation, the value of a stock is the present value of expected future dividends discounted at the required rate of return.</em>

<em>The model can me modified to determined the cost of equity as follows:</em>

Cost of equity = D/P  + g

d- dividend payable next period, p- price of stock ,, - g- growth rate

D- 4.5%, p- $2.48 , g -4.5%

Cost of equity = (2.48 /39.85) + 0.045

                      = 10.7%

6 0
3 years ago
Other questions:
  • Requirement 3. How much manufacturing overhead was incurred during the​ year? Is manufacturing overhead underallocated or overal
    15·1 answer
  • The 9 digit number that identifies the bank that a check came from is called?
    11·2 answers
  • Karen and Jay need a larger home. They have two large dogs and a baby on the way. One day in the real estate section, they see t
    7·1 answer
  • Pablo Company has budgeted production for next year as follows:QuarterFirst Second Third FourthProduction in units 48,000 88,000
    12·1 answer
  • In a debate on the state of the economy Senator A pointed out that the price of clothing, fruits, and computers had decreased sl
    6·1 answer
  • Redford is a seller of electric generators. He purchases a large quantity of generators from a manufacturer, Mallon Corp.,by mak
    11·1 answer
  • "Zurich Company reports pretax financial income of $70,000 for 2014. The following items cause taxable income to be different th
    7·1 answer
  • As a sole proprietor, what are the ways in which you can raise money to establish your business, and make it grow?
    12·1 answer
  • Match each component of a mortgage with its definition.
    11·1 answer
  • "Dave, I know that you are trained to work as a chemist and not to solve scheduling problems. But as lab manager, you are a fron
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!