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
Kim’s flowers decided to borrow $26,000 from the bank and use the proceeds to purchase a new delivery vehicle. How should they c
Neko [114]

Based on the fact that Kim's flowers borrowed the money and used it to buy a new delivery vehicle, this business activity should be categorized as both a financing activity and an investing activity.

<h3>What should they classify this business activity as?</h3>

Because Kim's Flowers got the money as a loan, it would be recorded as an inflow for financial activities.

They then used it to purchase a delivery vehicle which is an investment and a capital asset so this will count as an investment activity.

Find out more on classifying business activities at brainly.com/question/14790406

#SPJ1

8 0
1 year ago
The debit side of an account
Vikki [24]
Loan investment account.. can be either side of the account depending on how the accountant set up the system
4 0
3 years ago
Present value is: a. The future value of a current amount of money evaluated at a given interest rate. b. The current value of a
pogonyaev

Answer:

Explanation:

Present value is calculated as the discounted sum of either a fixed amount or a series of payments in the future, at a given interest rates.

For example, at an interest of 5%, $100 in 10 years will be valued at $100 / 1.05^10 = $61.39 today

3 0
3 years ago
Read 2 more answers
Adrienne had contracted to convey real estate to rich. however adrienne died before the conveyance is completed. what is the sta
kondaur [170]
If he chose to, Rich can enforce the contract against Adrienne's estate. This is because, sickness or death of a promisor is not an avenue or excuse for non-performance in contracts such as this, which  can easily be delegated to another person for performance. 
3 0
3 years ago
Which are major situational considerations or variables in determining whether or not to involve a group in the decision-making
Oksana_A [137]

Answer:

The correct answer will be Option B "Organizational complexity ".

Explanation:

  • A Complex organization does indeed have a broader organizational structure or even more personnel in each group, mission, or team.
  • Complexity can sometimes be susceptible to multiple actors, various organizational structures, as well as different service will be produced that would need to be implemented.

The other given choices are not related to the given scenario. So that the above would be the appropriate choice.

5 0
2 years ago
Other questions:
  • You are a consultant to a large manufacturing corporation considering a project with the following net after-tax cash flows (in
    13·1 answer
  • Wildhorse Magazine sold 9,240 annual subscriptions on August 1, 2017, for $17 each. Prepare Wildhorse’s August 1, 2017, journal
    9·1 answer
  • ________ feasibility refers to projecting whether the system will operate and be used once it is installed.
    8·1 answer
  • In the U.S. political arena, ______________________ may tend to emphasize the virtues of markets and the limitations of governme
    5·1 answer
  • On January 1, the Matthews Band pays $65,800 for sound equipment. The band estimates it will use this equipment for four years a
    5·1 answer
  • Garland Inc. offers a new employee a single-sum signing bonus at the date of employment, June 1, 2018.
    14·1 answer
  • ASC Topic 235, Notes to Financial Statements
    7·1 answer
  • On January 1, 2020, a customer purchased a new $29,400 automobile, making a downpayment of $840. The customer signed a note indi
    12·1 answer
  • At April 30, Marigold Corp. has the following bank information: Cash balance per bank $5400 Outstanding checks $330 Deposits in
    5·1 answer
  • At the beginning of the year, The Mann Corporation, a private entity, decided to go public.
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!