it is fine take your time but please i need the answer for this assignment

thank you

1. Understand how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c) Develop problem-solving and critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment 4 years 2) New equipment cost 3) Equipment Ship & Install cost 4) Related start up cost Inventory Increase 6) Accounts Payable increase 7Equip. salvage value before tax Sales for first year (1) -200.000 9) Sales increase per year -35.000 10) Operating cost of Sales) -5.000 (as a percent of salesia Yeart) 25.000 11) Depreciation (Straight LineYR 5.000 12) Marginal Corporate Tax Rate (T) 15.000 13) Cost of Capital Discount Rate ESTIMATING Initial Outlay Cash Flow. CF. TEO) CFO CF1CF2CF3 Investments: 1) Equipment cost 2) Shipping and Install cost 3) Start up expenses Total Basis Cost (1+2+3) 4) Net Working Capital Total Initial Outlay Operations: Revenue Operating Cost Depreciation EBIT Taxes Net Income Add back Depreciation Total Operating Cash Flow Terminal 1) Change in net WC 2) Salvage value (after tax) Total Salvage Value Before Tax (1-1) Project Net Cash Flows 0 0 0 NPV- IRR = Payback (a) EN 011 Would you accept the project based on NPV, IRR? Would you accept the project based on Payback rule if project cut-off is 3 years? Q82 Impact of 2017 Tax Cut Act on Net Income, Cash Flows and Capital Budgeting (Investment ) Decisions Estimate NPV, IRR and Payback period of the projectif equipment is fully deprecated in first year and tax rate equals to 21%. Would you accept or reject the project? (b) As a CFO of the firm, which of the above two scenario (a) or (b) would you choose? Why? Q83 How would you explain to your CEO what NPV means? Q84 What are advantages and disadvantages of using only Payback method? QHS What are advantages and disadvantages of using NPV versus IRR? QH6 Explain the difference between independent projects and mutually exclusive projects. When you are confronted with Mutually Exclusive Projects and have coflicts with NPV and IRR results, which criterion would you use (NPV or IRR) and why