80.2K

Verified Solution

Link Copied!

Joshua and White Technologies

Complete all sections in yellow. Please provide the Excel syntax.

Assets Cash and cash equivalents Short-term investments Accounts Receivable nventories $21,000$20,000 3,240 48,000 3,759 $161,259 $127,240 218400 200.000 $379 659 327240 Total current assets Net fxed assets Total assets Liabilities and equity Accounts payable Accruals Notes payable $33,600 $32,000 12,600 12,000 $66,129$50,480 766258320 $133,791 $108,800 183,793 178,440 62.075 40.000 $245 868 $218440 $379 659 327240 Total current labilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity Joshua & White Technologies December 31 Income Statements Thousands of Dollars) 2016 420,000 $400,000 COGS except excluding depr. and amort 300,000 298,000 18,000 27600 22.000 $72,740 $62,000 Deprecation and Amortization 19,660 Other operating expenses Interest Expense Taxes (40%) EBIT EBT Net Income $67,000 $57,540 26.800 23016 $40 200 $34524 Common dividends Addition to retained eanings $18,125$17,262 $22,075 $17.262 Other Data Year-end Stock Price # of shares Thousands) Lease payment (Thousands of Dollars) Sinking fund payment (Thousands of Doll $30.00 4,000 $20,000 $20,000 $5,000$5,000 4,052 Assets Cash and cash equivalents Short-term investments Accounts Receivable nventories $21,000$20,000 3,240 48,000 3,759 $161,259 $127,240 218400 200.000 $379 659 327240 Total current assets Net fxed assets Total assets Liabilities and equity Accounts payable Accruals Notes payable $33,600 $32,000 12,600 12,000 $66,129$50,480 766258320 $133,791 $108,800 183,793 178,440 62.075 40.000 $245 868 $218440 $379 659 327240 Total current labilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity Joshua & White Technologies December 31 Income Statements Thousands of Dollars) 2016 420,000 $400,000 COGS except excluding depr. and amort 300,000 298,000 18,000 27600 22.000 $72,740 $62,000 Deprecation and Amortization 19,660 Other operating expenses Interest Expense Taxes (40%) EBIT EBT Net Income $67,000 $57,540 26.800 23016 $40 200 $34524 Common dividends Addition to retained eanings $18,125$17,262 $22,075 $17.262 Other Data Year-end Stock Price # of shares Thousands) Lease payment (Thousands of Dollars) Sinking fund payment (Thousands of Doll $30.00 4,000 $20,000 $20,000 $5,000$5,000 4,052

Answer & Explanation Solved by verified expert

See Answer