Question

In: Finance

Cowboy Corp. is about to expand its operations and they have several projects with various cash...

Cowboy Corp. is about to expand its operations and they have several projects with various cash flows available in Excel upload file. Each project has an 8-year life and the firm has a cost of capital at 8%. The firm has $15,000 for the expansion and will invest in multiple projects with that capital constraint.

1. Calculate NPV for each project

2. Find the project combination that maximizes total NPV for Cowboy Corp. and calculate total capital spending

3. Find the optimum combination under following constraints; Project A and C can only be invested together and at least one out of Project E, F or G must be invested.

Cost of capital 8%
YEAR 0 1 2 3 4 5 6 7 8
Project A -5000 1000 1250 1000 900 850 750 700 700
Project B -3000 400 600 800 600 600 600 600 600
Project C -4500 1200 1500 1200 1200 500 500 300 300
Project D -2000 450 450 450 400 400 300 300 200
Project E -7500 1350 1350 1350 1350 1350 1350 1350 1350
Project F -8000 2000 2000 2000 1500 1500 1500 500 100
Project G -6500 1400 1400 1200 1200 900 900 900 900

Solutions

Expert Solution

Solution.>

Since it is a 8-year project, the values of year 7 and year 8 is missing in the question. So i have solved it till the year 6. The answer would be different if we include the year 7 and 8, but the methodology will remain the same. I have solved this question in Excel. The formula used are written along with the values. If you still have any doubt, kindly ask in the comment section.

Note: Give it a thumbs up if it helps! Thanks in advance!


Related Solutions

Cowboy Corp. is about to expand its operations and they have several projects with various cash...
Cowboy Corp. is about to expand its operations and they have several projects with various cash flows available in Excel upload file. Each project has an 8-year life and the firm has a cost of capital at 8%. The firm has $15,000 for the expansion and will invest in multiple projects with that capital constraint. 1. Calculate NPV for each project 2. Find the project combination that maximizes total NPV for Cowboy Corp. and calculate total capital spending 3. Find...
(Preparation of Corrected Statement of Financial Position) Bruno Corp. has decided to expand its operations. The...
(Preparation of Corrected Statement of Financial Position) Bruno Corp. has decided to expand its operations. The bookkeeper recently completed the following statement of financial position in order to obtain additional funds for expansion: Bruno Corp. Statement of Financial Position For the Year Ended December 31, 2020 Current assets  Cash (net of bank overdraft of $30,000) $260,000  Accounts receivable (net) 340,000  Inventory at the lower of cost and net realizable value 401,000  FV-NI investments (at cost—fair value $120,000) 140,000 Property, plant,...
Martinez Corp. has decided to expand its operations. The bookkeeper recently completed the following statement of...
Martinez Corp. has decided to expand its operations. The bookkeeper recently completed the following statement of financial position in order to obtain additional funds for expansion: MARTINEZ CORP. Statement of Financial Position For the Year Ended December 31, 2020 Current assets Cash (net of bank overdraft of $34,000) $ 410,000 Accounts receivable (net) 526,000 Inventory at the lower of cost and net realizable value 571,000 FV-NI investments (at cost—fair value $310,000) 300,000 Property, plant, and equipment Buildings (net) 590,000 Equipment...
Ayayai Corp. has decided to expand its operations. The bookkeeper recently completed the following statement of...
Ayayai Corp. has decided to expand its operations. The bookkeeper recently completed the following statement of financial position in order to obtain additional funds for expansion: AYAYAI CORP. Statement of Financial Position For the Year Ended December 31, 2020 Current assets Cash (net of bank overdraft of $31,000) $ 270,000 Accounts receivable (net) 349,000 Inventory at the lower of cost and net realizable value 411,000 FV-NI investments (at cost—fair value $130,000) 150,000 Property, plant, and equipment Buildings (net) 580,000 Equipment...
(Preparation of Corrected Statement of Financial Position) Bruno Corp. has decided to expand its operations. The...
(Preparation of Corrected Statement of Financial Position) Bruno Corp. has decided to expand its operations. The bookkeeper recently completed the following statement of financial position in order to obtain additional funds for expansion: Bruno Corp. Statement of Financial Position For the Year Ended December 31, 2020 Current assets    Cash (net of bank overdraft of $30,000)   $260,000  Accounts receivable (net)   340,000  Inventory at the lower of cost and net realizable value   401,000  FV-NI investments (at cost—fair value $120,000)   140,000 Property, plant,...
Question 1A A CEO of a multihospital system is planning to expand operations into various states....
Question 1A A CEO of a multihospital system is planning to expand operations into various states. It will take several years to get certificate of need (CON) approvals so that the new facilities can be constructed. The eventual cost (in millions of dollars) of building a facility will differ among states, depending upon finances, labor, and the economic and political climate. An outside consulting firm estimated the costs for the new facilities as based on declining, similar, or improving economies,...
If, in the long run, a small firm were to expand its scale of operations, then...
If, in the long run, a small firm were to expand its scale of operations, then initially it should expect to encounter ____________. a. decreasing total costs b. diseconomies of scale c. rising average total costs d. economies of scale The positive slope of the supply curve can be explained by comparative advantage and opportunity cost. a. True b. False There is a change in the price of wine. Which of the following causes the movement along the demand curve?...
On August 1, 2021, Trico Technologies, an aeronautic electronics company, borrows $21 million cash to expand operations. The loan is made by FirstBanc Corp. under a
On August 1, 2021, Trico Technologies, an aeronautic electronics company, borrows $21 million cash to expand operations. The loan is made by FirstBanc Corp. under a short-term line of credit arrangement. Trico signs a six-month, 9% promissory note. Interest is payable at maturity. FirstBanc Corp.’s year-end is December 31. Required:1. Record the acceptance of the note by FirstBanc Corp.2. Record the appropriate adjustment for the note by FirstBanc Corp. on December 31, 2021.3. Record the receipt of cash by FirstBanc...
GMFC is planning to expand its U.S. operations by building a new plant. They will employ...
GMFC is planning to expand its U.S. operations by building a new plant. They will employ about 500 production workers. This new plant will manufacture motorized recreational equipment including all-terrain vehicles, personal watercraft, and snowmobiles. The equipment will assemble mechanical components produced in other GMFC operations or purchased from suppliers. The new plant will fabricate fiberglass body parts and complete the final assembly process. GMFC would like to operate the new plant union-free. It's likely that the Untied Automobile Workers...
The SoCal Corp is about to begin producing and selling its prototype product. Annual cash flows...
The SoCal Corp is about to begin producing and selling its prototype product. Annual cash flows for the next five years are forecasted as:             Year                 Cash Flow             1                    -$40,000             2                      -$20,000             3                      $100,000             4                      $400,000             5                      $850,000 Assume annual cash flows are expected to remain at the $850,000 level after Year 5 (i.e., Year 6 and thereafter). If investors want a 40 percent rate of return on their investment, calculate the terminal value and calculate the venture’s present value.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT