Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Captain Kirk's Yellow Boat Tours had the following balance sheet and additional information: Captain Kirk's Yellow Boat Tour Company Balance Sheet December 31, 2020 Cash

image text in transcribed
Captain Kirk's Yellow Boat Tours had the following balance sheet and additional information: Captain Kirk's Yellow Boat Tour Company Balance Sheet December 31, 2020 Cash Accounts receivable Inventory Prepaid rent Total current assets 2020 108,900 82,000 105,000 6,000 301,900 2019 126,800 97,000 89,000 3,000 315,800 Land Equipment Accumulated depreciation TOTAL ASSETS 530,000 830,000 (438,000) $1,223,900 530,000 720,000 (288,000) $1,277,800 Accounts payable interest payable Income tax payable Total current liabilities $109,000 6,900 10,000 125,900 $94,000 13,800 6,000 113,800 115,000 230,000 Notes payable Common stock Retained earnings Total liabilities and stockholders' equity 750,000 233,000 $1,223,900 750,000 184.000 $1,277,800 . Additional information for 2020: Net income is $79,000 The company purchases $110,000 in equipment Depreciation expense is $150,000 The company repays $115,000 in notes payable The company declares and pays a cash dividend of $30,000 REQUIRED: In excel, prepare a statement of cash flows for 2020 using the Indirect method. Include a proper title and use good formatting. The table above can be copied into Excel if you wish to use it for calculating the changes in the line items from year to your

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

Strategic Cost Analysis

Authors: Roger Hussey

1st Edition

160649239X, 9781606492390

More Books

Students also viewed these Accounting questions

Question

In Problems 1520 establish each identity. sin (30) 3 sin - 4 sin 0

Answered: 1 week ago