P11-22 (similar to) Question Help are (Payback and discounted payback period calculations) The Bar-None Manufacturing Co. manufactures fence panels used in cattle food lots throughout the Midwest. Bar-None's management is considering three investment projects for next year but doesn't want to make any investment that requires more than three years to recover the firm's initial investment. The cash flows for the three projects (Project A, Project B, and Project C) are as follows: a. Given Bar-None's three-year payback period, which of the projects will qualify for acceptance? b. Rank the three projects using their payback period. Which project looks the best using this criterion? Do you agree with this ranking? Why or why not? c. Bar-None uses a discount rate of 10.3 percent to analyze projects, what is the discounted payback period for each of the three projects? I the firm still maintains its three-year payback policy for the discounted payback, which projects should the firm undertake? a. Given the cash flow information in the table, the payback period of Project Ais years. (Round to two decimal places.) 4 enalty 2 Data Table Irrect: 0 Questiot Project $(11.000) 4,000 Year 0 1 2 3 4 5 0/10) 10/10) 0/10) 3(0/10) 1-12 (excel pro Project A $1900) 650 400 160 90 480 3.500 Project ${5 300) 1,500 1.800 4,000 4,000 4.000 3.500 3,500 3.500 Print Done Enter your answer in the answer box and thed Clear A 13 parts remaining W P