help on #1 and #2 using this excel sheet. show steps. LYURULURCHPL1 uestion 1 (5 points) O'Mally Department Stores is considering two possible expansion plans. One proposal involves opening 5 stores in Indiana at the cost of $1,840,000. Under the other proposal, the company would focus on Kentucky and ope stores at a cost of $2,300,000. The following information is available: Indiana proposal Kentucky proposal Required investment $1,840.000 $2,300,000 Estimated life 10 years 10 years Estimated residual life $40.000 $50.000 Estimated annual cash inflows over the next 10 years $400,000 $600.000 Required rate of return 1. What is the net present value for the Indiana proposal? 2. What is the internal Rate of Return for the Indiana proposal? Use the attached Excel template to enter our date and answers the spreadsheet will open in a new tab within Respondus Lockdown Browser Practiceuz Chapter 12 FITO SAVE YOUR OR aste the CLICK HERE TO SAVE YOUR WORK J K L M N O plo A B C D E F G H I Steps to solve Time Value of Money Problems Diagram of cash flows for TVM problems oper 50 CON UN Data Rate 196 Legend present value of cash flows interest rate per period payments per period number of periods future value Type of -1-beg or 0-end (blank) annuity Solution $0.00 #NUM! #DIV/0! #DIV/0! $0.00 Nper Do 1 Clear all the data cells 2 Diagram cash flows 3 Fill in data grid 4 Note the solution in the cell next to the blank NPN 4
PLACE YOUR ORDER TO GET STARTEDThe post help on #1 and #2 using this excel sheet. show steps. LYURULURCHPL1 uestion 1 (5 points) O’Mally appeared first on Essay Gem.