Memo for accepting a proposal by evaluation NPV of the project

Memo

To: Bill Jones, Stryker Corporation’s CFO

From: XYZ, Senior Accountant at Stryker

Date: 21-April, 2018

Subject: PCB Project

 

Dear Bill,

I am hereby presenting the things for the PCB projects, where we can conclude the possibility of proposal XXX. For this proposal I strictly believe that we should proceed with it because of following facts:

  1. We can use the available resource of 30,000 sq. feet of Land owned by Stryker and construction of building will not cost more than the variable elements like engineering and architectural costs.
  2. Positive Cash flow can be realized after Year 3.
  3. IRR is higher than Hurdle Rate, which makes impact that proposal won’t led the stakeholders money down.
  4. Payback period could be re-instated in 4.57 years.

Further, if we assume to use the Perpetuity calculation for terminal value, we should understand that the perpetuity calculation has a similar character of a bond that never matures and these can be used in detecting the price preferred stock, which pays a dividend that is a specified percentage of its par value. So, in the given case, we can calculate the value of terminal value by using the same formula; as,

P = D1/ (r-g)

                        Where, D1 = Final Year’s cash flow

                                    r = hurdle rate/ required rate

                                    g = 0

After calculating the same in the excel sheet, the new Terminal Value = $31,242,993.

With this, we have been able to identify the new NPV = 13,404,897 and IRR = 40.54%

Positive Facts:

  1. As the NPV, in the case of perpetuity is higher by 1,518,562 we should opt for perpetuity method in order to calculate the terminal value.
  2. The Building has life of 30 years, which is supposed to be used for various other purposes, even if the proposal fails in during the years. But in case the proposal is viable in all respect then the cost of building will be utilized for manufacture of PCB for next 30 years, which means that the purchase from manufacturers which is supposed to be increased by 22% each year, will be saved and the cash flow tends to be positive each year at the rate of 31%.
  3. Capital equipment will be durable for 7 next year and the IT equipment will be durable for 3 years. Though, these Cash outflow will be recurring but as we are supposed to get the positive cash flow since from Year 3 itself we can be able to incur these expenses in future as well. The total cost of IT Equipment is 336,000, which is supposed to be incurred after 3 years is not a big deal as from that year itself we will be generating Positive Cash flow of $2,166,909, which present value tends to $1,424,778. So it is very much acceptable from that point of view.
  4. As we have the terminal Value of 31,242,993 at the end of year 2009 by means of perpetuity method of calculation, it is very much useful that the Terminal value which is the sum of all cash flows from an investment or project is beyond a forecast period based on a specified rate of return, is higher.
  5. As already discussed the pay back period is 4.57 years which means that the though the project is of 7 years or more, the working capital will be re-back within 4.57 years of time. The Proposal that leads to get the money in quick 60% of time is always viable with a projection that the company will continue to the operation in next many years.
  6. The company has been supposed to be possible that the NPV may not be recovered due to many variable constraints like the Tax rates, manufacturing costs. But as even in such situation the NPV will be recovered as the NPV is 24% of the total cost of the company incur for manufacturing. It means, even if such variable constraints increase by 24% (which is not possible, at such high rate), the company will be financially viable to opt for this proposal.
  7. The discounting rate may be increased to certain rates, but even if the increased to double figures upto 30% around, the cash flow will be $3,513,562.

Accumulating all the possible situation which could may lead the NPV to failure has been supposed to be an extra-ordinary situations but in such situations too the NPV of the company has a potential to recover a financially viable option than other. If we consider this option, we already know that the quality and delivery option for the company will get settle down and the market share will increase. Once the control over the production is in the hand of the company we can plan for increment of the production plan and the profit ratio will increase accordingly.

Regards,

XYZ

 

# The Tables has been shown below for the purpose of the working NPV and Payback period.

Tables:

 

Perpetuity Method

By Using Formula
p=D1/(r-g)
D1 = Final Year’s cash flow
r = hurdle rate/ Required rate
g = 0
As Given,
D1 = 4686448.81
r= 15%
g=0
New Terminal Value        31,242,993
2003200420052006200720082009
Subtotal of Cash Flows-177920-749931.68-301384.35942166909.6253027638.6813586148.7684686448.81
 Terminal value (at book value) 31,242,993
 Discount rate15.00%
 Discount factor 15% $      1.0000 $            0.8696 $       0.7561 $      0.6575 $      0.5718 $      0.4972 $     0.4323
 Present value of cash flows       (177,920)            (652,115)       (227,890)    1,424,778    1,731,062    1,782,950   2,026,081
 Present value of terminal value 13,507,208
 Sum of PV of cash flows and terminal value   19,414,155
 Less initial investments:
 Building    (3,030,000)
 Capital Equipment    (2,643,258)
 IT & Other Equipment      (336,000)
 Net Present Value   $13,404,897
 IRR Calculation:
 Cash flows    (6,187,178)            (749,932)       (301,384)    2,166,910    3,027,639    3,586,149 35,929,442
 IRR 40.54%
Total Cost54969038
NPV $13,404,897
% NPV $        24.39

 

Published by

Shushant mallik ( Chartered Accountant & Cost Accountant )

Shushant is a Chartered Accountant and a Cost Accountant. He has secured All India Rank-34 in CMA Final Exams. He is a Financial Controller at Mount Meru Soyco Limited, Rwanda. He is a administrator of this site . In his spare time he hang out with his friends and discuss about the current issues in market. You can find his latest blog posts at www.enrollmyexperience.com and at his facebook profile.

Leave a Reply