Prepare the financial section of a business case for the Cloud-Computing Case that is listed above this assignment in Canvas. Assume that this project will take eight months to complete (in Year 0) and will cost $600,000. The costs to implement some of the technologies will be $300,000 for year one and $200,000 for years two and three. Estimated benefits will start in year 1 at $400,000 and will be $600,000 for years 2 and 3. There is no benefit in year 0. Use the business case spreadsheet template (business_case_financials.xls) template provided below this assignment in Canvas to calculate the NPV, ROI, and the year in which payback occurs. Assume a 7 percent discount rate for the template. notes* Payback occurs in the first year that there is a positive value for cumulative benefits - costs. (*Negative values are presented in parenthesis) What I have so far is attached I need to make it so Pay back occurs in year 3 where there is positive cumulative benefits - costs.

Prepare the financial section of a business case for the Cloud-Computing Case that is listed above this assignment in Canvas. Assume that this project will take eight months to complete (in Year 0) and will cost $600,000. The costs to implement some of the technologies will be $300,000 for year one and $200,000 for years two and three. Estimated benefits will start in year 1 at $400,000 and will be $600,000 for years 2 and 3. There is no benefit in year 0. Use the business case spreadsheet template (business_case_financials.xls) template provided below this assignment in Canvas to calculate the NPV, ROI, and the year in which payback occurs. Assume a 7 percent discount rate for the template. notes* Payback occurs in the first year that there is a positive value for cumulative benefits - costs. (*Negative values are presented in parenthesis) What I have so far is attached I need to make it so Pay back occurs in year 3 where there is positive cumulative benefits - costs.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 35SP

See similar textbooks

Similar questions

Q6) IBM networks want to modernize their networking system. Proposals have been received from two major software companies. The first proposal cost $6million but will raise the firm’s annual cash flows by $3million. The second proposal cost $7million and provides cash flow of $3.5million a year. Both projects have a life span of 3 years. Assuming that the cost of capital is 8%, which proposal may be recommended on the basis of Net Present Value criteria. Select one: a. Project B, NPV 1731290 b. Project A, NPV 20198 c. Project B, NPV 2019839 d. Project A, NPV 2019839
Fast pls solve this question correctly in 5 min pls I will give u like for sure Svtrik Create the combined common-size, common-base year statement for 2022. What is the value for machines?
QA) choose the correct answer: 1. IBM networks want to modernize their networking system. Proposals have been received from two major software companies. The first proposal cost $6million but will raise the firm’s annual cash flows by $3million. The second proposal cost $7million and provides cash flow of $3.5million a year. Both projects have a life span of 3 years. Assuming that the cost of capital is 8%, which proposal may be recommended on the basis of Net Present Value criteria. Select one: a. Project B, NPV 1731290 b. Project A, NPV 20198 c. Project B, NPV 2019839 d. Project A, NPV 2019839 2. Mohammed is 65 years of age and has a life expectancy of 12 more years. He wishes to invest $40,000 in an annuity that will make a level payment at the end of each year until his death. If the interest rate is 10%, what income can Mr. Mohammed expect to receive each year? (Choose the correct answer from below options and attach all your explanations in the other link provided) Select…
How much would you invest today in order to receive $30,000 in each of the following? (for further instructions on present value in Excel, see the Suggested Resources in the textbook: https://cnx.org/contents/kg0cimBs@14.13:bDQCmuJO@6/Suggested-Resources) a. 10 years at 9% b. 8 years at 12% c. 14 years at 15% d. 19 years at 18%
Q6) IBM networks want to modernize their networking system. Proposals have been received from two major software companies. The first proposal cost $6million but will raise the firm’s annual cash flows by $3million. The second proposal cost $7million and provides cash flow of $3.5million a year. Both projects have a life span of 3 years. Assuming that the cost of capital is 8%, which proposal may be recommended on the basis of Net Present Value criteria.
Use attachment to answer question q5- This question relates to the diagram, which shows the NPV profile for Projects X and Y. If Project Y lasts for 3 years and returns cash flows of $49 for each of the 3 years, what is the initial outlay of the project? (Hint: This is tricky. It requires a bit of lateral thinking, but it does not require the use of any time-value-of-money formulas - just addition and/or subtraction.) a. $87 b. $97 c. $60 d. $50
eBook MIRR A project has an initial cost of $40,000, expected net cash inflows of $12,000 per year for 12 years, and a cost of capital of 12%. What is the project's MIRR? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to two decimal places. %
Task 2A business has two projects to invest in, as follows:Create a new spread sheet, calculate NPV for the following projects at discount rates of 3% and 7%, respectively, by creating a dynamic process. Project 1 Project 2Year Cash inflows Cash outflows Cash inflows Cash outflows0 0.00 70,000.00 0.00 70,000.001 24,000.00 13,000.00 25,000.00 15,000.002 22,000.00 1,000.00 25,000.00 03 25,000.00 0 20,000.00 04 25,000.00 0 43,000.00 21,000.005 17,500.00 7,500.00 20,000.00 5,000.00 P1: NPV P2: NPVThen, a) by using a built-in/Excel function, calculate the NPV for each project with discount rates of 3% and 7%, respectively;b) By comparing the NPVs at the rate of…
tudent question Time to preview question: 00:09:18 Seeking for accounting rate of return for Option 1, 2, & 3 (info below). The senior VP in charge has asked that you make a recommendation for the purchase of new equipment.Ideally, the company wants to limit its capital investment to $500,000. However, if an asset meritsspending more, an investment exceeding this limit may be considered. You assemble a team to helpyou. Your goal is to determine which option will result in the best investment for the company. Toencourage capital investments, the government has exempted taxes on profits from new investments.This legislation is to be in effect for the foreseeable future.The average reported operating income for the company is $1,740,000.The company uses a 10% discount rate in evaluating capital investments.The team is considering the following optionsOption 1:The asset cost is $300,000.The asset is expected to have an 8-year useful life with no salvage value.Straight-line…
SUBJECT: ENGINEERING ECONOMICS (a) Identify the Given and the Unknown or what is being asked in the problem (b)Provide the formula to be used (c)Show the complete solution. The final answer is already provided. At 5% annual interest, what is the difference in the present and future value of P100 paid at the end of each year for 10 years and P100 paid at the beginning of each year? Answer: P value difference = P88.61, F value difference = P62.89
How much would you invest today in order to receive $30,000 in each of the following independent scenarios: 10 years at 9% 8 years at 12% 14 years at 15% 24 years at 10% Use the appropriate EXCEL spreadsheet in the Chapter11 TVOM Examples.xlsx downloadto complete the following table: Present Value (PV) Rate Time (Years) Future Value (FV) A 9% 10 $30,000.00 B 12% 8 $30,000.00 C 15% 14 $30,000.00 D 10% 24 $30,000.00 PLEASE NOTE: All dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67). Use the present value of $1 table in the Appendix B PV FV Tables downloadand verify that your answers above are correct: Future Value (FV) Rate Time (Years) FV Factor (from Table) Present Value (PV) A $30,000.00 9% 10 B $30,000.00 12% 8 C $30,000.00 15% 14 D $30,000.00 10% 24 PLEASE NOTE: All PV Factors will be rounded to three decimal places (i.e. 1.234). All dollar amounts will be with "$" and…
QUESTION 5Read the information below and answer the following questionsINFORMATIONThe management of Mastiff Enterprises has a choice between two projects viz. Project Cos and Project Tan, each ofwhich requires an initial investment of R2 500 000. The following information is presented to you:PROJECT COS PROJECT TANNet Profit Net ProfitYear R R1 130 000 80 0002 130 000 180 0003 130 000 120 0004 130 000 220 0005 130 000 50 000A scrap value of R100 000 is expected for Project Tan only. The required rate of return is 15%. Depreciation is calculated using the straight-line method.5.4 Benefit Cost Ratio of Project Cos (expressed to three decimal places). 5.5 Internal Rate of Return of Project Cos (expressed to two decimal places) USING INTERPOLATION.