Ben is considering purchasing a new home. His banker has presented a 10-year mortgage at a fixed rate of 7.6%. The cost of the home is $196000 and Ben will be required to provide a 25% down
payment. If we use Sheets to determine his monthly payment, which of the following Sheets commands could be used to determine his payment? (Choose all that apply!)
-PMT(0.076/12,120,-147000)
PMT(0.076/12,10 12,-$147000)
PMT(7.6,10,-196000)
PMT (7.6% / 12,12 10,-147000)
PMT(7.6/12,12 10,-147000)
-PMT(0.076/12,120,-196000+49000)

Answers

Answer 1

Answer: The PMT function in Sheets is used to calculate the monthly payment for a loan. The syntax of the function is PMT(rate, nper, pv, [fv], [type]).

Rate: the interest rate per period

Nper: the total number of payments

Pv: the present value (the total amount of the loan)

Fv: the future value of the loan (optional)

Type: the number 0 or 1 indicating when payments are due (0 = end of period, 1 = beginning of period)

Given the information in the problem, Ben's mortgage is for 10 years, so the total number of payments is 10*12 = 120. The present value of the loan is $196000 and the down payment is 25% of the home's cost so 25%*196000 = $49000. Therefore, the present value of the loan is $196000 - $49000 = $147000

Based on this information, the following commands would be used to determine the monthly payment:

PMT(0.076/12,120,-$147000)

PMT(0.076/12,120,-196000+$49000)

The first command uses the annual interest rate divided by 12 to convert it to a monthly rate, and the total number of payments is 120 (10 years * 12 months/year). The second command also uses the same monthly rate and total payments and the present value which is $147000

The other commands

Step-by-step explanation:


Related Questions

A survey showed that ​74% of adults need correction​ (eyeglasses, contacts,​ surgery, etc. ) for their eyesight. If 21 adults are randomly​ selected, find the probability no more than that of them need correction for their eyesight. Is a significantly number of adults requiring eyesight​ correction?

Answers

7.9 x 10⁻¹¹ is the probability of people who need correction for there eyesight.Yes, it is a significantly number of adults requiring eyesight.

The probability of no more than 21 out of 21 randomly selected adults needing correction for their eyesight would be calculated using the binomial probability formula:

(n choose k) ×  [tex]p^{k}* (1-p)^{n-k}[/tex]

where n is the total number of trail. k is the number of successful trials (the number of adults not needing correction), p is the probability of a successful trial (the probability of an adult not needing correction)which is:

1-0.74 =0.26)

(n choose k) is the binomial coefficient, which is calculated by:

n! / (k! × (n-k)!).


So, the probability of no more than 21 out of 21 randomly selected adults needing correction for their eyesight would be:
(21 choose 21) ×0.26²¹ ×0.74⁰= 0.26²¹ = 7.9 x 10⁻¹¹


This is a very low probability, indicating that it is highly unlikely that no more than 21 out of 21 randomly selected adults would not need correction for their eyesight.


Yes, it is a significantly number of adults requiring eyesight correction. 74% is a high percentage.

To learn more about probability:

https://brainly.com/question/24756209

https://brainly.com/question/13604758

#SPJ4

What property is 4 x (X •10) = (4•x) • 10

Answers

Answer:

Your answer is Identitive property

Find veda and kalbes climming speeds

Answers

Veda’s speed= 300 m/s ,kalbes’s speed=140 m/s
MARK MY AS BRAINLIEST

How many miles is the diagonal path from Jim house to the mall

Answers

The distance from Jim's house to the mall is given as follows:

11.25 miles.

How to obtain the distance between two points?

Suppose that we have two points with coordinates given as follows:

[tex](x_1, y_1)[/tex] and [tex](x_2, y_2)[/tex]

Then the equation for the distance between these two points is given as follows:

[tex]D = \sqrt{(x_2-x_1)^2+(y_2-y_1)^2}[/tex]

The coordinates are given as follows:

Jim's house: (17, 13).Mall: (8,1).

Hence the distance is given as follows:

[tex]D = \sqrt{(17 - 8)^2+(13 - 1)^2}[/tex]

D = 15 units.

Each unit represents 0.75 miles, hence the distance in miles is given as follows:

15 x 0.75 = 11.25 miles.

Missing Information

The problem is given by the image presented at the end of the answer.

More can be learned about the distance between two points at brainly.com/question/7243416

#SPJ1

In the triangle ABC, AB = 6cm and BC = 9cm. Given that the area of the triangle is 18 cm², find the possible values of the angle B. ​

Answers

The angle, ∠B has 2 possible angles, one is 41.81° and the other will be 138.19°

In ΔABC we have been given that

AB = 6 cm

BC = 9 cm

A formula for the area of a triangle is

1/2 X one side X oth sde X sin(common angle)

Hence if we consider AB and BC with common angle, ∠B we get

1/2 X 6 X 9 X sinB = 18

or, sinB = 18/27

or, sinB = 2/3

Now since sin is positive in 2 quadrants, we will have 2 possible values for ∠B

one will be 41.81° and the other will be (180 - 41.81)° = 138.19°

To learn about Trigonometry visit

https://brainly.com/question/28889164

#SPJ4

Find an equation for the line through (0, -5) and parallel to y = 1/2x + 1

Answers

Answer:

y=1/2x-5

Step-by-step explanation:

Parallel lines always have the same slope. Thus, since you know y=1/2+1 is parallel you know the slope is 1/2 as in y=mx+b, m is the slope. In addition, you know the y-intercept as -5. So the equation is y=1/2x-5

Answer:

y=1/2x-5

Step-by-step explanation:

to be parallel it needs to have the same slope so the slope is the same

0,-5 is the y intercept so -5 is the y intercept

Yusuf drove 156 miles in 3 hours. If he continued at the same rate, how far would he travel in 2 hours?

Answers

Answer:104 miles in 2 hours.

Step-by-step explanation:

so first since we need to know how much he drove in 2 hours we just divide 156 by 3 to get 52 and then multiply 52 by 2 since we need to know how many miles he traveled in 2 hours then you get your final answer of

104

Sandy sold her homemade strawberry jam for $5 per jar at the farmers’ market. She bought a basket of strawberries for $24 to make the jam. If x represents the number of jars of jam sold, which expression represents Sandy’s earnings?

Answers

The expression that represents Sandy’s earnings is 5x - 24

How to determine the earnings expression

From the question, we have the following parameters that can be used in our computation:

Cost price = $24

Selling price = 5 per jar

This means that the total sales is

Total = 5 * x

Evaluate

Total = 5x

The earnings is the difference between the total sales and the cost price

Sp, we have

Earnings = 5x - 24

Read more about expression at

https://brainly.com/question/4344214

#SPJ1

Fifth term of (x-3y)^6

Answers

The fifth term of the expression is 1215x²y⁴.

What is Binomial Theorem?

Binomial theorem is the method of expanding an expression consisting of two terms raised to any power.

By binomial theorem,

(x - 3y)⁶ = 6C₀ x⁶ + 6C₁ x⁵ (3y) + 6C₂ x⁴ (3y)² + 6C₃ x³ (3y)³ + 6C₄ x² (3y)⁴ + 6C₅ x (3y)⁵ + 6C₆ (3y)⁶

Simplifying the combination part,

            = x⁶ + 6x⁵(3y) + 15x⁴(3y)² + 20x³(3y)³ + 15x²(3y)⁴ + 6x(3y)⁵ + (3y)⁶

            = x⁶ + 18x⁵y + 135x⁴y² + 540x³y³ + 1215x²y⁴ + 1458xy⁵ + 729y⁶

Hence the fifth term of the expression is 1215x²y⁴.

Learn more about Binomial Theorem here :

https://brainly.com/question/30100273

#SPJ1

purple
black
green
5-110
The spinner shown to the left is spun twice. Make a
table and calculate the probability of each of the
following outcomes. Write your answers as simplified
fractions.
Probability Table: NEED HELP WITH THE PROBABILITY TABLE


P(getting green twice)

Answers

Step-by-step explanation:

give me a brainlist please

(b) A workshop produces 360 chairs in
5 days.
The rate of production is ?
chairs/day.

Answers

Answer:

72

Step-by-step explanation:

just divide 360 by 5

ez

To find the rate of production, you have to divide the number of chairs produced by the amount of days.

Given:

Chairs produced - 360

Days - 5

[tex]360\div5[/tex]

[tex]\fbox{72 chairs per day}[/tex]

if vector c is added to vector b, the result is -9i - 8j. if b is subtracted from c, the result is 5i 4j. what direction is b to the nearest degree

Answers

221 degree is the direction of B to the nearest degree.

We have to find the vector B. We will substructure Equations

-9i - 8j - 5i - 4j = -14i -12j

                       = 2(-7i-6j)

From here you get the value of vector B. That is minus seven i and minus of six j. Now we can see that this is both. The signs are negative so it should lie in 3rd chord event.

And for third quarter went in their direction or we can say Angelo factor B is want A D. Plus theater. So when I. D. Plus and universal marvelous of -6 divided by -7 that provides us one or d. plus 41 degree. That is 221 degree.

To learn more about degree here:

https://brainly.com/question/364572

#SPJ4

After you have constructed a 60° angle, what other appropriately used construction will get you a 30° angle?

Answers

Answer:

Construct an angel bisector


If you want to divide an angle into two equal angles you can use angle bisector .

what is the probability of spinning a three on the first spinner, the color orange on the second spinner, and rolling an even number of the fair number cube?

A. 1/12
B. 1/16
C. 1/24
D. 1/48

Show your work please!!

Answers

Answer:

D. 1/48

Step-by-step explanation:

Each event (spinning a 3, spinning orange, rolling an even number) is an independent event, so the overall probability is the product of the three individual probabilities.

For each event,

p(event) = (number of desired outcomes)/(total number of possible outcomes)

p(spinning a 3) = 1/6

p(spinning orange) = 1/4

p(even number) = 3/6 = 1/2

p(spinning a 3 then spinning orange then rolling an even number) =

= 1/6 × 1/4 × 1/2

= 1/48

Answer: D. 1/48

Answer:

1/48

Step-by-step explanation:

First look at the spinner- there is only one three out of six, so the spinner is 1/6

Now looking at the second spinner- there are four spaces and one orange- giving us 1/4

And finally for the die there are six sides and three are even- which is 3/6


And in order to get our final answer we will multiply 1/6 * 1/4 * 3/6 which equals 1/48

Several friends each want to buy new basketball shoes that cost $60. To earn money, they do yard work for $9 an hour. The table shows the number of hours each person did yard work for each day. Who earned enough money to buy the basketball shoes? What inequality can you write to represent this situation?

Indicate whether or not each friend earned enough money to buy the basketball shoes.

Answers

Answer:

Step-by-step explanation:

There's no table or image attached to your question, but they would have to work at least 7 hours in order to earn enough money. In 7 hours, they would earn $63.

HS
Population
1200
1450
900
1500
1400
1005
# of active band members
150
155
100
125
125
120
What is the correlation coefficient? Interpret what this means for the context of this
data.

Answers

Answer:

I'm trying to figure that out to

Please answer the question :)

Answers

An inequality represented by situation A is x < -4.

An inequality represented by situation B is x ≤ 3.

What is an inequality?

In Mathematics, an inequality simply refers to a mathematical relation that is typically used for comparing two or more numerical values and variables in an algebraic equation based on any of the following inequality symbols:

Less than or equal to (≤).Greater than (>).Greater than or equal to (≥).Less than (<).

In this exercise, we would use interpret each of the situations by using an inequality to model them. On the balance in situation A, the tray on the left is denoted with the variable (x) while the tray on the right is denoted with numerical values of "-1" in four places, therefore, we would write the inequality as follows:

x < 4(-1)

x < -4.

In situation B, the circle on the number line (graph) is closed because it represents the less than or equal to (≤) symbol and it decreases to the left of the number line;

x ≤ 3.

Read more on inequality here: brainly.com/question/27976143

#SPJ1

There are two blue marbles, 10 orange marbles, and 4 white marbles in a bag. What is the probability of picking a blue or white marble?

Answers

Answer: Blue: 12.5%

              White: 25%

              Orange: 62.5%

              Blue or White: 37.5%

Step-by-step explanation:

Step 1: Add all the Marbles together: 2 blue + 10 Orange + 4 White = 16     Marbles

Step 2: Add Blue and White marbles together: 2 blue + 4 White = 6 Marbles

Step 3: Divide Blue and White Marbles with total Marbles: 6/16 = 0.375

Step 4: Convert to Percentage: 0.375 x 100 = 37.5%

A sculpture needs to lift a piece of marble.
It is a cuboid with dimensions 1 m by 0.6 m by 0.3 m.
Marble has a density of 2.7g/cm cubed.
What is the mass of the marble in kg?

Answers

The mass of the marble lifter by a sculpture is 0.0306 kg.

What is a cuboid?

A cuboid is a three-dimensional closed figure which has volume along with surface area.

The volume of a cuboid is the product of its length, width, and height.

The total surface area of a cuboid is 2(lw + wh + wl) and the lateral surface area is 2(l + w)×h.

We know the volume of a cuboid is (length×width×height).

Therefore, The volume of this cuboid is (1×0.6×0.3) = 0.18 m³.

The marble has a density of 2.7g/cm which is equivalent to 0.17kg/meter.

We know Mass = volume×density.

Therefore, The mass of the marble is 0.17×10.18 kg.

= 0.0306 kg.

learn more about cuboid here :

https://brainly.com/question/29568631

#SPJ1

the track of a bicycle tire that completes one revolution is 54 ft. what are the radius, diameter, and circumference of the wheel?

Answers

The radius is 8.59 ft, the diameter is 17.18 ft and the circumference is 54 ft.

How to find the radius, diameter, and circumference of the wheel?

The circumference of the wheel will be 54 ft, since that's the distance the tire travels in one revolution.

The diameter of the wheel is twice the radius, so if we can find the radius we can find the diameter.

To find the radius (r), we can use the formula:

circumference = 2 × π × radius

54 = 2 × π  ×  r

r = 54 /2 π = 8.59 ft

The diameter is twice the radius, so:

diameter = 2r

diameter = 2 × 8.59 =  17.18 ft

Learn more about circumference on:

brainly.com/question/12823137

#SPJ1

if the variance of a normal population is 5, what is the probability that the variance of a random sample of size 15 exceeds 9.329 (round off to third decimal place)?

Answers

If the variance of a normal population is 5,  the probability that the variance of a random sample of size 15 exceeds 9.329  is 0.069.The variance of a sample from a normal population has a chi-squared distribution, which is the sum of the squares of the standard normal distribution.

The probability can be calculated by finding the area to the right of the chi-squared value of 9.329 on the chi-squared distribution. This area can be found by using the chi-squared cumulative distribution function, which is the integrated form of the chi-squared probability density function.

To find the probability, the chi-squared cumulative distribution function is used to calculate the area to the right of the chi-squared value of 9.329. This will give us the probability of the variance of the sample exceeding 9.329, which is 0.069.

To know more about  probability  refer to the link brainly.com/question/29381779

#SPJ4

how to determine if a function is even or odd algebraically

Answers

If f(-x) = -f(x), the function is odd. and if f(-x) = f(x), the function is even.

What are functions?

A function is defined as a relation between a set of inputs having one output each, a function is a relationship between inputs where each input is related to exactly one output.

We can decide algebraically if a function is even, odd or neither by replacing x by -x and computing f(-x).

If f(-x) = f(x), the function is even.

If f(-x) = -f(x), the function is odd.

In order to "determine algebraically" whether a function is even, odd, or neither, you take the function and plug − x in for x, simplify, and compare the results with what you'd started with.

If you end up with the exact same function that you started with (that is, if f (− x) = f (x), so all the signs are the same), then the function is even; if you end up with the exact opposite of what you started with (that is, if f (− x) = − f (x), so all the signs are switched), then the function is odd.

If the result is neither exactly the same nor exactly opposite (that is, nor having all the same terms but with all the signs reversed), then the function is neither even nor odd.

Learn more about functions, click;

https://brainly.com/question/12431044

#SPJ1

solve for [tex]tan\frac{17\pi }{12}[/tex]

Answers

After calculating , The value of given expression is -3.73

What is Tanx in terms of sinx and cosx?

Tanx can be defined as the ratio of sinx and cosx or tanx also can be defined as the ratio opposite side and adjacent side.

Given

expression,

tan(17pi/12)

The value of pi = 180

so by putting the value we get,

tan(17*180 / 12 )

tan ( 3060 / 12 )

as we know the value of 3060/12 = 255.

tan(255)

= -3.73

so we got the value of tan(255) is -3.73 approximately

Hence, The value of given expression is -3.73

To learn more about Tanx from the given link.

https://brainly.com/question/13329070

#SPJ1

a cook wants to know what happens to bacon when it is fried in a frying pan versus microwaving it. specifically, the cook wonders if the bacon ends up moister and more flavorful when fried or when microwaved. what are the dependent variables

Answers

The dependent variables in the following scenario are whether the bacon becomes moister and more flavorful and the independent variable is the cooking method.

In statistics, a dependent variable is one whose value is determined by another set of variables called independent variables. To put it simply, the dependent variable is the thing that is being tested or calculated. The dependent variable is sometimes known as the "outcome variable." In the given scenario, the chef was curious as to whether or not frying or microwaving the bacon would produce a moister and more flavorful final product. The bacon is the result of the experiment, hence it is a dependent variable.

To learn more about dependent variables, click here:

https://brainly.com/question/1479694

#SPJ4

Question Down Below: (Please i really need to complete this right now)

Answers

The inequality to represent the constraints will be:

x + y ≥ 325

x + 2y = 600

How to calculate the inequality?

Inequalities are simply created through the connection of two expressions. In this case, it should be noted that the expressions in an inequality are not always equal. Inequalities implies that the expressions are not equal. Here, they are denoted by the symbols ≥ < > ≤.

Let x = number of vegetarian meals

Let y = number of meats.

The inequality to represent the constraints will be:

x + y ≥ 325

x + 2y = 600

In this case, the daily budget is 600.

Learn more about inequalities on;

brainly.com/question/24372553

#SPJ1

Solve the quadratic inequality in terms of x 3x^2-8x+15>10x

Answers

The solution of the inequality in terms of x is x > 3 or x < 5/3.

What is quadratic inequality?

A quadratic inequality is simply a type of equation that does not have an equal sign and includes the highest degree of two. The wavy curve method is a method used to solve quadratic inequalities. Solving quadratic inequalities is the same as solving quadratic equations.

To solve the quadratic inequality 3x^2 - 8x + 15 > 10x, we first need to move all the terms to one side of the inequality sign to create a standard form of quadratic inequality.

3x^2 - 8x + 15 > 10x

3x^2 - 18x + 15 > 0

Now we can factor the left side of the inequality as (3x-5)(x-3) > 0

To solve the inequality, we need to find the values of x that make the expression (3x-5)(x-3) > 0 true. We can do this by setting each factor to zero and solving for x:

3x - 5 = 0, x = 5/3

x - 3 = 0, x = 3

Now we need to test these values of x in the original inequality to see if they make it true or false, and also we need to test values of x between and around these roots.

For x = 5/3, we have 3(5/3)^2 - 8(5/3) + 15 > 10(5/3)

Which is true.

For x = 3, we have 3(3)^2 - 8(3) + 15 > 10(3)

Which is also true.

So, we can conclude that the solution of the inequality is x > 3 or x < 5/3.

Therefore, the solution of the inequality in terms of x is x > 3 or x < 5/3.

To learn more about quadratic inequality visit,

https://brainly.com/question/30239212

#SPJ1

POINTS GIVEN!!! ASAP Alang was out at a restaurant for dinner when the bill came. His dinner came to $18. He wanted to leave a 10% tip. How much was his meal plus the tip, before tax, in dollars and cents? ASAP

Answers

Answer: $19.80

Step-by-step explanation:

Step 1:

Multiply to get tip:

18*0.1=1.8

Step 2:

Add:

18+1.8=19.8

Add the zero in the hundredths digit place since there are always two-digit places after the decimal point when dealing with money.

What’s the missing angles??

Answers

Try multiplying the 91 and 65 then that's an answer for one. Then try dividing them for another angle.

Translate the following statements into equations and solve. Show your solution.

1. Two more than four times a number is -10.

2. One less than thrice a number is equal to 26.

3. Seven added to a certain number is 34.

Answers

Answer: 4x + 2 = -10

3x - 1 = 26

x + 7 = 34

Step-by-step explanation:

Draw a tape diagram that represents 5÷2/3

Answers

The numerical answer is 5

How to draw a tape diagram that represents 5÷2/3?

Start by drawing three unit tapes, and divide each one of them in 5 equal parts since we need to be dividing the quantity 3 by 3/5 (denominator 5)

In the second step, join the three tapes in one long one maintaining the original divisions.

In the third step, select groups of 3 divisions (recall you need to divide by 3/5) which will identify in your tape how many of these 3/5 groups you have.

Finally count the number of 3/5 groups you found in the collection of the three original tapes placed together. You should count a total of 5 of these 3/5 groups.

5 then tells you what is the quotient of 3 divided in 3/5

Learn more about division of numbers on https://brainly.com/question/2273245

#SPJ1

Other Questions
two point charges placed 5 cm apart on the x axis. at what points along the x axis is the potential zero? Of the following statements, which one or ones describe actions harmful to your credit score?I. Owing a lot of moneyII. Having many lines of creditIII. Making steady payments what happens if the spliceosome makes a small mistake such as inserting or deleting a single nucleotide from the final spliced mrna Economic theories, or models, enable us to predict and to give reasonable explanations regarding economic variables.Select one:TrueFalse Which of the following is true?Online estimators, metabolic carts (i.e. lab equipment), dietary recall questionnaires are all acceptable methods of estimating caloric needs 15, Jordan has been getting sick frequently. Her mom wants her to start eating healthier and getting more exercise to help strengthen herA. respiratory systemB. digestive system.C, immune systemD. mental health What is the constant of proportionality in this proportional relationship?X 2 2/1 3 3 1/2Y 5/2 25/8 15/4 35/8 The bank offers your deposit of 10000$ at 12% stated interest rate compounded monthly. Determine the rate of interest you can earn in a year which type of switch will shut off when the user releases it Suppose that y varies directly with x, and y=4 when x=20. (a) Write a direct variation equation that relates and y Equation: (b) Find y when x=9. y= calculate the monthly payment for the following: an automobile costs $30,000. an installment plan allows for monthly payments over a seven year period with an annual interest rate of four percent. Is the following statement a debatable claim? (Yes or No)The United States government owe reparations to African-American citizens descended from slavery. Considering the hazards information from the SDS, which choice represents the safest way to use this chemical? A. Next to a lit burner to burn off the vapors. B. In the park so you have fresh air. C. At your desk while eating lunch. D. In a laboratory fume hood, wearing PPE. is there a non-graded scratchpad in integrated excel question that you can freely use? a white cylindrical silo has a diameter of $30$ feet and a height of $80$ feet. a red stripe with a horizontal width of $3$ feet is painted on the silo, as shown, making two complete revolutions around it. what is the area of the stripe in square feet? What is the product of the polynomials? Help me Thank you so much Express tan Y as a fraction in simplest terms. Given that z is a standard normal random variable, compute the following probabilities (to 4 decimals).P(z ? -1.0)P(z ? -1.0)P(z ? -1.5)P(z ? -2.5)P(-3 < z ? 0) A list of disorders, along with descriptions of symptoms and guidelines for assigning individuals to the disorder, is known as a:A. syndrome clusterB. diagnosisC. classification systemD. symptom