Homework Help is Here – Start Your Trial Now!
Business
Finance
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
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
See similar textbooks
icon
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 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.
             
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
  272,800
NPV
Cumulative benefits - costs      (140,000)
     8,800
 146,400  272,800    
             
ROI
112%          
  Payback in Year 1      
Assumptions            
Enter assumptions here            
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Capital Budgeting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
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…
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
SEE MORE TEXTBOOKS

Expert Answers to Latest Homework Questions

Q: 1) Compute the inverse of the following matrix. 0 1 1 A = 5 1 -1 2-3 -3
Q: 3) Find the volume of the solid that lies inside both the sphere x² + y² + z² cylinder x²+y² = 1. =…
Q: 2) Compute the following anti-derivative. √1x4 dx
Q: Need help understanding please help  Let’s assume the initial volume of the gas is  4.80 LL   , the…
Q: 1) Compute the following limit. lim x-0 2 cos(x) 2x² - x4
Q: For each reaction shown below follow the curved arrows to complete each equation by showing the…
Q: Tryptophan is an essential amino acid important in the synthesis of neurotransmitter serotonin in…
Q: For the following compound identify the lone pairs and indicate if each lone pair is localized or…
Q: Draw resonance structures for the following compounds. Please provide a thorough explanation that…
Q: What is the relationship between the following compounds? Choose between: (a)constitutional isomers,…
Q: Caffeine has the following structure. What is the hybridization state and molecular geometry at each…
Q: Please solve.
Q: BF3 has a no dipole moment. a) Draw the Lewis structure for BF3, showing all nonbonding electrons.…
Q: At the Ford automobile Highland plant, assume the one-millionth vehicle was produced in 1916 at a…
Q: At the Ford automobile Highland plant,in 1913, how long did the average worker stay with the plant…
Q: Matthew Incorporated, owns 30 percent of the outstanding stock of Lindman Company and has the…
Q: Please solve for items circuled in RED. Thank you.
Q: I have a question for this problem in the first one wouldn't it be finding the total weight of the…
Q: In the image is a right rectangular pyramid of total mass m. Note the location of point Q. Determine…
Q: I do not understand the process to answer the second part of question b. Please help me understand…
Q: programmable logic controllers frank petruzellz 3rd edition