Using cell references enter a formula in B6 to calculate monthly payments for the loan described in this worksheet Omit the optional arguement use a negative value for pv

Answers

Answer 1

Answer:

= PMT(B4/B2, B2 * B3, B1)

Explanation:

The syntax to use is:

= PMT(Rate,NPER, PV)

To answer this question, the following assumptions will be made.

B1 = Present Value i.e. PV

B2 = Number of Payment Period i.e n

B3 = Duration (in years)

B4 = Rate

So, the formula to enter in B6 is:

= PMT(B4/B2, B2 * B3, B1)

The above formula will return the monthly payment in cell B6


Related Questions

Fill in the blank to make the following true.
2 ** 3 =

Answers

Answer:

2 ** 3 = 8

Explanation:

Answer:

8

Explanation:

Can someone tell me how to hit on a link on Brainly to see the answer

Answers

no, please do not hit on links. they're viruses i'm pretty sure.
Make sure to report the answer just in case

What is the purpose of the website directory provided by the website host?

A. to look up user account information
B. to provide help and training for new customers
C. to store all of a website’s content files
D. to archive website usage logs

Answers

Answer:

mabye A

Explana

.

.

.

A spreadsheet will complete a variety of mathematical formulas for the user.

True or false

Answers

Answer: True

Explanation:

A spreadsheet will complete any formula as long as its entered by the user

Answer:

True

Explanation:

The first form of the rocket is believed have been developed in _?
China
Germany
Greece
Poland
i will mark u brainliest mf

Answers

China in 1100 AD, if I am wrong I'm sorry.

Answer:

Greece

Explanation:

It is believed that the reaction principle, the physical law of rocket motion, was first demonstrated about 360 B.C. by a Greek named Archytas. Far from demonstrating the reaction principle in a weapon, Archytas simply filled a hollow clay pigeon with water. He then suspended the clay pigeon by string over a fire. The heating of the water produced steam, and the clay pigeon could move under its own power as steam escaped through strategically placed holes. Archytas could hardly have imagined that the same basic principle would one day carry men to the Moon.

Sharon wants to include her name on each slide in her science presentation. Where in the Header and Footer dialog box would she type her name?

Answers

Answer:

She will type her name in the Footer

Explanation:

To answer this question, I will assume Sharon is using the Microsoft Office PowerPoint package to handle her presentation.

In PowerPoint, the footer helps users to add names or any other details on every slide.

To do this:

Go to INSERT in the menu barThen, go to Text menuSelect Header & Footer to open the boxCheck the Footer optionEnter the text in the provided text box(This is where Sharon will enter her name)Lastly, click Apply to All to effect the changes

Help please
Who will give the answer I'll mark him/her as brainlist..​

Answers

Answer:

We will be using Average function of Excel Calculation sheet.

Its Syntax in Calc sheet is : =AVERAGE (number1, [number2], ...)

or you can use =Average and then click on the first cell and drag the whole row till end and close the brackets. It will calculate the average of that row.

Once you have applied average function on first row, you can drag this cell down the column and it will replicate the same function for respective rows.

Website managers use____ every day.

Answers

Answer:

technology

Explanation:

Answer:

uses a coena for his computer association

materials used in front office

Answers

Answer:

A Telephone, Printer, Computers, Security Monitor

What is wrong with the following recursive sum method? The method is supposed to sum up the values between 1 and x (for instance, sum(5) should be 5 + 4 + 3 + 2 + 1 = 15). public int sum(int x) { if (x == 0) return 0; else return sum(x – 1) + x; } Group of answer choices the base case should return 1 instead of 0 the recursive case should return sum(x – 1) + 1; instead of sum(x – 1) + x; the recursive case should return sum(x) + 1; the method should return a boolean instead of an int the base case condition should be (x <= 0) instead of (x = = 0)

Answers

Answer:

The base case condition should be (x <= 0) instead of (x = = 0)

Explanation:

The given recursive function works fine for positive number. However, it returns an error when the value passed to the function is negative.

To prevent this, the base case should be x <= 0.

This will allow the program returns 0 if a negative number or 0 is passed to the function.

Hence, the changes to be made is to replace the base case with x <= 0

What is one example of a pan lan man and a wan

Answers

Answer:

A LAN (local area network) is a group of computers and network devices connected together, usually within the same building. ... A WAN (wide area network), in comparison to a MAN, is not restricted to a geographical location, although it might be confined within the bounds of a state or country.

Explanation:

i hope this helps

Which of the following statements is valid?SELECT InvoiceNumber, VendorNameFROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorIDWHERE InvoiceTotal = MAX(InvoiceTotal)SELECT InvoiceNumber, VendorNameFROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorIDWHERE InvoiceTotal = (SELECT MAX(InvoiceTotal))SELECT InvoiceNumber, VendorNameFROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorIDWHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)All of the above

Answers

Correct Answer:

c.

SELECT InvoiceNumber, VendorName

FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID

WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)

Explanation:

All options only differ on the WHERE clause:

a: WHERE InvoiceTotal = MAX(InvoiceTotal)

Fails because aggregate functions (like MAX, COUNT, etc) have to be used on the SELECT clause.

b: WHERE InvoiceTotal = (SELECT MAX(InvoiceTotal))

Fails because the SELECT clause is incomplete.

c: WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)

This one is correct, and returns the InvoiceNumber and VendorName register with the largest value on the InvoiceTotal field.

Design a TestScores class that has fields to hold three test scores. The class should have a constructor, accessor and mutator methods for the test score fields, and a method that returns the average of the test scores. Demonstrate the class by writing a separate program that creates an instance of the class. The program should ask the user to enter three test scores, which are stored in the TestScores object. Then the program should display the average of the scores, as reported by the TestScores object.

Answers

Answer:

Answered below

Explanation:

class TestScores {

double test1;

double test2;

double test 3;

public TestScores (double test1, double test2, double teat3){

this.test1= test1;

this.test2 = test2;

this.test3 = teat3;}

//mutator

public setTest1(double test1){

this.test1 = test1;

}

//accessor

public double getTest1(){

return test 1;

}

//Write same accessors and mutators for test2 and test3

public double getTestAverage(){

double sum = test1+test2+test3;

return sum / 3;

}

}

class TestRun{

public static void main (String [] args){

TestScores scores = new TestScores(50.5, 40.0, 80.7)

int average = scores.getTestAverage();

System.out.print(average);

}

What is "public static grossPay()" an example of?



A) Method()


B) Literal()


C) Private()


D) Order()

Answers

Answer:

A) Method()

Explanation:

This is an example of a Java method header. It has the visibility modifier called public which makes it visible to other classes. It is a static method which means it can be only be called through the Class's name because an object instance of it cannot be created. It is named grossPay and has no parameters and does not return any type.

If your query is 'michael kors women's handbags' and the Product Ad shows 'Womens Burlington handbags', What should be your rating? A) Bad B) Fair C) Good D) Excellent

Answers

My rating would be C) Good, it recommended me a similar handbag, good algorithm but not excellent because it’s not what I was looking for

Describe how a cell’s content and format attributes are related.

Answers

Answer: They are independent and not related.

Explanation: Changing the format affects the content. Which of the following is NOT a way to change the column width in Excel?

a cell's content and format are similar. a cell's content and format are unrelated. the content of a cell is influenced by changing its format. the format of the cell is also affected when the content of the cell is changed.

hope this helps

Distinguish between bit and byte?​

Answers

By its simplest definition, a bit is just a smaller unit of information than a byte. ... There are eight bits in one byte of information. Alternately, and more commonly in modern connotations, bits (and their successively larger relatives, such as kilobits, megabits and gigabits) are used to measure rates of data transfer.

7. Application software is a program or group of programs designed for end-users.
True
False

Answers

Answer:

True

Explanation:

A software refers to "instructions that tell a computer what to do. Software comprises the entire set of programs, procedures, and routines associated with the operation of a computer system" (Encyclopedia Britannica).

There are two types of software;

i) system software

ii) Application software

An application software helps the user to perform specific tasks on the computer. It was specifically designed for the end user.

A typical example of an application software is the Microsoft office which could be used to prepare documents using the computer.

Answer:

true

Explanation:

What is the difference between motion transmission and motion transformation?

Answers

Answer:

When the parts move in the same direction, it is rotational motion, and this is called motion transmission. When there is a change in the type the motion from rotation (circular or round and round) to translation (up/down), this is called motion transformation.

Explanation:

Answer:

When we convert a movement of one type into another of the same type (that is, linear in linear or circular in circular) we speak of transmission of movement. When, on the other hand, we convert it into another of another type (that is, linear in circular or circular in linear), we speak of transformation of movements.

Explanation:

Can someone help me with solving this program using coding?

Answers

Answer:

Explanation:

The following program is written in Python and holds all of the powers and amounts in a dictionary called inventory which can be changed, or the values can be increased like any dictionary. The data is then called and outputed to the user as an Inventory like the one shown in the picture.

def Inventory():

   inventory = {'Mushroom': 5, 'Super Bell': 5, 'Boomerang': 5, 'Fire Flower': 5}

   print("Mario's Inventory")

   print("Power            Amount")

   for x in inventory.keys():

       spaces = ''

       for y in range(20 - len(x)):

           spaces += " "

       print(x + spaces + str(inventory.get(x)))

Inventory()

the processing is done in the​

Answers

Answer:

CPU Central Processing Unit

Answer:

CPU.... I'm not sure but it might be right or can u put the full question because it sorta don't make any sense

How do you access the

internet in your school and at home?​

Answers

I think they want you to answer personally, but we access internet through computers, ipads, phones, etc. using wifi or mobile data to attain connection.

Which of the following items is the most important piece of
information to include in a page header or footer?
O Author name
Grade
Date
Page number

Answers

Answer:

Page number

Explanation:

Hope this helps

Brainliest for correct answer :)
a. X = A NOR B
b. X= NOT (A OR B)
c. X = A OR B

Answers

the answer is A, the logic circuit is a NOR

Which of the following tasks can you perform using a word processor?

insert a bulleted list in a document
check a document for spelling errors
edit a video for inclusion in a document
create an outline of sections to be included in a document
set a password to restrict access to a document

Answers

Answer:

check a document for spelling errors

Explanation:

With a word processor, you can easily edit and make changes to a document, move text around in a document, add images, change fonts, check for spelling errors

Examples of system software include operating systems like macos, Linux, Android and
Microsoft Windows, computational science software, game engines, industrial automation, and
software as a service applications
True
False

Answers

Tru tru tru tru tru tru

A testing lab wishes to test two experimental brans of outdoor pain long each wiil last befor fading . The testing lab makes six gallon s of each paint to test. The resultare Shown to see how

Answers

Answer:

The answer is "[tex]\bold{Brand \ A \ (35, 350, 18.7) \ \ Brand \ B \ (35, 50, 7.07)}[/tex]"

Explanation:

Calculating the mean for brand A:

[tex]\to \bar{X_{A}}=\frac{10+60+50+30+40+20}{6} =\frac{210}{6}=35[/tex]

Calculating the Variance for brand A:

[tex]\sigma_{A}^{2}=\frac{\left ( 10-35 \right )^{2}+\left ( 60-35 \right )^{2}+\left ( 50-35 \right )^{2}+\left ( 30-35 \right )^{2}+\left ( 40-35 \right )^{2}+\left ( 20-35 \right )^{2}}{5} \\\\[/tex]

     [tex]=\frac{\left ( -25 \right )^{2}+\left ( 25 \right )^{2}+\left ( 15\right )^{2}+\left ( -5 \right )^{2}+\left ( 5 \right )^{2}+\left ( 15 \right )^{2}}{5} \\\\ =\frac{625+ 625+225+25+25+225}{5} \\\\ =\frac{1750}{50}\\\\=350[/tex]

Calculating the Standard deviation:

[tex]\sigma _{A}=\sqrt{\sigma _{A}^{2}}=18.7[/tex]

Calculating the Mean for brand B:

[tex]\bar{X_{B}}=\frac{35+45+30+35+40+25}{6}=\frac{210}{6}=35[/tex]

Calculating the Variance for brand B:

[tex]\sigma_{B} ^{2}=\frac{\left ( 35-35 \right )^{2}+\left ( 45-35 \right )^{2}+\left ( 30-35 \right )^{2}+\left ( 35-35 \right )^{2}+\left ( 40-35 \right )^{2}+\left ( 25-35 \right )^{2}}{5}[/tex]

    [tex]=\frac{\left ( 0 \right )^{2}+\left ( 10 \right )^{2}+\left ( -5 \right )^{2}+\left (0 \right )^{2}+\left ( 5 \right )^{2}+\left ( -10 \right )^{2}}{5}\\\\=\frac{0+100+25+0+25+100}{5}\\\\=\frac{100+25+25+100}{5}\\\\=\frac{250}{5}\\\\=50[/tex]

 Calculating the Standard deviation:  

[tex]\sigma _{B}=\sqrt{\sigma _{B}^{2}}=7.07[/tex]

In the Business world people are often measured by their???
A- soft skills
B- hobbies
C- iq
D- technical skills

Answers

Answer:

D

Explanation:

You need skills to succeed!!

Answer is D !!!!!!!!

It is important to reflect on feedback.
A. True
B. False

Answers

The answer is A. True

Answer:

YES ITS IS!!

Explanation:

Effective feedback assists the learner to reflect on their learning and their learning strategies so they can make adjustments to make better progress in their learning.

Which of the following items are not a
component of a graphical user
interface?
(A) windows
(B) icons
(C) menus
(D) prompts​

Answers

Answer:

D

Explanation:

we dont use prompts on graphical iser

Prompts​ following items are not a component of a graphical user interface.

What is Graphical user interface?

A mouse is used to interact with a graphics-based operating system interface, which uses menus and icons to govern user interaction. The Xerox GUI was made popular in the 1980s by the Apple Macintosh.

However, Microsoft Windows, the company's GUI, has since become the standard user interface for personal computers. At the time, Microsoft's operating system, MS-DOS, required the user to input particular commands (PCs).

A graphics library, an interface toolkit, an interface style guide, and standardized applications make up a complete GUI environment. A high-level graphics programming interface is offered by the graphics library.

Therefore, Prompts​ following items are not a component of a graphical user interface.

To learn more about Graphical user, refer to the link:

https://brainly.com/question/14758410

#SPJ2

Other Questions
The value of the function f(x) is 600 when x=0 and decreases by 9% for every one-unit increase in x. Complete the equation that represents the function f(x)its a open answer please help Which expression is equivalent to 8x-12y+32? 16(0.5x-4y+32) 16(0.5x-0.75y+32) 16(0.5x-0.75+2 16(0.5+4y+2) Help plzzzzz 30 points Earth's atmosphere and oceans transfer heat through the evaporation and movement of water, producing-A. Magnetic reversals and living organisms B. Solar eclipses and lunar stormsC. Earthquake and volcanoesD. Winds and ocean currents PLEASE HELP!!! TIMED where is the cadenza in Shotstakovich's Cello Concerto No. 1 Help really important The night of the fire, Boo Radley places a blanket around Scout as she watches the tragic event unfold from the front of the Radley place. When Atticus and Jem discover the blanket, they inform Scout that she must return it to Boo Radley immediately.truefalse How would the world be different if nuclear weapons weresmall enough and easy enough to make to be sold on theblack market?Help pls Apoyo recibido por las industrias y se palpo en protecciones fiscales , control de sindicatos para mantener salarios bajo limitaciones de demandas salariales Michael's lawn measures 12 feet wide and 15 feet long. Sue's lawn measures 36 feet wide and 50 feet long. How many times larger is Sue's lawn than Michael'slawn?(A)()D10 What is one difference between Thomas Jefferson and Alexander Hamilton?a. Hamilton wanted free public education for all, Jefferson did not.b.Jefferson believed that the debts of the old Congress of the Articles of Confederation should be paid by the new government, Hamilton did not.c.Hamilton was considered a liberal, Jefferson was not.d.Jefferson feared a strong central government, Hamilton did not. fin on the bony fish HELP PLES PLES (i need to write 20 characters but i have no idea what to say so ima put this instead) A triangle has vertices at (1,10), (-5,2), and (7,2). What is its orthocenter. Show your work. What is the stock market? Why were people buying stocks in the 1920s?| Its cost $3.75 to by 3/4 of a pound of walnuts.How many pounds of walnuts can your purchase with $11.25 Barrington Industries anticipated selling 29,000 units of a major product and paying sales commissions of $6 per unit. Actual sales and sales commissions totaled 31,500 units and $182,700, respectively. If the company used a static budget for performance evaluations, Barrington would report a cost variance of: Multiple Choice $6,300U. $6,300F. $8,700U. $8,700F. None of the answers is correct. Speaker of the House Henry Clay and other people in Congress who wanted to start the War of 1812 were known by what name? A rectangular billboard is 9.35 meters wide and 6.82 meters tall. What is the perimeter of the billboard in meters?