PLEASE SEE ATTACHMENT
I NEED HELP WITH THE ANNUITY PAYMENT (HIGHLIGHTED IN YELLOW) WHICH HAS TO BE POSITIVE AND NOT NEGATIVE.
Directly below these instructions is a blank table to compute PV factors.
Using cell formulas or functions, calculate the PV for the years and interest rates
given. Remember, only use cell formulas and reference the years and interest
rates that are on the borders of the table. Following the tables are TVM problems that
require that you calculate PV, FV, periods, or the interest rate. The answer cell is the
yellow shaded cell. Place your solution in the yellow cell provided below each problem.
Remember use cell formulas throughout. Also, you may use Excel =functions.
The =PV =FV =NPV =IRR =RATE may be helpful. Never hardcode numbers in the
cell formulas. For example, do not put the interest rate or periods in the cell formula,
only reference the proper cell on the border of the table.
Do not add or delete columns or rows, the cell references must be the same as my original.
Please see the attached file. In excel the future value is to be entered with ...
The solution explains the time value of money calculations using excel.