answer all questions and use excel

Box final answers Write out the formula when using EXCEL. Must draw cash flow diagram. 1(a) What nominal interest rate per year is equivalent to an effective 18% per year, compounded monthly? (3 Points) 1b At time t-0, an engineer deposited $10,000 into an account that pays interest at 8% per year, compounded semiannually. If she withdrew S1000 in months 2, 5, 8, 11, and 23, and paid in $500 in months 3, 7 and 22, what was the total value of the account at the end of 3 years? Assume no interperiod compounding. (7 Points) 2 The alternatives below are mutually exclusive and the MARR is 15% per year. Vendor 1 Vendor First Costs - 15000 18000 Annual cost. Sper year-3500 -3100 Revenue. Sper year 2000 2500 Salvage value, 2000 3000 Life, years w Determine which vendor should be selected on the basis of a present worth comparison, if the MARR is 15% per year. (b) MUST DO USING EXEL. This company has a standard practice of evaluating all options over a 5-year period. If a study period of 5 years is used and the salvage values are not expected to change, which vendor should be selected? (10 Points) Box final answers Write out the formula when using EXCEL. Must draw cash flow diagram. 1(a) What nominal interest rate per year is equivalent to an effective 18% per year, compounded monthly? (3 Points) 1b At time t-0, an engineer deposited $10,000 into an account that pays interest at 8% per year, compounded semiannually. If she withdrew S1000 in months 2, 5, 8, 11, and 23, and paid in $500 in months 3, 7 and 22, what was the total value of the account at the end of 3 years? Assume no interperiod compounding. (7 Points) 2 The alternatives below are mutually exclusive and the MARR is 15% per year. Vendor 1 Vendor First Costs - 15000 18000 Annual cost. Sper year-3500 -3100 Revenue. Sper year 2000 2500 Salvage value, 2000 3000 Life, years w Determine which vendor should be selected on the basis of a present worth comparison, if the MARR is 15% per year. (b) MUST DO USING EXEL. This company has a standard practice of evaluating all options over a 5-year period. If a study period of 5 years is used and the salvage values are not expected to change, which vendor should be selected? (10 Points)