Consider an investment where the cash flows are:

$1197.42 at timet= 0 (negative since this is your initial investment)

$476 at timet= 1 in years

$448 at timet= 2 in years

$454 at timet= 3 in years

(a)Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below.(b)What is the value of IRR found by Solver?

Problem #2: Consider an invesuneot where the cash ows are: -$1197.42 at time I =(l {negative since this is your initial investment) $47letmel=linjrears $448311ime r=2inyeers $454311ime I=3 injrears in} Use Excel's \"Solver" to nd the internal rate of remm {IRE} of this investment. Take e screen shot showing Solver open with your entries for the function clearly,r visible) Paste the screen shot into an application (like Paint}, and save it as e (.png} le. Upload your sereenshot below. {Ill What is The value of IRR found by Solver? Problem #25:): Choose File No le chosen Upload Now lI Answer as a percentage Pr ble #2 b : . D m i 1 correctto 2 [Journals Just Save Submit Problem #2 for Gradlng Problem 2 enema #J. Artemg #2 Artemg #3 Attemg #4 Attem #5 Your Answer: 203] 23:] ZEb) 2[b] 2[bj Yourl-'Iark:2b 2b 2b 2b 2b