Use the following excel file and data to present net value (total worth) and future net value (ignoring compounding). Here are the formulas that you will need. Use absolute cell referencing in your equations.
PNV (present net value) = savings – debt
FNV (future net value) = (income * saving % * 30) + (income * saving % * 30 * interest) + PNVUse conditional formatting to highlight in the cell in green with the highest number for each category of income, savings, debt, saving %, PNV and FNV. Do the same for the lowest number in yellow.
On a separate sheet, make a bar graph with two series of data, future net value and present net value.
Data is attached
For this challenge I submitted the following:
