Case study: Investment Analysis and Lockheed Tri Star

MGMTS-2700

Professor Hamza Abdurezak

Harvard University

Yang Zhong

1> A. Payback, NPV, IRR, Should purchase or not?
Payback: $35,000/5000=7 year

NPV: =Co+ C1…..n/(1+i)^1….n
Co=-3,5000
CF1-CF15= 5,000; I= 12
Computing result is $-945.67

IRR: 11.49%
NPV is negative and IRR is lower 12% so reject the proposal.

B.
NPV: =Co+ C1…..n/(1+i)^1….n
NPV= -35000+(4500/.12)
=2500
NPV is positive so should purchase the machine.

C. NPV: =Co+ C1…..n/(1+i)^1….n
= -35,000(4000/(0.12-0.04))
=-35,000+50,000
=15,000
NPV is positive so rainbow should reinvest the cost saving into the machine annually.

1,Using IRR I recommend the (4)
2, Using NPV I recommend the proposal (3)
3,NPV is better!
The NPV method is better because it shows the most cash flow as the highest. Because the discount rate is 15%, it is building a new both is prioritized higher.

4.
1, NPV=PV-Investment
=210k-110k=100k
2. Assuming issue N shares when price is P.
N*P=110,000(1)
P=1,210,000/(10,000+N) (2)
Then computing the result
So N=1000 P=$110
3, Stock price rises up $10 Stock holder make the profit.

Out cash flow in cash flownet cash flow
1967-100-100
1968-200-200
1969-200-200
1970-200140 -60
1971-200-490140-550
1972-490560 70
1973 -490560 70
1974-490560 70
1975-490560 70
1976-490420-70
1977420420
In total -584.05
Acc profit -480

Cost: 14 $mm
Units Per Year: 35
Revenue 16
Quantity: 210

...InvestmentAnalysis and LockheedTriStar
Group effort
Total points: 100 (Course grade 25%)
This case comprises four serially numbered stand-alone problems and the fifth one appears with the title of LockheedTri-Star. You are required to offer your calculations of values as indicated below. In addition to the calculations, write a brief summary of your findings in about 100 words for each problem.
1) Rainbow Products 20 points
| Machine Purchase | Machine plus service contract | Enhanced Machine |
Payback period | 7 Years | 7.78 Years | 7.65 Years |
NPV | ($945.68) | $2,500.00 | $15,000.00 |
IRR | 11.49% | 12.86% | 15.43% |
Decision (Yes/No) | NO | YES | YES |
We would advise Rainbow Products to not purchase the paint-mixing equipment unless they decided take on the additional $500 per year expenditure to service the machine, or decided to reinvest 20% of the yearly cost savings back into new machine parts. Either of the last two options would benefit the company, unlike the first option, as they provide both a positive Net Present Value (NPV) and Internal Rate of Return (IRR) greater than the Cost of Capital. Although the last two options have longer Payback Periods than the first option, using Payback Period to make a determination in this example is not suitable because of the shortcomings of the method....

...Pre-Feasibility Study
FRESH FRUITS PROCESSING
(Kinnow)
Small and Medium Enterprise Development Authority
Government of Pakistan
www.smeda.org.pk
HEAD OFFICE LDA Plaza, 6th Floor, Egerton Road, Lahore Tel: (042) 111-111-456, Fax: (042) 6304926-7 helpdesk@smeda.org.pk
REGIONAL OFFICE PUNJAB 6th Floor, LDA Plaza, Egerton Road, Lahore. Tel: (042) 111-111-456 Fax: (042) 6304926-7 helpdesk@smeda.org.pk REGIONAL OFFICE SINDH 5TH Floor, Bahria Complex II, M.T. Khan Road, Karachi. Tel: (021) 111-111-456 Fax: (021) 5610572 helpdesk-khi@smeda.org.pk REGIONAL OFFICE NWFP Ground Floor State Life Building The Mall, Peshawar. Tel: (091) 9213046-47 Fax: (091) 286908 helpdesk-pew@smeda.org.pk REGIONAL OFFICE BALOCHISTAN Bungalow No. 15-A Chaman Housing Scheme Airport Road, Quetta. Tel: (081) 831623, 831702 Fax: (081) 831922 helpdesk-qta@smeda.org.pk
May, 2006
Pre-Feasibility Study
Fresh Fruits Processing (Kinnow)
DISCLAIMER
The purpose and scope of this information memorandum is to introduce the subject matter and provide a general idea and information on the said area. All the material included in this document is based on data/information gathered from various sources and is based on certain assumptions. Although, due care and diligence has been taken to compile this document, the contained information may vary due to any change in any of the concerned factors, and the actual results may differ substantially from the presented...

...Harvard Business School
9-291-031
Rev. November 17, 1993
InvestmentAnalysis and LockheedTriStar
1. Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs. The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. The machine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost of capital for such aninvestment is 12%. [A] Compute the payback, net present value (NPV), and internal rate of return (IRR) for this machine. Should Rainbow purchase it? Assume that all cash flows (except the initial purchase) occur at the end of the year, and do not consider taxes. [B] For a $500 per year additional expenditure, Rainbow can get a “Good As New” service contract that essentially keeps the machine in new condition forever. Net of the cost of the service contract, the machine would then produce cash flows of $4,500 per year in perpetuity. Should Rainbow Products purchase the machine with the service contract? [C] Instead of the service contract, Rainbow engineers have devised a different option to preserve and actually enhance the capability of the machine over time. By reinvesting 20% of the annual cost savings back into new machine parts, the engineers can increase the cost savings at a 4% annual rate. For example, at the end of year one, 20% of the $5,000 cost savings ($1,000) is...

...LockheedTriStarCaseStudy
Introduction
By 1966, Lockheed had already invested almost $900 million in research and development of the TriStar L-1011 (Scott, 2010). By 1971, with over $1 billion in sunk costs, Lockheed was seeking a $250 million federal guarantee through a congressional hearing in order to complete the program. Lockheed presented their case as a liquidity issue caused by unrelated military contracts and assured that the TriStar program was economically sound (text).
Through net present value (NPV) calculations, break even breakdowns, and shareholder stock analysis based on a sales volume of 210 aircraft; this casestudy identifies flaws in the initial proposals presented by Lockheed in 1971.
Financial Analysis including tables, graphs and other Analysis
Table 1: Cash flow an NVP analysis
Net present value of this project is just over -$584 million
Table 2: Present Value factors and new present value based on varying discount rates
Chart 3: NPV vs. Discount Rate
Table 2: Breakeven analysis
Results and Analysis (and value added questions)
In 1971 Lockheed estimated a breakeven point somewhere between 195...

...o
\
Course: Financial Decision Making
Date: 01/26/2012
InvestmentAnalysis and TriStarLockheed
1 (A) According to the information provided the pay back time shall be
35000/5000 = 7 years. Formula for net present value NPV is as follows (CALCULATING NET PRESENTVALUE, PAYBACK PERIOD, AND RETURN ON INVESTMENT):
15
NPV= -35,000 + ∑ 5,000 / (1 + 12%) ^ 15
i=1
= $947
The IRR
15
0= -35,000 + ∑ 5,000 / (1 + IRR) ^ 15
i=1
= 11.49%
From the above calculation it can be projected that the net present value is negative and the IRR is also lover than the cost of capital which is 12%
(B)
Present value = annual cash flow/ cost of capital
= 4500/0.12
= 37500
The net present value NPV = - initial investment + PV
This comes to = -5000+37500
= 2500
Based on this it can be concluded that rainbow products can buy the machine for use in the long run as it is more economical
(C)
In computing PV the formula is PV = C/ (K-g) where C is the annual payout = 5000-1000 =$ 4,000, k- discount rate = 12% and g- annual growth rate = 4%
Hence PV= 4,000 / (0.12-0.04) = 50,000
And the NPV = -35000+50000 = 15000
=> From this calculation the project rainbow products company is commercially viable as the NPV is positive and this is due to the 20% of the annual...

...InvestmentAnalysis and LockheedTriStar
The Case is divided into 5 different mini Cases. Each case is about another scenario.
Case 1 is about a company called Rainbow Products. The company considers the purchase of a paint-mixing machine. The machine costs $35.000 but the company expects an annual saving of $5.000 additional cash flow. The machine is expected to last 15 years and the cost of capital is 12 %.
First I would calculate the NPV and the IRR. If the NPV is higher then the return on the capital market, the project is profitable. The IRR shows me the discount rate that puts the NPV to zero. It could also be explained as the break-even point.
Additionally the company could get a “Good As New” service contract for $500 a year. The machine would then produce cash flows of $4,500 per year.
I would again calculate the NPV with the new cash flow. If the NPV is higher then the return on the capital market I would recommend this project.
The last scenario of this case is that the engineers of Rainbow products found a way to enhance the capability of the machine over time. They should reinvest 20 % of the annual cost savings back into new machine parts. The saving rate is 4 %.
There for you should use a formula which is written in the case. After calculating with...

...1. Rainbow Products is considering the purchase of a paint-mixing machine in order to reduce labor costs. The savings are expected to provide the additional cash flows of $5,000 per year. The machine costs $35,000 and will last for 15 years. The cost of capital for this investment is 12%
a) The payback period of this project is 7 years. The sum of cash flows during the first seven years equal the initial investment. The net present value (NPV) and IRR of this project is -$945.68, and 11.49% respectively. As the project has negative NPV and the IRR is lower than the cost of capital, Rainbow should not purchase the machine.
b) If Rainbow pays additional $500 per year, Rainbow can get a service contract that keeps the machine in new condition forever. As a result, the net cash flows per year would be $4,500. The NPV of this project can be calculated as follows.
NPV = Initial cost + Present Value of All Cash Flows
= -$35,000 + (4,500/0.12)
= $2,500
In this case, Rainbow should purchase the machine with this service contract as the NPV of this investment is positive.
c) Instead of the service contract mentioned in b), Rainbow can reinvest 20% of the annual cost savings in new machine parts, resulting in the increase in cost saving at 4% annual rate. Additionally, as long as Rainbow reinvest at 20%, the cash flows will continue to grow at 4% in perpetuity.
Table 1 Net annual cost savings calculations...

...CASE 7: INVESTMENTANALYSIS AND LOCKHEEDTRISTARINVESTMENTANALYSIS QUESTION 1:
A) Payback, NPV, IRR: (35,000) 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000
1 (35,000)
2
3
4
5
6
7
8
5,000
5,000
5,000
5,000
5,000
5,000
5,000
9 Machine Cost Duration (years) Cash Flows Cost of capital Payback (years) 35000 15 5000 12% total cost annual cash flow
10
11
12
13
14
15
7
NPV IRR
present value of cash inflows - present value of cash outflows 3.07%
($9,073.04)
B) Should Rainbow Products purchase the machine with service contract? perpetuity annual receipt discount rate 4500 0.12 37,500
$37,500 - $35,000 = $2,500 Based on the perpetuity, Rainbow Products should purchase the machine with the service contract.
C)
�� =
�� �� − ��
V= 4,000 .12 - .04 4,000 0.08
$4,000 cash flow 12% cost of capital 4% growth rate 50,000
50,000 - 35,000 = 15,000 Rainbow Products should reinvest into new machine parts each year; by doing so, Rainbow Products will have a net present value of $15,000.
INVESTMENTANALYSIS QUESTION 2:
Incremental Cash Flows Investment Year 1 Year 2 Year 3 ($75,000) 44,000 44,000 44,000
Project Add a New Window
IRR 35%
NPV 22,140.79
Update Existing Equipment Build a New Stand Rent a Larger Stand Discount Rate...

{"hostname":"studymode.com","essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_1.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":false,"site_id":1,"autoComplete":false,"isPremiumCountry":false,"userCountryCode":"US","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":35908999,"categoryName":"Literature","categoryParentId":null,"currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":4,"pageRange":"1-4","totalPages":4}},"access":"premium","title":"Case Study: Investment Analysis and Lockheed Tri Star I","additionalIds":[7,3,93,52,92],"additional":["Education","Business \u0026 Economy","Education\/Greek System","Business \u0026 Economy\/Organizations","Education\/Educational Institutions"],"loadedPages":{"html":[],"text":[1,2,3,4]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/Case-Study-Investment-Analysis-And-Lockheed-1045157.html","pagesPerLoad":50,"userType":"member_guest","ct":10,"ndocs":"1,500,000","pdocs":"6,000","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.studymode.com\/signup\/","joinUrl":"https:\/\/www.studymode.com\/join","payPlanUrl":"\/checkout\/pay","upgradeUrl":"\/checkout\/upgrade","freeTrialUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fcheckout%2Fpay%2Ffree-trial\u0026bypassPaymentPage=1","showModal":"get-access","showModalUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fjoin","joinFreeUrl":"\/essays\/?newuser=1","siteId":1,"facebook":{"clientId":"306058689489023","version":"v2.9","language":"en_US"}}