Ga Math vs Short Cuts Assignment (1) (Protected View - Excel View O Tell me what you want to do... Rochelle Herron 2. Sh Data Review Home Insert Page Layout Formulas Enable Editing PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View f K 1 M N E D H F G 1 6 J 7 1 3 3 5 0 Yr 0 2 Yr 2 4 Yr 4 Yr 1 Yr 3 Yr 5 Yr 6 4 Yr 7 5 7 Future Cash Flows (PMT) $12,345 $8,764 $ 654 $1,009 $12,000 $4,567 $32,000 PV of Future Cash Flows (PMTS) 8 SUM 9 10 11 EXCEL FORMULA SHORT-CUT METHOD 12 PMTS 13 RATE 14 NPV 11.50% 15 16 Sheet1 100 8:54 AM 9/27/2020 ligi