Answer:
The correct answer is B.
Explanation:
Giving the following information:
Cash flow= $500
Number of months= 50
Monthly interest rate= 0.07/12= 0.00583
First, we need to calculate the future value using the following formula:
FV= {A*[(1+i)^n-1]}/i
A= cash flow
FV= {500*[(1.00583^50) - 1]} / 0.00583
FV= $28,928.06
Now, the present value:
PV= FV/(1+i)^n
PV= 28,928.06/(1.00583^50)
PV= $21,631.67
Answer:
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
Explanation:
In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
The cells provided in the formula above is just an example and more than two cells can be selected.
The answer is environment, this is the word that the wall street journals used in having to term the word comfort as this is somehow a word that made sense to them or something that depicts to them for them, environment is a way of having to say that it is comfort or comforting to other people.
Saturn and Jupiter both have large quantities of liquid
hydrogen and liquid metallic hydrogen while Neptune and Uranus just have the
gaseous form of hydrogen because they are too little to compress hydrogen to
its metallic state. Also, the two latter planets have icy cores.
A. $2164.89
Basically just subtract, 3,678.89-1514 = 2,164.89