Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the balance sheet below, solve for the cells in yellow (with Excel syntax): Assets Cash and cash equivalents Short-term investments Accounts Receivable nventories

Based on the balance sheet below, solve for the cells in yellow (with Excel syntax):

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems Thinking Development And Evaluation

Authors: Robyn L. Raschke, John A. Schatzel

1st Edition

1453396950, 9781453396957

More Books

Students also viewed these Accounting questions