Question

In: Finance

Hart Venture Capital Hart Venture Capital (HVC) specializes in providing venture capital for software development and...


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

Solutions

Expert Solution

Answer:


Related Solutions

soft... Hart Venture Capital Hart Venture Capital (HVC) specializes in providing venture capital for software development...
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...
Hart Venture Capital (HVC) specializes in providing venture capital for software development and Internet applications. Currently...
Hart Venture Capital (HVC) specializes in providing venture capital for software development and Internet applications. Currently HVC has two investment opportunities: (1) Security Systems, 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 software 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...
Hart Venture Capital (HVC) specializes in providing venture capital for software development and Internet applications. Currently...
Hart Venture Capital (HVC) specializes in providing venture capital for software development and Internet applications. Currently HVC has two investment opportunities: (1) Security Systems, 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 software 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...
Hart Venture Capital (HVC) specializes in providing venture capital for software development and Internet applications. Currently...
Hart Venture Capital (HVC) specializes in providing venture capital for software development and Internet applications. Currently HVC has two investment opportunities: (1) Security Systems, 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 software 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...
discusses the role that venture capital and angel investors play in providing capital for entrepreneurial ventures....
discusses the role that venture capital and angel investors play in providing capital for entrepreneurial ventures. Discuss the ways in which these sources of entrepreneurial capital are similar and how they are different, and discuss the importance of venture capital to a healthy economy. Most large cities have venture capital firms, and most metro areas have networks of angel investors; research and identify these for your geographical area and share some information about them.
a. As the Head of Business Development of Fidelity Venture Capital, a client has presented a...
a. As the Head of Business Development of Fidelity Venture Capital, a client has presented a business plan that has the following projected returns for your consideration; Stock A Stock B State of the Economy Returns / Prob Returns / Prob Excellent 32% / 0.4 40% / 0.2 Worse -5% / 0.4 8% / 0.3 Normal 21. % / 0.2 25% /  0.5 Required: i. Calculate the expected return for each stock ii. Calculate the total risk of the client’s business...
FARS Research Case VTech is an Enterprise Resource Planning (ERP) software development corporation that specializes in...
FARS Research Case VTech is an Enterprise Resource Planning (ERP) software development corporation that specializes in providing technological solutions for firms to better manage their businesses. Being in the technology industry, research, and development (R&D) is one of the largest expenditures. For example, in the second quarter of the fiscal year 2020 alone, VTech’s internal books reveal that the company has generated the following R&D expenditures directly attributable to the software they plan to develop and sell: - Incurred $5,000,000...
What Is Venture Capital Financing? Describe venture capital financing. Discuss the pros and cons. Discuss and...
What Is Venture Capital Financing? Describe venture capital financing. Discuss the pros and cons. Discuss and provide examples.
VENTURE CAPITAL. Delta Venture Capital Group is considering whether to invest in Maytime Products, a new...
VENTURE CAPITAL. Delta Venture Capital Group is considering whether to invest in Maytime Products, a new company that is planning to compete in the small kitchen appliance market. Maytime has three products in the design and test phase: (1) a unique refrigerator/oven that can be programmed in the morning to cook foods (like chicken) but keeps the food refrigerated until the cooking process begins; (2) a French fry maker that can make long thick French fries or small thin shoestring...
Standards for Nonmanufacturing Expenses CodeHead Software Inc. does software development. One important activity in software development...
Standards for Nonmanufacturing Expenses CodeHead Software Inc. does software development. One important activity in software development is writing software code. The manager of the WordPro Development Team determined that the average software programmer could write 25 lines of code in an hour. The plan for the first week in May called for 4,650 lines of code to be written on the WordPro product. The WordPro Team has five programmers. Each programmer is hired from an employment firm that requires temporary...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT