Concept explainers
Project Analysis [LO1, 2] McGilla Golf has decided to sell a new line of golf clubs. The clubs will sell for $715 per set and have a variable cost of $385 per set. The company has spent $150,000 for a marketing study that determined the company will sell 75,000 sets per year for seven years. The marketing study also determined that the company will lose sales of 10,000 sets of its high-priced clubs. The high-priced clubs sell at $1,150 and have variable costs of $620. The company will also increase sales of its cheap clubs by 12,000 sets. The cheap clubs sell for $425 and have variable costs of $195 per set. The fixed costs each year will be $9,400,000. The company has also spent $1,000,000 on research and development for the new clubs. The plant and equipment required will cost $30,100,000 and will be
To determine: The payback period
Introduction:
Payback period refers to the number of periods it will take to recover the initial investments.
Answer to Problem 20QP
The payback period is 3.35 times.
Explanation of Solution
Given information:
The new clubs sold $715 per set, and the number of sets sold is 75,000 set per year. The cheaper club was sold for $425 per set, and number of sets sold is 12,000 set per year. The expensive clubs was sold for $1,150 in which the company has lost sales of 10,000 sets.
The variable cost of the new club is $385 per set, variable cost of the expensive cub is $620, and the variable cost of the cheaper club is $195. The fixed costs each year is $9,400,000.
Steps to determine the payback period:
- Firstly, determine the total sales and total variable cost of each clubs separately. Then, sum up the total sales from the existing clubs and total variable costs from all the clubs.
- Secondly, prepare the pro forma income statement.
- Next, determine the operating cash flows (OFCs) by adding up the net income and depreciation.
- Finally, estimate the payback period using its formula.
Formulae:
The formula to calculate total sales:
The formula to calculate total variable costs:
The formula to calculate total sales of the entire clubs:
The formula to calculate total variable costs of the entire clubs:
Compute the total sales of new clubs:
Hence, the total sales of the new clubs are $53,625,000.
Compute the total sales of expensive clubs:
Hence, the total sales of the expensive clubs are −$11,500,000.
Compute the total sales of cheaper clubs:
Hence, the total sales of the cheaper clubs are $5,100,000.
Compute the total sales of the entire clubs:
Hence, the total sales of the entire clubs are $47,225,000.
Table that indicating the entire sales for clubs:
Particulars |
Variable cost per sets (in $) (A) |
Number of sets Sold (in units) (B) |
Total sales (in $) (C)=(A)×(B) |
New clubs | 715 | 75,000 | 53,625,000 |
Expensive clubs | 1,150 | (10,000) | (11,500,000) |
Cheaper clubs | 425 | 12,000 | 5,100,000 |
Total sales | 47,225,000 |
Hence, the total sales for the entire clubs are $47,225,000.
Compute total variable costs of new clubs:
Hence, the total variable costs of the new clubs are −$28,875,000.
Compute total variable costs of expensive clubs:
Hence, the total variable costs of the expensive clubs are $6,200,000.
Compute total variable costs of cheaper clubs:
Hence, the total variable costs of the cheaper clubs are -$2,340,000.
Compute the total variable costs of the entire clubs:
Hence, the total variable costs of the entire clubs are -$25,015,000.
Table indicating the variable costs:
Particulars |
Variable cost per set (in $) (A) |
Number of sets Sold (in units) (B) |
Total variable costs (in $) (C)=(A)×(B) |
New clubs | ($385) | 75,000 | ($28,875,000) |
Expensive clubs | ($620) | (10,000) | $6,200,000 |
Cheaper clubs | ($195) | 12,000 | ($2,340,000) |
Total variable costs | ($25,015,000) |
Hence, the variable costs for the clubs are −$25,015,000.
Note: In order to prepare the pro forma income statement, depreciation of plant and equipment, earnings before interest and taxes (EBIT), and tax have to be computed to ascertain the net income from this statement.
The formula to calculate depreciation of plant and equipment:
The formula to calculate EBIT:
The formula to calculate tax when tax rate is given:
The formula to calculate the net income:
Compute depreciation expense of plant and equipment:
Hence, the depreciation expense is $4,300,000.
Compute the EBIT:
Hence, the EBIT is $8,510,000.
Compute tax when tax rate is given:
Hence, the tax is $3,404,000.
Compute the net income:
Hence, the net income is $5,106,000.
Table indicating the pro forma income statement:
Pro forma income statement | |
Particulars |
Amounts (in $) |
Sales | 47,225,000 |
Variable costs | 25,015,000 |
Fixed costs | 9,400,000 |
Depreciation | 4,300,000 |
Earnings before interest and taxes | 8,510,000 |
Taxes | 3,404,000 |
Net income | 5,106,000 |
Hence, the net income as per the pro forma income statement is $5,106,000.
Note: After preparing the pro forma income statement, determine the operating cash flow (OCF) and NPV to find out the sensitivity of the NPV to changes in the price of the new club.
The formula to calculate OCF:
Compute the operating cash flow (OCF):
Hence, the OCF is $9,406,000.
Now, determine the total investment
The formula to calculate the total investment:
Compute the total investment:
Hence, the total investment is $31,500,000.
Now, determine the accumulated net cash inflows for 7 years.
Years |
Net Cash Outflows | Net Cash Inflows | |
Amount invested | Annual |
Accumulated | |
0 | $31,500,000 | ||
1 | $9,406,000 | $9,406,000 | |
2 | $9,406,000 | $18,812,000 | |
3 | $9,406,000 | $28,218,000 | |
4 | $9,406,000 | $37,624,000 | |
5 | $9,406,000 | $47,030,000 | |
6 | $9,406,000 | $56,436,000 | |
7 | $9,406,000 | $65,842,000 |
Note: By the end of the year 3, the recovery amount is shorter than the total initial investment. In the year 4, the recovery amount is higher than total initial investment. It means that the payback period will be in between the years 3 and 4. As a result, estimate the amount needed to complete recovery in Year 4 by deducting accumulated net cash inflows at the end of Year 3 from the total investment amount.
The formula to calculate the amount needed to complete recovery in Year 4:
The formula to calculate the payback period:
Compute the amount needed to complete recovery in Year 4:
Hence, the amount needed to complete recovery in Year 4 is $3,282,000.
Compute the payback period:
Hence, the payback period is 3.35 years.
To determine: The net present value (NPV)
Introduction:
Net present value (NPV) refers to the current discounted value of the future cash flows. The company should accept the project, if the net present value is positive or greater than zero and vice-versa. If there are two mutually exclusive projects, then the company has to select the project that has higher net present value.
Answer to Problem 20QP
The net present value (NPV) is $15,010,782.5.
Explanation of Solution
Given information:
The cost of capital is 10% and the project lifetime is 7 years.
The formula to calculate the present value of OCF:
The formula to calculate the present value of the net working capital:
Where,
t refers to the project lifetime
The formula to calculate the NPV:
Compute the present value of OCF:
Note: To determine the present value of annuity of $1 period for 7 period at a discount rate of 10%, refer the PV of an annuity of $1 table. Then find out 10% discount rate and period of 7 years value from the table. Here, the value for the rate 10% and 7 years period the value is 4.86842.
Hence, the present value of OCF is $45,792,358.52.
Compute the present value of the net working capital:
Hence, the present value of net working capital is $718,423.98.
Compute the net present value:
Hence, the NPV is $15,010,782.5.
To determine: The Internal rate of return (IRR)
Introduction:
Internal rate of return (IRR) is a projected rate of return for a particular project based on the given incremental cash flows of the project. This method considers all the cash flows of the particular project and adjusts for time value of money like net present value.
Answer to Problem 20QP
The IRR is 23.15%.
Explanation of Solution
Given information:
The net working capital is $1,400,000, and fixed costs each year is $9,400,000. The cost of capital is 10% and the number of years is 7 years.
The steps to calculate the IRR using the Excel sheet:
- Firstly, specify the total investment made of the year and show the net annual cash inflows for seven years in a tabular format as given below.
- Then, add net working capital with the initial cash flow in the seventh year.
- Finally, use Excel function “IRR (values, [guess])” to determine the internal rate of return. The values indicate the entire cash flows, and guess indicates the percentage of cost of capital.
Compute the IRR:
Particulars | Amount |
Total investment | ($31,500,000) |
First year cash flow | $9,406,000 |
Second year cash flow | $9,406,000 |
Third year cash flow | $9,406,000 |
Forth year cash flow | $9,406,000 |
Fifth year cash flow | $9,406,000 |
Sixth year cash flow | $9,406,000 |
Seventh year cash flow | 10,806,000.00 |
Internal rate of return (IRR) | 23.15% |
Hence, the IRR is 23.15%.
Want to see more full solutions like this?
Chapter 11 Solutions
FUND.OF CORP.FIN.(LL)-W/ACCESS >CUSTOM<
- Hemmingway, Inc. is considering a $5 million research and development (R&D) project. Profit projections appear promising, but Hemmingway’s president is concerned because the probability that the R&D project will be successful is only 0.50. Furthermore, the president knows that even if the project is successful, it will require that the company build a new production facility at a cost of $20 million in order to manufacture the product. If the facility is built, uncertainty remains about the demand and thus uncertainty about the profit that will be realized. Another option is that if the R&D project is successful, the company could sell the rights to the product for an estimated $25 million. Under this option, the company would not build the $20 million production facility. The decision tree follows. The profit projection for each outcome is shown at the end of the branches. For example, the revenue projection for the high demand outcome is $59 million. However, the cost of the R&D project ($5 million) and the cost of the production facility ($20 million) show the profit of this outcome to be $59 – $5 – $20 = $34 million. Branch probabilities are also shown for the chance events. Analyze the decision tree to determine whether the company should undertake the R&D project. If it does, and if the R&D project is successful, what should the company do? What is the expected value of your strategy? What must the selling price be for the company to consider selling the rights to the product? Develop a risk profile for the optimal strategy.arrow_forwardCH5 #10 A company is considering two alternative marketing strategies for a new product. Introducing the product will require an outlay of $15,000. With a low price, the product will generate cash proceeds of $10,000 per year and will have a life of two years. With a high price, the product will generate cash proceeds of $18,000 but will have a life of only one year. The hurdle rate for this project is 0.05. Which marketing strategy should be accepted?arrow_forwardA3 8avi You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (vi) Average Accounting Return (AAR in %) Hint: Net Income = {[(Price – variable cost)*Quantity Sold] – Fixed Costs – Depreciation} * (1 – Tax rate)arrow_forward
- 4 a. Shimada Products Corporation of Japan is anxious to enter the electronic calculatormarket. Management believes that in order to be competitive in world markets, theprice of the electronic calculator that the company is developing cannot exceed $15.Shimada’s required rate of return is 12% on all investments. An investment of$5,000,000 would be required to purchase the equipment needed to produce the300,000 calculators that management believes can be sold each year at the $15 price.Required:Compute the target cost of one calculatorb. Poskey Corporation uses an activity-based costing system with three activity costpools. The company has provided the following data concerning its costs and itsactivity based costing system:Costs:Wages and salaries ............ $400,000Depreciation ...................... 160,000Utilities .............................. 100,000Total ................................... $660,000Distribution of resource consumption:Activity Cost PoolsAssembly Setting Up…arrow_forward1. A manager has determined that a potential new product can be sold at a price of $25 each. The cost to produce the product is $17.5, but the equipment necessary for production must be leased for $75,000 per year. What is the break-even point? 2. In order to produce a new product, a firm must lease equipment at a cost of $175,000 per year. The managers feel that they can sell 65,000 units per year at a price of $90. What is the highest variable cost that will allow the firm to at least break even on this project? (Round your answer to 2 decimal places.)arrow_forwardProject Evaluation [LO1] Dog Up! Franks is looking at a new sausage systemwith an installed cost of $460,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped for $55,000. The sausage system will save the firm $155,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $29,000. If the tax rate is 21 percent and the discount rate is 10 percent, what is the NPV of this project?arrow_forward
- A company just paid $10 million for a feasibility study. If the company goes ahead with the project, it must immediately spend another $84,052,480 now, and then spend $20 million in one year. In two years it will receive $80 million, and in three years it will receive $90 million. If the cost of capital for the project is 11 percent, what is the project’s NPV 10.6. 1 newarrow_forward[6:46 am, 15/01/2022] Mahmoud: 19. Cost of Capital. Pollution Busters, Inc., is considering a purchase of 10 additional carbon sequesters for $100,000 apiece. The sequesters last for only 1 year until saturated with carbon. Then the carbon is removed and sold. (O LO4) a. Suppose the government guarantees the price of carbon. At this price, the payoff after 1 year is guaranteed to be $115,000. How would you determine the opportunity cost of capital for this investment? b. Suppose instead that the sequestered carbon has to be sold on the London Carbon Exchange. Carbon prices have been extremely volatile, but Pollution Busters' CFO learns that average rates of return from investment on that exchange have been about 20%. She thinks this is a reasonable forecast for the future. What is the opportunity cost of capital in this case? Is the purchase of an additional sequester a worthwhile capital investment if she expects that the price of extracted carbon will $115,000? please show the strpsarrow_forwardA3 8av You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (v) Internal Rate of Return (IRR in %)arrow_forward
- Sons Inc. management is considering purchasing a new machine at a cost of $4,390,000. They expect this equipment to produce cash flows of $845,890, $819,250, $917,830, $1,103,400, $1,093,260, and $1,306,800 over the next six years. If the appropriate discount rate is 15 percent, what is the NPV of this investment? (Enter negative amounts using negative sign e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.) The NPV is $arrow_forward2. A manufacturing firm spends $500,000 annually for a required safety inspection program. A new monitoring technology would eliminate the need for such inspection. If the interest rate is 9.569% per year compounded monthly, how much can the firm afford to spend on this new technology? The firm wants to recover its investment in 10 years. The company also needs to spend $10,000 in year 5 and $15,000 in year 7 for software updates related to the new monitoring technology.arrow_forwardYour firm is contemplating the purchase of a new $500,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life and has no salvage value. You will save $210,000 per year in order processing costs, and you will be able to reduce working capital by $75,000. If the tax rate is 30 percent, what is the IRR for this project? 18.82% 20.94% 28.17% Cannot be calculated from the information provided. None of the above.arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning