Preview

Memo for financial analysis

Satisfactory Essays
Open Document
Open Document
520 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Memo for financial analysis
Memo
To: ABC Inc.
From: Hank
Date: September 30, 2013
Re: Problem 1&2&3

In the first problem, based on a careful study, the project will have the following performance:

a) The exact Payback Period is 4.62 years
b) The discounted Payback Period is 5.58 years
c) The Internal Rate of Return (IRR) of the machine is 13.87%
d) The Net Present Value (NPV) is $1,136,020.85
e) The Profitability Index (PI) associated with the project is 1.14

If we make decision based on NPV or IRR or PI, we should accept this project. This is because the project has a positive NPV, its PI over 1 and the IRR is more than the required rate of return. All of this factors mean that the project can actually benefit the company. However, since your company required that all the projects have a payback period of 2 years or less and a discounted payback period of 2.5 years or less, I recommend that you should reject this particular project. This is because the exact Payback Period and discounted Payback Period are 4.62 years and 5.58 years, which are far beyond the requirements. Therefore, the project should be reject.

I also make some sensitivity analysis and scenario analysis as you required. In the sensitivity analysis, you can see that the change of the price per unit has the greatest impact on the NPV. If the price per unit decreases by 10%, the NPV will be -694,837.57 and the IRR will be 7.59%, which means the project will make the company lose money on this investment. Based on your requirements, I also do a scenario analysis. You can see it in the appendix. Since you just require the NPV and IRR results, the others are not show there, you should notice that if you pretty sure that the good case may happen, you can accept the project. This is because in the best case, all your company’s requirements will be achieved and the NPV and IRR of the project will increase a lot (The NPV will be 14,907,810.60 and the IRR will be 54.06%). However, if

You May Also Find These Documents Helpful

  • Powerful Essays

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

    Super Project

    • 462 Words
    • 2 Pages

    For Super Project, I calculated a positive NPV of $70M, an IRR of 12% (with WACC=10%) and a payback recovery of 6.7 years against a 10 year required payback. Those three factors tell me to accept the project. A positive NPV will result in profitability over the 10 year period, a positive EVA, & positive MVA. A positive IRR indicates we will be earning more than we are paying for the project and it will increase shareholder’s wealth. However, sensitivity analysis showed me that our NPV and IRR have steep slopes (extremely sensitive) which could change my decision. If WACC increased, the NPV could become negative meaning outflows exceed inflows (not profitable). If IRR falls below the WACC, they will be paying more than what will be earned back. It will also…

    • 462 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    This report utilizes the base case analysis, worse case analysis and best case analysis feeling these analyses are sufficient, while many analyses may be of interest, they could confuse the recommendations and strategic value of the project. In preparation the board would be told that calculating multiple NPVs for multiple inflationary rates for labor cost and supply cost would further confuse the issue. The information presented the NPV, IRR, MIRR and payback times would be calculated and discussed. Additionally, a break even point would be calculated. The break even point calculation included in fixed cost would…

    • 495 Words
    • 2 Pages
    Good Essays
  • Good Essays

    According to the following calculations the net present value for this project is negative $3,680,709. This is not a positive outcome for the company and they even may want to…

    • 854 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Busn

    • 1773 Words
    • 8 Pages

    Answer: Yes, I believe the company should accept this project. The company’s IRR is greater than the RRR and the NPV of $450,866.74 is a positive. Whenever the Irr is greater than the RRR or the NPV is zero or greater, the investment will earn a return greater than the RRR.…

    • 1773 Words
    • 8 Pages
    Good Essays
  • Satisfactory Essays

    Ameritrade HBS Case

    • 334 Words
    • 2 Pages

    Do some sensitivity analysis of the NPV of each of these projects using different discount rates for the cash flows generated (try the discount rates from 2, 3 and 4 above as well as a few others). What is the appropriate discount rate for the technology project? What about the marketing project? Should they be undertaken? How sensitive is the decision to the discount rate (i.e. will small…

    • 334 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Nucor Case

    • 342 Words
    • 2 Pages

    The first consideration about to undertake the investment is based on particular assumptions about the future, if we change those the result of the decision could also change. Due to the fluctuation of the market is difficult to make the right assumptions and this is why to calculate the NPV is not easy. For instance if we changed the discount rate and we lower it below the IRR, the resulting NPV will be positive and this case to invest in the new technology could be a profitable decision. We can also change the steel price rate keeping the cost rate constant, if it is increased enough the NPV could result positive, at the same time if we reduce cost rate keeping the price rate constant we can find an equal result.…

    • 342 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Keywords: NPV, NPV Profile, NPV, IRR, multiple IRRs, ranking conflict of NPV vs. IRR, payback period, profitability index, discount rate, cost of capital concept, cash flow analysis, cash flow timeline, conventional cash flow stream, non-conventional cash flow stream, sunk cost, opportunity cost, independent projects, mutually exclusive projects…

    • 1640 Words
    • 6 Pages
    Better Essays
  • Good Essays

    Running Simulation Paper

    • 3567 Words
    • 15 Pages

    The Warehouse Facility Consolidation project is aim to improve the NH’s warehouse facilities and can save the company’s operating costs as well as increase the shipping speed. This project is in retail division with an NPV of 2.29, an IRR of 13.56%, and a payback period of 8.23 years and a payback index of 0.31. Also, this project was considered as a medium risk project with 9.25% discount rate. Expansion of Mail-order Catalog Business to Asia is a retail division project, it is considering expanding its mail-order to the Asian market. Although there two possibilities that might happen, succeed or fail, it viewed as a low risk project with very low lifetime project costs which is only 2.73 million. It had an IRR of 19.77%, a discount rate of 8.46%, and a payback period is more than 10 years and the profitability index of this project is 2.85. I choose this project is because the Asian market is a very big market, since the project is low risk and the cost of this project is very low, we think it is worth to try, because if this project is succeed, the company will earn more profit. The last project we selected for this year is Retail Store Expansion in Northeast. The NPV of this project is 5.34 and it had an IRR of 37.45%, a discount rate of 10.04% and a payback period is 5.33 years. We suggested…

    • 3567 Words
    • 15 Pages
    Good Essays
  • Satisfactory Essays

    Despite the economic conditions, analyzing the Income statement and Balance sheet with an inflation of 11%; I think that the purchase of a new plant is a good long term investment which will start generating profits year after year while the country's economy is recovering. We will begin to see how economic and sales growth will gradually increase, which will allow us to recover the investment and make a profit, this is the reason why I would approve this project , in conclusion I think that the NPV will be positive.…

    • 961 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Business Memo-Accounting

    • 459 Words
    • 2 Pages

    I developed a spreadsheet including three budget schedules of Spiffy Shade Corporation, which is Production Budget, Direct-labor Budget, and Manufacturing Over-head Budget. According to the budget schedules, the company can plan ahead and meet the needs of demand. For example, form the Production Budget, the company can plan how many sunglasses should be produced for each month and quarter. Budget can also facilitating communication and coordination, and allocate resources. For example, from the schedules, the company can allocate the funds to different departments based on the budget. It can improve the correctness of the company’s decision. In addition, budgeting can control profit and operations, for instance, the company can compare the actual sales for a period against its budget sales. This can help the company evaluate the firm’s effectiveness in selling sunglasses. Thus to provide incentives for people to perform well and to make maximum profit for the company.…

    • 459 Words
    • 2 Pages
    Good Essays
  • Good Essays

    3. Compute the internal rate of return (IRR) and payback period for each project. How should these…

    • 787 Words
    • 4 Pages
    Good Essays
  • Good Essays

    In the case of Worldwide Paper Company we performed calculations to decide whether they should accept a new project or not. We calculated their net income and their cash flows for this project (See Table 1.6 and 1.5). We computed WPC’s weighted average cost of capital as 9.87%. We then used the cash flows to calculate the company’s NPV. We first calculated the NPV by using the 15% discount rate; by using that number we calculated a negative NPV of $2,162,760. We determined that the discount rate of 15% was out dated and insufficient. To calculate a more accurate NPV for the project, we decided to use the rate of 9.87% that we computed. Using this number we got the NPV of $577,069. With the NPV of $577,069 our conclusion is to accept this project as long as everything stays as it currently is. We recommend that they evaluate themselves at least yearly as things may change from year to year.…

    • 1117 Words
    • 5 Pages
    Good Essays
  • Good Essays

    The Investment Detective

    • 439 Words
    • 2 Pages

    3. What rank should we assign to each project? Why do payback and NPV not agree completely? Which criterion is best?…

    • 439 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Harding Plastic Company

    • 558 Words
    • 3 Pages

    No. While, in general, it is true that when one discounted cash flow method (NPV, PI, or IRR) gives a project an acceptable rating, the other two methods also give this project an acceptable rating; it is not necessarily true that these discounted cash flow methods will rank these acceptable projects in the same order. Ranking differences may occur as a result of (a) the time disparity problem resulting from differences in the cash inflow patterns over time between two projects; (b) the size disparity problem, resulting from the comparison of projects requiring initial cash outflows of differing size; or (c) the life disparity problem, resulting from projects with differing lives. These problems are illustrated in the case with Projects A and B representing the time disparity problem, C and D, the size disparity problem, and with E, F, G, and H, the life disparity problem. The ranking problems incurred using the discounted cash flow methods are generally a function of the different assumptions made about the reinvestment opportunities for cash inflows over the life of the project.…

    • 558 Words
    • 3 Pages
    Good Essays