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
Pie
3 years ago
8

Casey wants to calculate the monthly payments for each loan option that he is considering. Switch to the Loan Options worksheet.

In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12.
Business
1 answer:
taurus [48]3 years ago
6 0

Answer:

= PMT(B8/12,B10,B5)

Explanation:

The excel PMT function is calculated using the following formula

PMT(rate, nper, pv, [fv], [type])

Where rate = rate of payments per month

nper = duration of payment in month

pv = Present Value

fv = future value (it's an optional field)

type = payment type (it's an optional field)

Given that

B8 = rate

B10 = nper

B5 = pv

In cell B12, type the following

= PMT(B8/12,B10,B5)

We're making use of B8/12 because we need the rate to be in months not years.

Since there are 12 months in a year, monthly rate = B8/12

To use this formula in C12:D12

Use the following;

In cell C12, type the following

= PMT(C8/12,C10,C5)

In cell D12, type the following

= PMT(D8/12,D10,D5)

You might be interested in
Identify the correct sentence.
disa [49]
Answer choice D is punctuated correctly due to the use of the long dash between the words year and summer.
8 0
3 years ago
On September 1, Year 1, Gomez Company collected $9,000 in advance from a customer for services to be provided over a one-year pe
Margaret [11]

Answer:

d. $9,000; $9,000

Explanation:

As cash received on January 1 in advance to provide service in one year which is completed on December 31. So all the Unearned revenue is recognized because service for 12 month has been performed so whole amount will be reported in Income statement for the year ended December 31. Only cash received is from the service revenue activity so, it is also reported as $9,000. correct option is d. $9,000; $9,000.

4 0
3 years ago
Question 6 write an essay on the forms of ownership​
Ne4ueva [31]

Answer:

huh?no one's got time to write an essay for you

3 0
3 years ago
Read 2 more answers
Ginny and Eric are partners at an architecture firm. They are trying to determine which of them has a comparative advantage in b
blondinia [14]

Answer: (i) $20 per model

(ii) $27 per model

(iii) Ginny has a comparative advantage in building models.

Explanation:

A country or a firm has a comparative advantage in producing a commodity if the opportunity cost of producing that commodity in terms of other commodities is lower than the other country or firm.

Opportunity cost is the benefit that is foregone for an individual by choosing one alternative over other alternatives available to him.

If the opportunity cost is lower for an individual then this will benefit him whereas if the opportunity cost is higher then this will not benefit the individuals.

Therefore,

Ginny's Opportunity cost of producing one model = \frac{400}{20}

                                                                                      = $20 per model

Eric’s opportunity cost of building models = $20 + 35% of $20

                                                                      = $20 + $7

                                                                      = $27 per model

Hence, Ginny has a comparative advantage in building models because Ginny's opportunity cost of building model is lower than Eric's opportunity cost.

5 0
3 years ago
Metacognition is
slega [8]
Metacognition is often referred to ask "knowing about knowing." Metacognition is the awareness or understanding of one's own thought process. 
6 0
3 years ago
Other questions:
  • What is an example of a recreational goal??
    11·1 answer
  • 4. If a good is considered "normal" by economists, an increase in consumers' incomes will result in a decrease in the
    6·1 answer
  • Parr Paper's stock has a beta of 1.442, and its required return is 13.00%. Clover Dairy's stock has a beta of 0.80. If the risk-
    8·1 answer
  • Jones co. returned merchandise purchased from smith co. under the perpetual inventory system, the journal entry to record the re
    15·1 answer
  • What shows the quantities of products demanded at each price by all consumers in a market?
    5·2 answers
  • The firm's target capital structure should do which of the following?
    15·1 answer
  • Suppose the government wants to help the coffee industry, where many producers earn relatively little. It is considering two pos
    7·1 answer
  • The cost of plant in use with Hand Sanitizer Ltd (Hand Sanitizer), a manufacturing firm on 1 st April 2018 was GH₵375,000 agains
    5·1 answer
  • When certain brands are exclusively targeted to certain demographic groups, that is part of this market
    14·1 answer
  • What are three strategies that you can use to make better financial decisions?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!