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
An ethical issue is an identifiable problem, situation, or opportunity that requires a person or organization to choose from amo
xenn [34]

Answer:

True, an ethical issue is an identifiable problem/ situation or opportunity that requires a person to choose from among several actions that may be evaluated as right or wrong, ethical or unethical.

Explanation:

Ethical issues arise when a given decision scenario or activity creates a conflict with a society's moral principles. Both businesses and individuals can be involved in these conflicts and sometimes these conflicts can be legally dangerous as some alternative to solve them might breach a particular law.

4 0
3 years ago
What are the three riches nations in the world​
Rus_ich [418]

Answer:

1. Qatar

2. Macao SAR

3. Luxembourg

Explanation:

The 3 wealthiest countries in the world according to GDP (PPP) is Qatar - $134,623, Macao SAR - $122,201 and  Luxembourg - $108,813

5 0
3 years ago
On March 1, it was discovered that the following errors took place in journalizing and posting transactions:
kaheart [24]

Answer:

a. Reversal entry:

Debit Rent expense $4,650

Credit Miscellaneous Expense $4,650

Correct Entry:

Debit Rent expense $4,650

Credit Cash $4,650

b. Reversal entry:

Debit Accounts payable $3,700

Credit Cash $3,700

Correct Entry

Debit Cash $3,700

Credit Accounts Receivable $3,700

Explanation:

Reverse entry is to simply close to zero the original entry that has been made in mistake. Afterwards, record the correct entry to properly account the transaction.

To reverse the previously made entry, we simply debit what is credited and debit what is credited.

a. We need to close the rent expense credited by debiting it and credit the miscellaneous expense that is previously debited to zereod out the mistake recording. Then to record the correct entry, Debit Rent expense and Credit Cash at the amount $4,650

b. Just ike what we did on the previous transaction, we will debit the Accounts payable and credit the cash that has been recorded by mistake to zereod out the balance and then make the correct entry. Debit Cash $3,700 and credit Accounts receivable $3,700.

5 0
3 years ago
Several years ago, Grant County was sued by a former County employee for wrongful discharge. Although it was to be contested by
vovangra [49]

Answer:

d) Debit Expenses $50,000 and Claims payable $100,000; Credit Cash $150,000.

Explanation:

As for the information provided,

There was this law suit against the company from past several years. Where the lawyers already estimated that liability on the company will arise amounting $100,000.

Thus, on the provisional basis such claims of $100,000 would have been provided ideally.

Now, after final judgement the court had cleared about the claim which is $150,000.

Thus, entry to record such claim of $150,000 will be:

Expenses A/c Dr.               $50,000

Claims Payable A/c Dr.      $100,000

    To Cash A/c                                             $150,000

7 0
3 years ago
What is the role of Scientific management in the modern era?​
rjkz [21]

The Scientific management in the modern era is management that analyzes and synthesizes workflows.

The role of  Scientific management in the modern era is improving economic efficiency, especially in the labor productivity. It is a systematic approach to handle management problems. It implies scientific techniques in method of work, recruitment, selection and training of workers.

Scientific management in the modern era is helped in the enhanced production. The employees perform repetitive tasks and are therefore easily controlled by the management.

To know more about management here,

brainly.com/question/20435550

#SPJ9

6 0
1 year ago
Other questions:
  • Which of the following is an example of a hidden variable? Quality of life is a hidden variable because it cannot be measured di
    13·1 answer
  • How does excessive money in the economy lead to inflation?
    12·1 answer
  • Gains are: a) Inflows from selling a product or service to a customer b) Increases in equity resulting from transfers of assets
    14·1 answer
  • The payment for environmental services (psa) program in costa rica collects payments from the beneficiaries of ecosystem service
    11·1 answer
  • Why was money scarce when crops produced a good profit? savestylesformat instructions?
    14·1 answer
  • On November 1, 2021, NoleCo signed a $100,000, 6%, six-month note payable with the amount borrowed plus accrued interest due six
    14·1 answer
  • Yummy Foods purchased a two-year fire and extended coverage insurance policy on August 1, 2016, and charged the $4,320 premium t
    7·1 answer
  • Which methods predicts the amount by which the value of a firm will change if a project is accepted?
    8·1 answer
  • The top managers of an organization typically use a variety of financial indicators to assess the performance of their organizat
    12·1 answer
  • a newspaper reports that in urban area the average price of new homes had decreased, but the number sold had increased. The sita
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!