| 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 |
||||
|---|---|---|---|---|
|
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 |
||||
|---|---|---|---|---|
|
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) 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
|
|
||||||||
| 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 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 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 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 this article about?
In: Operations Management
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.
In: Computer Science