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
aleksley [76]
2 years ago
12

You recently discovered that your job provides a 25% matching towards your retirement.

Mathematics
1 answer:
Harman [31]2 years ago
3 0

Answer:

What is typed in the attached Excel file is =FV(B4,B5,-B3,0,0).

Step-by-step explanation:

Note: See the attached excel file for the calculation of future value of an ordinary annuity.

Since we want to find the balance after 30 years, the function in the Excel is the FV function which is used to calculate the future value (FV) of an ordinary annuity as follows:

=FV(rate,nper,-pmt,0,0) …………………… (1)

rate = Monthly interest rate = APR / 12 = 8.99% / 12 = 0.0899 / 12 = 0.00749166666666667. Note: This is typed in cell B4 in attached excel file.

nper = periods = number of months = 30 years * 12 months = 360. Note: This is typed in cell B5 in attached excel file.

pmt = monthly payment = $300. Note: This is typed in cell B3 in the attached excel file. And also typed as a negative value in cell B7, i.e. as -B3.

pv = present value = 0. Note: This is the first 0 typed in cell B7 in the attached excel file.

type 0 = 0 this is typed to indicate that deposit is made at end of period as a regular or ordinary annuity. This is the second 0 typed in cell B7 in the attached excel file.

Based on the above, the FV function in equation (1) above is converted to the following which is typed in the attached Excel file to find the balance after 30 years:

=FV(B4,B5,-B3,0,0)

The above then gives a future value of $548,080.11 which is  the balance after 30 years.

Download xlsx
You might be interested in
Formula for the surface area of a cylinder, SA = 2ar2 + 2arh. Solve for h.
MakcuM [25]

Answer:

h=\frac{SA-2\pi r^2}{2\pi r}

Step-by-step explanation:

The formula for the surface area of a cylinder is:

SA=2\pi r^2+2\pi rh

And we want to solve for the height h.

First, subtract 2\pi r^2 from both sides. This yields:

2\pi rh=SA-2\pi r^2

Now, divide both sides by 2\pi r. This yields:

h=\frac{SA-2\pi r^2}{2\pi r}

And we're done!

8 0
3 years ago
Find the discriminant of the equation. x2 + 3x - 4 = 0
ivann1987 [24]

Please use " ^ " to indicate exponentiation: x^2 + 3x - 4 = 0

Here, a = 1, b = 3 and c = -4.

The formula for the discriminant is b^2 - 4(a)(c).

Substituting the given values of a, b and c, we get:

(3)^2 - 4(1)(-4)

Evaluating this, we get 9 + 16 = 25.

The discriminant is 25.

-3 plus or minus √25

Taking this further, x = ------------------------------------

2

-3 plus or minus 5

or: x = -------------------------------- => {-4, 1} (solutions)

2

5 0
3 years ago
Read 2 more answers
Someone pls help me I will make you brain
Sergio039 [100]
The answer is the 2nd choice, number of sales.

The function described f(x) = B + Cx
5 0
2 years ago
What is a proportation??<br> I need help
Elden [556K]

Answer:

what probortation?

Step-by-step explanation:

5 0
2 years ago
Read 2 more answers
How are the divisibility rules involved with the simplification of fractions?
Rashid [163]
Because when you simplify a fraction you divide the number on bottom be the top number to simplify the fraction and make it a mixed number
5 0
3 years ago
Other questions:
  • Convert the repeating decimal 0.2323232323...... into a fraction.
    13·1 answer
  • Polynomial standard form for the square root of 7n^4
    7·1 answer
  • Given △RST ~ △RQP.<br><br><br> What is the value of x?
    11·2 answers
  • The quotient of two numbers is 20. Their sum is 84. What are the two numbers?
    6·1 answer
  • Given a rectangle with demensions 5cm and 10cm as shown find the length of the diagonal If possible
    7·1 answer
  • What is the average speed of a biker if she biked 4.25 of a mile in 25 minutes?
    6·1 answer
  • The substitution method solve 6x-y=3 4x+3y=1
    10·2 answers
  • F (x)=2x-1<br>find (-1)​
    13·1 answer
  • Solve -17 = x/-3 for x.
    10·2 answers
  • pls help me with this i’ve been stuck on it for a while but i did it on paper and it doesn’t look right
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!