User Account

All Pages

Develop a spreadsheet to perform a cost benefit analysis to

Assignment Help Finance Basics
Reference no: EM13483005

MC's CIO has determined that the up front costs of developing their new Web site will be $54,000. The site will take 6 months to become operational.Once operating, the monthly cost for running the site is $5,000 (this includes hosting fees, data entry, marketing, fulfillment, and a Web master).The company expects the site to result in $6,500 per month in additional after tax revenue.

The cost for the ERP project is $100,000 the first year and $50,000 in years 2 and 3.After year 3 the annual cost of maintaining and upgrading the system will be $40,000.The company expects to begin reaping the benefits of the project in year 2 when it will save $50,000.Beginning in year 3 and continuing into the future the annual projected savings is $90,000.

a. Develop a spreadsheet to perform a cost benefit analysis to determine how much the company will make or lose over the next five years for each project. What is the company's annual return on investment for each project?Based solely on this analysis which project would you recommend?

b. Determine the net present value (NPV) for each project (use a discount rate of 10%). What is the company's annual return on investment?Based solely on this analysis which project would you recommend?How would your analysis change if the discount rate increased to 13%?How would you revise your recommendation?

Reference no: EM13483005

Questions Cloud

The fair value of exactas net assets was equal to the book : exacto company reported the following net income and dividends for the years indicated year net income dividends 20x5
What are the advantages and disadvantages of mergers and : you are functional managers in a relatively small but high-growth trucking company. the company was started 10 years
The correct order of presentation in a classified balance : the correct order of presentation in a classified balance sheet for the following current assets isa accounts
Tonga toys manufactures and distributes a number of : tonga toys manufactures and distributes a number of products to retailers. one of these products playclay requires
Develop a spreadsheet to perform a cost benefit analysis to : mcs cio has determined that the up front costs of developing their new web site will be 54000. the site will take 6
Earnings per share eps is the most featured single : earnings per share eps is the most featured single financial statistic about modern corporations. daily published
In mid-march 2007 the us dollar equivalent of a euro was : in mid-march 2007 the u.s. dollar equivalent of a euro was 1.3310. in mid-july2009 the u.s. dollar equivalent of a euro
In a classified balance sheet assets are usually classified : in a classified balance sheet assets are usually classified asa current assets long-term assets property plant and
Renee manufactured and sold a gadget a specialized asset : renee manufactured and sold a gadget a specialized asset used by auto manufacturers that qualifies for the domestic

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd