Your boss has come to you for advice on the current finances of the company and needs
Question:
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.
Questions are in excel (photos attached) but are as follows:
-Has J&W's liquidity position improved or worsened? Explain
-Has J&W's ability to manage its assets improved or worsened? Explain
-How has J&W's profitability changed during the last year?
-Perform an extended DuPont analysis for J7W for 2015 and 2016. What do these results tell you? -Perform a common size analysis. What has happened to the composition (That is, the percentage in each category) of assets and liabilities?
-Perform a percentage change analysis. What does this tell you about the change in profitability and asset utilization?
Fill in all yellow Squares with the appropriate answer.
A D E 2 Joshua & White Technologies: December 31 Balance Sheets 3 (Thousands of Dollars) 4 5 Assets 6 Cash and cash equivalents 7 Short-term investments 8 Accounts Receivable 9 Inventories B 10 Total current assets 11 Net fixed assets 12 Total assets 13 14 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current liabilities 19 Long-term debt 20 Total liabilities 21 Common stock 22 Retained Earnings 23 Total common equity 24 Total liabilities and equity 33 EBIT 34 Interest Expense 35 EBT 36 Taxes (40%) 37 Net Income. 38 39 Common dividends 40 Addition to retained earnings 41 42 Other Data 43 Year-end Stock Price 2016 2015 $21,000 $20,000 3,759 3,240 52,500 48,000 84.000 56.000 $161,259 $127,240 218.400 200.000 $379,659 $327.240 44 # of shares (Thousands) 45 Lease payment (Thousands of Dollars) 46 Sinking fund payment (Thousands of Do $33,600 12,600 19.929 $66,129 67.662 $133,791 183,793 62,075 $245.868 $379,659 25 26 Joshua & White Technologies December 31 Income Statements 27 (Thousands of Dollars) 28 29 Sales 30 COGS except excluding depr. and amort. 31 Depreciation and Amortization 32 Other operating expenses $18,125 $22,075 $32,000 12,000 6.480 $50,480 58.320 $108,800 178,440 40,000 2016 2015 $420,000 $400,000 300,000 298,000 19,660 18,000 27,600 22,000 $72,740 $62,000 5,740 4,460 $67,000 $57,540 26,800 $40,200 2016 $90.00 4,052 $218.440 $327.240 $20,000 $5,000 23,016 $34,524 $17,262 $17,262 2015 $96.00 4,000 $20,000 $5,000 F G 47 48 Ratio Analysis 49 Liquidity Ratios Current Ratio A 50 51 Quick Ratio 52 Asset Management Ratios 53 Inventory Turnover (Total COGS/Inventories) 54 55 59 60 56 Total Assets Turnover 57 Debt Management Ratios 58 Debt Ratio (Total debt-to-assets) B 63 64 65 Days Sales Outstanding Fixed Assets Turnover 61 EBITDA coverage ratio 62 Profitability Ratios Liabilities-to-assets ratio Times-interest-earned ratio Profit Margin Basic Earning Power Return on Assets 66 Return on Equity 67 Market Value Ratios 68 Earnings per share 69 Price-to-earnings ratio 70 Cash flow per share 71 Price-to-cash flow ratio 72 Book Value per share 73 Market-to-book ratio 90 91 92 93 94 95 96 2016 2016 2015 2015 Industry Avg 2.58 1.53 7.69 47.45 2.04 1.23 20.0% 32.1% 15.33 4.18 8.86% 19.48% 10.93% 16.10% ΝΑ 10.65 74 75 a. Has Joshua & White's liquidity position improved or worsened? Explain. 76 77 78 79 80 b. Has Joshua & White's ability to manage its assets improved or worsened? Explain. 81 82 83 ΝΑ 7.11 ΝΑ 1.72 84 85 C. How has Joshua & White's profitability changed during the last year? 86 87 88 d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009. 89 ROE = PM X TA Turnover x Equity Multiplier G 94 95 A 109 110 Liabilities and equity 111 Accounts payable 112 Accruals 113 Notes payable 114 Total current liabilities 115 Long-term debt 116 Total liabilities 117 Common stock B 96 97 e. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? 98 99 100 Common Size Balance Sheets 101 Assets 102 Cash and cash equivalents 103 Short-term investments 104 Accounts Receivable 105 Inventories 106 Total current assets. 107 Net fixed assets 108 Total assets 118 Retained Earnings 119 Total common equity 120 Total liabilities and equity 127 EBIT 128 Interest Expense 129 EBT 121 122 Common Size Income Statements 123 Sales 124 COGS except excluding depr. and amort. 125 Depreciation and Amortization 126 Other operating expenses 130 Taxes (40%) 131 Net Income 132 133 134 135 126 C D 2016 2016 E 2016 2015 2015 F 2015 G A 156 Long-term debt 157 Total liabilities B 138 139 140 Percent Change Balance Sheets 141 Assets 142 Cash and cash equivalents 143 Short-term investments 144 Accounts Receivable 145 Inventories 146 Total current assets 147 Net fixed assets 148 Total assets 149 150 151 Liabilities and equity 152 Accounts payable 153 Accruals 154 Notes payable 155 Total current liabilities C 170 Interest Expense 171 EBT 158 Common stock 159 Retained Earnings 160 Total common equity 161 Total liabilities and equity 162 163 164 Percent Change Income Statements 165 Sales 166 COGS except excluding depr. and amort. 167 Depreciation and Amortization 168 Other operating expenses 169 EBIT 172 Taxes (40%) 173 Net Income 174 175 176 177 178 179 135 136 137 f. Perform a percent change analysis. What does this tell you about the change in profitability and asset utilization? D 2016 2016 E 2016 Base 2015 Base 2015 F Base 2015 G A D E 2 Joshua & White Technologies: December 31 Balance Sheets 3 (Thousands of Dollars) 4 5 Assets 6 Cash and cash equivalents 7 Short-term investments 8 Accounts Receivable 9 Inventories B 10 Total current assets 11 Net fixed assets 12 Total assets 13 14 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current liabilities 19 Long-term debt 20 Total liabilities 21 Common stock 22 Retained Earnings 23 Total common equity 24 Total liabilities and equity 33 EBIT 34 Interest Expense 35 EBT 36 Taxes (40%) 37 Net Income. 38 39 Common dividends 40 Addition to retained earnings 41 42 Other Data 43 Year-end Stock Price 2016 2015 $21,000 $20,000 3,759 3,240 52,500 48,000 84.000 56.000 $161,259 $127,240 218.400 200.000 $379,659 $327.240 44 # of shares (Thousands) 45 Lease payment (Thousands of Dollars) 46 Sinking fund payment (Thousands of Do $33,600 12,600 19.929 $66,129 67.662 $133,791 183,793 62,075 $245.868 $379,659 25 26 Joshua & White Technologies December 31 Income Statements 27 (Thousands of Dollars) 28 29 Sales 30 COGS except excluding depr. and amort. 31 Depreciation and Amortization 32 Other operating expenses $18,125 $22,075 $32,000 12,000 6.480 $50,480 58.320 $108,800 178,440 40,000 2016 2015 $420,000 $400,000 300,000 298,000 19,660 18,000 27,600 22,000 $72,740 $62,000 5,740 4,460 $67,000 $57,540 26,800 $40,200 2016 $90.00 4,052 $218.440 $327.240 $20,000 $5,000 23,016 $34,524 $17,262 $17,262 2015 $96.00 4,000 $20,000 $5,000 F G 47 48 Ratio Analysis 49 Liquidity Ratios Current Ratio A 50 51 Quick Ratio 52 Asset Management Ratios 53 Inventory Turnover (Total COGS/Inventories) 54 55 59 60 56 Total Assets Turnover 57 Debt Management Ratios 58 Debt Ratio (Total debt-to-assets) B 63 64 65 Days Sales Outstanding Fixed Assets Turnover 61 EBITDA coverage ratio 62 Profitability Ratios Liabilities-to-assets ratio Times-interest-earned ratio Profit Margin Basic Earning Power Return on Assets 66 Return on Equity 67 Market Value Ratios 68 Earnings per share 69 Price-to-earnings ratio 70 Cash flow per share 71 Price-to-cash flow ratio 72 Book Value per share 73 Market-to-book ratio 90 91 92 93 94 95 96 2016 2016 2015 2015 Industry Avg 2.58 1.53 7.69 47.45 2.04 1.23 20.0% 32.1% 15.33 4.18 8.86% 19.48% 10.93% 16.10% ΝΑ 10.65 74 75 a. Has Joshua & White's liquidity position improved or worsened? Explain. 76 77 78 79 80 b. Has Joshua & White's ability to manage its assets improved or worsened? Explain. 81 82 83 ΝΑ 7.11 ΝΑ 1.72 84 85 C. How has Joshua & White's profitability changed during the last year? 86 87 88 d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009. 89 ROE = PM X TA Turnover x Equity Multiplier G 94 95 A 109 110 Liabilities and equity 111 Accounts payable 112 Accruals 113 Notes payable 114 Total current liabilities 115 Long-term debt 116 Total liabilities 117 Common stock B 96 97 e. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? 98 99 100 Common Size Balance Sheets 101 Assets 102 Cash and cash equivalents 103 Short-term investments 104 Accounts Receivable 105 Inventories 106 Total current assets. 107 Net fixed assets 108 Total assets 118 Retained Earnings 119 Total common equity 120 Total liabilities and equity 127 EBIT 128 Interest Expense 129 EBT 121 122 Common Size Income Statements 123 Sales 124 COGS except excluding depr. and amort. 125 Depreciation and Amortization 126 Other operating expenses 130 Taxes (40%) 131 Net Income 132 133 134 135 126 C D 2016 2016 E 2016 2015 2015 F 2015 G A 156 Long-term debt 157 Total liabilities B 138 139 140 Percent Change Balance Sheets 141 Assets 142 Cash and cash equivalents 143 Short-term investments 144 Accounts Receivable 145 Inventories 146 Total current assets 147 Net fixed assets 148 Total assets 149 150 151 Liabilities and equity 152 Accounts payable 153 Accruals 154 Notes payable 155 Total current liabilities C 170 Interest Expense 171 EBT 158 Common stock 159 Retained Earnings 160 Total common equity 161 Total liabilities and equity 162 163 164 Percent Change Income Statements 165 Sales 166 COGS except excluding depr. and amort. 167 Depreciation and Amortization 168 Other operating expenses 169 EBIT 172 Taxes (40%) 173 Net Income 174 175 176 177 178 179 135 136 137 f. Perform a percent change analysis. What does this tell you about the change in profitability and asset utilization? D 2016 2016 E 2016 Base 2015 Base 2015 F Base 2015 G
Expert Answer:
Question 1 Liquidity Position We evaluate based on the current ratio of the business The current rat... View the full answer
South Western Federal Taxation 2016 Corporations Partnerships Estates and Trusts
ISBN: 9781305399884
39th edition
Authors: James Boyd, William Hoffman, Raabe, David Maloney, Young
Students also viewed these accounting questions
-
Your client, Rich N. Ready, has come to you for advice. Rich is interested in many social welfare issues (e.g., access to higher education, welfare reform, and abortion rights). He wishes to use his...
-
Your friend Bryan McNair has come to you for advice. He has a very successful antiques store that had sales of more than $800,000 in the year just ended. He would like to expand and will need to...
-
The owner of Dynamo Stores has come to you for assistance because his bookkeeper has just moved to another city. The following is the only information his bookkeeper left him. 1. Balance sheets as of...
-
A solid of constant density is bounded below by the plane z = 0, on the sides by the elliptical cylinder x 2 + 4y 2 = 4, and above by the plane z = 2 - x. a. Find x and y. b. Evaluate the integral...
-
In her bag, a photographer is carrying three exchangeable camera lenses with focal lengths of 400.0 mm, 50.0 mm, and 28.0 mm. Which lens should she use for? (a) Wide angle shots (a cathedral, taken...
-
The observed baseline vector components in meters between two control stations are (3814.244, 470.348, 1593.650). The geocentric coordinates of the control stations are (1,162,247.650, 4,655,656.054,...
-
A sail plane with a lift-to-drag ratio of 25 flies with a speed of \(50 \mathrm{mph}\). It maintains or increases its altitude by flying in thermals, columns of vertically rising air produced by...
-
Suppose that a product must go through an assembly line that consists of five sequential operations. The time it takes to complete each operation is normally distributed with a mean of 180 seconds...
-
General Electric PLC is manufacturer of aviation electrical systems which are used in manufacturing Aero planes. It has a forecast of demand for eighteen months to supply Boeing one of the largest...
-
Indicate whether the statement is true or false, and justify your answer. Unlike with most types of goods, deriving a demand curve for health care is quite simple because people rarely skimp on...
-
A new business will generate a one-time cash flow of? $22,000 after one year. The business will be financed with? 60% equity and? 40% debt. If the? firm's unlevered equity cost of capital is? 11%,...
-
Find the monthly payment for the loans in Problems 33-44. A \(\$ 512,000\) home bought with a \(20 \%\) down payment and the balance financed for 30 years at \(5.1 \%\)
-
A car dealer carries out the following calculations: What is the annual percentage rate? List price Options Destination charges Subtotal Tax Less trade-in Amount to be financed 5% interest for 48...
-
In Problems 23-34, find the value of each annuity at the end of the indicated number of years. Assume that the interest is compounded with the same frequency as the deposits. Amount of Deposit m 25....
-
Evaluate the expressions in Problems 11-18. \(\sum_{k=1}^{4} k^{2}\)
-
Convert each credit card rate in Problems 25-30 to the APR. Oregon, \(1 \frac{1}{4} \%\) per month
-
Allocate overhead using a single plantwide rate, multiple department rates, and activity-based costing Downhill Sports Inc. manufactures two products: snowboards and skis. The factory overhead...
-
A 20-cm-square vertical plate is heated to a temperature of 30oC and submerged in glycerin at 10oC. Calculate the heat lost from both sides of the plate.
-
(a) Write the pseudocode for a Divide-and-Conquer algorithm that finds the index of the minimum element of an array. Hints: Emulate the pseudocode examples in our text, e.g. the first lines could be...
-
For 2015, Apple Corporation (a calendar year integrated oil company) had the following transactions: Taxable income $3,600,000 Regular tax depreciation on realty in excess of ADS (placed in service...
-
Several years ago, Lowell, who is single, acquired 1244 stock in Blue Corporation at a cost of $60,000. He sells the Blue stock for $5,000 in the current year. Determine the amount and nature of...
-
Use a timeline to diagram the gain/loss recognition by this affiliated group. Year 1: SubCo purchases an asset for $400. Year 3: SubCo sells the asset to Parent for $300. Year 4: Parent sells the...
-
Mulberry Ltd has been using the FIFO costing method to account for inventories for several years. The company also has a policy of paying out all of its profits in cash dividends. What are the likely...
-
Burkinshaw Ltd was established on 1 April 2025 and began by issuing 250000 ordinary shares and 1200008% cumulative preference shares. The preference shares were issued privately at a value of \($4\)...
-
The directors of Outback Ltd decided to issue 200 000 ordinary shares. Required (a) Prepare journal entries (in general journal form) to record the issue of shares as a private placement to Rural Ltd...
Study smarter with the SolutionInn App