Questions
Cuneo Company’s income statements for the last 3 years are as follows: Cuneo Company Income Statements...

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’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...

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...

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...

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...

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...

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...

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

May 15

Accounts Receivable

7,900

    Service Revenue

7,900

May 15

Accounts Receivable - J. Simmons

2,500

Accounts Receivable - A. Jones

4,100

Accounts Receivable - J. Williams

1,300

     Service Revenue

7,900

May 15

Service Revenue

7,900

    Accounts Receivable

7,900

May 15

Accounts Receivable Control

7,900

    Sales Revenue

7,900

May 15

Accounts Receivable - J. Simmons

2,500

Accounts Receivable - A. Jones

4,100

Accounts Receivable - J. Williams

1,300

     Accounts Receivable - Control

7,900

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...

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.

  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