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: General Accounting
Q: Trinity's gross profit percentage is ?
Q: The following table provides financial data for a company over several years
Q: Please help me solve this financial accounting problem with the correct financial process.
Q: Gadot Industries developed the following per-unitstandards for its product: 7 pounds of direct…
Q: I need help with this financial accounting problem using proper accounting guidelines.
Q: A speaker manufacturer, Golding Audio, uses approximately 36,000 tweeter units annually. These…
Q: How can I solve this financial accounting problem using the appropriate financial process?
Q: Canoe company's manufacturing accounting system uses direct labor costs to apply overhead to goods…
Q: Calculate the company's overhead rate based on total direct labor hours
Q: Can you solve this financial accounting problem using appropriate financial principles?
Q: What is millstone's price-sales ratio?
Q: I need assistance with this financial accounting question using appropriate principles.
Q: Can you help me solve this financial accounting problem using the correct accounting process?
Q: Can you solve this general accounting problem using accurate calculation methods?
Q: Quick answer of this accounting question
Q: Maple Metals started the year with total assets of $410,000 and total liabilities of $245,000.…
Q: I am trying to find the accurate solution to this financial accounting problem with the correct…
Q: What is the number of workdays in an order cycle ?
Q: Please provide the solution to this general accounting question using proper accounting principles.
Q: How much of the 45000 should be allocated to each division?