please show all excel functions and formulas

PV & FV IRR Goal Seek Solver Example 1 Example 2 Discount Rate 10% Discount Rate 10% PV PV Year 1 2 3 4 5 Cash Flow 100 100 100 100 Year 0 1 2 3 4 Cash Flow 100 100 100 100 100 100 NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) FV (Method 1: FV-One CF, End of Yr 5) FV (Method 2: FV-Multiple CF, End of Yr 5) NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) FV (Method 1: FV-One CF, End of Yr 5) FV (Method 2: FV-Multiple CF, End of Yr 5) Example 3 Example 4 Discount Rate 10% Discount Rate 10% PV PV Year 1 2 4 6 Cash Flow 100 100 100 100 100 Year 1 2 3 4 4 (Face Value) Cash Flow 100 100 100 100 10000 8 NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) FV (Method I: FV-One CF, End of Yr 8) FV (Method 2: FV-Multiple CF, End of Yr 8) NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) PV & FV IRR Goal Seek Solver Example 1: IRR Year Cash Flow 0 -800 1 200 2 250 3 300 4 350 5 400 Year 0 1 2 3 4 5 Example 2: IRR Cash Flow -145 100 100 100 100 -275 Solver PV & FV IRR Goal Seek Example 1: Goal Seck Example 2: Goal Seek The Goal Seek Function DATA. Whilf Analysis -Goal Seck Year 0 1 2 3 4 5 Cash Flow -800 200 250 300 350 400 Year 0 1 2 3 4 5 Cash Flow -2000 200 400 600 800 1000 At what discount rate Discount rate NPV At what discount rate will NPV equal to 0 Discount rate NPV PV & FV IRR Goal Seek Solver Example 2: Solver Cash Flow -20 Example 1: Solver Year 0 1 2 3 4 5 Cash Flow -70 100 100 100 100 -275 Year 0 1 2 3 4 5 150 200 500 600 -1500 At what discount rate will we have highest NPV? Discount Rate NPV At what discount rate will we have highest NPV? Discount Rate NPV At what discount rate will we have NPV equal to 70? The discount rate has to be below 30% Discount Rate NPV At what discount rate will we have NPV equal to 707 The discount rate has to be below 30% Discount Rate NPV Goal Seek Solver The Solver Function: File - Options - Add-Ins - Solver add-In - Go Data - Solver Year 0 1 2 3 4 5 Example 2: Solver Cash Flow -20 150 200 500 600 -1500 At what discount rate will we have highest NPV? Discount Rate NPV At what discount rate will we have NPV equal to 70? The discount rate has to be below 30% Discount Rate NPV PV & FV IRR Goal Seek Solver Example 1 Example 2 Discount Rate 10% Discount Rate 10% PV PV Year 1 2 3 4 5 Cash Flow 100 100 100 100 Year 0 1 2 3 4 Cash Flow 100 100 100 100 100 100 NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) FV (Method 1: FV-One CF, End of Yr 5) FV (Method 2: FV-Multiple CF, End of Yr 5) NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) FV (Method 1: FV-One CF, End of Yr 5) FV (Method 2: FV-Multiple CF, End of Yr 5) Example 3 Example 4 Discount Rate 10% Discount Rate 10% PV PV Year 1 2 4 6 Cash Flow 100 100 100 100 100 Year 1 2 3 4 4 (Face Value) Cash Flow 100 100 100 100 10000 8 NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) FV (Method I: FV-One CF, End of Yr 8) FV (Method 2: FV-Multiple CF, End of Yr 8) NPV (Method 1: Sum) NPV (Method 2: NPV) NPV (Method 3: PV) PV & FV IRR Goal Seek Solver Example 1: IRR Year Cash Flow 0 -800 1 200 2 250 3 300 4 350 5 400 Year 0 1 2 3 4 5 Example 2: IRR Cash Flow -145 100 100 100 100 -275 Solver PV & FV IRR Goal Seek Example 1: Goal Seck Example 2: Goal Seek The Goal Seek Function DATA. Whilf Analysis -Goal Seck Year 0 1 2 3 4 5 Cash Flow -800 200 250 300 350 400 Year 0 1 2 3 4 5 Cash Flow -2000 200 400 600 800 1000 At what discount rate Discount rate NPV At what discount rate will NPV equal to 0 Discount rate NPV PV & FV IRR Goal Seek Solver Example 2: Solver Cash Flow -20 Example 1: Solver Year 0 1 2 3 4 5 Cash Flow -70 100 100 100 100 -275 Year 0 1 2 3 4 5 150 200 500 600 -1500 At what discount rate will we have highest NPV? Discount Rate NPV At what discount rate will we have highest NPV? Discount Rate NPV At what discount rate will we have NPV equal to 70? The discount rate has to be below 30% Discount Rate NPV At what discount rate will we have NPV equal to 707 The discount rate has to be below 30% Discount Rate NPV Goal Seek Solver The Solver Function: File - Options - Add-Ins - Solver add-In - Go Data - Solver Year 0 1 2 3 4 5 Example 2: Solver Cash Flow -20 150 200 500 600 -1500 At what discount rate will we have highest NPV? Discount Rate NPV At what discount rate will we have NPV equal to 70? The discount rate has to be below 30% Discount Rate NPV