10:47 AM Sat Jun 27 11% Mod 1 Assignment.xlsx A + BIUS A . 50 120.000 10000 1000 3400 SO 5.500 5. . 5.50 . S.900 re Denne S. 10.000 DOO 015 000 10.800 14.500 500 4500 5500 2.50 2500 2500 0.000 IME Cash Back : - 50 son GO So SO 500 15 100 000 BOSS DE BOB B000 10 200 08 008 BOTE IN N fx Enter text or formula -SUM D16:M16) D Based on the two projects and cash basis of accounting income statements, calculate the corresponding cash flows, taxes, After Tax Cash Flows, and the present value of after tax cash flows for each Year (assuming an in discount rate). Be sure to complete all cells highlighted in yellow Additionally, tell me if you had to pick between project 1 and project 2, which project would be more financially viable which project is more financially viable?? Cash Basis of Accounting Yr D YE 1 YT 2 Y 3 Yr 4 Yr 5 Yr 6 Y 7 Yr 8 Y 9 Yr 10 Total Initial Investment in Project 1 120.000 Revenue 100,000 120,000 140,000 160,000 170,000 170,000 160,000 140.000 120.000 100,000 1.380,000 Supplies Expense Interest Expense Depreciation Expense Salaries Expense 5.000 5.500 10.000 65 000 5.000 5.500 10,000 75.000 5.000 5,500 30,000 75,000 5,000 5,500 10.000 5,000 5,500 10,000 90.000 5,000 5,500 10,000 90,000 5,000 5.500 10,000 90.000 5.000 5.500 10 000 90 000 5,000 5,500 10,000 90.000 5,000 5,500 30.000 80 000 50,000 55,000 100,000 835,000 Net Income 14500 24,500 4500 49,500 59,500 59.500 49.500 29.500 9,500 (500 340,000 Cash Flower (20,000) Tax (Marginal Rate 395) After Tax Cash Flow 120,000.00 NPV of Project Present Value of Alter Tax Cash Flow Cash Basis of Accounting Yr YE Y YF 3 4 5 Y 8 Yr 10 6 Total Credits vs Deductions ATCF Taxable income Type here to search o SH X2 2 Present Value of Afer Tax Cash Flow No Project Cash Basis of Accounting Yr 1 Yr Yr 2 Yr 1 Yr 4 YT 5 Yr 6 Yr 7 YE 9 Tr 10 Total Initial Investment in Project 2 (20,000 Revenue 170,000 170,000 160 000 160 000 120,000 120,000 120,000 120,000 100,000 100.000 1,30 000 5.000 5,000 Supplies Expense Interest Expense Depreciation Expense Salaries Expense 5.000 5.500 10000 65.000 5.000 5.500 10.000 75.000 5.000 5,500 30 DO 75.000 5.000 5,500 30 000 90,000 5.000 5,500 10,000 90,000 5.500 10.000 90,000 5.500 10,000 90,000 5,000 5.500 10.000 90.000 5,000 5,500 10 000 90,000 5.000 5.500 10.000 80.000 50.000 55000 100,000 835.000 Net Income 84,500 74 500 64.500 49,500 9,500 9.500 9.500 9.500 (10 500 1500) 300,000 Cash Flow 120.000 Tax Marginal Rate 39%) After Tax Cash Flow 120,000.00 NPV of Project Present Value of After Tax Cash Flow Credits vs Deductions ATCF Taxable income O Type here to search hp