Using Excel, construct the following scenarios based on situations related to personal finance situations:

1. Present value of a lump sum.
2. Present value of an annuity.
3. Future value of a lump sum.
4. Future value of an annuity.

(NOTE: An example of the PV of a lump sum may be: "A client is expecting the need to purchase a new car in three years. They would like to deposit an amount now to cover this purchase in cash. How much would they need to deposit into an account earning 7% today, to have $20,000 in three years to purchase the new car?")

Submit your Excel template with four sheets. Include one scenario on each sheet with an explanation paragraph and a summary of the data calculation.

THE QUESTION: I do not understand the assignment prompt and would like further explanation. Am I just supposed to make the data up? Or should I cite from something? I am doing something wrong because my work is not equating 4 pages but two, but im fairly sure my two pages of made up data is not correct either. This is the first assignment I have gotten so I am still at a loss. plz help :(

Also this is everything I was given to do the assignment.