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

  What is the cross rate between francs and pounds round

the exchange rate between the us dollar and the swiss franc is sf1.31 and the exchange rate betweent he dollar and the

  How much additional equity financing required for next year

If all assets, short-term liabilities, and costs vary directly with sales, how much additional equity financing is required for next year?

  What is company total asset turnover

The company has an ROA of 17percent, a 12 percent ptofit margin,and an ROE of 22 percent. What is company's total asset turnover? What is the equity multiplier?

  Determine the market rate of return

Bet'R Bilt Bikes just announced that its yearly dividend for this coming year will be $2.42 a share and that all future dividends are expected to increase by 2.5% yearly.

  What are the benefits to boeing of outsourcing

What are the benefits to Boeing of outsourcing so much work on the 787 to foreign suppliers? What are the potential risks? Do the benefits outweigh the risks?

  Calculate the after-tax weighted average cost of capital

Given the following data for U&P Company: Debt (D) = $100 million; Equity (E) = $300 Million; rD = 6%; rE = 12% and TC = 30%. Calculate the after-tax weighted average cost of capital (WACC)

  Determine the expected return of common stock

Siebling Manufacturing Corporations's common stock has a beta of .8. If the expected risk-free return is 7 percent and the market offers a premium of 8% over the risk-free rate,

  What is the 95 percent probability range

A stock has returns of 8 percent, 12 percent, -22 percent, and 18 percent for the past 4 years. Based on this information, what is the 95 percent probability range for any one given year?

  Difference between a short, medium and long term loan

Describe the difference between a short term, medium term and a long term loan. Use the following situations to describe the relative size of the interest rates charged on the following types of loans:

  Find macaulay duration and modified duration

Find the duration of a bond with settlement date May 27, 2012, and maturity date November 15, 2021. The coupon rate of the bond is 7%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8%. Find Macaulay duration..

  Calculate the profit or loss on bags

University Catering sells 50-pound bags of popcorn to university dormitories for $10 a bag. The fixed costs of this operation are $80,000, while variable costs of the popcorn are $.10 per pound.

  Drive fluctuation in the short term stock market prices

Can you tell me what are the most important factors that drive the fluctuation in the short term stock market prices, and why do you think that they do drive short term securities price fluctuations?

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: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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