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.
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.
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter19: Capital Investment
Section: Chapter Questions
Problem 15E: Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided...
Related questions
Question
100%
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
| 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. | |||||||
| Discount rate | 8.00% | ||||||
| Assume the project is completed in Year 0 | Year | ||||||
| 0 | 1 | 2 | 3 | Total | |||
| Costs | 140,000 | 40,000 | 40,000 | 40,000 | |||
| Discount factor | 1.00 | 0.93 | 0.86 | 0.79 | |||
| Discounted costs | 140,000 | 37,200 | 34,400 | 31,600 | 243,200 | ||
| Benefits | 0 | 200,000 | 200,000 | 200,000 | |||
| Discount factor | 1.00 | 0.93 | 0.86 | 0.79 | |||
| Discounted benefits | 0 | 186,000 | 172,000 | 158,000 | 516,000 | ||
| Discounted benefits - costs | (140,000) | 148,800 | 137,600 | 126,400 |
|
NPV | |
| Cumulative benefits - costs | (140,000) |
|
146,400 | 272,800 | |||
|
112% | ||||||
| Payback in Year 1 | |||||||
| Assumptions | |||||||
| Enter assumptions here |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Expert Answers to Latest Homework Questions
Q: Um carro percorre 150 km en 3 horas qual e a velocidade media do carro
Q: Kindly help me answer the discussion below in 1500 words. Kindly provide in-text citations.
‘
Social…
Q: Kindly help me answer the discussion below in 1500 words. Kindly provide in-text citations.
‘
Social…
Q: Solve the equation cosh(2z) + sinh(2z) = −1
ikπ
O a. {ik; k = Z}
○ b. {ikë; k € Z}
О с. { i(2k+1); k…
Q: Write f(z)
=
Im(z
-
f(z) = u(x, y) + iv(x, y).
3z) zRe(z²) - 5z in the form
○ a. (4y+x³ − xy²) +…
Q: The graph of the region |Argz| < and | Rez| < 2 is
○ a.
O b.
-2
О с.
○ d.
0
2
2
2
Q: 8+6i (12)6
If z₁ = 4 — 2i, z2 = 8+ 6i then (1 − ⁄2)6 =
21
-
○ a.
-215i
O b.
215i
○ c.
-215
O d. -210…
Q: If C is the circle | z-3|=4, given counterclockwise, then the value of the line integral fo
a. -6πί…
Q: One of the followings is a harmonic function.
a. u(x, y) = 4x² - 8y² - 4y
O b. u(x, y) = e−3x cos…
Q: The solution of the equation In(3z – i) = −3+2i is
-
○ a. ¹³e¯³ cos2+i+i½³e¯³sin2
O b. e³ cos2+i+ie³…
Q: The set of all solutions of e22
= -2i-2 is
O a. ln(√√8) + (547)
○ b. {½ln(√√8)+i(¯¾³ª + kñ); k ≤ Z}…
Q: Let z₁ = 3 − 7i, z2 = 4 − 3i, z3 = 4 – 2i. Then (z1 — 22) – 323
O a. None
O b. 13-2i
○ c. -13+2i
O…
Q: The values of one phase of a 15
kW, 380V, star - connected, 3-
phase, 4-pole 50 Hz squirrel
cage…
Q: Maria is considering operating a local business in the beauty and cosmetology sector in the island…
Q: In the show a figure the switch (5) is cloved and all the resistors have the same value
What happens…
Q: When estimated future bad debt expense, which account are debited/credited, respectively?
Cash,…
Q: What is the mass, in grams, of 7.80×1020 molecules of caffeine, C8H10 N4O2?
xpress your answer using…
Q: A drag bit or finger bit and a Roller bit are to be used In a geotechnical drilling project, which…
Q: Organic chemistry synthesis
Q: 7.8.2
A particular solution to y' = y²/x³-y/x+2x is y=x². Find
a more
general solution.
Q: Please give an explanation about the graph briefly according to your understanding based on the…