Preview

237 C S S A D 560

Satisfactory Essays
Open Document
Open Document
284 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
237 C S S A D 560
Using a format similar to the spreadsheets in this chapter, develop a spreadsheet that summarizes this project’s cash flow, assuming a four-year useful life after the project is developed. Compute the present value of the cash flows, using an interest rate of 9%. What is the NPV for this project? What is the ROI for this project? What is the break-even point? Should this project be accepted by the approval committee?

SOLUTION

As the numbers indicate, this would not be an economically feasible project for a number of reasons. It would take more than the projected four year life span to breakeven on the initial investment, the return on investment is a very low number (-1), and the net present value is currently projected as a number less than zero.

Year 1
Year 2
Year 3
Year 4
Year 5
Year 6

Sales
30,000
33000
36300
39930
43923
48315.3

savings
15000
15000
15000
15000
15000
15000

Total cash

PV
45000

41284.4
48000

40400.6
51300

39613.8
54930

38916.04
58923
63315.3

PV = 45000 = 45000 (1+ 0.09) 1.09 = 41284.4

PV2 = 48000 = 48000 = 40400.6 (1+0.09)2 1.1881

PV3= 51300 = 51300 = 39613.8 (1.09)3 1.2950

PV4 = 54930 = 54930 = 38916.046 (1.09)4 1.4115

Now calculate NPV:

Annual operating cost = 995 + 525 + 3300 = $4820

Development cost = 18700 + 1500 + 7500 + 6650 = $34350

Total Cost = $39170

Total initial investment= sales in first year+ inventory savings+ total cost = 30000 + 15000 + 39170 = $ 84170

NPV = -84170 + 45000 + 48000 + 51300 + 54930 1 + 0.09 (1 + 0.09)2 (1.09)3 (1.09)4

= -84170 + 41284.4 + 40400.6 + 39613.8 + 38916.046

NPV = 76044.846

Gain from investment = initial investment – cost = $45000

45000 - 39170
=
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Caladonia Products Integrative Problem Paper
    • 516 Words
    • 3 Pages

    Caladonia Products Integrative Problem Paper

    For project A, the projects net present value is $100,000 the initial investment overhead of the project is a negative expenditure because it is an expense to the company. Over the next five years the group expects to add the present annual value of $32,000, the return rate will be 11% utilizing the annuity table. The factor will be 3.696 at 11% for five years. To calculate the cash inflow, multiply the annual $32,000 by 3.696 at 11% to equal $118.272. Over a five year period the total cash inflow is $118,272 with a net value of $18,272 for project A. Net present value = $118,272 - $100,000 = $18,272…

    • 516 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Concordia Real Estate Inc Case Study: Analysis of the Investment Opportunity
    • 3248 Words
    • 13 Pages

    Concordia Real Estate Inc Case Study: Analysis of the Investment Opportunity

    The results of the analysis lend favourably towards accepting the investment project. First it is important to note that based on the after tax cost of borrowing and a risk premium of 3.75%, a discount rate of 8.89% was deemed appropriate for the project. The majority of the investment indicators used to value the project use discounted cash flows to determine the investment’s profitability. This technique allows for comparison amongst different investment opportunities available, as it provides the total return that is expected to be achieved over the project’s horizon in current dollar terms.…

    • 3248 Words
    • 13 Pages
    Powerful Essays
    Read More
  • Better Essays

    ACCT614-1403A-02 Applied Managerial Accounting
    • 1228 Words
    • 4 Pages

    ACCT614-1403A-02 Applied Managerial Accounting

    The focus of EEC’s investment of the purchasing of the supplier is to cut down on the cost expenditures of the company. The primary board members and investors anticipate in the timeframe the fifth of to save financially in revenue $600,000 per annum this will accumulate $9 million in net in the timeframe of that 15 years. 14% of that investment and consumption cost will be attributed out of $9 million net, which adds up to sum of $3 million. The president of the company asked me to give an analysis in the possibilities foreseen in the investment what would be the Net Present Value, along with the Internal Rate of Return, and the payback of the investment.…

    • 1228 Words
    • 4 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Mat 540 Quiz 4
    • 644 Words
    • 3 Pages

    Mat 540 Quiz 4

    1. Is this project financially feasible given the base scenario? Why or why not. Be sure to include a discussion of NPV and IRR. How does the lifetime income compare to the initial investment? 5 points…

    • 644 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    week five for ops 571
    • 639 Words
    • 2 Pages

    week five for ops 571

    According to the project descriptions, $450,000 has been spent on the product and they average a total of $575,000 being spent in order to bring the product to the market. Even though the dollar amount spent in this project is high, the return on investment for this project is high; by the third year the product is forecasted to have a return of investments of $750,000. The product life of this project is forecasted to be 7 years. Because this product has not been used we would be the first company to launch the product to the market which would create an innovative style allowing our company to be the leader in the industry.…

    • 639 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Net Present Value and Correct Answer
    • 836 Words
    • 4 Pages

    Net Present Value and Correct Answer

    A project has initial costs of $3,000 and subsequent cash inflows in years 1 – 4 of $1350, 275, 875, and 1525. The company 's cost of capital is 10%. Calculate NPV for this project.…

    • 836 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Fin Exam
    • 1062 Words
    • 5 Pages

    Fin Exam

    A project has initial costs of $3,000 and subsequent cash inflows in years 1 ? 4 of $1350, 275, 875, and 1525. The company's cost of capital is 10%. Calculate NPV for this project.…

    • 1062 Words
    • 5 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    FIN 486 Week 4 Individual Assignment Capital Budgeting
    • 588 Words
    • 6 Pages

    FIN 486 Week 4 Individual Assignment Capital Budgeting

    Given a 10% weighted average cost of capital, the following table shows the net present value that is computed for this project.…

    • 588 Words
    • 6 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Mt217 Finance Unit 2 Challenge Problem
    • 278 Words
    • 2 Pages

    Mt217 Finance Unit 2 Challenge Problem

    At the time of retirement, he is expecting to live the life span of 25 years.…

    • 278 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Caladonia Products Integrative Problem
    • 1388 Words
    • 6 Pages

    Caladonia Products Integrative Problem

    The financial assistant received the important assignment by memorandum from the CEO. The memorandum stated that the company is considering the introduction of a new product (Keown, Martin, Perry, & Scott, 2005). Caradonia is currently at a 34% marginal tax bracket with a 15% required rate of return or cost of capital (Keown, Martin, Perry, & Scott, 2005). The new project is estimated to last five years and then be terminated because of being a fad project (Keown, Martin, Perry, & Scott, 2005). The financial assistant must analyze two mutually exclusive projects. Each project has an 11% rate of return and a life span of five years (Keown, Martin, Perry, & Scott, 2005). The following table (table one) shows the expected cash flows for each project.…

    • 1388 Words
    • 6 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    boeing guideline
    • 305 Words
    • 2 Pages

    boeing guideline

    of Return (IRR) from this project is around 15.66%. Given the projected cash flow information…

    • 305 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Capital Budget Mini-Case
    • 2439 Words
    • 10 Pages

    Capital Budget Mini-Case

    l. In a 1,050-1,500-word memo, define, analyze, and interpret the answers to items (c) through (h). Present the rationale behind each item and why it supports your decision stated in item (i). Also, attempt to describe the relationship between NPV and IRR. (Hint: The key factor here is the discount rate used.) In this memo, explain how you would analyze projects differently if they…

    • 2439 Words
    • 10 Pages
    Good Essays
    Read More
  • Powerful Essays

    Cost of Capital at Ameritrade
    • 1337 Words
    • 6 Pages

    Cost of Capital at Ameritrade

    1-b What type of cash flows and discount rate you are evaluating in this project? Is there any financial effect (i.e. leverage) involved? Why, or why not?…

    • 1337 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Good Essays

    Sampa
    • 524 Words
    • 3 Pages

    Sampa

    The annual projected free cash flows which are presented in the Exhibit 1 are $-112,000; $6,000; $151,000; $314,000; $495,000 respectively for year from 2002 to 2006. After year 2006, the free cash flow would grow at 5%, so we can calculate the terminal value of the project at the end of 2006 using the perpetual-growth DCF formula.…

    • 524 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    PFF Outcome2
    • 780 Words
    • 5 Pages

    PFF Outcome2

    I have been advised that any projects chosen should have an accounting rate of return at least 15% and company’s cost of capital is 10%. The cost of investment should be recovered within four years.…

    • 780 Words
    • 5 Pages
    Powerful Essays
    Read More

Related Topics