The original price of a car is entered into spreadsheet cell A1 and the annual depreciation amount in cell B1.

a. Write the spreadsheet formula to determine the number of years it will take for the car to totally depreciate.
b. The spreadsheet user is instructed to enter a car value in cell D1. Write the spreadsheet formula to compute how long it will take for the car to depreciate to that value.
c. The spreadsheet user is instructed to enter a percent into cell E1. Write the spreadsheet formula to compute the length of time it will take for the car to decrease by that percent.

Answers

Answer 1

Answer:

A1 / B1 ;

(D1 - A1) / B1 ;

(A1 - E1*A1) / B1

Step-by-step explanation:

A1 = original price of car

B1 = annual Depreciation amount

Number of years it will take for the car to depreciate totally :

Using the straight line Depreciation relation :

y = mx + c

c = intercept = initial or original value of car

m = annual Depreciation amount

x = number of years

y = value after x years

For total Depreciation, final value, y = 0

0 = mx + c

mx = - c

x = - c / m

Hence, x = A1 / B1

B.)

D1 = car value

Length it will take for car to depreciate to value in D1 :

y = mx + c

y = D1; m = B1 ; c = A1

D1 = B1x + A1

B1x = D1 - A1

x = (D1 - A1) / B1

C.)

E1 = decrease percentage

Time it takes for car to decrease by percentage in E1

y = E1 * A1

E1 * A1 = B1x + A1

(A1 - E1*A1) = B1x

x = (A1 - E1*A1) / B1


Related Questions

Two forces of 401 newtons and 477 newtons act on a point. The resultant force is 828 newtons. Find the
angle between the two forces.

The angle between the two forces is ____°

(Round to the nearest integer as needed.)

Answers

Answer:

The answer is "[tex]39.01^{\circ}[/tex]"

Step-by-step explanation:

[tex]\to R= 828\\\\\to F_1= 401\\\\\to F_2=477\\\\\to \bold{R=\sqrt{F_1^2+F_2^2+2F_1F_2 \cos \theta}}[/tex]

[tex]828=\sqrt{401^2+477^2+2 \times 401 \times 477 \cos \theta}\\\\828=\sqrt{160801+227529+382554 \cos \theta}\\\\828=\sqrt{388330+382554 \cos \theta}\\\\[/tex]

square the above equation:

[tex](828)^2=(\sqrt{388330+382554 \cos \theta})^2\\\\[/tex]

[tex]685584 =388330+382554 \cos \theta\\\\685584 -388330=382554 \cos \theta\\\\297254=382554 \cos \theta\\\\\cos \theta=\frac{297254}{382554}\\\\\cos \theta=0.777025\\\\\theta= \cos^{-1} 0.777025\\\\\theta= 39.01^{\circ}[/tex]

the probability of it raining on a given day is 3/8
what is the probability of its not raining

Answers

5/8

Step-by-step explanation:

Probability of raining = 3/8

Total days= 8/8

Then probability of not raining= 8/8 - 3/8

= 5/8

Answer:

5/8.

Step-by-step explanation:

These probabilities add up to 1 so

Probability(Not Raining)

= 1 - 3/8

= 8/8- 3/8

= 5/8.

roads diverge at an angle of 70 degree. aurea walks on the first road at 4kph while marcelino on the other road at 5 kph. both start walking at the diversion point. how far are they after 3 hours?

Answers

Answer:

ggyfuae5iyrsi6rs6esyleslysyrslur

Jesse has three one-gallon containers. The first
3
one has of a gallon of juice, the second has
gallon of juice and the third has of a gallon of juice.
How many total gallons of juice does Jesse have?

Answers

Step-by-step explanation:

Total gallons of juice = No. of containers x one gallon of juice

= 3x1

= 3 gallons of juice

I NEED HELP WITH THIS QUESTION!!!!

Answers

9514 1404 393

Answer:

  see attached

  (x, y) = (8, 4)

Step-by-step explanation:

The relations given in the problem statement let you write two equations. One for the number of shots, and one for the number of points. The variables x and y are defined in the problem statement.

  x + y = 12 . . . . . total number of shots

  x + 2y = 16 . . . . total number of points

__

These equations are easily plotted by considering their x- and y-intercepts. The x-intercepts of the equations are found when y=0, so are 12 and 16, respectively.

The y-intercepts are found when x=0, so are 12 and 8, respectively. The two lines are shown in the attached. The first is blue; the second is red. Their point of intersection at (x, y) = (8, 4) is circled.

the number of free throws Angel made was 8the number of 2-point shots Angel made was 4

Answer:

the answer is (x, y) = (8, 4)

In AMNO, the measure of Z0=90°, the measure of ZM=13°, and OM = 9.6 feet. Find
the length of MN to the nearest tenth of a foot.

Answers

Answer:

Hypotenuse MN = 10.54 ft (Approx.)

Step-by-step explanation:

Given:

Base OM = 9.6 ft

Angle θ = 13'

Find:

Hypotenuse MN

Computation:

Using trigonometry function

Cos θ = Base / Hypotenuse

Cos 13 = 9.6 / Hypotenuse

0.97 = 9.6 / Hypotenuse

Hypotenuse MN = 10.54 ft (Approx.)

Hey! please help! i don't understand these type of questions! Please answer the question and explain how you got the answer! Thanks!​

Answers

i’m pretty sure you use the formula to find the area for a triangle which is 1/2 over b?
The person above me I exactly correct, if you going to give brainalist give them it

Answer the question

Answers

Answer:

D

Step-by-step explanation:

demos

Use the given information to find the new price. Round to the nearest cent.

Original Price: $28
Discount Rate: 28%

Answers

Answer:

Step-by-step explanation:

7.84 = 8.

Answer:

Original Price: $28

Discount Rate: 28%

new price=?

we have

discount:

28% of 0riginal Price=28/100×$28=$7.84

now

new Price=original -discount price=$28-7.84=$20.16 is your answer

Mrs. Harrison records the number of vacation days employees in her department have used this year. The histogram below shows the recorded data.

Which of the following is the best measure of center for the data?

Answers

I think it’s the mean

Use f(x)=-2x+5 to find x when f(x)=11

Answers

When it asks this question, ultimately you want to plug 11 into x because its f(x). 11=-2+5.

Then you subtract 5 on both sides because of the opposite of addition is subtraction.

6=-2x

now divide on both sides

x=-3

help please need asap

Answers

Answer:

4.5

Step-by-step explanation:

4 * 1.5 = 6

3* 1.5 = 4.5

1.5=4.5
1.5=6
I think

help?? i will mark the correct answer brainlest!!

Answers

Answer: 13 is the first one and the second one is 15

Step-by-step explanation:

SOMEONE PLEASE HELP ME WITH THIS QUESTION IT WOULD MEAN ALOT IM REALLY STRUGGLING

Answers

Answer:

The volunteers should be a group of 10 and meditators should be 5 groups.

Step-by-step explanation:

True or false. If false write the correct statement

1. The depreciation takes place by a specific rate for a specific time​

Answers

it is very much true

Combine the like terms to create an equivalent expression.
2q+2+9

Answers

Answer:

the answer is 2q + 11 because 2 and 9 are like terms so you can add them

Answer:

2q+11

Step-by-step explanation:

khan said so

please help me i really need help please please please

Answers

Answer: ≈117.15375m (if you're expected to round make sure you do so!)

Explanation: Because this a right triangle, you can apply the pythagorean theorem which is a^2 + b^2 = c^2. a and b can be any side except the hypotenuse (the one across from the 90° angle). You take 90^2 + 75^2 = c^2. This equals 13,725 after that you can take the square root of it and you're left with ≈ 117.15375m

Hope this helped! :)

Please help I’ll mark you as brainliest if correct

Answers

Answer:

Option 4 is correct

x° + 126° = 180° and value of x is 54°

Step-by-step explanation:

Here, In a given Triangle two sides are equal i.e., Isosceles Triangle.

We know that, in a triangle the sum of all angles Is 180°.

If two sides are equal then also two angles are also equal of that sides.

Now,

63° + 63° + x° = 180°

x° + 126° = 180°

Now, To find the value of x

x° + 126° = 180°

x° = 180° - 126°

x = 54°

Thus, The value of x is 54°

FOR VERIFICATION ONLY:-

x° + 126° = 180°

54° + 126° = 180°

180° = 180°

Hence, L.H.S = R.H.S

-TheUnknownScientist

Answer:

the value x is 54

I am sure

A. 92%
B. 29%
C. 23%
D. 100%

Branliest to correct answer explain how you solved please

Answers

[tex]\huge\mathfrak\blue{answer}[/tex]

[tex]c) \: 23\%[/tex]

Let's figure out how many pieces of candy there is in total:

10 + 12 + 6 = 28

In total, there are 28 pieces of candy.

Let's find the probability that a piece is sour:

[tex] \frac{10}{28} = \frac{5}{14} [/tex]

The probability of pulling a sour piece out of the bag is 5/14.

This means that the probability that the candy pulled is not sour is 9/15 (or simplified 3/5)

To find the probability that the first candy picked out is sour AND the second candy picked is not sour we have to multiply the probabilities of both:

[tex] \frac{5}{14} * \frac{3}{5} = 0.229 = 23\%[/tex]

[tex]\huge\sf\blue{thank \: you}[/tex]

(Brainliest would be appreciated :))

the simple interest earned from a deposit after 5 years is 8,500. if the interest rate is 8% per annum, how much was deposited?​

Answers

Answer:

Your answer is in the photo attached

Identify the x- and y-intercepts for y = 9 – x2.

Answers

The x-intercept and the y-intercept are ±3 and 9 respectively

Intercept of a function

The x-intercept of a function is the point where y = 0
Given the function y = 9 - x^2

0 = 9 -x^2
x^2 = ±9
x = -3 and 3

The y-intercept of a function is the point where x = 0
Given the function y = 9 - x^2

y = 9 -0^2
y = 9

Hence the x-intercept and the y-intercept are ±3 and 9 respectively

Learn more on intercept here; https://brainly.com/question/1884491

#SPJ1

In ΔABC, the measure of ∠C=90°, the measure of ∠A=63°, and AB = 35 feet. Find the length of CA to the nearest tenth of a foot.

Answers

Answer:

x ≈ 15.9 ft

Step-by-step explanation:

Reference angle = <A = 63°

Hypotenuse = AB = 35

Adjacent = CA = x

Apply trigonometric function CAH:

Cos A = Adj/Hyp

Plug in the values

Cos 63 = x/35

35 × cos 63 = x

15.8896675 = x

x ≈ 15.9 ft

solve for the equation
5= g/8
g=? g equals

Answers

STEP BY STEP BREAK DOWN.

rewrite the equation to g/8=5

multiply both sides by 8

cancel the common factors (cancel both 8s)

rewrite g=8 x 5

solve 8 x 5 (equals 40)

g=40

Please help quickly what's the answer Ill give u brainlest
Richard deposits $193.67 every month into his mortgage. At the end of 30 years, he has a balance of $120,182.07. What interest has accrued (been earned) over 30 years?

Answers

Answer:

$50,460.87 of interest has been accrued.

Step-by-step explanation:

Richard deposits $193.67 every month into his mortgage.

Each year as 12 months. So after 30 years he will have deposited:

$193.67*12*30 = $69,721.2

At the end of 30 years, he has a balance of $120,182.07. What interest has accrued (been earned) over 30 years?

Interest is total subtracted by deposits. So

120,182.07 - 69,721.2 = $50,460.87

$50,460.87 of interest has been accrued.

a = 10, b = 24, c = _____

Answers

Answer:

c=26

Step-by-step explanation:

By using pythagoram thoerem

c^2=a^2+b^2

c^2=(10)^2+(24)^2

c^2=100+576

c^2=676

c=sqrt(676)

c=26

c=26

Determine the ordered pair of the y-intercept of the function below:
y= x2 + 4x – 8

Answers

Answer: If you want to graph it this is ez (0, -8)

Step-by-step explanation:

Two methods, A and B, are available for teaching a certain industrial skill. The failure rate is 30% for method A and 10% for method B. Method B is more expensive, however, and hence is used only 20% of the time. (Method A is used the other 80% of the time.) A worker is taught the skill by one of the two methods, but he fails to learn it correctly. What is the probability that he was taught by using method A

Answers

Answer:

Probability that he was taught by using method A is 14/17

Step-by-step explanation:

Following probabilities are given -  

P (F|A) = 0.2

P (F|B) = 0.1

P (A) = 0.7

P (B) = 0.3

Now, P(A|F) = { P (F|A)* P(A)}/{{ P (F|A)* P(A)} + P (F|B)* P(B)}}

P(A|F) = (0.2*0.7)/( (0.2*0.7)+(0.1*0.3)) = 14/17

How many three letter passcodes can you make, where the first letter must be a vowel?

Answers

Answer:

app

and

ack

abc

as.s (my favorite)

add

all

i can make more im just lazy lol have a good day kind sir/madam/person

The garden staff can mow 45 lawns in 10 hours at this rate how many lawns can they mow in 6 hours

Answers

Answer:

b

Step-by-step explanation:

Answer:

27 lawns.

Step-by-step explanation:

45÷10

4.5

So every hour they mow 4.5 lawns.

Now do 4.5 • 6

So 27 lawns

Hope this helps

PLEASE PLEASE PLEASE HELP!

Answers

9514 1404 393

Answer:

  x + 3

Step-by-step explanation:

If x > 5, the quantity x+3 is always positive. The absolute value symbol does nothing in that case, so the simplified expression is ...

  x + 3

Answer:

the answer is x+3

Step-by-step explanation:

:)))))

Other Questions
How does changing one of the 3 necessities affect seed germination? polynomial in the form ax^2+b+c Why did the crew have to put on life jackets? relationship Break up because of a number of reasons. name and explain three factors that contribute to a detrimental relationship Gregor Mendel's research consisted of using parent pea plants that were pure breeds. What genotype(s) would be considered pure breeds? (use the letter "B" and/or "b" in your genotype) * A teacher pushes on a wall with a force of 125N but the wall does not move. Calculate the amount of work in Joules the teacher accomplished. Study the dashed arrows in the image.A diagram of the Earth rotating on its axis. A red horizontal line through the center of the Earth shows the Equator. A double headed arrow runs vertically through the center of the Earth and is labeled Intended path. A line begins at the bottom right of the Earth, curves to pass through the center, and ends in the top right.What causes the arrows to move in this direction?Earth rotatingair moving to the polesEarths equatorwind moving over short distances The employment relationship is a contractual relationship between the employer and the employee.a. Trueb. False what is [tex]\sqrt{x} 192[/tex] Which of the following is the equation of the function below? y=2csc[2(x+pi)]-2 y=0.5sec[2(x+pi)]-4 y=0.5csc[2(x+pi)]-4 y=2csc[2(x+pi)]-2 john Adams, our second president, disagreed with his wife that How did the various groups of Muslims expand the empire through the years?A) They used military tactics.B) They made alliances and conquered by force.C) They flooded new regions with large numbers of Muslims.D) They made treaties with neighboring regions. What is the Pythagorean theorem A parabola has the same vertex as the parabola y = 3(x 1)2 + 6 and has a y-intercept of 7. What is the equation of the parabola? Please help is everyone equal American Calculate the pH of a solution with [H+]=1.45x10-10 . Is the solution acidic or basic What criteria would you use to select a group of people to draft a constitution today? Find the volume of the prism make short advocacy about education Redox reactions include which types of reactions?A. Single-replacement, double-replacement, acid-base, synthesisB. Single-replacement, synthesis, decomposition, combustionC. Acid-base, decomposition, double-replacement, synthesisO D. Double-replacement, combustion, synthesis, decomposition