Question

In: Accounting

The Airport Shuttle Services Inn provides the following balance sheet, income statement and other information. Use...

The Airport Shuttle Services Inn provides the following balance sheet, income statement and other information.

Use this information to complete a Statement of Cash Flows using the Indirect Method.

Airport Shuttle Services: Balance Sheets 12/31

20X1 20X2
ASSETS
Cash

$ 34,000

$ 56,000

Accounts Receivable

   30,000

   20,000

Prepaid Expenses

   0

     4,000

Land

   0

130,000

Building

   0

160,000

Equipment

   10,000

    27,000

Accumulated Depreciation

   0

   (14,000)

Total Assets

$ 74,000

$ 383,000

LIABILITIES AND EQUITIES
Accounts Payable

$ 4,000

$ 59,000

Bonds Payable

   0

130,000

Common Stock

50,000

    50,000

Retained Earnings

20,000

144,000

Total Liabilities and Equities

$ 74,000

$ 383,000

Airport Shuttle Services: Income Statement 12/31

Revenues

$ 507,000

Operating Expenses

$ 261,000

Depreciation Expenses

     15,000

Loss on Sale of Equipment

       3,000

Total Expenses

   279,000

Operating Income

   228,000

Income Taxes

      89,000

Net Income

$ 139,000

Airport Shuttle Services: Additional Information

  1. The company declared and paid a $ 15,000 cash dividend.
  2. The company obtained land through the issuance of $ 130,000 in long-term bonds.
  3. A building costing $ 160,000 was purchased with cash.
  4. Equipment costing $ 25,000 was purchased with cash.
  5. The company sold equipment with a book value of $ 7,000 (cost was $ 8,000 with accumulated depreciation of $ 1,000) for cash of $ 4,000.

Solutions

Expert Solution

Airport Shuttle Services Inn
Statement of Cash flows
For the Year Ended December 31, 20X2
Cash flows from operating activities
Net Income   $    139,000
Adjustments to reconcile net income to ;
Depreciation expense $       15,000
Loss on sale of equipment $         3,000
Decrease in accounts receivable $       10,000
Increase in prepaid expenses $       (4,000)
Increase in accounts payable $       55,000
$       79,000
Net cash provided by operating activities $    218,000
Cash flows from investing activities
Cash received from sale of equipment $         4,000
Cash paid for purchase of building $ (160,000)
Cash paid for purchase of equipment $    (25,000)
Net cash used by investing activities $ (181,000)
Cash flows from financing activities
Payment of dividends $    (15,000)
Net cash used by financing activities $    (15,000)
Net Increase in cash   $       22,000
Cash and cash equivalents at beginning of period $       34,000
Cash and cash equivalents at end of period $       56,000
Non cash investing and financing activities
Acquisition of land by issuing long term bond $     130,000

You can reach me over comment box if you have any doubts. Please rate this answer


Related Solutions

USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE TAX RATE IS 40%. (COMMON EQUITY IS A PLUG IN NUMBER) ITEM 2010 2011 SALES 10,000 12,000 DEPRECIATION 3,000 3,000 COST OF GOODS SOLD 2,000 2,000 OTHER EXPENSES 3,000 4,000 INTEREST 1,000 1,000 CASH 1,000 1,000 ACCOUNTS RECEIVABLE 3,000 3,000 S.T. NOTES PAYABLE 1,000 1,000 L.T. DEBT 10,000 11,000 NET FIXED ASSETS 20,000 20,000 ACCOUNTS PAYABLE 2,000 2,000 INVENTORY 3,000 3,000 DIVIDENDS 600 600...
Question 7 Use the following income statement and balance sheet information to put together a statement...
Question 7 Use the following income statement and balance sheet information to put together a statement of cash flows. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) 2017 Sales $1,242,000 Cost of goods sold $685,000 Gross profit $557,000 Gen'l & admin expense $156,000 Selling & mkt expense $135,000 Depreciation $24,000 Operating income $242,000 Interest $140,000 Income before taxes $102,000 Income taxes (27%) $27,540 Net income $74,460 Dividends paid $25,000 Assets 2017...
Required Use the following information to prepare a multistep income statement and a classified balance sheet...
Required Use the following information to prepare a multistep income statement and a classified balance sheet for Eller Equipment Co. for Year 1. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) Salaries expense $ 122,000 Beginning retained earnings $ 61,100 Common stock 110,000 Warranties payable (short term) 6,500 Notes receivable (short term) 32,500 Gain on sale of equipment 19,000 Allowance for doubtful accounts 19,000 Operating expenses 65,000 Accumulated depreciation 66,000...
Required Use the following information to prepare a multistep income statement and a classified balance sheet...
Required Use the following information to prepare a multistep income statement and a classified balance sheet for Eller Equipment Co. for Year 1. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) Salaries expense $ 103,000 Beginning retained earnings $ 42,100 Common stock 91,000 Warranties payable (short term) 4,600 Notes receivable (short term) 13,500 Gain on sale of equipment 8,000 Allowance for doubtful accounts 15,000 Operating expenses 46,000 Accumulated depreciation 47,000...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 84,000 Operating Expenses $ 77,000 Common Stock 100,000 Cash Flow from Investing Activities 93,400 Notes Receivable (short term) 39,000 Prepaid Rent 14,000 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 79,000 Operating Expenses $ 72,000 Common Stock 100,000 Cash Flow from Investing Activities 88,400 Notes Receivable (short term) 34,000 Prepaid Rent 13,500 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 75,000 Operating Expenses $ 68,000 Common Stock 100,000 Cash Flow from Investing Activities 84,400 Notes Receivable (short term) 30,000 Prepaid Rent 13,100 Allowance for...
The latest income statement, balance sheet and other related information for ABC Company is as follows:...
The latest income statement, balance sheet and other related information for ABC Company is as follows: Net Sales Revenue = $1,000,000 COGS = $600,000 (60% of Sales) Operating Expenses = $200,000 (20% of Sales) Interest Expense = $20,000 (10% of Long Term Debt) Tax Expense = $54,000 (30% of Earnings Before Taxes) Net Income = $126,000 Addition to Retained Earnings = $88,200 (70% of Net Income) Current Assets = $700,000 (70% of Sales) Net Fixed Assets = $900,000 (90% of...
The latest income statement, balance sheet and other related information for ABC Company is as follows:...
The latest income statement, balance sheet and other related information for ABC Company is as follows: Net Sales Revenue = $1,000,000 COGS = $600,000 (60% of Sales) Operating Expenses = $200,000 (20% of Sales) Interest Expense = $20,000 (10% of Long Term Debt) Tax Expense = $54,000 (30% of Earnings Before Taxes) Net Income = $126,000 Addition to Retained Earnings = $88,200 (70% of Net Income) Current Assets = $700,000 (70% of Sales) Net Fixed Assets = $900,000 (90% of...
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 &...
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 & 2012. Also include a 40% tax rate expense on your pretax income. 2011 2012 Sales $4,203 $4,507 Cost of Goods Sold 2,422 2,633 Depreciation 785 952 Interest 180 196 Dividends 225 250 Current Assets 2,205 2,429 Net fixed Assets 7,344 7,650 Current Liabilities 1,003 1,255 Long-Term debt 3,106 2,085
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT