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) Financial Analysis for Project Name Created by:   Date:         Note: Change the inputs, shown in green below (i.e. interest rate, number of years, costs, and benefits). Be sure to double-check the formulas based on the inputs.

Q: The manager of a division that produces add-on products for the automobile industry has just been…

A: Answer: Formula of ROI: ROI = Net Operating Income/Average Operating Assets   Net Operating Income…

Q: AMT, Inc., is considering the purchase of a digital camera for the maintenance of design…

A: Internal rate of return: It is the tools utilised  in capital budgeting  to estimate the…

Q: The production department is proposing the purchase of an automatic insertion machine. It has…

A: Payback period is the time required to recover the investment.  Payback period = Initial…

Q: AMT, Inc., is considering the purchase of a digital camera for the maintenance of design…

A: Annual worth is calculated over one life cycle of the asset and is usually used to compare the…

Q: whether this is a desirable investment by using the present worth method.

A: Present worth method means the difference between PV of cash inflow & Cash outflow. Decision…

Q: Heavy Motors is taking a look at a new product line that will take a few years to create. New lab…

A: Future Worth: Using an expected rate of growth, future value (FV) is defined as the worth of a…

Q: AMT, Inc., is considering the purchase of a digital camera for the maintenance of design…

A: IRR method is one of the project selection methods in capital budgeting. IRR is compared with the…

Q: he capital investment requirement is P345,000 and the estimated market value of the system after a…

A: Net Cashflow for each of 6 years = Annual revenues - Annual expenses Net Cashflow for each of 6…

Q: Your firm has been hired to develop new software for the university's class registration system.…

A: IRR IRR is the internal rate of return at which the NPV is equal to zero. IRR is calculated using…

Q: Given a project with the following characteristics, answer the following questions: You are the…

A: As per our protocol we provide solution to one question only or in case of sub-parts then first…

Q: 2. As supervisor of a facilities engineering department, you consider mobile cranes to be critical…

A: PW Method The present worth approach is frequently used in various industry because it reduces all…

Q: Suppose a College has the option of either buying payroll software off-the-shell at $50,000 or…

A: The college has two options of either buying payroll software off-the-shell at $50,000 or employ a…

Q: A design company is evaluating the purchase of automatic tools to automate the design process. The…

A: Computation of discounting factor at the rate of 10% is as follows:

Q: Quantum Logistics, Inc., a wholesale distributor, is considering the construction of a new warehouse…

A: The internal rate of return (IRR) is one of the capital budgeting techniques to evaluate the…

Q: AMT, Inc., is considering the purchase of a digital camera for the maintenance of design…

A: The return of initial investment during the life of the investment is known as capital recovery. An…

Q: This case study is a justification of a computer system for, the ABC Company. The following are…

A: ATCF are the net cash flows from which tax or income tax is subtracted.

Q: Your manager has asked you to advise your client Kofi Gyato, owner and director of Kofi Gyato…

A: Depreciation means the amount of expenses due to usage of fixed assets due to normal wear and tear…

Q: You and your team are continuing your work on the Global Treps Project. Your project sponsor, Dr. K.…

A: The project costs are capitalized costs that are incurred after initiating or after a successful…

Q: A new biomaterial used for prosthetic devices was developed by engineers in the laboratory that…

A:

Q: Raytronics wishes to use an automated environmental chamber in the manufacture of electronic…

A: For conventional cash flow pattern, both IRR and ERR provide the same result.

Q: AMT, Inc., is considering the purchase of a digital camera for maintenance of design specifications…

A: EVA stands for economic value added. It is the total value addition which an investor gets from the…

Q: The manager of a division that produces add-on products for the automobile industry has just been…

A: Answer -    First three subparts are solved here.  Part 1 -  Computation of the ROI for each…

Q: An engineering company was awarded a project with an original budget of 250,000 hours, valued at…

A: Hours earned of a project will always be decided and calculated on the basis of the percentage of…

Q: JigSaw Puzzle Company is a chain of 10 retail stores that sell puzzles.  In order to more…

A: Following are the answers to the given questions

Q: A project engineer is assigned to provide computer networking and internet access to an office…

A: Least Common Multiple method uses the LCM of the estimated life's of the alternatives available and…

Q: Genz has come up with a new product prototype and is ready to go ahead with pilot production and…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: AMT, Inc., is considering the purchase of a digital camera for the maintenance of design…

A: External rate of return is the rate of return on a project where all the extra returns on the…

Q: where computer-aided design files can be superimposed over the digital pictures. Differences between…

A: The payback period method is used to appraise various capital investment projects. It uses the cash…

Q: Acme Semiconductor is expanding its facility and needs to add equipment. have been asked to perform…

A: The net present value is the difference between the present value of cash flow and initial…

Q: Raytronics wishes to use an automated environmental chamber in the manufacture of electronic…

A: Installation cost = 1.4 mn Salvage value = 200000 Term = 8 years Increase sales = 650000 Operating…

Q: Students at Harvard University are interested in developing a 6th generation 3D printer. The project…

A: Required: Decision Tree for the expected cash flows Calculate the NPV of the project.

Q: discounted payback method.

A: The payback period method is used to appraise various capital investment projects. It uses the cash…

Q: ou are a project manager for the Swirling Seas Cruises food division. You’re considering two…

A: Payback period is the time required to recover the investment made in a project. Formula: Payback…

Q: The projects review committee of Microsoft has $20 million to allocate next year to new software…

A: NPV can be calculated by following function in excel =NPV(rate,value1,[value2],…) + Initial…

Q: Russell Trent was recently tasked with evaluating projects for Stan's No Touch Car Wash. The company…

A: Hurdle Rate for first 3 years = 23% Hurdle Rate after 3 years = 37% Cash Flow Year Investment…

Q: Maddy is the founder and CEO of Sauerbreit Manufacturing Global (SMG). The firm is introducing a new…

A: NWC (Net Working capital) is difference of current assets and current liabilities of an entity. It…

Q: A firm is considering the installation of an automatic data processing unit to handle some of its…

A: Capital budgeting is the process by which a corporation examines potential large projects or…

Q: i) Calculate the breakeven number of students needed at the two different prices being considered.…

A: Break-even point: The point where the company generates revenue equal to the cost incurred in…

Q: Raytheon wishes to use an automated environmental chamber in themanufacture of electronic…

A:

Q: Light Motors is taking a look at a new product line that will take a few years to create. New lab…

A: Initial Cost  Php 1,00,00,000.00 MARR 12% Expense for 4 Years Php 1,50,00,000.00 Time Period…

Q: El Paso Water is planning to install wind turbines to provide enhanced evaporation of reverse…

A: Single cell spreadsheet function: Using single spread sheet: Answer: $499,109.98

Q: Consider an order delivery business that will be a 5-year project. The required net working capital…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: ACI Group is evaluating the proposal of a new RMG factory called ACI Exclusive Fabrics. The project…

A:

Q: Raytronics wishes to use an automated environmental chamber in the manufacture of electronic…

A: Initial cost=$1,400,000 Salvage value=$200,000 Time period=8 years Calculating depreciation: year…

Q: AMT, Inc., is considering the purchase of a digital camera for maintenance of design specifications…

A: NPV computes the existing value of future benefits by discounting future worth with a stated…

Q: You are charged with choosing a vendor to produce a new software that is going to benetit your…

A: a.) Cash flow diagram is a diagram which shows various cash flows over a period of time on a time…

Q: As the new engineer in the company, you are tasked to send out a proposal for an expansion of the…

A: The question is related to Capital Budgeting. The rate of return on investment is calculated with…

Q: AMT, Inc., is considering the purchase of a digital camera for the maintenance of design…

A: IRR is the rate of return a project generates through its lifetime expressed in annual terms. It is…

Q: Before you begin this assignment, review the Tying It All Together feature in the chapter Granite…

A: “Hey, since there are multiple sub-parts posted, we will answer first three sub-parts. If you want…

Production Budget

A budget can be defined as a financial plan designed by an undertaking for a definite period in the future that can contribute towards enhancing the financial success of the business undertaking. It is used to estimate the revenue and expenses. The budget generally takes into account both current and future income and expenses.