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
  • Satisfactory Essays

    Mercedes Benz AAV Case
    • 368 Words
    • 2 Pages

    Mercedes Benz AAV Case

    Projected cash flows were analyzed over a 10-year period using Net Present Value (NPV) analysis to acquire project approval from the Board of Directors…

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

    Doll Company Assignment Guideline
    • 787 Words
    • 4 Pages

    Doll Company Assignment Guideline

    2. Use the operating projections to compute a net present value (NPV) for each project. Which project…

    • 787 Words
    • 4 Pages
    Good 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

    The Dallas Project
    • 346 Words
    • 2 Pages

    The Dallas Project

    3. The project is a slam-dunk for the corporation because they are yielding an internal rate of return of 80%. The NPV of the future cash flows is significantly larger than the purchase costs of the assets.…

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

    Finance Part 2
    • 711 Words
    • 3 Pages

    Finance Part 2

    You have now been tasked with providing a recommendation for the project based on the results of a Net Present Value Analysis. Assuming that the required rate of return is 15% and the initial cost of the machine is $3,000,000.…

    • 711 Words
    • 3 Pages
    Good 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
  • Powerful Essays

    Proj592 Course Project Part 1
    • 1930 Words
    • 8 Pages

    Proj592 Course Project Part 1

    The company will begin working out of a home. Therefore, cost will not extend past the startup cost of $50,000, of which the company will supply $4,000. Based on preliminary estimates, the company will be expecting revenues of approximately $15,336 and a net income of $1,278 per month. Assuming the net income holds true the payback on the $46,000 of capital required is five years. The Net Present Value of the project is approximately $23,000 assuming a 10% discount rate for 5 years.…

    • 1930 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Good Essays

    Project Managememt Email
    • 841 Words
    • 4 Pages

    Project Managememt Email

    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 (University of Phoenix, 2012). 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 (University of Phoenix, 2012). The product life of this project is forecasted to be 7 years (University of Phoenix, 2012).…

    • 841 Words
    • 4 Pages
    Good 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
  • Good Essays

    Busn
    • 1773 Words
    • 8 Pages

    Busn

    You have now been tasked with providing a recommendation for the project based on the results of a Net Present Value Analysis. Assuming that the required rate of return is 15% and the initial cost of the machine is $3,000,000.…

    • 1773 Words
    • 8 Pages
    Good 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

    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