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
What are the primary advantages to owning a franchise?
Volgvan

Answer:

Explanation:

Owning a franchise has the following main advantages:

1) A franchise owner gets valuable help throughout the lifespan of the business. Upon acquiring a franchise, the business owner receives a continuous training and assistance necessary for marketing and management.

2) Owning a franchise comes with a low rate of failure. A franchise comes with an established business concept that is already successful in the market which assures the owner of better chances of success compared to starting up an independent business.

6 0
3 years ago
Read 2 more answers
Luis follows a lot of news sources in his industry. He subscribes to several blogs written by industry experts, and updates are
bekas [8.4K]

Answer:

Group of choices:

a. Media sharing

b. Blog

c. Content aggregator

d. Mass media

The correct answer is c. Content aggregator .

Explanation:

Feedly is considered to be a content aggregator site because all of its information is derived from external sources. In a broader sense, content aggregators are tools that allow information to be collected in order to locate it in a specific place. One of the advantages is that it allows having the information in the same place, which saves time for those who are interested in the same or similar topics.

3 0
3 years ago
When a company maintains its price but removes or prices separately one or more elements that were part of the former offer, suc
fomenos

The name which is given to the process when a company maintains its price but removes or prices separately is known as E. unbundling

<h3>What is Price?</h3>

This refers to the attached value which is given to a good or service that is exchanged for that particular value.

Hence, we can see that when a company removes freebies such as free delivery or installation but maintains its price is known as unbundling and is a market activity.

Read more about marketing here:

brainly.com/question/25754149

8 0
2 years ago
__________ consist of organization infrastructure (administration and management), human resources (employee recruiting, hiring,
olga55 [171]

Answer:

Secondary Activities

Explanation:

Secondary activities inside an organization are those who support the primary activity. The primary activity consists in the production and distribution of goods and/or services to customers, while secondary activities are meant to improve aspects of the primary activity.

For example, the goal of human resources is to create good labor conditions so that employees are happier, and therefore, more productive. And the goal of the technology department is to engage in research to produce new goods or provide new services in the future.

4 0
3 years ago
A private university is made up of various "schools," such as the School of Journalism, the School of Business, the School of La
Oxana [17]

Answer:

The correct answer is D

Explanation:

SBU stands for Strategic business unit , it is a profit center whose focus is on the product offering and the market segment. It is usually have a marketing plan which is discrete, marketing campaign and analysis of competition, though it is a part of larger business entity.

So, the private university facing financial problems, they decided to become a profit center. Therefore, this scheme is parallel to SBU which is Strategic business unit.

6 0
3 years ago
Other questions:
  • When the "full-cost approach" to marketing cost analysis is used, allocating fixed costs on the basis of sales:A. may make low-v
    13·1 answer
  • Last month, sellers of good Y took in $100 in total revenue on sales of 50 units of good Y. This month sellers of good Y raised
    12·1 answer
  • In which case do investors buy stock in expectation of higher profits
    12·2 answers
  • Which of the following refers to a cluster of decisions concerning what organizational goals to pursue, what actions to take, an
    6·1 answer
  • Flipco signed a 10​-year note payable on January​ 1, 2018​, of $ 800, 000. The note requires annual principal payments each Dece
    14·1 answer
  • Office Depot has instituted the Office Depot Advantage, a program in which a customer who spends a minimum of $200 up to $299 in
    10·1 answer
  • When a company's business strategy and technology strategy are intertwined, this situation is known as _______. select one:
    10·1 answer
  • Janice started receiving an annuity payment of $1,500 per month when she turned 68 years old (expected return multiple for ordin
    14·1 answer
  • In a world with no taxes, MM show that a firm's capital structure does not affect the firm's value. However, when taxes are cons
    10·1 answer
  • When you buy stock in the "stock market" what are you buying? Why would you but a stock?
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!