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: A galvanic cell is powered by the following redox reaction:
2103(aq) + 12 H(aq) + 5 Zn(s)
+
2+
12(s)…
Q: Don't use chatgpt will upvote and provide solution in Handwritten form neat and clean and please be…
Q: lodine monobromide,, occurs as brownish-black
crystals that vaporize with decomposition:
The…
Q: A point charge q₁ = +2.40 μC is held stationary at
the origin. A second point charge q2 = -4.30 μC…
Q: None
Q: None
Q: Don't use chat GBT will upvote
Q: help please answer in text form with proper workings and explanation for each and every part and…
Q: None
Q: Shielding is the blocking of the Blank nuclear charge
from the Blank electrons. The shielding is…
Q: None
Q: None
Q: Don't use chat gpt It Chatgpt means downvote
Q: 41. Balance each of the following equations according to the half-reaction method:
(a) MnO4 (aq) +…
Q: The following table shows predicted product demand using your particular forecasting method along…
Q: None
Q: V.
сорд
20 V₁
car
VcopB
▾ Part A.
Case 1: Cop car A emits the radar signal (of frequency 1,) which…
Q: help please answer in text form with proper workings and explanation for each and every part and…
Q: Don't use chat gpt It Chatgpt means downvote
Q: On December 31, 2023, Cullumber Company rendered services to Riverbed Corp. at an agreed price of…
Q: None