File Home Insert Page Layout Formulas Data Review View ? Tell me what you want to do... To Cut Calibri - 11 - A A Be Wrap Text Number Paste EB Copy 2 - A . E Merge & Center Con Format Painter BIU- - Forma Clipboard Font Alignment Number J49 X V fx B D G H 1 Problem 1 2 B D 3 Future Future 4 Present Value Value Future 5 Value Factor Factor Value 6 a) 7 b) 8 c ) 9 d ) 10 11 12 Problem 2 13 Present Present 14 Future Value Value Present 15 Value Factor Factor Value 16 a ) 17 b ) 18 c ) 19 d ) 20 21 2 Problem 3 23 24 IRR 25 Year Cash Flow Cummulative Cash Flow 26 27 Year 0 28 Year 1 Year 2 29 Year 3 30 Year 4 31 Year 5 32 33 IRR= 34 35 36 Problem 4 37 38 39 Excel 40 less the investment 41 NPV 42 Accept or do not accept the project 43 44 Problem 5 45 What is the payback period for problem 3? 46 47 Payback period = Year before recovery + Year before cummulative cash flow/cash flow for year paid off 48 Payback period (show calculation) = 49 Payback period (show answer)= Template + + Ready EliteDisplay E221i