Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the 4 requirements. THE PANAMA PAJAMA COMPANY Adjusted Trial Balance 12/31/18 2017 Balance Sheet Info 2018 Account Title Adjusted Trial Balance

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedI need help with the 4 requirements.

THE PANAMA PAJAMA COMPANY Adjusted Trial Balance 12/31/18 2017 Balance Sheet Info 2018 Account Title Adjusted Trial Balance Debit Credit Debit Credit $ 137,100 12,000 4,400 26,000 59,000 $ 35,700 11,000 5,600 20,000 21,000 Cash Accounts Receivable Inventory Office Equipment Machinery & Tools Accumulated Depreciation-Plant Assets Accounts Payable Note Payable-Short Term Note Payable-Long Term Common Stock, $10 par Retained Earnings Dividends Sales Revenue Cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense $8,600 12,200 10,000 33,000 150,000 6,000 9,800 15,500 50,000 12,000 30,700 11,600 2,000 800 2,600 256,500 244,500 Transaction Data for 2018 (Note, these transactions were included in the trial balance numbers above Cash paid for purchase of office equipment Cash paid for purchase of tools Acquisition of Machinery with Notes Payable-Long-term Cash payment of dividends Cash receipt from issuance of 10,000 shares of common stock $6,000 5,000 33,000 1,000 100,000 Requirements: (See sheet tabs at bottom. Use each sheet for the following requirements.) Use Excel Skills in completing these requirements. You must use formulas and functions, cell references, and professional formatting 1. Prepare the Panama Pajama Company multi-step income statement for the year ended December 31, 2018. Include the EPS at the bottom Also include a vertical analysis column at the right and perform a vertical analysis of the income statement. (Use percentage format with 1 decimal place.) 2. Prepare the Panama Pajama Company balance sheet for December 31, 2018. Include a vertical analysis column at the right and perform a vertical analysis of the balance sheet. (Use the percentage format with 1 decimal place.) 3. Prepare the Panama Pajama Company statement of cash flows for the year ended December 31, 2018. Use the indirect method 4. Complete the analysis of the financial statements as directed on the Analysis sheet

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_2

Step: 3

blur-text-image_3

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

Auditing Cases An Interactive Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

5th International Edition

0132815591, 9780132815598

More Books

Students also viewed these Accounting questions

Question

Can you see what limitations your purpose imposes on your strategy?

Answered: 1 week ago