FINC3310 im looking for discounted payback period discount rate is 10 percent

62% [4] Wed 12:11 PM Q E Search Sheet Co MMC : Excel File Edit View Insert Format Tools Data Window Help OOO DJ SC_EX_2-2 Asher Franklyn [Last saved by user] Q Home Insert Page Layout Formulas Data Review. Visu Calibri (Body) 11 A- A- OOO @. Le @ Le MC Lu w wa D 5 Capital Budgeting Case PROBLEM SPRING 2020 Q Search Sheet Home Insert Page Layout Formulas Data Review View Arial ,14 A- A Conditional Formatting 5 % Format as Table Paste B IUE A D O E Number Cell Styles N60 xv fx O Payback period years Ins x C (a) C C Gme New T + 3+ (108... * : A Paused ^ examine these to indicate some periods. Editing hrough E N P Q $200 -$ 50 100 100 Discounted Payback Period Year 0 AWN-O Projected CF Discount factor $ (260,000) 1 $ 235,997 255,738 $ 241,760 247,010 Payback period $ 100 - 50,000,000 Discounted CF Cummulative CF Count ($260,000) $ (260,000) 200 $0 (260,000) 200 $0 (260,000) (260,000) (260,000) years ld. The sum of the cash flows for $30 to go. Because the cash flow in that year. When we compare the 9 0 - + 125% $30/$50 = .6; so, payback will occur 60 percent of the way into the year. The payback period is thus 2.6 years. Case and Template Response Sheet3 + Ready Ready vili