ZuoTi.Pro
Question

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 liabilities 19 Long-term debt 20 Total liabilities 21 Common stock 22 Retained Eamings 23 Total common equity 24 Total liabilities and equity 25 26 Joshua & White Technologies December 31 Income Statements 27 (Thousands of Dollars) 28 29 Sales 30 COGS except excluding depr. and amort.300,000 298,000 31 Depreciation and Amortization 32 Other operating expenses 33 EBIT 34 Interest Expense 35 EBT 36 Taxes (40%) 37 Net Incon 38 39 Common dividends 40 Addition to retained earnings $33,600$32.000 12,000 12,600 $66,129$50.480 6766258320 $133,791 $108,800 183,793 178.440 $245,868 $218,440 $379.659 $327.240 2015 $420,000 $400,000 2016 19,660 27,600 18,000 $72,740 $62.000 5,740 $67,000 $57,540 26,800 23,016 $40 200 $34524 $18,125 $17,262 $22,075 $17.262 42 Other Data 43 Year-end Stock Price 44 # of shares ( 1 housands) 45 Lease payment (Thousands of Dollars) 46 Sinking fund payment (Thousands of Do 2016 $90.00 4,052 2015 $96.00 4,000 0.000 $20,000 $5,000 $%2 $5,000

47 48 Ratio Analysis 49 Liquidity Ratios 50 Current Ratio 51Quick Ratio 52 Asset Management Ratios 53 Inventory Turnover Total COGSInwentories) 54 Days Sales Outstanding 55 Fixed Assets Turnover 56 Total Assets Turnover 57 Debt Management Ratios 58 Debt Ratio (Total debt-to-assets) 59 Liabilities-to-assets ratio 6Times-interest-earned ratio 61 EBITDA coverage ratio 62 Profitability Ratios 63 Profit Margin 64BasSiC Eaming Power 65Return 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 74 75a. Has Joshua & Whites liquidity position improved or worsened? Explain. 76 2016 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% NA 10.65 NA 7.11 NA 1.72 78 79 80 b. Has Joshua & Whites ability to manage its assets improved or worsened? Explain. 82 83 84 85 C. How has Joshua & Whites profitability changed during the last year? 86 87 88 d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009 89 90 2016 91 2015 92 93 94 95 ROE PM X TA Tumover x Equity Multiplier

94 95 96 97 e. Perform a common size analysis. What has happened to the composition 98 (that is, percentage in each category) of assets and liabilites? 100 Common Size Balance Sheets 101 Assets 102 Cash and cash equivalents 103 Short-term investments 104 Accounts Receivable 105 Irwentories 106 Total current assets 107 Net fixed assets 108 Total assets 109 110 Liabilities and equity 111 Accounts payable 1 12 Accruals 113 Notes payable 14 Total current liabilities 115 Long-term debt 16 Total liabilities 117 Common stock 118 Retained Earnings 119 Total common equity 120 Total liabilities and equity 121 122 Common Size Income Statements 123 Sales 124 COGS except excluding depr. and amort. 125 Depreciation and Amortization 126 Other operating expenses 127 EBIT 128 Interest Expense 129 EBT 130 Taxes (40%) 131 Net Income 132 133 134 135 2016 2015 2016 2015 2016 2015

135 136 137f. Perform a percent change analysis. What does this tell you about the change in profitability 138 and asset utilization? 139 10 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 Accruas 154 Notes payable 155 Total current liabilities 156 Long-term debt 157 Total liabilities 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 170 Interest Expense 171 EBT 172 Taxes (40%) 173 Net Income 174 175 176 Base 2015 2016 Base 2015 2016 Base 2015 2016 178 179

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Cheng Excel HILE HOME INSERT PAGE LAYOLUT FORMULAS DATA REVIE EW General Calitri E Copy E Calculation Check Cell Insert Delete hormat tomat Painter B SortHind & Filtrr〒 Select Fommatti ing Tahle Edrrg f The ability to manage assets is moderate as compared to 2015 and industry averape. There is improvement in Inventory turnover and days sales outsatanding but the assets turnover ratio needs improvement. 1Ratio Analysis Currerit Rati Quick Ratio 2016 2015 USD000 Currerit Assets/Current Liabilities 2.44 2.52 tiun has worsened asIi ratios ul 2016 비는 less than 2015 and industry aver The ability to manage assets is moderate as compared to 2015 and industry average. There is improvement in Inventory turnover and days sales outsatandine but the assets turnover ratio needs Cash and Equivalents Marketable Securities Accounts Reccivable)/Current Liabilities Total Cnst at gnods saldInventories 1.17 1.41 .57 5.32 45.63 43.80 1.92 20.00 1.11 1.22 17.82% 17.82% 35.24% 23.25% Times Interest Earried Ratio Earnings belore Interest arid Expenses Interest Cost 12.67 13.90 1.37 1.09 s to Qb improvement Ans to Q-c Yes the profitability ratins are improved from last year 4 Inventory Turnaver Days Sales OutstaiAccount Receivable/Tutal Sales 365 days 6 Fixed Assets Turnover 7 Total Assets Turnover g Dobt Ratio Total Seles/Total Fixed Assets Total Sales/Total Assets Total Debt/Total Assets Iiabilities to asset ratinTotal inbilities Total Assets EBITDA Coverage Ratio (Earnings before Interest, Expenses, depreciation and amortization+Lease paymentsiInterest CostiLease payments Net Income/Net Sales Earnings belore Interest arid Exp Net Income/Total Assets Net Income/Shareholders Equity Not Incomo/No. of Sharc Market Price per share/Fa Cash I lcw earned/Nu. Shar쓴 1 Prnfit Margin 13Dasi Earning Puwer 9.57% 8.63% 19.16% 18.95% 10.59% 10.55% 16.35% 15.80% 9.92 10.05 9.07 .55 eses TotalAsets 1 15 Returm on Equity 1 Earnings Per share 17 Price to Farning 18 Cash Flow per share 19 Price to Cash Flow ratioMarket Price per share/Cash Flow per share 20 Book Value Per share 21 Market to Book Ratio rnings Per sharr Net Assets/No. of Share Market Price per share/Book Value Per sharc 60.68 54.61 1.48 1.76 23 25 26 Sheet1 ! Q21020 Q19| Q18 Q17|Q16 | Q15 0141013 012 | 011 | 010 09 Q8|07|06|0 舟: +100 1:04 AM 1/18/2019

0 0
Add a comment
Know the answer?
Add Answer to:
Need Help filling in all yellow blocks. Thank you in advance! 2 Joshua & White Technologies:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 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...

  • Notes Based on year-end balance sheet figures. Calculation is based on a 365-day year. SPREADSHEET PROBLEM...

    Notes Based on year-end balance sheet figures. Calculation is based on a 365-day year. SPREADSHEET PROBLEM (3-15) Analysis Start with the partial model in the file Ch03 P15 Build a Model.XIS From the textDOORS Web site. Joshua & White (J&W) Technology's financial statements are also shown here. Answer the following questions. (Note: Industry average ratios are provided in Ch03 P15 Build a Model.xlsx.) a. Has J&W's liquidity position improved or worsened? Explain. b. Has J&W's ability to manage its assets...

  • 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...

  • My question is how to solve the answers for the yellow blocks? Is there any possible...

    My question is how to solve the answers for the yellow blocks? Is there any possible way I could get some help with this question. AutoSave OFF Unit 2 Ratio Data Home Insert Draw Page Layout Formulas Data Review View Tell me e Share O Comments X Arial 10 AA General Σν Comments HH 23 Insert Delete y Paste B I AY Y % Ideas Conditional Format Formatting as Table Cell Styles Format Sort & Filter Find & Select v...

  • 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...

  • 15 and 16 PART 2 Understanding Financial Statements and Cash Flow 2016 BETHESDA MINING COMPANY Balance...

    15 and 16 PART 2 Understanding Financial Statements and Cash Flow 2016 BETHESDA MINING COMPANY Balance Sheets as of December 31, 2015 and 2016 2015 2016 2015 Assets Liabilities and Owners' Equity Current assets Cash Current liabilities $ 19,256 $ 21,946 Accounts receivable Accounts payable $171,531 46,396 54,486 Inventory Notes payable 79,218 109,626 129.253 Total $250.749 Total $175,278 $205,685 Long-term debt $255,000 Owners' equity Common stock and paid-in surplus $160,000 Fixed assets Accumulated retained earnings 214,915 Net plant and equipment...

  • JOSHUA COMPANY Comparative Balance Sheets December 31, 2016 and 2017 2017 2016 Current assets: Cash and...

    JOSHUA COMPANY Comparative Balance Sheets December 31, 2016 and 2017 2017 2016 Current assets: Cash and cash equivalents $ 204 $ 133 Accounts receivable 267 157 Inventories 131 264 Prepaid insurance 12 42 Total current assets 614 596 Long term assets: Property, plant, and equipment 245 260 Less accumulated depreciation - 140 - 125 Property, plant, and equipment, net 105 135 Total assets $ 719 $ 731 Current liabilities: Accounts payable $ 97 $ 83 Wages payable 20 17 Current...

  • JOSHUA COMPANY Comparative Balance Sheets December 31, 2016 and 2017 2017 2016 Current assets: Cash and...

    JOSHUA COMPANY Comparative Balance Sheets December 31, 2016 and 2017 2017 2016 Current assets: Cash and cash equivalents $ 204 $ 133 Accounts receivable 267 157 Inventories 131 264 Prepaid insurance 12 42 Total current assets 614 596 Long term assets: Property, plant, and equipment 245 260 Less accumulated depreciation - 140 - 125 Property, plant, and equipment, net 105 135 Total assets $ 719 $ 731 Current liabilities: Accounts payable $ 97 $ 83 Wages payable 20 17 Current...

  • ADDITIONAL FUNDS NEEDED Morrissey Technologies Inc.'s 2016 financial statements are shown here. Morrissey Technologies Inc.: Balance...

    ADDITIONAL FUNDS NEEDED Morrissey Technologies Inc.'s 2016 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2016 Cash $180,000 Accounts payable $360,000 Receivables 360,000 Notes payable 56,000 Inventories 720,000 Accrued liabilities 180,000 Total current assets $1,260,000 Total current liabilities $596,000 Long-term debt 100,000 Fixed assets 1,440,000 Common stock 1,800,000 Retained earnings 204,000 Total assets $2,700,000 Total liabilities and equity $2,700,000 Morrissey Technologies Inc.: Income Statement for December 31, 2016 Sales $3,600,000 Operating costs including depreciation...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT