Please help me with these formulas!

ezto.mheducation.com C Question 1 - 3.9 Excel Spreadsheet Assignment #1 - C... Course Hero FIN 300 Exam 2 Flashcards | Quizlet Lohn Corporation is expected to pay the following di. + Not found Q syno Done 3.9 Excel Spreadsheet Assignment #1 Saved Help Save & Exit Submit Calculating IRR - Excel X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Ruler Formula Bar 10 Normal Page Break Page Custom Zoom 100% Zoom to Window Macros Preview Layout Views Gridlines |Headings Selection points Workbook Views Show Zoom Macros A1 X Print A B D E F G H K What is the IRR of the following set of cash flows? BUT A W N H Annual cash flows: Year 0 (13,900) Year 1 6,400 Year 2 8,700 Year 3 5,900 11 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 15 IRR 16 Mc Graw Hill ezto.mheducation.com C Question 2 - 3.9 Excel Spreadsheet Assignment #1 - C.. Course Hero FIN 300 Exam 2 Flashcards | Quizlet Lohn Corporation is expected to pay the following di. + 3.9 Excel Spreadsheet Assignment #1 Saved Help Save & Exit Submit 2 Calculating NPV - Excel 6 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Connections Clear B-1 To Reapply From From From From Other Existing Refresh Properties 10 I! Sort Data Outline Access Web Text Sources - Connections All - los Edit Links Filter Advanced Tools points Get External Data Connections Sort & Filter G10 Print G H What is the NPV of the following cash flows at a discount rate of zero percent? What if the discount rate is 10 percent? If it is 20 percent? If it is 30 percent? Year 0 (13,900) Year 1 6,400 Year 2 8,700 Year 3 5,900 Discount rate 0% Discount rate 10% Discount rate 20% Discount rate 30% calculations. You must use the built-in Excel function to answer this question. NPV at 0 percent NPV at 10 percent NPV at 20 percent 25 NPV at 30 percent Sheet1 + READY -- 70% Attempt(s) Mc Graw