2022S PROJ1002(A2S) lecture notes - Excel File Home Insert Page Layout Formulas Data Review View Help QuickBooks Tell me what you want to do Cut Calibri 11 -A A ab Wrap Text General Copy Paste B I U A == Merge & Center $% Format Painter S Font 5 Alignment Number E Clipboard A23 A = x fx B D E Conditional Format as Formatting Table F G H 1 4 ABC Company is studying a project that would have a five year life and 5 require a $1,600,000 investment in the equipment. At the end of five years, the 6 project would terminate and the equipment would have no value left over. 8 Yr2020 Dec31, 2020. 7 The project would provide net income each year as follows: 9 Sales 10 Less COGS 11 Gross Margin 12 13 Less: Operating Expenses 14 Advertising and other fixed exp 15 Salary Expense 16 Amortization Expense 17 Total Expenses 18 19 3,200,000 300,000 2,900,000 1,200,000 1,400,000 100,000 2,700,000 200,000 20 Net Income 21 22 The company's discount rate is 25% 23 24 compute the net present value of the project. Is it acceptable? 4 Sheet2 W4 A1 Sheet1 A1S Sheet3 A2 A2S Sheet6 NPV1 NPV2 A4 Sheet4 Sheet5 Sh + Ready Accessibility: Investigate