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
2 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]2 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
g you are deciding between a conventional air conditioner and a high efficiency (High SEER) unit. The high efficiency unit costs
Ivanshal [37]

Answer:

no se lo siento /╲/\╭(•‿•)╮/\╱\

5 0
2 years ago
Suppose Nicholas owns a business making Christmas tree ornaments. Currently, he makes 300 ornaments a month. At this level of pr
Fudgin [204]

<u>Solution and Explanation:</u>

1. MC = Cost of raw material + Cost of time

MC = 5 plus (10 divide by 2)

MC = $10

2.  TFC = $300

Q = 300 ,  AFC = TFC/Q = 300 divide by 300 = $1

3.  His profit maximizing output would be higher

Reason: P = MR = $15 ,  MC = $10

Since MR > MC, and at the profit maximizing point MR = MC, it is better for Nicholas to increase his output.

4.  His profit maximizing output would be higher

Reason: P = MR = $15 ,  MC = $4 + $5 = $9

Since MR > MC, and at the profit maximizing point MR = MC, it is better for Nicholas to increase his output.

3 0
3 years ago
A final ir plan should be tested at least ____________________ by performing at least a structured walk-through test and a more
Makovka662 [10]
The answer to the question is Semiannually

This means that a final Incident Response plan should be tested a minimum of two times every year by performing a structured walk-through test at least, and when possible, perform a more realistic type of test.
4 0
2 years ago
Kirk McCoy is district sales manager for the Jimmy Dean division
arlik [135]

Answer: centralized

Explanation:

Based on the information given in the question, we can infer that McCoy operates a centralized department.

This is a centralized department because McCoy takes the decisions in the organization. In a centralized department, the organizational structure is such that the power regarding the decision is confined to top management, while the followers just follow the instructions

8 0
3 years ago
When a company expands by entering new business areas, it is called growth through __________?
garri49 [273]
When a company expands by entering a new business area, it is called growth through diversification. 

Diversity is the means of being different, new, exciting.. something not like another. When a business enters something new, it's called diversification because it's not like what they've done before. With this comes risk but huge growth potential.
7 0
2 years ago
Other questions:
  • In the country of Mashwen, the state owns key industries such as energy and transportation. The rest of the industries are priva
    10·1 answer
  • Once April has the photo in her document, she wants to make several changes to it. What DTP feature is the best tool for April t
    14·2 answers
  • Approximately __________ of trades involving shares issued by firms listed on the New York Stock Exchange actually take place on
    6·1 answer
  • After being introduced to a higher-priced washing machine, the customer expresses a desire to purchase a lower-priced item. when
    12·1 answer
  • Each Cutco knife goes through 30 steps to ensure that it meets the firm's standards and provides a good value for a premium prod
    12·1 answer
  • Making comparisons if the average historical return on a stock market investment is 11%, why doesn’t everyone put their money in
    13·1 answer
  • Alex has allocated his income in such a way that the marginal utility of the last unit of product X he consumes is 40 utils and
    13·1 answer
  • The economic survey 2018 suggest that the psychological biases
    10·1 answer
  • When banks have less money in required reserves they lend more money out to people and business. So Lower reserves usually help
    6·1 answer
  • . If you are in a position to advise a Western company that was considering doing business in Saudi Arabia for the first time, w
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!