Concept explainers
Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of $320,000 and the 500 units purchased to replace them cost $256,000, so his cash account has increased by $64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her heʼd “make at least $50,000 after taxes. That will give us $25,000 after paying off the investors.”
Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales.
Using a pencil, fill in columns F and G in the Data Section of the worksheet printout at the end of this problem.
Want to see the full answer?
Check out a sample textbook solutionChapter 7 Solutions
Excel Applications for Accounting Principles
- Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Examine your completed worksheet and answer the following questions: a. Which inventory cost flow assumption produces the most net income? b. Which inventory cost flow assumption produces the least net income? c. What caused the difference between your answers to a and b? d. Which inventory cost flow assumption produces the highest ending cash balance? e. Which inventory cost flow assumption produces the lowest ending cash balance? f. Does the assumption that produces the highest net income also produce the highest cash balance? Explain. g. As you recall, Del originally used the specific identification method in his initial calculations when he projected 51,600 net income. According to Dels reckoning, that should have left him cash of 25,800 (50% of 51,600) after paying his investors. Why would he only have 3,800 left? Explain. h. Which inventory cost flow assumption would you suggest Del use? Explain.arrow_forwardDel Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Reset the purchase prices to their original values (cells C11 through C14). Suppose Del had purchased 250 units on November 20 rather than 150. Enter 250 in cell C14 and alter column G in the Data Section. Explain what happens to net income under each inventory cost flow assumption and why. Also, what management implications might this have for Del?arrow_forwardMalone Industries has been in business for five years and has been very successful. In the past year, it expanded operations by buying Hot Metal Manufacturing for a price greater than the value of the net assets purchased. In the past year, the customer base has expanded much more than expected, and the companys owners want to increase the goodwill account. Your CPA firm has been hired to help Malone prepare year-end financial statements, and your boss has asked you to talk to Malones managers about goodwill and whether an adjustment can be made to the goodwill account. How do you respond to the owners and managers?arrow_forward
- Benton is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over six years using the straight- line method. The new cars are expected to generate $195,000 per year in earnings before taxes and depreciation for six years. The company is entirely financed by equity and has a 23 percent tax rate. The required return on the company's unlevered equity is 12 percent and the new fleet will not change the risk of the company. The risk-free rate is 5 percent. a. What is the maximum price that the company should be willing to pay for the new fleet of cars if it remains an all-equity company? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose the company can purchase the fleet of cars for $700,000. Additionally, assume the company can issue $520,000 of six-year debt to finance the project at the risk-free rate of 5 percent. All principal will be repaid in…arrow_forwardGerald is a sales representative for Wirksworth Corp. In the month of August, he closed $1,020,000.00 of sale, what is his gross earning if he is paid 2.50% on the first $250,000.00, 3.50% the next $250,000.00, 5.00% the next $250,000.00, and 7.00% on all remaining sale (round to the nearest cent)? O a. $45,900.00 O b. $35,700.00 O c. $46,400.00 O d. $25,500.00 Previous page Type here to search 23arrow_forwardTom Scott is the owner, president, and primary salesperson for Scott Manufacturing. Because of this, the company's profits are driven by the amount of work Tom does. If he works 40 hours each week, the company's EBIT will be $630,000 per year; if he works a 50-hour week, the company's EBIT will be $785,000 per year. The company is currently worth $4 million. The company needs a cash infusion of $2.1 million and can issue equity or issue debt with an interest rate of 10 percent. Assume there are no corporate taxes. a. What are the cash flows to Tom under each scenario? (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.) b. Under which form of financing is Tom likely to work harder? a. Debt issue and 40-hour week Debt issue and 50-hour week Equity issue and 40-hour week Equity issue and 50-hour week b. Which form of financing is Tom likely to work harder?arrow_forward
- Benton is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over five years using the straight- line method. The new cars are expected to generate $210,000 per year in earnings before taxes and depreciation for five years. The company is entirely financed by equity and has a 22 percent tax rate. The required return on the company's unlevered equity is 11 percent and the new fleet will not change the risk of the company. The risk-free rate is 4 percent. a. What is the maximum price that the company should be willing to pay for the new fleet of cars if it remains an all-equity company? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose the company can purchase the fleet of cars for $665,000. Additionally, assume the company can issue $450,000 of five-year debt to finance the project at the risk-free rate of 4 percent. All principal will be repaid…arrow_forwardVijayarrow_forwardGRB Ltd has several product lines with a manager in charge of each product line. The managers are paid a bonus based on the net income generated by their product line. Rubica (the CEO of GRB Ltd) was going through the financial reports of the 2nd quarter of 2021 to analyse the performance of the product lines. For 'Sweets' one of the largest product lines of GRB Ltd, Rubica noted that while the sales declined from $800,000 in quarter 1 to $600,000 in quarter 2, the product line manager of Sweets received a bonus larger than the 1st quarter. The manager of Sweets division was eligible for a higher bonus due to an operating profit increase from $90,000 in the 1st quarter to $120,000 in the 2nd quarter. Rubica wondered how the product line manager was entitled to a higher bonus with a decline in sales. Rubica also wants to know how net income increased with a decline in sales. Rubica found the following data from the financial reports of 'Sweets': Particulars Quarter 2 Quarter 1 Units…arrow_forward
- Zoso is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over five years using the straight-line method. The new cars are expected to generate $140,000 per year in earnings before taxes and depreciation for five years. The company is entirely financed by equity and has a 40 percent tax rate. The required return on the company's unlevered equity is 12 percent, and the new fleet will not change the risk of the company. a. What is the maximum price that the company should be willing to pay for the new fleet of cars if it remains an all-equity company? (Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) Maximum price b. Suppose the company can purchase the fleet of cars for $360,000. Additionally, assume the company can issue $200,000 of five-year, 8 percent debt to finance the project. All principal will be repaid in one balloon payment at…arrow_forwardSprington makes and sells a single product, black handbags, at a price of $1,600 each. During the three months to December 31,2020, he sold 1,500 handbags and turnover was the same for each month. He expects the volume of sales to remain unchanged for January 2021 but to increase by 5% in February, and by a further 20% in April. The price of the handbags will be increased by 10% in January and by a further 5% in June. The following budgeted information is presented to assist in the preparation. Month Budgeted sales $ Budgeted purchases $ January 880,000 600,000 February 924,000 750,000 March 924,000 820,000 April 1,108,800 820,000 May 1,250,000 968,000 June 1,285,000 1,250,000 Notes: Effective January 1, 2021 Springton’s collection on sales will be as follows: 70% collected in the month of sale The balance will be collected one month following sale Required: Prepare a sales budget for the handbags…arrow_forwardTom Scott is the owner, president, and primary salesperson for Scott Manufacturing. Because of this, the company's profits are driven by the amount of work Tom does. If he works 50 hours each week, the company's EBIT will be $645,000 per year; if he works a 60-hour week, the company's EBIT will be $815,000 per year. The company is currently worth $4.15 million. The company needs a cash infusion of $2.25 million and can issue equity or issue debt with an interest rate of 9 percent. Assume there are no corporate taxes. a. What are the cash flows to Tom under each scenario? (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.) b. Under which form of financing is Tom likely to work harder?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningBusiness Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:Cengage