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
Which of the following statement is not true about the Project stakeholders?
xxMikexx [17]

I think d is the answer

Explanation:

all stakeholders must not be independent all must work together

4 0
3 years ago
Amir is a computer engineer. he occasionally works for a lazlo inc., a publishing company; however, he only works for the organi
Shalnov [3]

amir would be classified as an on-call worker.

<h3>What is on-call worker?</h3>

An on-call employee (oproepkracht) works only when you, the employer, summon them. You and your employee have agreed on this. There are various forms of on-call contracts, each with its own set of rules.

An on-call schedule (or on-call shift) is a timetable that guarantees the appropriate person is always accessible, day or night, to respond rapidly to events and outages. On-call doctors in the medical field are expected to respond to medical crises at any moment during their shift.

On call is a vital duty among many IT, developer, support, and operations teams that provide services that customers demand to be available 24 hours a day, seven days a week. Team members rotate via an on-call cycle, providing coverage around the clock or solely during normal business hours.

To know more about on-call worker follow the link:

brainly.com/question/12831236

#SPJ4

5 0
1 year ago
Natalie owns a condominium near Cocoa Beach in Florida. This year, she incurs the following expenses in connection with her cond
kumpel [21]

Answer and Explanation:

Natalie's Gross Income = $10,000

75 + 35 = 110 days

Expenses:

Insurance Expense (75/110) x 1000                 682

Advertising Expense                                        500

Mortgage Interest (75/110) x 3500                  2386

Property Taxes (75/110) x 900                         614

Repairs and Maintenance (75/110) x 650        443

Utilities    (75/110) x 950                                   648

Depreciation (75/110) x 8500                          5795

Until the depreciation expenses the total expenses accumulate to  5273. If we deduct that with the gross income total we get 4727. We can only deduct 4727 from the total portion of 5795 depreciation expense.

Therefore, for AGI deductions we take total of (5273 + 4727) = $10,000

For Natalie's personal deduction of AGI

Mortgage interest (35/110) x 3500                    1114

Property taxes (35/110) x 900                            286

Total personal deduction for AGI                    $1400

4 0
3 years ago
Question 8 of 10
s344n2d4d5 [400]

It is important to name an executor B. To provide that beneficiaries acquire whatever they want from the estate.

<h3>Who is an executor?</h3>

An executor exists as someone who stands responsible for executing or following an assigned task or duty. The feminine form, executrix, may sometimes be utilized.

An executor typically presents the will for probate, brings the action to rescue the assets of the estate, creates distributions of effects to beneficiaries, and produces the debts and taxes of the estate.

An executor handles your estate when it's in probate (aka the procedure of being distributed and carried out). Particularly, they begin and observe through the probate approach. They also manage your assets, pay your obligations, and allocate property to your heirs as summarized in your will

Hence, It is important to name an executor B. To provide that beneficiaries acquire whatever they want from the estate.

To learn more about executor refer to:

brainly.com/question/10308372

#SPJ9

7 0
1 year ago
Read 2 more answers
According to the enotes, what do you call inventory that is readily available on the retail shelf?
Tems11 [23]

Market Inventory is the inventory that is readily available on the retail shelf. Both the products that are on hand for sale and the raw materials required to make those products are considered inventory. On the balance sheet of an organization, it is categorized as a current asset. A business should generally avoid keeping a large volume of inventory on hand for an extended period of time.

The three different categories of inventory are raw materials, finished commodities, and work-in-progress. The first-in, first-out method, the last-in, first-out method, and the weighted average method are the three methods used to value inventory. As items are produced or acquired as needed, inventory management enables organizations to reduce inventory expenditures.

To learn more inventory, click here

brainly.com/question/15118949

#SPJ4

8 0
2 years ago
Other questions:
  • When interspecific competition has an outcome called competitive exclusion, _________?
    9·1 answer
  • "Probably the most fertile areas for career opportunities today can be found in the investments and financial markets fields. "
    8·1 answer
  • Amy takes her car to Better Fix-It, Inc., which repairs the car and bills Amy for $500. Amy writes out a check drawn on Capital
    11·1 answer
  • In certain industries, Japanese employers do not lay off workers. Therefore, they sometimes have excess supplies of goods that t
    9·1 answer
  • Your friend Harold is trying to decide whether to buy or lease his next vehicle. He has gathered information about each option b
    6·1 answer
  • In 2021, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. T
    7·1 answer
  • During its first year of operations, Anthony Lupa set up Lupo Inc. and invested $15,000 in the corporation. The company earned $
    15·1 answer
  • In early April 2020, an amendment to the annual budget for 2020 was approved by the city council for inflows and outflows in the
    6·1 answer
  • our economists estimate that citizens in our country have an mpc of 0.75. To increase GDP by $800 how much should we increase go
    8·1 answer
  • Export assistance centers work with small and medium-sized businesses who wish to get involved in:_______
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!