Cuneo Company’s income statements for the last 3 years are as follows:
|
Cuneo Company |
|
Income Statements |
|
For the Years 1, 2, and 3 |
|
1 |
Year 1 |
Year 2 |
Year 3 |
|
|
2 |
Sales |
$1,000,000.00 |
$1,200,000.00 |
$1,700,000.00 |
|
3 |
Less: Cost of goods sold |
(700,000.00) |
(700,000.00) |
(1,000,000.00) |
|
4 |
Gross margin |
$300,000.00 |
$500,000.00 |
$700,000.00 |
|
5 |
Less operating expenses: |
|||
|
6 |
Selling expenses |
(150,000.00) |
(220,000.00) |
(250,000.00) |
|
7 |
Administrative expenses |
(50,000.00) |
(60,000.00) |
(120,000.00) |
|
8 |
Operating income |
$100,000.00 |
$220,000.00 |
$330,000.00 |
|
9 |
Less: |
|||
|
10 |
Interest expense |
(25,000.00) |
(25,000.00) |
(25,000.00) |
|
11 |
Income before taxes |
$75,000.00 |
$195,000.00 |
$305,000.00 |
| Required: | |
| 1. | Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) |
| 2. | Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) |
| 3. | Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) |
1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 1 |
|
1 |
Year 1 |
Percent of Sales in Year 1 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 2 |
|
1 |
Year 2 |
Percent of Sales in Year 2 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 3 |
|
1 |
Year 3 |
Percent of Sales in Year 3 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
In: Accounting
Taylor’s is a popular restaurant that offers customers a large dining room and comfortable bar area. Taylor Henry, the owner and manager of the restaurant, has seen the number of patrons increase steadily over the last two years and is considering whether and when she will have to expand its available capacity. The restaurant occupies a large home, and all the space in the building is now used for dining, the bar, and kitchen, but space is available on the property to expand the restaurant. The restaurant is open from 6 p.m. to 10 p.m. each night (except Monday) and, on average, has 27 customers enter the bar and 52 enter the dining room during each of those hours. Taylor has noticed the trends over the last 2 years and expects that within about 4 years, the number of bar customers will increase by 50% and the dining customers will increase by 20%. Taylor is worried that the restaurant will be not be able to handle the increase and has asked you to study its capacity. In your study, you consider four areas of capacity: the parking lot (which has 82 spaces), the bar (56 seats), the dining room (102 seats), and the kitchen. The kitchen is well-staffed and can prepare any meal on the menu in an average of 12 minutes per meal. The kitchen, when fully staffed, is able to have up to 20 meals in preparation at a time, or 100 meals per hour (60 min/12 min × 20 meals).
To assess the capacity of the restaurant, you obtain the additional information: Diners typically come to the restaurant by car, with an average of 3 persons per car, while bar patrons arrive with an average of 1.5 persons per car. Diners, on average, occupy a table for an hour, while bar customers usually stay for an average of 2 hours. Due to fire regulations, all bar customers must be seated. The bar customer typically orders one drink per hour at an average of $9 per drink; the dining room customer orders a meal with an average price of $20; the restaurant’s cost per drink is $3, and the direct costs for meal preparation are $3.
Required: 1-a. Given the current number of customers per hour, what is the amount of excess capacity in the bar, dining room, parking lot, and kitchen? 1-b. Calculate the expected total throughput margin for the restaurant per day, and month (assuming a 26-day month). 2-a. Given the expected increase in the number of customers, determine if there is a constraint for any of the four areas of capacity. What is the amount of needed capacity for each constraint? 2-b. If there is a constraint, reduce the demand on the constraint so that the restaurant is at full capacity (assume some customers would have to be turned away). Calculate the expected total throughput margin for the restaurant per day, and month (assuming a 26-day month).
In: Accounting
Raymond Santana created Computer Solutions on October 1, 2019. The company has been successful, and its list of customers has grown.
In response to requests from customers, R. Santana will begin selling computer software. The company will extend credit terms of 1/10, n/30, FOB shipping point, to all customers who purchase this merchandise. However, no cash discount is available on consulting fees. Also, Business Solutions does not use reversing entries and, therefore, all revenue and expense accounts have zero beginning balances as of January 1, 2020. Its transactions for January through March follow:
|
Jan. |
4 |
The company paid cash to Lyn Addie for five days’ work at the rate of $125 per day. Four of the five days relate to wages payable that were accrued in the prior year. |
||
|
5 |
Ray Santana invested an additional $20,000 cash in the company in exchange for more common stock. |
|||
|
7 |
The company purchased $5,800 of merchandise from Kansas Corp. with terms of 1/10, n/30, FOB shipping point, invoice dated January 7. |
|||
|
9 |
The company received $2,750 cash from Gomez Co. as full payment on its account. |
|||
|
11 |
The company completed a five-day project for Alex’s Engineering Co. and billed it $5,500, which is the total price of $7,000 less the advance payment of $1,500. |
|||
|
13 |
The company sold merchandise with a retail value of $5,200 and a cost of $3,560 to Liu Corp., invoice dated January 13. |
|||
|
15 |
The company paid $600 cash for freight charges on the merchandise purchased on January 7. |
|||
|
16 |
The company received $4,000 cash from Delta Co. for computer services provided. |
|||
|
17 |
The company paid Kansas Corp. for the invoice dated January 7, net of the discount. |
|||
|
20 |
Liu Corp. returned $500 of defective merchandise from its invoice dated January 13. The returned merchandise, which had a $320 cost, is discarded. (The policy of Computer Solutions is to leave the cost of defective products in cost of goods sold.) |
|||
|
22 |
The company received the balance due from Liu Corp., net of both the discount and the credit for the returned merchandise. |
|||
|
24 |
The company returned defective merchandise to Kansas Corp. and accepted a credit against future purchases. The defective merchandise invoice cost, net of the discount, was $496. |
|||
|
26 |
The company purchased $8,000 of merchandise from Kansas Corp. with terms of 1/10, n/30, FOB destination, invoice dated January 26. |
|||
|
26 |
The company sold merchandise with a $4,640 cost for $5,800 on credit to KC, Inc., invoice dated January 26. |
|||
|
31 |
The company paid cash to Lyn Addie for 10 days’ work at $125 per day. |
|||
|
Feb. |
1 |
The company paid $2,475 cash to Hillside Mall for another three months’ rent in advance. |
||
|
3 |
The company paid Kansas Corp. for the balance due, net of the cash discount, less the $496 amount in the credit memorandum. |
|||
|
5 |
The company paid $600 cash to the local newspaper for an advertising insert in today’s paper. |
|||
|
11 |
The company received the balance due from Alex’s Engineering Co. for fees billed on January 11. |
|||
|
15 |
The company paid $4,800 cash in dividends. |
|||
|
23 |
The company sold merchandise with a $2,660 cost for $3,220 on credit to Delta Co., invoice dated February 23. |
|||
|
26 |
The company paid cash to Lyn Addie for eight days’ work at $125 per day. |
|||
|
27 |
The company reimbursed Ray Santana for business automobile mileage (600 miles at $0.32 per mile). |
|||
|
Mar. |
8 |
The company purchased $2,730 of computer supplies from Harris Office Products on credit, invoice dated March 8. |
||
|
9 |
The company received the balance due from Delta Co. for merchandise sold on February 23. (Note discount period versus payment) |
|||
|
11 |
The company paid $960 cash for minor repairs to the company’s computer. |
|||
|
16 |
The company received $5,260 cash from Dream, Inc., for computing services provided. |
|||
|
19 |
The company paid the full amount due to Harris Office Products, consisting of amounts created on December 15 (of $1,100) and March 8. |
|||
|
24 |
The company billed West Leasing for $9,045 of computing services provided. |
|||
|
25 |
The company sold merchandise with a $2,002 cost for $2,800 on credit to Wildcat Services, invoice dated March 25. |
|||
|
30 |
The company sold merchandise with a $1,048 cost for $2,220 on credit to IFM Company, invoice dated March 30. |
|||
|
31 |
The company reimbursed R. Santana for business automobile mileage (400 miles at $0.32 per mile). |
I am mainly interested in COGS and inventory transactions (journal entries), and both of the account end balances. Please show the work. Thank you
In: Accounting
A person’s muscle mass is expected to be associated with age. Some people also thought exercise time would be associated with the muscle mass. To explore the potential relationships between muscle mass and age, muscle mass and exercise time, a nutritionist randomly selected 20 women from a population of women with age ranging from 40 to 80 years old, and measured their muscle mass (a score without unit) and exercise time (hours per month)
|
Patient |
Age |
MuscleMass |
ExcerciseTime |
|
1 |
43 |
106 |
23 |
|
2 |
41 |
106 |
24 |
|
3 |
47 |
97 |
26 |
|
4 |
76 |
56 |
21 |
|
5 |
72 |
70 |
23 |
|
6 |
76 |
74 |
19 |
|
7 |
42 |
105 |
22 |
|
8 |
49 |
97 |
17 |
|
9 |
53 |
92 |
14 |
|
10 |
44 |
103 |
21 |
|
11 |
63 |
80 |
25 |
|
12 |
55 |
90 |
16 |
|
13 |
66 |
77 |
25 |
|
14 |
58 |
86 |
19 |
|
15 |
70 |
72 |
18 |
|
16 |
57 |
87 |
22 |
|
17 |
71 |
71 |
21 |
|
18 |
46 |
100 |
18 |
|
19 |
61 |
83 |
27 |
|
20 |
68 |
74 |
20 |
|
21 |
44 |
105 |
21 |
|
22 |
53 |
94 |
19 |
|
23 |
60 |
82 |
23 |
|
24 |
72 |
78 |
21 |
Using the regression equation representing the SIGNIFICANT relationship, make the following predictions: [of note: based on the regression model you chose, information for one of Age and ExcercieTime is not needed for prediction, but you should make your own decision on which variable is not needed!]
The expected Muscle Mass (the mean) for Women at Age= 65 and ExerciseTime = 20; (4 points)
The expected difference in Muscle Mass between women with Age = 55 and ExcerciseTme =23 and women with Age = 58 and ExcerciseTime=25. (4 points)
In: Statistics and Probability
Write a program that checks if all the input numbers cover 1 to 99. Each ticket for the Pick-10 lotto has 10 unique numbers ranging from 1 to 99. Suppose you buy a lot of tickets and like to have them cover all numbers from 1 to 99. Write a program that reads the ticket numbers from a file and checks whether all numbers are covered. Assume the last ending number in the file is 0. Suppose the file contains the numbers
80 3 87 62 30 90 10 21 46 27
12 40 83 9 39 88 95 59 20 37
80 40 87 67 31 90 11 24 56 77
11 48 51 42 8 74 1 41 36 53
52 82 16 72 19 70 44 56 29 33
54 64 99 14 23 22 94 79 55 2
60 86 34 4 31 63 84 89 7 78
43 93 97 45 25 38 28 26 85 49
47 65 57 67 73 69 32 71 24 66
92 98 96 77 6 75 17 61 58 13
35 81 18 15 5 68 91 50 76 0
Your program should display
The tickets cover all numbers
Suppose the file contains the numbers
11 48 51 42 8 74 1 41 36 53
52 82 16 72 19 70 44 56 29 33
0
Your program should display
The tickets don't cover all numbers
In: Computer Science
A person’s muscle mass is expected to be associated with age. Some people also thought exercise time would be associated with the muscle mass. To explore the potential relationships between muscle mass and age, muscle mass and exercise time, a nutritionist randomly selected 20 women from a population of women with age ranging from 40 to 80 years old, and measured their muscle mass (a score without unit) and exercise time (hours per month)
|
Patient |
Age |
MuscleMass |
ExcerciseTime |
|
1 |
43 |
106 |
23 |
|
2 |
41 |
106 |
24 |
|
3 |
47 |
97 |
26 |
|
4 |
76 |
56 |
21 |
|
5 |
72 |
70 |
23 |
|
6 |
76 |
74 |
19 |
|
7 |
42 |
105 |
22 |
|
8 |
49 |
97 |
17 |
|
9 |
53 |
92 |
14 |
|
10 |
44 |
103 |
21 |
|
11 |
63 |
80 |
25 |
|
12 |
55 |
90 |
16 |
|
13 |
66 |
77 |
25 |
|
14 |
58 |
86 |
19 |
|
15 |
70 |
72 |
18 |
|
16 |
57 |
87 |
22 |
|
17 |
71 |
71 |
21 |
|
18 |
46 |
100 |
18 |
|
19 |
61 |
83 |
27 |
|
20 |
68 |
74 |
20 |
|
21 |
44 |
105 |
21 |
|
22 |
53 |
94 |
19 |
|
23 |
60 |
82 |
23 |
|
24 |
72 |
78 |
21 |
Using the regression equation representing the SIGNIFICANT relationship, make the following predictions: [of note: based on the regression model you chose, information for one of Age and ExcercieTime is not needed for prediction, but you should make your own decision on which variable is not needed!] The expected Muscle Mass (the mean) for Women at Age= 65 and ExerciseTime = 20; The expected difference in Muscle Mass between women with Age = 55 and ExcerciseTme =23 and women with Age = 58 and ExcerciseTime=25.
In: Math
RTE Telecom Inc., which is considering the acquisition of Galaxy Sun Corp., estimates that acquiring Galaxy Sun will result in an incremental value for the firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company:
|
Data Collected (in millions of dollars) |
|||
|---|---|---|---|
| Year 1 | Year 2 | Year 3 | |
| EBIT | $16.0 | $19.2 | $24.0 |
| Interest expense | 5.0 | 5.5 | 6.0 |
| Debt | 31.9 | 37.7 | 40.6 |
| Total net operating capital | 121.5 | 123.9 | 126.3 |
Galaxy Sun Corp. is a publicly traded company, and its market-determined pre-merger beta is 1.40. You also have the following information about the company and the projected statements:
| • | Galaxy Sun currently has a $28.00 million market value of equity and $18.20 million in debt. |
| • | The risk-free rate is 3%, there is a 5.10% market risk premium, and the Capital Asset Pricing Model produces a pre-merger required rate of return on equity rsL of 10.14%. |
| • | Galaxy Sun’s cost of debt is 5.00% at a tax rate of 30%. |
| • | The projections assume that the company will have a post-horizon growth rate of 4.00%. |
| • | Current total net operating capital is $118.0, and the sum of existing debt and debt required to maintain a constant capital structure at the time of acquisition is $29 million. |
| • | The firm does not have any nonoperating assets such as marketable securities. |
Given this information, use the adjusted present value (APV) approach to calculate the following values involved in merger analysis. (Note: Only round intermediate calculations when entering them as a final answer.)
|
Value |
|
|---|---|
| Unlevered cost of equity | |
| Horizon value of unlevered cash flows | |
| Horizon value of tax shield | |
| Unlevered value of operations | |
| Value of tax shield | |
| Value of operations |
Thus, the total value of Galaxy Sun’s equity is . Suppose RTE Telecom Inc. plans to use more debt in the first few years of the acquisition of Galaxy Sun Corp. Assuming that using more debt will not lead to an increase in bankruptcy costs for RTE Telecom Inc., the interest tax shields and the value of the tax shield in the analysis, will , leading to a value of operations of the acquired firm. The APV approach is considered useful for valuing acquisition targets, because the method involves finding the values of the unlevered firm and the interest tax shield separately and then summing those values. Why is it difficult to value certain types of acquisitions using the corporate valuation model? The acquiring firm usually assumes the debt of the target firm. Thus, old debt with different coupon rates usually becomes a part of the acquisition deal. The acquiring firm immediately retires the target firm’s old debt. Thus, the acquisition deal consists of only new debt in its capital structure. (LOOKING FOR THE VALUE ANSWERS) |
In: Finance
Customer A. Smith owed Stonebridge Electronics $325. On April 27, 2016, Stonebridge determined this account receivable to be uncollectible and wrote off the account. The company uses the direct write-off method. On July 15, 2016, Stonebridge received a check for $325 from the customer. How should the July 15, 2016 transaction be recorded?
Group of answer choices
|
A business maintains subsidiary accounts for each of its customers. On May 15, the business sells services on account: $2,500 to customer J. Simmons; $4,100 to customer A. Jones; and $1,300 to customer J. Williams. Which journal entry is needed to record this sales transaction? Group of answer choices
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
July 15 |
Accounts Receivable - A. Smith |
325 |
|
|
Bad Debt Revenue |
325 |
||
|
July 15 |
Cash |
325 |
|
|
Bad Debt Expense |
325 |
|
July 15 |
Accounts Receivable - A. Smith |
325 |
|
|
Bad Debt Expense |
325 |
||
|
July 15 |
Cash |
325 |
|
|
Accounts Receivable - A. Smith |
325 |
Flag this Question
Question 152.5 pts
Which of the following is the correct formula to calculate inventory turnover?
Group of answer choices
Inventory turnover = Cost of goods sold / Average merchandise inventory
Inventory turnover = Cost of goods sold × Average merchandise inventory
Inventory turnover = Cost of goods sold + Average merchandise inventory
Inventory turnover = Cost of goods sold - Average merchandise inventory
Flag this Question
Question 162.5 pts
The ending merchandise inventory for the current year is overstated by $25,000. What effect will this error have on the following year's net income?
Group of answer choices
The net income will be overstated by $50,000.
The net income will be overstated by $25,000.
The net income will be understated by $25,000.
The net income will be understated by $50,000.
Flag this Question
Question 172.5 pts
Which of the following is added to operating income to arrive at net income?
Group of answer choices
sales revenue
cost of goods sold
interest revenue
operating expenses
Flag this Question
Question 182.5 pts
The goal of reporting realistic figures and never overstating assets or net income applies to the ________.
Group of answer choices
conservatism principle
materiality concept
disclosure principle
consistency principle
Flag this Question
Question 192.5 pts
In a good internal control system, which of the following sets of documents is required for proper approval of a payment to a supplier?
Group of answer choices
a journal entry, a supplier invoice, and a description of the goods being purchased
a receiving report, an invoice, and a purchase order
a purchase order, a journal entry, and a price catalog
a supplier invoice, a bill of lading, and the supplier's financial statements
In: Accounting
You buy a share of stock, write a one-year call option with strike X, and buy a one-year put option with same strike X. You know that stock shares are currently traded at the same price as the strike price of the options, i.e. options are at the money. Your net outlay to establish the entire portfolio is $50. Risk-free interest rate is 4%
-What must the strike price be? The stock pays no dividends.
- Find the one-year stock futures price.
- Which of the above two same strike options should be more expensive
- Given that one-year put option with same strike X is traded at $3. Find the value of call option with the same strike and maturity.
In: Finance
In a barber, the rate for the number of customers is 3 per hour. On average, the barber can serve customers at a rate of one every 15 minutes.
A) Find an average number of the customers in the barber (system) and queue?
B) Find average waiting time in the barber and queue?
C) What is the probability that the barber be empty?
D) What is the probability that exactly 2 customers present in the system?
C) with which probability that the number of customers in the system can be between 7 and 10?
In: Other