1.
Construct a variable-costing income statement for the proposed plant and calculate the ratio if net income to sales. Also state the Person K is right on return on sales being lower than the company average.
1.
Explanation of Solution
Income Statement:
The statement that shows revenue and expenses incurred over a period of time (usually one year) is called an income statement. It is used for external financial reporting as it helps the outsiders and investors in evaluating the firm’s financial health.
The following table represents the income statement of Company SRM:
Company SRM | ||
Income Statement | ||
For the proposed plant | ||
Particulars | Amount ($) | Amount ($) |
Sales revenue1 | 1,575,000 | |
Less: Variable expenses2 | 1,227,800 | |
Contribution margin | 347,600 | |
Less Fixed expenses: | ||
Salaries | 135,000 | |
Insurance | 75,000 | |
Telephone | 5,000 | |
Depreciation | 56,200 | |
Utilities | 25,000 | 296,200 |
Net income | 51,000 |
Table (1)
Therefore, the net income from the proposed project is $51,000.
Use the following formula to calculate ratio of net income to sales:
Substitute $51,000 for net income and $1,575,000 for sales in the above formula.
Therefore, the ratio of net income to sales is 0.0324 or 3.24%.
Person K is correct as the return on sales is relatively lower than the average of the company.
Note: Depreciation excludes the erroneously reported amount of $2,000 for the land.
Working Notes:
1.
Calculation of sales revenue:
2.
Calculation of variable cost:
2.
Find out payback period for the proposed plant. State that the estimation of Person K about payback period being more than 4 years is correct. State that the sale of the plant on its book value will affect the answer or not.
2.
Explanation of Solution
Payback Period:
The time taken by an investment to recover its original value is known as payback period. It is calculated by dividing the original amount of investment by annual cash flow from the investment.
Use the following formula to calculate payback period:
Substitute $352,000 for original investment and $107,2003 for average annual investment in the above formula.
Therefore, the payback period for the proposed project is 3.28 years.
Person K’s estimation about the payback period is incorrect because payback period for the proposed project is less than 4 years.
Person K’s estimation will be correct about the payback if equipment is sold for its book value. If the book value of the investment has a opportunity cost that will be added to the original investment.
Working Note:
3.
Calculation of average annual cash flow:
3.
Find out the
3.
Explanation of Solution
Net Present Value:
The remaining balance of the present value of a project’s inflows and outflows is known as net present value (NPV). It is a discounting model of capital investment decision. A project with a positive NPV increases the wealth of a firm whereas a project with a negative NPV decreases the wealth of a firm.
Internal
An interest rate at which the present value of an investment’s cash inflows is equal to the present value cost of the investment is known as internal rate of return. The value of NPV is 0 in case of an internal rate of return.
Use the following formula to calculate NPV of the investment:
Substitute $658,6984 for P and $352,000 for I in the above formula.
Therefore, net present value of the investment is $306,698.
Use the following formula to calculate discount factor:
Substitute $352,000 for investment and $107,200 for annual cash flow in the above formula.
Therefore, discount factor is 3.28358.
The IRR is in between 25% and 30% for 10 years and discount factor of 3.28358.
Calculate NPV and IRR if furniture and equipment are sold on their book value:
Use the following formula to calculate NPV of the investment:
Substitute $658,6984 for P and $582,000 for I in the above formula.
Therefore, net present value of the investment is $76,698.
Use the following formula to calculate discount factor:
Substitute $582,000 for investment and $107,200 for annual cash flow in the above formula.
Therefore, discount factor is 3.28358.
The IRR is in between 12% and 14% for 10 years and discount factor of 5.42910.
Working Note:
4. Calculation of present value of future cash flow:
4.
Calculate the break-even cubic yards that must be sold. Calculate NPV and IRR with the help of break-even volume. State whether the investment is acceptable or not. Explain the reason of accepting an investment that promises earn only break-even.
4.
Explanation of Solution
Break-Even Point:
The point or situation where the amount of total cost is equivalent to total revenue is known as the break-even point. It is the point where there is no loss or no profit.
Let break even volume be Z.
Use the following formula to calculate break-even volume:
Substitute $45 for price, Z for break-even volume, $35.08 for unit variable cost and $296,200 for total fixed cost in the above formula.
Therefore, the break-even volume is 29,859 cubic yards.
Use the following formula to calculate NPV of the investment:
Substitute $345,3255 for P and $352,000 for I in the above formula.
Therefore, net present value of the investment is $(6,675).
Use the following formula to calculate discount factor:
Substitute $352,000 for investment and $56,200 for annual cash flow in the above formula.
Therefore, discount factor is 6.26335.
The IRR is in between 9% and 10% for 10 years and discount factor of 6.26335.
The investment should be rejected because it is not profitable. Its NPV is negative which will decrease the value of the firm.
Note: Refer to present value annuity table for discount factors which is given at the end of the chapter.
There is possibility to have a positive NPV at the break-even volume. Accounting income is defined on the basis of break-even rather than cash flow. The cash income must be understated by accounting income because noncash expenses are not subtracted from revenues. Zero cash inflows is not an outcome of no income.
Working Note:
5.
Calculation of present value of future cash flow:
5.
Calculate the volume of cement at which IRR equals firm’s cost of capital. Calculate the firm’s expected annual income using the calculated volume. Explain the answer.
5.
Explanation of Solution
Let the volume be Y.
Use the following formula to calculate the volume of cement which earns an IRR equals to the cost of capital:
Substitute $45 for price, Y for volume, $35.08 for unit variable cost, $1,0866 for net income and $296,200 for total fixed cost in the above formula.
Therefore, the volume is 29,968 cubic yards.
The following table represents the income statement of Company SRM:
Company SRM | |
Income Statement | |
Amount ($) | |
Sales revenue7 | 1,348,560 |
Less: Variable expenses8 | 1,051,277 |
Contribution margin | 297,283 |
Less Fixed expenses: | 296,200 |
Net income | 1,083 |
Table (2)
Therefore, the net income from the proposed project is $1,083.
Working Note:
6.
Calculation of net income:
Calculate cash flow:
The discount factor for 10% cost of capital for 10 years is 6.14457 with reference to the present value annuity table given at the end of the chapter.
Calculate net income:
7.
Calculation of sales revenue:
8.
Calculation of variable cost:
Want to see more full solutions like this?
Chapter 12 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- Whitehill Chemicals has two operating divisions. Its Formulation Division in the United States mixes, processes, and tests basic chemicals, and then ships them to Ireland, where the company's Commercial Division uses the chemicals to produce and sell various products. Operating expenses amount to $27.0 million in the U.S. and $79.0 million in Ireland exclusive of the costs of any goods transferred from the U.S. Revenues in Ireland are $205 million. If the chemicals were purchased from one of the company's Irish mixing divisions, the costs would be $40.0 million. However, if it had been purchased from an independent U.S. supplier, the cost would be $53.0 million. The marginal income tax rate is 20 percent in the U.S. and 12 percent in Ireland. Required: What is the company's total tax liability to both jurisdictions for each of the two alternative transfer pricing scenarios ($40.0 million and $53.0 million)? Note: Enter your answers in dollars and not in millions of dollars. Total tax…arrow_forwardWhitehill Chemicals has two operating divisions. Its Formulation Division in the United States mixes, processes, and tests basic chemicals, and then ships them to Ireland, where the company's Commercial Division uses the chemicals to produce and sell various products. Operating expenses amount to $27.2 million in the U.S. and $79.2 million in Ireland exclusive of the costs of any goods transferred from the U.S. Revenues in Ireland are $207 million. If the chemicals were purchased from one of the company's Irish mixing divisions, the costs would be $40.2 million. However, if it had been purchased from an independent U.S. supplier, the cost would be $53.2 million. The marginal income tax rate is 20 percent in the U.S. and 12 percent in Ireland. Required: What is the company's total tax liability to both jurisdictions for each of the two alternative transfer pricing scenarios ($40.2 million and $53.2 million)? Note: Enter your answers in dollars and not in millions of dollars. Total tax…arrow_forwardUniversal Auto is a large multinational corporation headquartered in the United States. For segment reporting purposes, the company is engaged in two businesses: production of motor vehicles and information processing services.The motor vehicle business is by far the larger of Universal’s two segments. It consists mainly of domestic U.S. passenger car production, but it also includes small truck manufacturing operations in the United States and passenger car production in other countries. This segment of Universal has had weak operating results for the past several years, including a large loss in 2017. Although the company does not reveal the operating results of its domestic passenger car segments, that part of Universal’s business is generally believed to be primarily responsible for the weak performance of its motor vehicle segment.Idata, the information processing services segment of Universal, was started by Universal about 15 years ago. This business has shown strong, steady…arrow_forward
- United Recycling Inc. is one of the largest recyclers of glass and paper products in the United States. The company is looking into expanding into the cardboard recycling business. The company's CFO has performed a detailed analysis of the proposed expansion. The company's CFO hired a third-party consulting firm to estimate the cost per ton of processing the cardboard. The consulting firm's cost estimate for processing the cardboard was significantly higher than what the CFO had been using in his financial model. Based on the information given, determine which of the statements is correct. O When the CFO adjusts the cost per ton of processing the cardboard, the project's NPV will decrease. O When the CFO adjusts the cost per ton of processing the cardboard, the project's NPV will increase. Which of the following is measured by its effect on the firm's beta coefficient? O Stand-alone risk Beta, or market, risk Corporate, or within-firm, riskarrow_forwardA manufacturing company, Prince Concrete Manufacturing, Inc situated in General Santos City, has been known for production of quality cement products. In fact, it has the capacity to produce 2,500,000 bags of Type 1 Portland Cement per year considering its large-scale machineries for manufacturing. On its regular operations, the company is able to manufacture and sell only 1,250,000 bags of Type 1 Portland Cement per year at a total income of P 225,000,00.00. Annual fixed costs are estimated by Production Department are P 50,000,000.00 and the variable costs for maintenance and operating expenses per bag are P 110.00. a. Determine the annual profit or loss of the company for this production. b. How many bags of Type 1 Portland Cement should be sold per year to break – even? c. Due to high demand of cement because of massive infrastructure projects implicated by ‘Build!, Build!, Build!’ Program of this administration, the firm’s management decided to increase by 25% of full…arrow_forwardGregg Manufacturing has one plant located in Belgium and another plant located in the United States. The Belgium plant manufactures a component used in a finished product manufactured at the U.S. plant. Currently, the Belgium plant is operating at 70 per cent capacity. In Belgium, the income tax rate is 30 per cent; in the United States, the corporate income tax rate is 35 per cent. The market price of the component is £280 and the Belgium plant's costs to manufacture the component are as follows: Direct materials £30Direct labour 50Variable overhead 12Fixed overhead 56 Refer to Figure 20-10. What is the minimum transfer price that the Belgium division would be willing to accept? Group of answer choices £280 £148 £136 £92arrow_forward
- ZCCM-IH is a major supplier of iron ore to the steel industry and the company is the 4th largest supplier of seabome iron ore in the world. The company exports over 34 million tonnes per year. The company's reserves amount to over a billion tonnes. Konkola Copper Mine (Konkola) represented a major expansion mining project for ZCCM-IH. ZCCM-IH is considering a new project with an expected life of three years and is expected to result in an increase in sales revenue of K20 billion in the first year, K30 bilion in the second year and K10 billion in the third year. Operating costs will amount to 70% of sales revenue and the company is required to make an investment in working capital of K6 billion at the beginning of the project, which is recoverable at the end of the life of the project. The cost of the project is K18 billion and the residual value at the end of three years is K11 billion. The required rate of return is 14%. Assuming no taxation. A. Calculate ZCCM-IH project's NPV? B.…arrow_forwardSembotix Company has several divisions including a Semiconductor Division that sells semiconductors to both internal and external customers. The company’s X-ray Division uses semiconductors as a component in its final product and is evaluating whether to purchase them from the Semiconductor Division or from an external supplier. The market price for semiconductors is $100 per 100 semiconductors. Dave Bryant is the controller of the X-ray Division, and Howard Hillman is the controller of the Semiconductor Division. The following conversation took place between Dave and Howard: Dave: I hear you are having problems selling semiconductors out of your division. Maybe I can help. Howard: You’ve got that right. We’re producing and selling at about 90% of our capacity to outsiders. Last year, we were selling 100% of capacity. Would it be possible for your division to pick up some of our excess capacity? After all, we are part of the same company. Dave: What kind of price could you give…arrow_forwardCompu Limited is a company that manufactures computer monitors, keyboards, computer boxes and modems (both internal and external). These four products are sold all over the country and in a few overseas markets. The head office is situated in Sandton, South Africa, with three plants in other parts of the country. Four years ago, a fourth plant was opened in Zimbabwe to take advantage of the inexpensive labour available. 90% of the items manufactured in Zimbabwe are shipped back to South Africa and the remaining 10% are sold in other African countries. Compu Limited advertises its products in computer magazines, on the internet and over the television. It shares are traded on the Johannesburg Stock Exchange (JSE). Three major organisations account for almost 50% of Compu’s sales and the remaining sales are made to other smaller computer manufacturers. Lately one of these customers is constantly complaining about the lack of new technology in Compu’s products. A total of 900 plant…arrow_forward
- Sembotix Company has several divisions including a Semiconductor Division that sells semiconductors to both internal and external customers. The company's X-ray Division uses semiconductors as a component in its final product and is evaluating whether to purchase them from the Semiconductor Division or from an external supplier. The market price for semiconductors is $100 per 100 semiconductors. Dave Bryant is the controller of the X-ray Division, and Howard Hillman is the controller of the Semiconductor Division. The following conversation took place between Dave and Howard: Dave: I hear you are having problems selling semiconductors out of your division. Maybe I can help. Howard: You've got that right. We're producing and selling at about 90% of our capacity to outsiders. Last year we were selling 100% of capacity. Would it be possible for your division to pick up some of the excess capacity? After all, we are part of the same company. Dave: What kind of price can you give me?…arrow_forwardSoft Cushion Company is highly decentralized. Each division is empowered to make its own sales decisions. The Assembly Division can purchase stuffing, a key component, from the Production Division or from external suppliers. The Production Division has been the major supplier of stuffing in recent years. The Assembly Division has announced that two external suppliers will be used to purchase the stuffing at $26per pound for the next year. The Production Division recently increased its unit price to $54.The manager of the Production Division presented the following information — variable cost $38 and fixed cost $14 — to top management in order to attempt to force the Assembly Division to purchase the stuffing internally. The Assembly Division purchases 21,000 pounds of stuffing per month. What would be the monthly operating advantage (disadvantage) of purchasing the goods internally, assuming the external supplier increased its price to $88 per pound and the Production Division…arrow_forwardCompu Limited is a company that manufactures computer monitors, keyboards, computer boxes and modems (both internal and external). These four products are sold all over the country and in a few overseas markets. The head office is situated in Sandton, South Africa, with three plants in other parts of the country. Four years ago, a fourth plant was opened in Zimbabwe to take advantage of the inexpensive labour available. 90% of the items manufactured in Zimbabwe are shipped back to South Africa and the remaining 10% are sold in other African countries. Compu Limited advertises its products in computer magazines, on the internet and over the television. It shares are traded on the Johannesburg Stock Exchange (JSE). Three major organisations account for almost 50% of Compu’s sales and the remaining sales are made to other smaller computer manufacturers. Lately one of these customers is constantly complaining about the lack of new technology in Compu’s products. A total of 900 plant…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning