Perform a financial analysis for an IT Project which requires an initial investment of $32,000, but it is expected to generate revenues of $10,000, $20,000 and $15,000 for the first, second and third years respectively. The target rate of return is 12%. Write the formula and calculate the Net Present Value (NPV). In addition, Justify your result. (For this question Write the answer on the paper and take photo and upload OR Type in the MS Word document and upload the file)

Perform a financial analysis for an IT Project which requires an initial investment of $32,000, but it is expected to generate revenues of $10,000, $20,000 and $15,000 for the first, second and third years respectively. The target rate of return is 12%. Write the formula and calculate the Net Present Value (NPV). In addition, Justify your result. (For this question Write the answer on the paper and take photo and upload OR Type in the MS Word document and upload the file)

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter14: Real Options

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

Perform a financial analysis for an IT Project which requires an initial investment of $32,000, but it is expected to generate revenues of S10,000, $20,000 and $15,000 for the first, second and third years respectively. The target rate of return is 12%. Write the formula and calculate the Net Present Value (NPV). In addition, Justify your result. (For this question Write the answer on the paper and take photo and upload OR Type in the MS Word document and upload the file) tach File Browse My Computer
A company that manufactures magnetic flow meters expects to undertake a project that will have the cash flows below. At an interest rate of 10% per year, what is the equivalent annual cost of the project? Find the AW value using (a) tabulated factors, (b) calculator functions, and (c) a spreadsheet. Which method did you find the easiest to use?
a) Project Panda requires an initial investment of $560,000. The project will generate $46,000 in 2 years. After that, the project will generate 108,000 at the end of each year until the end of year 13. Using this information answer parts i), i) and i) below: i) Write down the equation that can be used to find the internal rate of return (IRR) of the project. In your equation, you must use the annuity formulas when possible. Can you advise if the rate of return is higher or lower than 12%? Provide your reason by calculating the net present value (NPV) of the project, you must use the annuity formulas when possible. Calculate the payback period in years for Project Panda. Round your answer to 2 decimal places.
An IT company receives two new project proposals. Project A will cost $250,000 to develop and is expected to have an annual net cash flow of $50,000. Project B will cost $350,000 to develop and is expected to have an annual net cash flow of $60,000. Analyzing the two projects from a cashflow perspective using the payback period, which project is better? Why? Write the answers in the “Payback" tab of the attached EXCEL template. You may use the Payback Period template if you wish to. Note: Enter the discounted costs and benefits for your project below. Add and delete rows as needed. Year Costs Benefits Cumulative Costs Cumulative Benefits 1 2 3 4
An IT company receives two new project proposals. Project A will cost $250,000 to develop and is expected to have an annual net cash flow of $50,000. Project B will cost $350,000 to develop and is expected to have an annual net cash flow of $60,000. Analyzing the two projects from a cashflow perspective using the payback period, which project is better? Why? Write the answers in the “Payback" tab of the attached EXCEL template. You may use the Payback Period template if you wish to. Note: Enter your criteria, weights, and scores in the template below Insert or clear rows and columns as needed. Double check formulas and results. Criteria Project 1 Project 2 Project 3 Project 4 Project 5 Sponsor Support Strategic Alliance Urgency Fills a market gap Sales Competition Weighted Project Scores 0.00 0 0 0 0 0
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…
Suppose a project has an initial outflow of $600000. If the cash flows projected for years 1-6 are $225000, $200000, $250000, $100000, $0, and $50000, respectively the IRR. Draw the timeline. Set up (by hand) the equation to solve for IRR. DO NOT SOLVE. Solve for the IRR using excel. Create a data table in excel to solve for the NPV based on different costs of capital and initial outflow.
ABC Service can purchase a new assembler for $15,052 that will provide an annual net cash flow of $6,000 per year for five years. Calculate the NP of the assembler if the required rate of return is 12%. Show calculation. Would you accept/reject a project based on NPV decision criteria? Why? Based on NPV calculated in part A, determine Profitability Index (PI). Show calculation. Would you accept/reject a project based on PI decision criteria? Why?
A project has initial costs of $1,000 and subsequent cash inflows of $700, 200, 200 and 200. The company's 10% cost of capital is an appropriate discount rate for this average risk project. Calculate the following: 1. Payback Period 2. NPV 3. Profitability Index 4. IRR 5. MIRR Please number/label each of your answers as shown above. Be sure to show your TVM function calculator inputs, and four decimal places.
Do the following problems. You must show your work.c) Find the IRR and MIRR of the following project and make your decision. Assume that the project's cost of capital (or WACC) is 4%. Project X that costs $30 million is expected to generate $13m per year for 3 years. Is this project acceptable?
A project has initial costs of $3,000 and subsequent cash inflows of $1350,275,875 and 1525 . The company's 10% cost of capital is an appropriate discount rate for this average risk project. Calculate the following: NPV IRR Profitability Index Please number/label each of your answers as shown above. Be sure to show your TVM function calculator inputs, and four decimal places.
a) Calculate the payback period for each project. The maximum allowable payback period setby the company for all projects is 3 years. b) Calculate the net present value (NPV) for each project c) Calculate the profitability index (PI) for each project d) Calculate the internal rate of return (IRR) for each project. e) Based on the answer in (a) – (d), explain briefly which project should be accepted. f) If the project is independent project, how would your answer change in part (e) Note: I need only e,f no question answer. only e and f