A financial analyst is in the process of reviewing four investments projects for one of his clients. The net present cash values for the four projects are estimated at $50 million, $15 million, $20 million and $80 million respectively. His client is committed to $20 million of capital funds for the first year and $13 million for the second year. The cash requirements for each project in the two-year period are as follows:
Projects --> Period i v |
1 |
2 |
3 |
4 |
First year |
6 |
2 |
4 |
10 |
Second year |
8 |
4 |
8 |
6 |
Net present value |
$50 (million) |
$15(million) |
$20(million) |
$80(million) |
Formulate for the financial analyst.Describe the optimal solution to the client.
All projects having positive NPVs, thus all projects are feasible.
(All figures are in $' million)
Funds required to invest in all projects are
First year = 6 + 2 + 4 + 10 = 22 & available fund for first year is only 20.
Second year = 8 + 4 + 8 + 6 = 36 & available fund for second year is only 13.
In these type of situations we use Profitability Index to decide which projects are selected and which are to be skipped.
Profitablilty index = PV of cash inflow/ PV of cash outflows
But in this such information is not given to calculate Profitability index, thus we are calculating here NPV per One $ of investment.
thus NPV per One $ of investment = NPV of project / Investment in Project
Note: We are taking here value of investment in project for both two year with out taking effect of time value of money as no discount rate is provided in the question.
Project | NPV |
Investment in two year |
NPV per one $ of invsetment | Priority |
1 | 50 | 14 | 3.57 | II |
2 | 15 | 6 | 2.5 | III |
3 | 20 | 12 | 1.67 | IV |
4 | 80 | 16 | 5 | I |
Total fund available with investor = 20+13 = 33
Total fund required for Project 4 & Project 1= 16 + 14 =30
thus he can invest in only project 4 & Project 1, for investing in next profitable project i.e. project 2 he requires $6 million but he has only $3 million in his hands.
Thus the optimal solution for the client is to invest in Project 4 & Project 1.
Thus Funds available in first year = 20, Investment in First year = 10+6 = 16, Funds remains in hand =4
Funds available in second year = 4+ 13= 17, Investment in second year =6+8= 14, funds remains in hand = 3
NPV from total investment = 80 + 50 = 130
A financial analyst is in the process of reviewing four investments projects for one of his...
Talbot, a financial analyst for FTE Corporation, must choose one of four projects for his firm to pursue. Talbot has summarized the financial and social impact of each project in the table below. Assuming that all aspects of the four projects are the same, which one should Talbot recommend to the President of FTE Corporation to maximize shareholders’ wealth? Bellar Constad Abron Dundar Location Upfront Costs Expected Operating Income Positive Social Impact Abron $250,000 $500,000 None Bellar $250,000 $450,000 Increase...
please help answer these Financial Analysis Exercise #1 You are the newest Financial Analyst in Investments, you need to demonstrate your prowess in Excel, your outstanding written skills and ability to communicate. Mr. Richards is the Executive Vice President and Chief Investment officer in your new firm. You are being asked to complete a series of “pet” projects for Mr. Richards. You have been told not to try to impress him, just do the work and stick to the facts....
The management of Revco Products is exploring four different investment opportunities. Information on the four projects under study follows: Project Number 2 $ (440,000) 523,050 83.050 16 years Investment required Present value of cash inflows at a 12% discount rate Net present value Life of the project Intemal rate of return $ (490,000) 596,160 $ 106,160 8 years 18% $ (340,000) 447,120 $ 107.120 8 years $ (460,000) 540,750 80.750 $ 5 vears 19 % 15 % 21 % Because...
Dan Boyd is a financial planner trying to determine how to invest $100,000 for one of his clients The cash flows for the five investments under consideration are summarized in the following table Summary of Cash in-Flows and Out-Flows (at Beginning of Year) Year 1 1.00 1.00 1.00 0.00 0.00 1.00 0.00 Year 20.45 0.00 0.00 Year 3 +1.05 1.00 0.00 0.00 1.25 Year 4 +1.30 +1.30 0.00 +1.65 0.00 For example, if Dan invests $1 in investment A at...
34-39 Assume that you are a financial analyst for Tangshan Mining Company and are given the following about the firnn's new project: the project's initial after-tax cost at t-o is S8,000,000 and are a financial analyst for Ta the e project is expected to provide after-tax operating cash inflows as follows: Year One Two Three Four Cash In flow: $2,800.000 $2,900,000 $3.200,000 si .800.000 a. Calculate the payback period for this project 1. If the maximum acceptable payback period is...
Alternative Capital Investments The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $1,310,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year Office Expansion Server 1 $366,000 $483,000 2 366,000 483,000 3 366,000 483,000 4 366,000 483,000 5 366,000 6 366,000 The committee has selected a rate of 15% for purposes...
Alternative Capital Investments The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $1,428,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year Office Expansion Server 1 $375,000 $495,000 2 375,000 495,000 3 375,000 495,000 4 375,000 495,000 5 375,000 6 375,000 The committee has selected a rate of 12% for purposes...
Alternative Capital Investments The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $1,343,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year Office Expansion Server 1 $338,000 $446,000 2 338,000 446,000 3 338,000 446,000 4 338,000 446,000 5 338,000 6 338,000 The committee has selected a rate of 10% for purposes...
Alternative Capital Investments The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $490,000. The estimated net cash flows from each project are as follows: Net Cash Flows Year Office Expansion Servers 1 $125,000 $165,000 2 125,000 165,000 3 125,000 165,000 4 125,000 165,000 5 125,000 6 125,000 The committee has selected a rate of 12% for purposes of net...
There are 2 projects in the intake process. There is only enough financial capital available to do 1 of the 2, though it might later be possible to do the other one. The company is also concerned with cash flow. Finally, the organization has given a weight of 50 to project 1 and 60 for project 2, in terms of how likely each project might increase market penetration for these markets served by what each project provides. Knowing the above,...