Questions
Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2016 2015 Cash and...

Joshua & White Technologies: December 31 Balance Sheets
(Thousands of Dollars)
Assets 2016 2015
Cash and cash equivalents $21,000 $20,000
Short-term investments 3,759 3,240
Accounts Receivable 52,500 48,000
Inventories 84,000 56,000
Total current assets $161,259 $127,240
Net fixed assets 218,400 200,000
Total assets $379,659 $327,240
Liabilities and equity
Accounts payable $33,600 $32,000
Accruals 12,600 12,000
Notes payable 19,929 6,480
Total current liabilities $66,129 $50,480
Long-term debt 67,662 58,320
Total liabilities $133,791 $108,800
Common stock 183,793 178,440
Retained Earnings 62,075 40,000
Total common equity $245,868 $218,440
Total liabilities and equity $379,659 $327,240
Joshua & White Technologies December 31 Income Statements
(Thousands of Dollars)
2016 2015
Sales $420,000 $400,000
COGS except excluding depr. and amort. 300,000 298,000
Depreciation and Amortization 19,660 18,000
Other operating expenses 27,600 22,000
EBIT $72,740 $62,000
Interest Expense 5,740 4,460
EBT $67,000 $57,540
Taxes (40%) 26,800 23,016
Net Income $40,200 $34,524
Common dividends $18,125 $17,262
Addition to retained earnings $22,075 $17,262
Other Data 2016 2015
Year-end Stock Price $90.00 $96.00
# of shares (Thousands) 4,052 4,000
Lease payment (Thousands of Dollars) $20,000 $20,000
Sinking fund payment (Thousands of Dollars) $5,000 $5,000
Ratio Analysis 2016 2015 Industry Avg
Liquidity Ratios
   Current Ratio 2.58
   Quick Ratio 1.53
Asset Management Ratios
   Inventory Turnover (Total COGS/Inventories) 7.69
   Days Sales Outstanding 47.45
   Fixed Assets Turnover 2.04
   Total Assets Turnover 1.23
Debt Management Ratios
   Debt Ratio (Total debt-to-assets) 20.0%
   Liabilities-to-assets ratio 32.1%
   Times-interest-earned ratio 15.33
   EBITDA coverage ratio 4.18
Profitability Ratios
   Profit Margin 8.86%
   Basic Earning Power 19.48%
   Return on Assets 10.93%
   Return on Equity 16.10%
Market Value Ratios
   Earnings per share NA
   Price-to-earnings ratio 10.65
   Cash flow per share NA
   Price-to-cash flow ratio 7.11
   Book Value per share NA
   Market-to-book ratio 1.72
a. Has Joshua & White's liquidity position improved or worsened? Explain.
b. Has Joshua & White's ability to manage its assets improved or worsened? Explain.
c. How has Joshua & White's profitability changed during the last year?
d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009.
ROE =           PM     x TA Turnover    x    Equity Multiplier
2016
2015
e. Perform a common size analysis. What has happened to the composition
     (that is, percentage in each category) of assets and liabilities?
Common Size Balance Sheets
Assets 2016 2015
Cash and cash equivalents
Short-term investments
Accounts Receivable
Inventories
Total current assets
Net fixed assets
Total assets 100.0%
Liabilities and equity 2016 2015
Accounts payable
Accruals
Notes payable
Total current liabilities
Long-term debt
Total liabilities
Common stock
Retained Earnings
Total common equity
Total liabilities and equity
Common Size Income Statements 2016 2015
Sales
COGS except excluding depr. and amort.
Depreciation and Amortization
Other operating expenses
EBIT
Interest Expense
EBT
Taxes (40%)
Net Income
pg 120
f. Perform a percent change analysis. What does this tell you about the change in profitability
     and asset utilization?
Percent Change Balance Sheets Base
Assets 2016 2015
Cash and cash equivalents
Short-term investments
Accounts Receivable
Inventories
Total current assets
Net fixed assets
Total assets
Base
Liabilities and equity 2016 2015
Accounts payable
Accruals
Notes payable
Total current liabilities
Long-term debt
Total liabilities
Common stock
Retained Earnings
Total common equity
Total liabilities and equity
Base
Percent Change Income Statements 2016 2015
Sales
COGS except excluding depr. and amort.
Depreciation and Amortization
Other operating expenses
EBIT
Interest Expense
EBT
Taxes (40%)
Net Income
pg 121

In: Accounting

The following financial information is for Wildhorse Company. WILDHORSE COMPANY Balance Sheets December 31 Assets 2017...

The following financial information is for Wildhorse Company.

WILDHORSE COMPANY
Balance Sheets
December 31

Assets

2017

2016

Cash

$ 70,000

$ 68,000

Debt investments (short-term)

51,000

40,000

Accounts receivable

109,000

91,000

Inventory

231,000

167,000

Prepaid expenses

27,000

26,000

Land

134,000

134,000

Building and equipment (net)

264,000

186,000

Total assets

$886,000

$712,000

Liabilities and Stockholders’ Equity

Notes payable

$171,000

$109,000

Accounts payable

67,000

53,000

Accrued liabilities

41,000

41,000

Bonds payable, due 2017

250,000

170,000

Common stock, $10 par

206,000

206,000

Retained earnings

151,000

133,000

Total liabilities and stockholders’ equity

$886,000

$712,000

WILDHORSE COMPANY
Income Statements
For the Years Ended December 31

2017

2016

Sales revenue

$ 899,000

$ 798,000

Cost of goods sold

650,000

575,000

Gross profit

249,000

223,000

Operating expenses

192,000

168,000

Net income

$  57,000

$  55,000


Additional information:

1. Inventory at the beginning of 2016 was $ 117,000.
2. Accounts receivable (net) at the beginning of 2016 were $ 90,000.
3. Total assets at the beginning of 2016 were $ 634,000.
4. No common stock transactions occurred during 2016 or 2017.
5. All sales were on account.


(a1)

Compute the liquidity and profitability ratios of Wildhorse Company for 2016 and 2017. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%. If % change is a decrease show the numbers as negative, e.g. -1.83% or (1.83%).)

2016

2017

% Change

LIQUIDITY

Current ratio

enter the current ratio

:1

enter the current ratio

:1

enter percentages

%

Accounts receivables turnover

enter accounts receivables turnover in times

times

enter accounts receivables turnover in times

times

enter percentages

%

Inventory turnover

enter inventory turnover in times

times

enter inventory turnover in times

times

enter percentages

%

2016

2017

% Change

PROFITABILITY

Profit margin

enter percentages

%

enter percentages

%

enter percentages

%

Asset turnover

enter asset turnover in times

times

enter asset turnover in times

times

enter percentages

%

Return on assets

enter percentages

%

enter percentages

%

enter percentages

%

Earnings per share

$ enter a dollar amount

$ enter a dollar amount

enter percentages

%


(b)

Given below are three independent situations and a ratio that may be affected. For each situation, compute the affected ratio (1) as of December 31, 2017, and (2) as of December 31, 2018, after giving effect to the situation. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%. If % change is a decrease show the numbers as negative, e.g. -1.83% or (1.83%).)

Situation

Ratio

1.

18,000 shares of common stock were sold at par on July 1, 2018. Net income for 2018 was $ 54,000.

Return on common stockholders’ equity

2.

All of the notes payable were paid in 2018. All other liabilities remained at their December 31, 2017 levels. Total assets on December 31, 2018, were $ 908,000.

Debt to assets ratio

3.

The market price of common stock was $ 9 and $ 12 on December 31, 2017 and 2018, respectively.

Price-earnings ratio

2017

2018

% Change

Return on common stockholders’ equity

enter percentages

%

enter percentages

%

enter percentages

%

Debt to assets ratio

enter percentages

%

enter percentages

%

enter percentages

%

Price earnings ratio

enter a price earnings ratio in times

times

enter a price earnings ratio in times

times

enter percentages

%

In: Accounting

1. Preparation of financial statements Using the Adjusted Trial Balance shown below, prepare the company’s: (a)  ...

1. Preparation of financial statements

Using the Adjusted Trial Balance shown below, prepare the company’s:

(a)   Income Statement

(b)   Statement of Retained Earnings

(c)    Balance Sheet

by completing the tables provided on the following pages.

All Star Repair Shop

Adjusted Trial Balance

Dec. 31, 2016

Debit

Credit

Cash

$ 25,000

Supplies

2,000

Accounts Receivable

70,000

Equipment

30,000

Accumulated Depreciation on Equipment

$ 10,000

Accounts Payable

20,000

Notes Payable

5,000

Income Taxes Payable

20,000

Capital Stock

30,000

Retained Earnings (as of Jan 1, 2016)

5,000

Dividends

15,000

Repair Service Sales Revenue

125,000

Wages Expense

35,000

Rent Expense

10,000

Supplies Expense

4,000

Utilities Expense

3,000

Depreciation Expense

1,000

Income Tax Expense

20,000

______

215,000

215,000

#2   Below is a series of accounts for the Whitman Company, numbered for identification. Following the accounts is a series of transactions. For each transaction, indicate the account(s) that should be debited and credited in the required journal entry(s) by entering the appropriate account number(s) to the right of each transaction.

     

Acct. #

Account Title

1

Accounts receivable

2

Accounts payable

3

Sales Revenue

4

Inventory

5

Cash

6

Cost of Goods Sold

7

Notes Receivable

8

Income taxes payable

9

Interest Revenue

10

Interest Receivable

11

Allowance for Doubtful Accounts

12

Bad Debt Expense

Transactions

Debit

Credit

Example:

    On March 1, 2016, Whitman Co. paid its suppliers $20,000 that it owed for merchandise it bought on credit in the previous month.

2

5

A. On March 30, 2016, Whitman Co. sells $50,000 of merchandise to customers on credit. The merchandise originally cost Whitman $30,000.

B. On March 31, 2016 the appropriate bad debt expense was recorded using 2% of credit sales as an estimate.

C. On April 1, 2016 Whitman determined that $500 of its first quarter credit sales were uncollectible and was written off.

D. On Oct. 1, 2015, Whitman provided one of its customers with a $10,000, 1 year, 12% loan. Interest is paid twice on March 31, 2016 and at maturity on Sept. 30, 2016. What journal entry did Whitman make on Oct. 1, 2015?

E. On Sept. 30, 2016 what journal entries will Whitman make regarding the loan?

Hints:   Transactions B, C, D each have only one debit and one credit.

              Transaction A had 2 debits and 2 credits.

            Transaction E has one debit and three credits.

3  

On Jan 1, Bike Mart had a beginning inventory of 20 bicycles which it purchased for $350 each.

During January, the company purchases four more bicycles for $400 each. None were sold in January.

On February 15, the company purchases five more bicycles for $450 each.

Between February 16 and 28, Bike Mart sells 10 of these bicycles.

a.) Calculate Bike Mart’s Ending Inventory Balance (in dollars) at the end of February and Cost of Goods Sold through February using the FIFO Method. (show all work.)

b.) Calculate Bike Mart’s Ending Inventory Balance (in dollars) at the end of February and Cost of Goods Sold through February using the Weighted Average Method. (show all work.)

c.) At the end of February, will Bike Mart’s Net Income (profits) on its Income Statement be higher if it uses the FIFO or Weighted Average Inventory Method? Why?

In: Accounting

Using the financial statements shown below, calculate net operating working capital(NOWC)

 

               
                 
Chapter Two -- Spreadsheet Assignment    
Using the financial statements shown below, calculate net operating working capital(NOWC), total net operating capital (OC), net operating profit after taxes (NOPAT), operating cash flow (OCF), free cash flow (FCF), and return on invested capital (ROIC).    
   
   
   
   
                 
                 
Charleston Enterprises: Income Statements for Year Ending December 31        
(Thousands of Dollars)     2017 2016      
                 
Sales       $1,458,956 $1,289,560      
Expenses excluding depreciation and amortization $1,094,217 $967,170      
EBITDA       $364,739 $322,390      
Depreciation and amortization   $67,179 $59,708      
EBIT       $297,560 $262,682      
Interest Expense     $32,188 $31,320      
EBT       $265,372 $231,362      
Taxes (35%)     $92,880 $80,977      
Net income     $172,492 $150,385      
                 
Common dividends     $25,874 $22,558      
Addition to retained earnings   $146,618 $127,828      
                 
Charleston Enterprises: December 31 Balance Sheets          
(Thousands of Dollars)              
        2017 2016      
Assets                
Cash and cash equivalents     $112,980 $91,950      
Short-term investments     $179,000 $90,450      
Accounts Receivable     $295,700 $225,785      
Inventories     $561,820 $475,790      
Total current assets     $1,049,500 $803,975      
Net fixed assets     $247,573 $298,540      
Total assets     $1,397,073 $1,182,515      
                 
        2017 2016      
Liabilities and equity              
Accounts payable     $164,890 $145,980      
Accruals       $140,503 $118,136      
Notes payable     $165,500 $115,850      
Total current liabilities     $470,893 $299,966      
Long-term debt     $272,473 $276,670      
Total liabilities     $743,366 $576,636      
Common Stock     $125,000 $125,000      
Retained Earnings     $528,707 $400,879      
Total common equity     $653,707 $525,879      
Total liabilities and equity     $1,397,073 $1,182,515      
                 
Key Input Data:              
Tax rate       35%        
                 
WORKZONE BELOW          
                 
Net operating working capital -- NOWC            
2017 NOWC = Operating current assets - Operating current liabilities        
2017 NOWC = $970,500.00 - $305,393.00        
2017 NOWC = $665,107.00            
                 
2016 NOWC = Operating current assets - Operating current liabilities        
2016 NOWC = $793,525.00 - $264,116.00        
2016 NOWC = $529,409.00            
                 
Total net operating capital -- OC            
2017 OC = NOWC + Net Fixed assets        
2017 OC = $665,107 + $247,573        
2017 OC = $912,680.00            
                 
2016 OC = NOWC + Net Fixed assets        
2016 OC = $529,409.00 + $298,540.00        
2016 OC = $827,949.00            
                 
                 
Net operating profit after taxes            
2017 NOPAT = EBIT x ( 1 - Tax rate ) NOTE: Do NOT type-in the      
2017 NOPAT = $297,560.00 x 0.650000 tax rate -- cell reference!      
2017 NOPAT = $193,414.00            
                 
                 
Operating Cash Flow (OCF)     NOTE:      
2017 OCF= NOPAT + Depreciation The OCF equation is on the      
2017 OCF= $193,414.00 + $67,179.00 BLUE concept sheet.      
2017 OCF= $260,593.00            
                 
Free cash flow              
2017 FCF = NOPAT - Net investment in operating capital      
2017 FCF = $193,414.00 - $84,731.00        
2017 FCF = $108,683.00            
                 
Return on invested capital              
2017 ROIC = NOPAT / Total net operating capital -- 2017 OC      
2017 ROIC = $193,414 / $912,680.00        
2017 ROIC = 21.1919%            
                 
Assume that there were 29 million shares outstanding at the end of the year, the year-end closing stock price was $35.65 per share, and the after-tax cost of capital was 12.5000%. Calculate EVA and MVA for the most recent year.    
   
   
   
Additional Input Data:              
Stock price per share $35.65            
# of shares (in thousands) 29,000            
After-tax cost of capital 12.5000%            
                 
Market Value Added              
MVA = [ Stock Price x # of shares ] - Total common equity      
  $35.65 x 29,000          
    $1,033,850.00   - $653,706.52      
MVA = $380,143.48              
                 
Economic Value Added              
EVA = NOPAT - [ After-tax cost of capital x Operating Capital -- 2017 OC ]      
    - 12.5000% x $912,680.00      
  $193,414 -   $114,085.00        
EVA = $79,329.00              

In: Accounting

4. Describe the changes made by ASU No. 2016-14 5. Describe the Accounting for donated services...

4. Describe the changes made by ASU No. 2016-14 5. Describe the Accounting for donated services    6. Describe the accounting for contributions to collections

In: Accounting

Do an order of magnitude estimate for building a new catalytic cracking plant in the Middle...

Do an order of magnitude estimate for building a new catalytic cracking plant in the Middle East with a capacity of 5000 metric tons/year in 2016.

In: Accounting

What is ASU 2016-01 and what is its impact on the company’s reporting of its AFS...

What is ASU 2016-01 and what is its impact on the company’s reporting of its AFS securities? How might this impact the company’s earnings?

In: Accounting

“Whistle-Blower Suit Accuses Visiting Nurse Service of Fraud” New York Times 23 Sept. 2016 What is...

“Whistle-Blower Suit Accuses Visiting Nurse Service of Fraud” New York Times 23 Sept. 2016

What is this article about?

In: Operations Management

scenario; imagine DHCP has been installed in the window server 2016, Question: how to verify that...

scenario; imagine DHCP has been installed in the window server 2016,

Question: how to verify that the DHCP has been installed correctly?

In: Computer Science

Complete the following assignment in C programming language. Get the user’s first name and store it...

Complete the following assignment in C programming language.

  1. Get the user’s first name and store it to a char array
    • Declare a character array to hold at least 20 characters.
    • Ask for the user’s first name and store the name into your char array.
    • Hint: Use %s for scanf. %s will only scan one word and cannot scan a name with spaces.
  2. Get 3 exam scores from the user:
    • Declare an array of 3 integers
    • Assume the scores are out of 100, and use a for loop to get user’s input
    • Your prompts should print out which exam score you are asking for:
      1. Example: “What is the score of Exam #1?” … “What is the score of Exam #3?”
    • Warning: Be careful of your array indexes!
  3. Find out the average exam score:
    • Use a for loop to calculate the sum of all exams.
    • Divide the sum by 3 to get the average and store the is data in a variable.
  4. Print out the summary for the use similar to:
    • “Hello NAME, based on your exam score of 80, 90, and 100, your average is 90.0 with a letter of an ‘A.’”

In: Computer Science