Question

soft...

Hart Venture Capital

Hart Venture Capital (HVC) specializes in providing venture capital for software development and Internet applications. Currently HVC has two investment opportunities: (1) Security Sys- tems, a firm that needs additional capital to develop an Internet security software package, and (2) Market Analysis, a market research company that needs additional capital to develop a soft- ware package for conducting customer satisfaction surveys. In exchange for Security Systems stock, the firm asked HVC to provide $600,000 in year 1, $600,000 in year 2, and $250,000 in year 3 over the coming three-year period. In exchange for Market Analysis stock, the firm asked HVC to provide $500,000 in year 1, $350,000 in year 2, and $400,000 in year 3 over the same three-year period. HVC believes that both investment opportunities are worth pursuing. How- ever, because of other investments, HVC is willing to commit at most $800,000 for both projects in the first year, at most $700,000 in the second year, and $500,000 in the third year.

HVC’s financial analysis team reviewed both projects and recommended that the com- pany’s objective should be to maximize the net present value of the total investment in Secu- rity Systems and Market Analysis. The net present value takes into account the estimated value of the stock at the end of the three-year period as well as the capital outflows that are necessary during each of the three years. Using an 8% rate of return, HVC’s financial analysis team esti- mates that 100% funding of the Security Systems project has a net present value of $1,800,000, and 100% funding of the Market Analysis project has a net present value of $1,600,000.

HVC has the option to fund any percentage of the Security Systems and Market Analy- sis projects. For example, if HVC decides to fund 40% of the Security Systems project, investments of 0.40($600,000) ?? $240,000 would be required in year 1, 0.40($600,000) ?? $240,000 would be required in year 2, and 0.40($250,000) ?? $100,000 would be required in year 3. In this case, the net present value of the Security Systems project would be 0.40($1,800,000) ?? $720,000. The investment amounts and the net present value for par- tial funding of the Market Analysis project would be computed in the same manner.

Managerial Report

Perform an analysis of HVC’s investment problem and prepare a report that presents your findings and recommendations. Be sure to include information on the following:

1. The recommended percentage of each project that HVC should fund and the net present value of the total investment

2. A capital allocation plan for Security Systems and Market Analysis for the coming three-year period and the total HVC investment each year

3. The effect, if any, on the recommended percentage of each project that HVC should fund if HVC is willing to commit an additional $100,000 during the first year

4. A capital allocation plan if an additional $100,000 is made available

5. Your recommendation as to whether HVC should commit the additional $100,000

in the first year

Provide model details and relevant computer output in a report appendix.

please use excel solver thanks

Answer 1

Answer:-
(a) Let X1 = percentage of funds invested in security systems
X2 = percentage of funds invested in market analysis
Objective function is to maximise the npv of investment in security systems and market analysis
maximise z = X1/100(1800000)+X2/100(1600000)
constraints:
X1/100(600000)+X2/100(500000)<=800000
X1/100(600000)+X2/100(350000)<=700000
X1/100(250000)+X2/100(400000)<=500000
X1,X2>=0
Solving the above, HVC should invest 60.87% in Security Systems and 86.95% in Market Analysis which will maximise the NPV at $2,486,956.522
(b) Capital Allocation Plan
Year 1 Year 2 Year 3
Security Systems $365,220 $365,220 $152,175
Market Analysis $434,750 $304,325 $347,800
Slack $30 $30,455 $25
(c) If additional $100,000 is available in the first year, HVC should choose to invest the said funds among the two projects 68% in Security Systems and 82% in Market analysis thereby increasing the NPV to $2,536,000
(d) Revised capital allocation plan would be as below:
Year 1 Year 2 Year 3
Security Systems $408,000 $408,000 $170,000
Market Analysis $410,000 $287,000 $328,000
Slack $82,000 $5,000 $2,000