Cash Flow Worksheet HW CHEE 442 Due 10/2 Done individually Problem statement: The balance sheet for a proposed project reveals a fixed capital investment of $350M. Annual total project expenses are estimated to be $150M and sales income as $240M. Calculate annual and cumulative cash flows for an estimated project lifetime of 10 years. Assume the plant is constructed in 3 years with $100M invested the first and second years and $150M in the third. Sales income in year 4 is only 2/3 normal. Working capital is $50M. Assume straight line depreciation with zero scrap value. Interest rate is 20% Activities: Create cash flow worksheet for this problem (in excel) including NPV assuming ROR of 20% 1. Calculate annual and cumulative cash flows for an estimated project lifetime of 10 years 2. Compute Payback Period 3. What is after tax rate of return and DCFRR 4. Find ROI for 2nd year of production tes) could someone please help me with this problem? if possible please give a brief explanation of the steps or the solution. can you do step 1,2 and 4 if possible because the tax rate is missing for step 3