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.
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education
Expert Answers to Latest Homework Questions
Q: Choice best answer
Q: General accounting
Q: None
Q: BH is tangent to circle A and DF is a diameter. I don't know where to go from here. May you help…
Q: anshul need calculate emi
Q: Subject - General Account
Q: Can you please give me correct answer this financial accounting question?
Q: General accounting question
Q: Branton Ltd. had cash sales of $56,390, credit sales of $42,810, sales returns and allowances of…
Q: 5 PTS
Q: What is the gross profit margin of this accounting question?
Q: Solve this questions
Q: Hello tutor need soln
Q: Provide answer A and B
Q: Calculate dividends for this
Q: I am looking for the correct answer to this general accounting question with appropriate…
Q: What is the differential revenue?
Q: Don't use ai given answer general accounting
Q: Ardor Ltd. purchased a new equipment that is expected to be used in operations for 6 years for…
Q: General Accounting
Q: Please help me solve this general accounting problem with the correct financial process.