Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need all of the blank boxes filled in . Please show the excel equations for each one. Build a Model Chapter: Problem: 3 15 Joshua
Need all of the blank boxes filled in Please show the excel equations for each one.
Build a Model Chapter: Problem: 3 15 Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars Assets Cash and cash equivalents Short-term investments Accounts Receivable 11 Inventories 12 Total current assets 13 Net fixed assets 14 Total assets 15 16 Liabilities and equi 17 Accounts payable 18 Accruals 19 Notes payable Total current liabilities 21 Long-term debt 22 Total liabilities 23 Common stock 24 Retained Earnings 25 Total common equity 26 Total liabilities and equ' 27 28 29 31 32 33 36 37 38 39 41 42 43 46 47 48 49 50 2019 $21,000 3,759 52,500 84 ooo $161 ,259 223 097 $33,600 12,600 19 929 $66,129 67 662 $133,791 178,440 72 125 $250.565 2018 $20,000 3,240 48,000 56 ooo $127 ,240 200 ooo $32,000 12,000 6480 $50,480 58 320 $108,800 178,440 40 ooo $218.440 2018 $400,000 298,000 18,000 22 ooo $62,000 4 460 $57,540 14 385 $17,262 $17,262 2018 $96.00 4,000 $20,000 $5,000 52 53 54 55 56 57 58 59 62 63 64 65 66 67 68 69 72 73 74 75 76 77 141 142 143 144 145 146 147 148 149 151 152 153 154 155 156 157 158 '159 161 162 163 164 - 165 166 167 168 169 171 1 74 175 176 177 178 Ratio Analysis Liquidity Ratios Current Ratio Quick Ratio Asset Management Ratios Inventory Turnover (Total COGS/lnventories Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover Debt Management Ratios Debt Ratio (Total debt-to-assets Liabilities-to-assets ratio Times-interest-earned ratio EBITDA coverage ratio Profitability Ratios Profit Margin Basic Earning Power Return on Assets Return on Equity Market Value Ratios Earnings per share Price-to-earnings ratio Cash flow per share Price-to-cash flow ratio Book Value per share Market-to-book ratio 2019 2.44 1.17 3.57 45.63 1.88 1.09 11.96% 18.93% 13.07% 20.05% 2018 Indust 2.52 1.41 5.32 43.80 2.00 1.22 8.63% 18.95% 10.55% 15.80% 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 NA 7.11 1.72 f. Perform a percent change analysis. and asset utilization? Percent Change Balance Sheets . Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets Liabilities and equ Accounts _payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equ Percent Change Income Statements Sales COGS except excluding depr. and amort. Depreciation and Amortization Other pperating expenses EBIT Interest Expense EBT Taxes (25% Net Income What does this tell you about the change in profitabilit Joshua & White Technologies December 31 Income Statements (Thousands of Dollars Sales COGS except excluding depr. and amort. Depreciation and Amortization Other o atin ex nses EBIT Interest Expense EBT Taxes (25%) Net Income Common dividends Addition to retained earnings Other Data Year-end Stock Price # of shares (Thousands) Lease payment (Thousands of Dollars Sinking fund payment Thousands of Dollars 2019 $420,000 300,000 19,660 27 600 $72,740 5740 $67,000 16 750 $18,125 $32,125 2019 $90.00 4,052 $20,000 $5,000 2019 2019 2019 Base 2018 Base 2018 Base 2018
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started