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: In what why ways did the films highlight the resilience and strength of individuals experiencing…
Q: 2. For the circuit below, utilize only the node-voltage method:
Vb
+
V1
R1
3la
+
R4
ww
Va
R3
V2
V3…
Q: Did the films challenge any preconceived notions or stereotypes you may have had?
Q: What emotions did the films evoke in us and why? the films are Time to listen, The criminalization…
Q: 1. For the circuit below, utilize the superposition method to solve the following
ли
R17
12
2 A
+
V3…
Q: What were some of the micro, mezzo, and macro issues discussed in the three films: Time to listen,…
Q: 4. Calculate V₁
+ V1
10 V
ци
R1
5 Ω
+
R3
V1
6 Ω
C
S
R13
6 Ω
Q: 3. Write enough equations to create an expression for Vx. You may use node
voltages here.
ли
ли
R4…
Q: How did the documentarys potray the issues of being unhoused: the documentarys were Time to listen,…
Q: 2. For the circuit below:
| +
V2
10 V
+ V1 -
ww
R2
20
a. Calculate I4
b. Calculate I₁
c. Calculate…
Q: 1. For the circuit below:
11
10 A
ли
R2
10 Ω
a. Calculate I₂
b. Calculate V2
R1
ли
55
5 Ω
ли
R3
2.5…
Q: The records of a casualty insurance company show that, in the past, its clients have had a mean of…
Q: What in the three documentary films, Time to listen, Under the Bridge: The Criminalization of…
Q: Based on their records, a hospital claims that the proportion, p, of full-term babies born in the…
Q: A psychologist is interested in the mean IQ score of a given group of children. It is known that the…
Q: The mean starting salary offered to graduating students with a certain major in a recent year was…
Q: Suppose that 45% of all babies born in a particular hospital are boys. If 8 babies born in the…
Q: A = {x in R
|
0 < x <1}
B={xin R
|
1< x <2}
C={xin R
|
0 < x <2}
where R is the set of real numbers.…
Q: Mrs. Bell is a librarian at Central Library. In examining a random sample of the library's book…
Q: Here is a table showing all 52 cards in a standard deck.
Face cards
Color
Suit Ace Two Three Four…
Q: The gender and year of each of the 221 students in a high school band were recorded. The data are…