AutoSave GO a ( >> Thu le Insert Draw Page Layout Formulas Comment 1 A = %" Conditional Formatting Format as Table oard Font Number Cells Editing Sen Cell Styles C Alignment fx D QUESTION # 12 (10 Points) (5 Minute Question) Problem Statement: Understand Present Value vs. Future Value L M O P a The total "Present Value" of the following "FV Cash Flow" streams is $6,832.98 when the Discount Rate = 12% annually. What is the value of the missing (FV) Cash Flow? YOU MUST SHOW THE CALCULATIONS IN EXCEL EQUATION FORMAT: Calculations: PV Year Forecast Year-End Cash Flow (FV) Discount Rate, % 1 2 $1,150.00 $2.157.60 12.0% PV of Year (1) 12.0% PV of Year (2) 3 12.0% PV of Year (3) 4 $2.600.00 12.0% PV of Year (4) = (11) SWOT & PORTER MODELS Ready Accessibility: Investigate Book Pro F7 DII FB @ = FV/(1+r) = (1,150.00/1.12) = (2,157.60/1.127 (3,419.34/1.12) (2,600.00/1.12) PV (12) PV & FV CALCULATIONS (13) REAL RATE OF RE tv A DD F9 F10 24 W X F12