2. All the problem must be complete with MS Excel (not using MS Excel will result Zero grade). 3. Show your work for full credit. Just showing the answer values will result Zero grade). Problem 1- 10 points After 4 years of use, Company A has decided to replace a capital equipment. Cash flow data is listed in $1000 unit, MACRS 3-year depreciation was used. After tax MARR is 10% per year compounded monthly, Tax rate is 35%. 1. Utilize the CFBT value to determine if the cash flow over 4 years exceeded MARR. 2. Calculate MACRS depreciation and estimate the CFAT series over the 4 years. Determine if the cash flow over 4 years exceed MARR. Problem 2- 20 points Company 8 wants to compare the investment in three different countries based on the following information. Tax rate is 30% for all three countries. MARR is 9% compounded quarterly. 1. Determine the CFAT for the above three countries. 2. Perform a PW Analysis and make a recommendation of which country should the company choose to invest