Use Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial investment is $60,000. The returns on investment in dollars for the following 5 years are (a) $10,000, (b) $12,000, (c) $15,000, (d) $21,000, and (e) $26,000. Use the IRR function to compute the internal rate of return after 2, 4, and 5 years. Next, assume that the loan for the initial $60,000 is at 8 percent and you are earning 16 percent on the annual returns. Use the MIRR function to calculate the internal rate of return. Required: 1. What is the Internal Rate of Return after 2 years? -46% -20% -1% -10% Required: 2. What is the Internal Rate of Return after 4 years? -46% -20% -1% 10% Required: 3. What is the Internal Rate of Return after 5 years? 10% 16% 8% 20%

Use Excel to calculate the solutions to the following problems. Your worksheet will be graded on accuracy, dynamic calculations, and presentation of solutions (should be well organized with variables clearly labeled). 1. What is the future value in 30 years of $5,000 invested today at 8.0%? 2. What is the present value of $1,000,000 received 6 years from today if the appropriate discount rate is 4.0%? 3. What is the present value of ordinary annuity of $400 per year for 8 years if the discount rate is 10.0%? 4. What is the future value of an annuity due of $500 deposited per month into account paying 12.0% annually for 25 years?

Use the format in the figure below to perform a financial analysis. Create a spreadsheet to perform the analysis and show the NPV, ROI, and year in which payback occurs. + Perform a financial analysis for a project using the format provided in Figure 4-5. Assume that the projected costs and benefits for this project are spread over four years as fol- lows: Estimated costs are $200,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in Years 2, 3, and 4. Use a 9 percent discount rate, and round the discount factors to two decimal places. Create a spreadsheet or use the business case financials template on the companion website to cal- culate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis. Discount rate 8% Assume the project is completed in Year 0 0 Costs Discount factor…

solve the problem given in the image.