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
Fundamentals of Corporate Finance
- Grove Audio is considering the introduction of a new model of wireless speakers with the following price and cost characteristics. Sales price $ 570.00 per unit Variable costs 330.00 per unit Fixed costs 960,000 per year Required: What number must Grove Audio sell annually to break even? What number must Grove Audio sell to make an operating profit of $180,000 for the year?arrow_forwardSeattle Radiology Group plans to invest in a new CT scanner. The group estimates $1,500 net revenue per scan. Preliminary market assessments indicate that demand will be less than 5,000 scans per year. The group is considering a scanner (Scanner B) that would result in total fixed costs of $800,000 and would yield a profit of $450,000 per year at a volume of 5,000 scans. What is the estimated breakeven volume (in number of scans) for Scanner B?arrow_forwardNetwork Systems is introducing a new network card. Suppose Network Systems knows its fixed costs are $600,000, its variable costs are $500 per card, and it must sell 15,000 cards to break even the first year. What is the minimum price per unit it should chargearrow_forward
- A1 fx Chapter 5: Applying Excel A В 1 Chapter 5: Applying Excel 2 3 Data 20,000 units $60 per unit $45 per unit $270,000 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 8 9 Enter a formula into each of the cells marked with a ? below 10 Review Problem: CVP Relationships 11 12 Compute the CM ratio and variable expense ratio 13 Selling price per unit 14 Variable expenses per unit 15 Contribution margin per unit $60 per unit 45 per unit $15 per unit 16 17 CM ratio 25% 18 Variable expense ratio 75% 19 20 Compute the break-even 18,000 units $1,080,000 21 Break-even in unit sales 22 Break-even in dollar sales 23 24 Compute the margin of safety 25 Margin of safety in dollars 26 Margin of safety percentage 120,000 10% 27 28 Compute the degree of operating leverage $ 1,200,000 900,000 300,000 $270,000 $ 29 Sales 30 Variable expenses 31 Contribution margin 32 Fixed expenses 33 Net operating income 30,000 34 35 Degree of operating leverage 10.00 36 %24arrow_forwardHemmingway, 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_forwardFlanders Manufacturing is considering purchasing a new machine that will reduce variable costs per part produced by $0.15. The machine will increase fixed costs by $18,250 per year. The information they will use to consider these changes is shown here.arrow_forward
- Talbot Industries is considering launching a new product. The new manufacturing equipment will cost 17 million, and production and sales will require an initial 5 million investment in net operating working capital. The companys tax rate is 40%. a. What is the initial investment outlay? b. The company spent and expensed 150,000 on research related to the new product last year. Would this change your answer? Explain. c. Rather than build a new manufacturing facility, the company plans to install the equipment in a building it owns but is not now using. The building could be sold for 1.5 million after taxes and real estate commissions. How would this affect your answer?arrow_forwardeEgg is considering the purchase of a new distributed network computer system to help handle its warehouse inventories. The system costs $50,000 to purchase and install and $32,000 to operate each year. The system is estimated to be useful for 4 years. Management expects the new system to reduce the cost of managing inventories by $58,000 per year. The firm’s cost of capital (discount rate) is 11%. a.The firm is not yet profitable and therefore pays no income taxes. b.The firm is in the 26% income tax bracket and uses straight-line (SLN) depreciation with no salvage value. Assume MACRS rules do not apply. c. The firm is in the 26% income tax bracket and uses double-declining-balance (DDB) depreciation with no salvage value. Given a four-year life, the DDB depreciation rate is 50% (i.e., 2 × 25%). In year four, record depreciation expense as the net book value (NBV) of the asset at the start of the year. 1. What is the internal rate of return (IRR) of the proposed investment for…arrow_forwardA chain of take-away pizza stores is considering introducing a new line of gluten-free pizzas. Net revenue from the new line of pizzas is expected to total $500,000 per year, but 15% of this net revenue is forecast to consist of people switching from the regular pizzas to the gluten-free pizzas. How would you describe this situation in terms of the NPV analysis upon which the situation will be based. Question 1Answer a. There is a negative externality equal to $425,000 which should be included in the NPV analysis for the gluten-free pizza project. b. There is a positive externality equal to $425,000 which should be included in the NPV analysis for the gluten-free pizza project. c. There is a positive externality equal to $75,000 which should be included in the NPV analysis for the gluten-free pizza project. d. There is a negative externality equal to $75,000 which should be included in the NPV analysis for the gluten-free pizza project.arrow_forward
- Mikes Bike Co. currently sells 11 million bike tires each year at a price of $17 per tire. It is about to introduce a new tire, and it forecasts annual sales of 17 million of these improved tires at a price of $23 each. However, demand for the old tire will decrease, and sales of the old tire are expected to fall to 4 million per year (note, this says "fall TO 4 million per year," not "fall BY."). The old tire costs $6 each to manufacture, and the new ones will cost $9 each. What is the proper cash flow to use to evaluate the present value of the introduction of the new tire? (Hint: Realized cash inflows from new tire sales minus unrealized cash inflows from old tire sales.)arrow_forward[EXCEL] EBIT: The Generic Publications Textbook Company sells all of its books for $100 per book, and it currently costs $50 in variable costs to produce each text. The fixed costs, which include depreciation and amortization for the firm, are currently $2 million per year. Management is considering changing the firm's production technology, which will increase the fixed costs for the firm by 50 percent but decrease the variable costs per unit by 50 percent. If management expects to sell 45,000 books next year, should they switch technologies? Please use excelarrow_forwardAmazon is considering using high capacity drones that would make its product deliveries more efficient. For this project, $116,000 would need to be spent right away to buy the required fleet of drones. The drones will be losing their economic value in equal amount each year, fully over their 6-year economic lives. Once the drones economic life is over, they would all be sold for $8,700 selling price to a new owner, and Amazon would then immediately purchase the same but brand-new drones for the same price as what it paid for the initial fleet of drones. When those drones' life is over, they would again be sold and, again, brand-new ones would be purchased - all for the same prices as for the initial drones, and so on, over and over. Additional information: . .. Amazon expects $9,300 in annual operating costs. All future cash flows are year-end cash flows. Amazon pays 21 percent tax rate on all taxable income. Amazon requires an annual discount rate of 10 percent, and the rate is not…arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College