Related questions with answers

Courtside Concepts Co. began business on January 2, 2011. Salaries were paid to employees on the last day of each month, and social security tax, Medicare tax, and federal income tax were withheld in the required amounts. An employee who is hired in the middle of the month receives half the monthly salary for that month. All required payroll tax reports were filed, and the correct amount of payroll taxes was remitted by the company for the calendar year. Early in 2012, before the Wage and Tax Statements (Form W-2) could be prepared for distribution to employees and for filing with the Social Security Administration, the employees’ earnings records were inadvertently destroyed.

None of the employees resigned or were discharged during the year, and there were no changes in salary rates. The social security tax was withheld at the rate of 6.0% and Medicare tax at the rate of 1.5% on salary. Data on dates of employment, salary rates, and employees’ income taxes withheld, which are summarized as follows, were obtained from personnel records and payroll records:

 Employee  Date First  Employed  Monthly  Salary  Monthly  Income Tax  Withheld  Garnett  Jan. 2$4,400$706 Kidd  Oct. 17,2001,442 J. O’Neal  Apr. 163,600506 Bryant  Nov. 13,000356 S. O’Neal  Jan. 1612,8003,012 Marbury  Dec. 15,000856 Duncan  Feb. 1 11,2002,564\begin{array}{lccc} \text { Employee } & \begin{array}{c} \text { Date First } \\ \text { Employed } \end{array} & \begin{array}{c} \text { Monthly } \\ \text { Salary } \end{array} & \begin{array}{c} \text { Monthly } \\ \text { Income Tax } \\ \text { Withheld } \end{array} \\ \hline \text { Garnett } & \text { Jan. } 2 & \$ 4,400 & \$ 706 \\ \text { Kidd } & \text { Oct. } 1 & 7,200 & 1,442 \\ \text { J. O'Neal } & \text { Apr. } 16 & 3,600 & 506 \\ \text { Bryant } & \text { Nov. } 1 & 3,000 & 356 \\ \text { S. O'Neal } & \text { Jan. } 16 & 12,800 & 3,012 \\ \text { Marbury } & \text { Dec. } 1 & 5,000 & 856 \\ \text { Duncan } & \text { Feb. 1 } & 11,200 & 2,564 \end{array}

Instructions

  1. Calculate the amounts to be reported on each employee’s Wage and Tax Statement (Form W-2) for 2011
  2. Calculate the following employer payroll taxes for the year: (a) social security; (b) Medicare; (c) state unemployment compensation at 4.6% on the first $10,000 of each employee’s earnings; (d) federal unemployment compensation at 0.8% on the first$10,000 of each employee’s earnings; (e) total.

See Table down below showing financial statement data and stock price data for Mydeco Corp.

a. What is Mydeco's market capitalization at the end of each year?

b. What is Mydeco's market-to-book ratio at the end of each year? Windows.

c. What is Mydeco's enterprise value at the end of each year?

2012–2016 Financial Statement Data and Stock Price Data for Mydeco Corp

Mydeco Corp. 2012–2016 \hspace{30mm} (All data as of fiscal year end; in million)million)

Income statement20122013201420152016Revenue401.9361.6429.6513.6602.6Cost of Goods Sold(192.1)(175.4)(207.1)(248.3)(295.8)Gross Profit209.8186.2222.5265.3306.8Sales and Marketing(65.0)(64.4)(84.3)(104.9)(121.1)Administration(61.8)(57.1)(59.0)(66.9)(79.8)Depreciation & Amortization(27.5)(26.3)(32.5)(38.3)(40.1)EBIT55.538.446.755.265.8Interest Income (Expense)(32.4)(31.8)(32.0)(37.0)(40.9)Pretax Income23.16.614.718.224.9Income Tax(8.1)(2.3)(5.1)(6.4)(8.7)Net Income15.04.39.611.816.2Shares outstanding (millions)56.856.856.856.856.8Earnings per share$0.26$0.08$0.17$0.21$0.29Balance Sheet20122013201420152016AssetsCash49.468.091.780.483.6Accounts Receivable87.670.669.377.484.2Inventory33.532.227.330.235.8Total Current Assets170.5170.8188.3188.0203.6Net Property, Plant & Equip.244.3243.3306.1349.6347.9Goodwill & Intangibles365.5365.5365.5365.5365.5Total Assets780.3779.6859.9903.1917.0Liabilities & Stockholders’ EquityAccounts Payable18.818.822.427.130.3Accrued Compensation7.66.37.57.79.4Total Current Liabilities26.425.129.934.839.7Long-term Debt498.9498.9572.2597.5597.5Total Liabilities525.3524602.1632.3637.2Stockholders’ Equity255.0255.6257.8270.8279.8Total Liabilities & Stockholders’ Equity780.3779.6859.9903.1917.0Statement of Cash Flows20122013201420152016Net Income15.04.39.611.816.2Depreciation & Amortization27.526.332.538.340.1Chg. in Accounts Receivable3.917.01.3(8.1)(6.8)Chg. in Inventory(2.9)1.34.9(2.9)(5.6)Chg. in Payables & Accrued Comp.1.7(1.3)4.84.94.9Cash from Operations45.247.653.144.048.8Capital Expenditures(26.6)(23.8)(97.5)(75.4)(40.0)Cash from Investing Activities(26.6)(23.8)(97.5)(75.4)(40.0)Dividends Paid(5.2)(5.2)(5.2)(5.2)(5.6)Sale (or purchase) of stockDebt Issuance (Pay Down)73.325.3Cash from Financing Activities(5.2)(5.2)68.120.1(5.6)Change in Cash13.418.623.7(11.3)3.2Mydeco Stock Price$7.02$3.55$5.86$8.33$11.57\begin{array}{lccccc} \text{Income statement} & 2012 & 2013 & 2014 & 2015 & 2016 \\ \text{Revenue} & 401.9 & 361.6 & 429.6 & 513.6 & 602.6 \\ \underline{\text{Cost of Goods Sold}} & (192.1) & (175.4) & (207.1) & (248.3) & (295.8)\\ \text{Gross Profit} & 209.8 & 186.2 & 222.5 & 265.3 & 306.8\\ \text{Sales and Marketing} & (65.0) & (64.4) & (84.3) & (104.9) & (121.1)\\ \text{Administration} & (61.8) & (57.1) & (59.0) & (66.9) & (79.8)\\ \underline{\text{Depreciation $\And$ Amortization}} & (27.5) & (26.3) & (32.5) & (38.3) & (40.1)\\ \text{EBIT} & 55.5 & 38.4 & 46.7 & 55.2 & 65.8\\ \underline{\text{Interest Income (Expense)}} & (32.4) & (31.8) & (32.0) & (37.0) & (40.9)\\ \text{Pretax Income} & 23.1 & 6.6 & 14.7 & 18.2 & 24.9\\ \underline{\text{Income Tax}} & (8.1) & (2.3) & (5.1) & (6.4) & (8.7)\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Shares outstanding (millions)} & 56.8 & 56.8 & 56.8 & 56.8 & 56.8\\ \text{Earnings per share} & \$0.26 & \$0.08 & \$0.17 & \$0.21 & \$0.29\\ \text{Balance Sheet} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Assets}\\ \text{Cash} & 49.4 & 68.0 & 91.7 & 80.4 & 83.6\\ \text{Accounts Receivable} & 87.6 & 70.6 & 69.3 & 77.4 & 84.2\\ \text{Inventory} & 33.5 & 32.2 & 27.3 & 30.2 & 35.8\\ \text{Total Current Assets} & 170.5 & 170.8 & 188.3 & 188.0 & 203.6\\ \text{Net Property, Plant $\And$ Equip.} & 244.3 & 243.3 & 306.1 & 349.6 & 347.9\\ \text{Goodwill $\And$ Intangibles} & 365.5 & 365.5 & 365.5 & 365.5 & 365.5\\ \text{Total Assets} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Liabilities $\And$ Stockholders’ Equity}\\ \text{Accounts Payable} & 18.8 & 18.8 & 22.4 & 27.1 & 30.3\\ \text{Accrued Compensation} & 7.6 & 6.3 & 7.5 & 7.7 & 9.4\\ \text{Total Current Liabilities} & 26.4 & 25.1 & 29.9 & 34.8 & 39.7\\ \text{Long-term Debt} & 498.9 & 498.9 & 572.2 & 597.5 & 597.5\\ \text{Total Liabilities} & 525.3 & 524 & 602.1 & 632.3 & 637.2\\ \text{Stockholders’ Equity} & 255.0 & 255.6 & 257.8 & 270.8 & 279.8\\ \text{Total Liabilities $\And$ Stockholders’ Equity} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Statement of Cash Flows} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Depreciation $\And$ Amortization} & 27.5 & 26.3 & 32.5 & 38.3 & 40.1\\ \text{Chg. in Accounts Receivable} & 3.9 & 17.0 & 1.3 & (8.1) & (6.8)\\ \text{Chg. in Inventory} & (2.9) & 1.3 & 4.9 & (2.9) & (5.6)\\ \underline{\text{Chg. in Payables $\And$ Accrued Comp.}} & 1.7 & (1.3) & 4.8 & 4.9 & 4.9\\ \text{Cash from Operations} & 45.2 & 47.6 & 53.1 & 44.0 & 48.8\\ \underline{\text{Capital Expenditures}} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Cash from Investing Activities} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Dividends Paid} & (5.2) & (5.2) & (5.2) & (5.2) & (5.6)\\ \text{Sale (or purchase) of stock} & — & — & — & — & —\\ \underline{\text{Debt Issuance (Pay Down)}} & — & — & 73.3 & 25.3 & —\\ \text{Cash from Financing Activities} & (5.2) & (5.2) & 68.1 & 20.1 & (5.6)\\ \text{Change in Cash} & 13.4 & 18.6 & 23.7 & (11.3) & 3.2\\ \text{Mydeco Stock Price} & \$7.02 & \$3.55 & \$5.86 & \$8.33 & \$11.57\\ \end{array}

$

Refer to Exercise 1.301.30 (p. 52) and the data on structurally deficient highway bridges compiled by the Federal Highway Administration (FHWA) into the National Bridge Inventory (NBI). For each state, the NBI lists the number of structurally deficient bridges and the total area (thousands of square feet) of the deficient bridges. The data for the 50 states (plus the District of Columbia and Puerto Rico) are saved in the file. (The first five and last five observations are listed in the table in the next column.) For future planning and budgeting, the FHWA wants to calculate the total area of structurally deficient bridges in a state based on the number of deficient bridges.

State Number Area (thousands of sq. ft.)
Alabama 1,899 432.7432.7
Alaska 155 60.960.9
Arizona 181 110.5110.5
Arkansas 997 347.3347.3
California 3,140 5,177.95,177.9
\quad \vdots \vdots \vdots
Washington 400 502.0502.0
West Virginia 1,058 331.5331.5
Wisconsin 1,302 399.8399.8
Wyoming 389 143.4143.4
Puerto Rico 241 195.4195.4

Minitab printout in tabular form: Regression Analysis: SDArea versus NumberSD Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 1 12710141 12710141 31.50 0.000
Error 50 20173111 403462
Total 51 32003252

Model Summary

s R-sq R-sq(adj)
635.187 38.654 37.434

Coefficients

Term Coef SE Coef F-Value P-Value
Constant 120 123 0.97 0.335
NumberSD 0.3456 0.0616 5.61 0.000

Regression Equation SDArea =120+0.3456=120+0.3456 Number SD

d. Find the estimated standard error of the regression model, ss, on the printout.

Question

Sherene Nili manages a company that makes wedding gowns. She produces both a custom product that is made to order and a standard product that is sold in bridal salons. Her accountant prepared the following forecasted income statement for March, which is a busy month:

Custom Dresses Standard Dresses Total
Number of dresses 10 20 30
Sales revenue $50,000 $30,000 $80,000
Materials $10,000 $8,000 $18,000
Labor 20,000 9,000 29,000
Machine depreciation 600 300 900
Rent 4,200 2,800 7,000
Heat and light 1,000 600 1,600
Other production costs 2,800
Marketing and administration 7,700
Total costs 67,000
Operating profit $13,000

Ms. Nili already has orders for the 10 custom dresses refl ected in the March forecasted income statement. The depreciation charges are for machines used in the respective product lines. Machines depreciate at the rate of$1 per hour based on hours used, so these are variable costs. In March, cutting and sewing machines are expected to operate for 900 hours, of which 600 hours will be used to make custom dresses. The rent is for the building space, which has been leased for several years at $7,000 per month. The rent, heat, and light are allocated to the product lines based on the amount of fl oor space occupied.

A valued customer, who is a wedding consultant, has asked Ms. Nili for a special favor. This customer has a client who wants to get married in early April. Ms. Nili’s company is working at capacity and would have to give up some other business to make this dress. She can’t renege on custom orders already agreed to, but she can reduce the number of standard dresses produced in March to 10. Ms. Nili would lose permanently the opportunity to make up the lost production of standard dresses because she has no unused capacity for the foreseeable future. The customer is willing to pay$24,000 for the special order. Materials and labor for the order will cost $6,000 and$10,000, respectively. The special order would require 140 hours of machine time. Ms. Nili’s company would save 150 hours of machine time from the standard dress business given up. Rent, heat and light, and other production costs would not be affected by the special order.

Required
What are the other factors, if any, besides price that she should consider?

Solution

Verified
Answered 1 year ago
Answered 1 year ago
Step 1
1 of 3

In this exercise, we will determine what other factors might Ms. Nili want to consider in setting a price for the special order.

Create an account to view solutions

Create an account to view solutions

More related questions

1/4