Safari File Edit View History Bookmarks Window Help 8 7 100% Fri 8:09 PM Q DE . . . A mailmvnu-my.sharepoint.com C X Week 4 _Finc_Homework_Useful_Hints_062319.xisx Course Hero Assignment How to take a screenshot on your Macbook Air, Pro or. Excel Online Saba Fekadu > Documents Week 4_Finc_Homework_Useful_Hints_062319 - Saved Saba Fekadu er 2 File Home Insert Data Review View Tell me what you want to do Open in Excel Share Comments X Arial 10 A A ab General AutoSum ~ Ap O Paste BIUDab VA $ ~ % 9 -00 Conditional Format Insert Delete Format Clear ~ Sort & Find & Formatting ~ as Table Filter . Select ~ Undo Clipboard Font Alignment Number Tables Cells Editing M18 D E F G H I J K L M N O P Q R S T 1 AWN ($40,000) $9,000 8 years 11% Cash PV Cumulative PV $40,000) ($40,000.00) ($40,000.00) 10 $9,000 $8, 108.11 ($31,891.89) 11 ? 12 13 14 15 hints: 16 17 18 ? 1.page 457 of your text book provides a 19 shortway to calculate NPV using excel 's PM 20 ? NPV function. See figure 12-2. 21 22 2 2. page 460 figure 12-3 provides the 23 excel formula for calculating IRR and a 24 ? years good example Ch 12 Q Ch 12 P Ch 13 Q Ch 13 P + Help Improve Office font 28Safari File Edit View History Bookmarks Window Help 8 7 100% Fri 8:09 PM Q DE . . A mailmvnu-my.sharepoint.com C Week 4_Finc_Homework_Useful_Hints_062319.xisx Course Hero Assignment How to take a screenshot on your Macbook Air, Pro or. Excel Online Saba Fekadu > Documents Week 4_Finc_Homework_Useful_Hints_062319 - Saved Saba Fekadu er 2 File Home Insert Data Review View Tell me what you want to do Open in Excel Share Comments X Arial 10 A A ab General AutoSum ~ Ap O Paste BIUDab VA $ ~ % 9 -00 Conditional Format Insert Delete Format Clear ~ Sort & Find & Formatting ~ as Table Filter . Select ~ Undo Clipboard Font Alignment Number Tables Cells Editing K45 D E F G H I K L M N O P Q R S T 23 24 ? years good example 25 ? rounded 26 3. page 467 figure 12-6 provides the 27 #VALUE! years excel formula for calculating MIRR and a 28 #VALUE! rounded good example 29 30 4. See good example of payback period 31 B-Millions 32 on page 471. Remember it is cost (at ($15,000,000) 33 $20,000,000 time 0) / annual flow. Note the -ve cost 34 $10,000,000 amount and reference your cell 35 $6,000,000 accordingly 36 37 5. page 472 has a good example of 38 $18,300,939.42 discounted payback period and how to 39 calculate it (click the #VALUE! to see a 40 ? quick excel reference formula) PM 41 42 43 Y 44 ($5,000) 45 $4,500 Ch 12 Q Ch 12 P Ch 13 Q Ch 13 P + Help Improve Office font 28