Using the dropdowns, construct the functions you would use in Excel to solve for present values. Then, using Excel , enter the formulas you just constructed to calculate the answers. If one of the elements is zero, be sure to enter "0" in the appropriate field. Use the answers from Excel to fill in the "Total" in the activity; make sure you always enter "Total" as a POSITIVE number rounded to the nearest whole dollar. (Note: When entering Time Value of Money problems one of the amounts must be negative. In this activity, enter PMT as negative in STEP 1 and FV as negative in STEP 2. Rate should always be entered as a decimal rounded to two decimal places; do NOT enter rate as a percent.) STEP 1: STEP Z