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]
3 years ago
12

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

Mathematics
1 answer:
Harman [31]3 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
Robert is purchasing some equipment for his baseball team. He wants to buy some baseballs, each priced at m dollars. He has alre
KiRa [710]

Answer:

Part A: (1/2)m

Part B: (1/3rd)b and 3mx

Step-by-step explanation:

Price of each baseball is=$m

Price of other equipment are=$b collectively

Total amount He spent on purchasing equipment is =(m+b)$

Part A:

in part A the amount on purchasing other equipment than baseball is getting doubled i.e. $2b <u> then value of m will be (1/2)half of the total amount spent on purchasing baseball i.e. (1/2)m</u>

Part B:

in part B the amount spent on purchasing baseball is getting tripled i.e. <u>3m</u>, then value of b(amount of purchasing other equipment) is<u> (1/3rd) of total</u> <u>amount spent on purchasing other equipment</u> and value of mx will be<u> 3mx</u>

4 0
3 years ago
35 is 5% of what number
Naily [24]
35 is 5% of the number 175.
5 0
3 years ago
A moving company’s moving rates can be represented by the function f(x) = 3x + 400, where x is the number of miles for the move.
Diano4ka-milaya [45]

Answer:

B) h(x) = –2x + 200

Step-by-step explanation:

f(x) = 3x + 400

g(x) = 5x + 200

f(x) - g(x) = 3x + 400 - (5x + 200) = -2x + 200

6 0
3 years ago
Read 2 more answers
A motorboat takes 5 hours to travel 100 kilometers going upstream. The return trip takes
tatuchka [14]

Step-by-step explanation:

Let's say b is the rate of the boat in still water, and c is the rate of the current.

Distance = rate × time

Going upstream:

100 = (b − c) (5)

20 = b − c

Going downstream:

100 = (b + c) (2)

50 = b + c

Solve the system of equations using substitution or elimination.  Using elimination, add the equations together:

70 = 2b

b = 35

c = 15

The boat's speed is 35 km/h, and the current's speed is 15 km/h.

8 0
3 years ago
What is the average rate of change for ƒ(x) = −3x + 79 over the interval 2 ≤ x ≤ 4?
Ainat [17]

Answer:

The average rate of change is -3.  

Step-by-step explanation:

Given : Function f(x)=-3x+79 over the interval 2 ≤ x ≤ 4.

To find : What is the average rate of change ?

Solution :

Function f(x)=-3x+79 over [2,4]

The rate of change is the slope of the line,

So, \text{Rate of change}=\frac{f(4)-f(2)}{4-2}

f(4)=-3(4)+79

f(4)=-12+79

f(4)=67

f(2)=-3(2)+79

f(2)=-6+79

f(2)=73

Substitute,

\text{Rate of change}=\frac{67-73}{4-2}

\text{Rate of change}=\frac{-6}{2}

\text{Rate of change}=-3

Therefore, The average rate of change is -3.

8 0
3 years ago
Read 2 more answers
Other questions:
  • Brian rolls 2 fair dice and adds the results from each. Work out the probability of getting a total that is prime.
    15·1 answer
  • Out of a population of 1,500 students, 100 were asked by a random sampling to choose their favorite national park. Their respons
    11·2 answers
  • Earth is approximately 9.3 × 107 miles from the sun. Saturn is approximately 8.87 × 108 miles from the sun. About how much farth
    7·1 answer
  • How do you find the inverse of y=2x-3
    9·1 answer
  • Can someone please help!:)
    5·2 answers
  • Suppose Rm (3,-4)=(1,1) and Rn (1,1)=(-5,16) Is m || n? Explain.
    5·1 answer
  • Find the slope of the line that contains the points (-2, 5) and (-1, 7).
    5·1 answer
  • Joe makes an hourly wage of $14.00. Last week, Joe worked 58 hours.
    12·2 answers
  • Y = -3/5x + 17
    11·1 answer
  • Dear Garden Designer,
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!