Homework Answers
| a. Liquidity ratios | 2016 | 2015 | ||
| Current ratio = Current assets / Current liabilities | =161259/66129 | 2.44 | =127240/50480 | 2.52 |
| Quick ratio = (Current assets - Inventories) / Current liabilities | =(161259-84000)/66129 | 1.17 | =(127240-56000)/50480 | 1.41 |
| Liquidity ratio of J&W worsened as both current and quick ratio has decreased from 2015 levels | ||||
| b. Asset turnover ratios | 2016 | 2015 | ||
| Inventory turnover = Sales / inventory | =420000/84000 | 5.00 | =400000/56000 | 7.14 |
| Receivable turnover = Sales / receivable | =420000/52500 | 8.00 | =400000/48000 | 8.33 |
| Inventory and receivable turnover ratios have decreased that means the asset management has worsened in 2016 compared to 2015 | ||||
| c. Profitability ratios | 2016 | 2015 | ||
| Net profit margin= Net income / Sales | =40200/420000 | 9.57% | =34524/400000 | 8.63% |
| Return on assets = Net income / Total assets | =40200/379659 | 10.59% | =34524/327240 | 10.55% |
| Return on equity = Net income / Common equity | =40200/245868 | 16.35% | =34524/218440 | 15.80% |
| Inventory and receivable turnover ratios have increased in 2016 compared to 2015 levels hence profitability of J&W have improved | ||||
| d. DuPont analysis | ||||
| ROE = (Net income / Sales) x (Sales / Assets) (Assets / Equity) | =(40200/420000)*(420000/379659)*(379659/245868) | 16.35% | =(34524/400000)*(400000/327240)*(327240/218440) | 15.80% |
Add Answer to:
Notes Based on year-end balance sheet figures. Calculation is based on a 365-day year. SPREADSHEET PROBLEM...
Need Help filling in all yellow blocks. Thank you in advance! 2 Joshua & White Technologies:...
Need Help filling in all yellow blocks. Thank you in
advance!
2 Joshua & White Technologies: December 31 Balance Sheets 3 Thousands of Dollars) 2016 21,000 3,759 52,500 Assets 6 Cash and cash equivalents Short-term investments 8 Accounts Receivable g Inventories 10 Total current assets 11 Net fixed assets 12 Total assets 2015 20,000 3,240 48,000 84000 56.000 $161,259 $127,240 218400 200,000 $379,659 $327 240 4 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current...
Consider the following scenario: Your boss has come to you for advice on the current finances...
Consider the following scenario: Your boss has come to you for
advice on the current finances of the company and needs you to
create an extended DuPont analysis, common size analysis, and
percentage change analysis. Your boss wants you to fill out the
attached Excel file because he/she has no idea what she is talking
about and is going to use your report as her work. Remember to
answer all the questions in the attached document. Has J&W's
liquidity position...
Consider the following scenario: Your boss has come to you for advice on the current finances...
Consider the following
scenario: Your boss has come to you for advice on the current
finances of the company and needs you to create an extended DuPont
analysis, common size analysis, and percentage change analysis.
Your boss wants you to fill out the attached Excel file because
he/she has no idea what she is talking about and is going to use
your report as her work.
Remember to answer all the questions in the attached
document.
Has J&W's liquidity position...
Finance
Joshua & White Technologies: December 31 Balance Sheets(Thousands of Dollars)Assets 2010 2009Liabilities& Equity 2010 2009Cash and cashequivalents $ 21,000 $ 20,000 Accounts payable $ 33,600 $ 32,000Short-terminvestments 3,759 3,240 Accruals 12,600 12,000Accountsreceivable 52,500 48,000 Notes payable 19,929 6,480Inventories 84,000 56,000Total currentliabilities $ 66,129 $ 50,480Total currentassets $161,259 $127,240Long-termdebt 67,662 58,320Net fixed assets 218,400 200,000 Total liabilities $133,791 $108,800Total assets $379,659 $327,240 Common stock 183,793 178,440Retainedearnings 62,075 40,000Total commonequity $245,868 $218,440Total liabilities& equity $379,659 $327,240Joshua & White Technologies December 31 Income...
Zandi's Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets Cash and cash equivalents Short-term investments...
Zandi's Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets 2018 $21,000 3.759 52 500 84.000 $161,259 218.400 $379,659 2017 $20,000 3,240 48.000 56.000 $127,240 200.000 $327,240 2016 $21,053 $3,411 $50.526 $58,947 $133,937 200.000 $333,937 Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity $33,600 12,600...
Balance sheet. Use the data from the financial statements of a company shown below. Use it...
Balance sheet. Use the data from the financial statements of a company shown below. Use it to answer the 7 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign and place it in front of first digit of your answer when your answer is a negative number. Round to the nearest dollar. Income Statement year...
Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx...
Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx at the textbook's website. Build a Model: Cumberland Industries' most recent balance sheets (in thousands of dollars) are shown Financial Statements, below and in the partial model in the file: EVA, and MVA 2015 2014 Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common steck $...
EXCESS CAPACITY Krogh Lumber's 2016 financial statements are shown here. Krogh Lumber: Balance Sheet as of...
EXCESS CAPACITY Krogh Lumber's 2016 financial statements are shown here. Krogh Lumber: Balance Sheet as of December 31, 2016 (Thousands of Dollars) Cash $1,800 Accounts payable $7,200 Receivables 10,800 Notes payable 3,472 Inventories 12,600 Accrued liabilities 2,520 Total current assets $25,200 Total current liabilities $13,192 Mortgage bonds 5,000 Net fixed assets 21,600 Common stock 2,000 Retained earnings 26,608 Total assets $46,800 Total liabilities and equity $46,800 Krogh Lumber: Income Statement for December 31, 2016 (Thousands of Dollars) Sales $36,000 Operating...
2-19 Begin with the partial model in the file Ch02 Build a Model.xlsx on the textbook's...
2-19 Begin with the partial model in the file Ch02 Build a Model.xlsx on the textbook's website. Build a Model: Free a. Using the financial statements shown below for Lan & Chen Technologies, calculate net Cash Flows, EVA, operating working capital, total net operating capital, net operating profit after taxes, and MVA free cash flow, and return on invested capital for 2016. (Hint: Start with the partial model in the file and report all dollar figures in thousands to reduce...
Problem 23.1A Horizontal and vertical analysis of income statement and balance sheet. LO 23-1, 23...
Problem 23.1A Horizontal and vertical analysis of income
statement and balance sheet. LO 23-1, 23-2
The EastTN Company sells computer parts through a retail store
that it operates. The firm’s comparative income statement and
balance sheet for the years 2016 and 2015 are shown below.
1-a.
Complete both a horizontal and a vertical analysis of
comparative income statement for the years 2016 and 2015.
(Round your percentage answers to 1 decimal place. i.e.,
0.123 should be entered as 12.3.)
1-b....
Need Help filling in all yellow blocks. Thank you in
advance!
2 Joshua & White Technologies: December 31 Balance Sheets 3 Thousands of Dollars) 2016 21,000 3,759 52,500 Assets 6 Cash and cash equivalents Short-term investments 8 Accounts Receivable g Inventories 10 Total current assets 11 Net fixed assets 12 Total assets 2015 20,000 3,240 48,000 84000 56.000 $161,259 $127,240 218400 200,000 $379,659 $327 240 4 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current...
Consider the following scenario: Your boss has come to you for
advice on the current finances of the company and needs you to
create an extended DuPont analysis, common size analysis, and
percentage change analysis. Your boss wants you to fill out the
attached Excel file because he/she has no idea what she is talking
about and is going to use your report as her work. Remember to
answer all the questions in the attached document. Has J&W's
liquidity position...
Consider the following
scenario: Your boss has come to you for advice on the current
finances of the company and needs you to create an extended DuPont
analysis, common size analysis, and percentage change analysis.
Your boss wants you to fill out the attached Excel file because
he/she has no idea what she is talking about and is going to use
your report as her work.
Remember to answer all the questions in the attached
document.
Has J&W's liquidity position...
Zandi's Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets 2018 $21,000 3.759 52 500 84.000 $161,259 218.400 $379,659 2017 $20,000 3,240 48.000 56.000 $127,240 200.000 $327,240 2016 $21,053 $3,411 $50.526 $58,947 $133,937 200.000 $333,937 Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity $33,600 12,600...
Balance sheet. Use the data from the financial statements of a company shown below. Use it to answer the 7 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign and place it in front of first digit of your answer when your answer is a negative number. Round to the nearest dollar. Income Statement year...
Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx at the textbook's website. Build a Model: Cumberland Industries' most recent balance sheets (in thousands of dollars) are shown Financial Statements, below and in the partial model in the file: EVA, and MVA 2015 2014 Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common steck $...
2-19 Begin with the partial model in the file Ch02 Build a Model.xlsx on the textbook's website. Build a Model: Free a. Using the financial statements shown below for Lan & Chen Technologies, calculate net Cash Flows, EVA, operating working capital, total net operating capital, net operating profit after taxes, and MVA free cash flow, and return on invested capital for 2016. (Hint: Start with the partial model in the file and report all dollar figures in thousands to reduce...
Problem 23.1A Horizontal and vertical analysis of income
statement and balance sheet. LO 23-1, 23-2
The EastTN Company sells computer parts through a retail store
that it operates. The firm’s comparative income statement and
balance sheet for the years 2016 and 2015 are shown below.
1-a.
Complete both a horizontal and a vertical analysis of
comparative income statement for the years 2016 and 2015.
(Round your percentage answers to 1 decimal place. i.e.,
0.123 should be entered as 12.3.)
1-b....
Most questions answered within 3 hours.
-
Industry: Telecommunications in India
Here, you need to discuss the sources of the growth pattern
and...
asked 55 minutes ago -
Hydrobromic acid
dissolves solid iron according to the followiaung reaction:
Fe(s)+2HBr(aq)→
FeBr2(aq)+ H2(g)
Part A. What...
asked 2 hours ago -
Verify the following vector identity in SPHERICAL
COORDINATES.
div(curl(A)) = 0
asked 4 hours ago -
The work function (Φ) for a metal is 7.50×10-19 J.
What is the longest wavelength (nm)...
asked 5 hours ago -
1. Would the following procedural changes cause the
calculated mass percent Ni2+ ion in Ni(NH3)nCl2 to...
asked 6 hours ago -
1. Why does the voltage of the capacitor vary with frequency?
where does this missing voltage...
asked 7 hours ago -
p p please write each step out clearly
3. A manager of a company is considering...
asked 6 hours ago -
On October 1, Ebony Ernst organized Ernst Consulting; on October
3, the owner contributed $83,540 in...
asked 7 hours ago -
A.)As an electron moves through a region of space, its speed
decreases from 9.60 × 106...
asked 8 hours ago -
In java with the netbeans program do:
Through object programming
Create a class "ContadorP", which is...
asked 8 hours ago -
Pattern Corporation acquired all of Science
Company's outstanding stock on January 1, 2016 for $600,000 cash....
asked 8 hours ago -
Here are all accounts Tyler Co. maintains.
Tax expenses $4,750
Common stocks $48,840
SG&A expenses $2,500...
asked 8 hours ago