1.

part 2

Part 3

File Home Insert Page Layout Formulas Data Rei Arial 12 A A X Cut LECopy Format Painter Paste BIU. A 1.1.1 Clipboard Font : A Year B Cash Inflows (Outflows) 1 1 2 0 3 4 2 5 3 6 4 7 5 8 9 Annual discount rate 10 Net present value 11 Internal rate of return ($200,000) $40,000 $80,000 $38,000 $50,000 $58,000 8.00% $12,015.09 10.23% Applying Excel 8: Calculating internal rate of return Which of the following formulas correctly calculates the internal rate of return of this $200,000 investment in cell B11? Multiple Choice EIRR(B3:37) =IRR(B9,B2:B7) =IRR(B2:B7) =IRR(B2:39) File Home Insert Page Layout Formulas Data Review View Help 11 - ab Wrap Texd % Cut Copy Paste Format Painter Clipboard Merge & Font Alignment . ROUND X =B1*$C$1 . B D 1 =B1*$C$1 25 $4.75 $5.00 2 30 3 4 The formula in cell A1 is =B1*$C$1. This formula is copied to cell A2. What is the resulting formula in cell A2? Multiple Choice =B2*$C$1 =B2*$C1 =B2*$C2 =B2*C2 B D 1 Which formula properly calculates the future value of monthly deposits of $400 left on 2 deposit for 20 years at an annual return of 8%? Assume an initial deposit of $50,000. Your formula must return a positive value. 3 4. Initial deposit $50,000 5 Monthly deposit $400 6 Annual return 8% 7 Number of years 20 8 Payments per year 12 9 Multiple Choice =-FV(B6/B8,87*B8,,B4) =-FV(+B6/B8,B7*B8,+B5) =-FV(B6/B8,87*B8,B5,B4) =FV(B6/B8,B7*B8,B5,B4)