Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please open file and complete the questions in red at the bottom. Need done ASAP. Is due today, Thank you P 10-7 Arrowbell Company is

Please open file and complete the questions in red at the bottom. Need done ASAP. Is due today, Thank you

image text in transcribed P 10-7 Arrowbell Company is a growing company. Two years ago, it decided to expand in order to increase its production capacity. The company anticipates that the expansion program can be completed in another two years. Financial information for Arrowbell is as follows. ARROWBELL COMPANY Sales and Net Income Year Sales Net Income 2007 $ 2,568,660.00 $ 145,800.00 2008 $ 2,660,455.00 $ 101,600.00 2009 $ 2,550,180.00 $ 52,650.00 2010 $ 2,625,280.00 $ 86,800.00 2011 $ 3,680,650.00 $ 151,490.00 ARROWBELL COMPANY Balance Sheet December 31,2011 and 2010 ARROWBELL COMPANY Statement of Cash Flows For Years Ended December 31, 2011 and 2010 2011 Assets Current assets: Cash Accounts receivable(net) Inventories at lower-of-cost-or-market Prepaid expenses Total current assets Plan and equipment: Land, building, machinery, and equipment Less:Accumulated depreciation Net plant and equipment Other assets: Cash surrender value of life insurance Other Total other assets Total assets Liabilities and Stockholders' equity Current liabilities: Notes and mortgages payable, current portion Accounts payable and accured liabilities Total current liabilities Long-term notes and mortgages payable, less current portion above Total liabilities Stockholders' equity: Capital stock, par $1.00;authorized, 800,000; issued and outstanding, 600,000 (2011 and 2010) Paid in excess of par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 250,480.00 $ 760,950.00 $ 725,318.00 $ 18,555.00 $ 1,755,303.00 2010 $ 260,155.00 $ 690,550.00 $ 628,238.00 $ 20,250.00 $ 1,599,193.00 $ 3,150,165.00 $ 2,646,070.00 $ 650,180.00 $ 525,650.00 $ 2,499,985.00 $ 2,120,420.00 $ 20,650.00 $ 40,660.00 $ 61,310.00 $ 4,316,598.00 $ 18,180.00 $ 38,918.00 $ 57,098.00 $ 3,776,711.00 $ 915,180.00 $ 550,155.00 $ 1,160,111.00 $ 851,080.00 $ 2,075,291.00 $ 1,401,235.00 $ 550,000.00 $ 775,659.00 $ 2,625,291.00 $ 2,176,894.00 $ 600,000.00 $ 600,000.00 $ 890,000.00 $ 890,000.00 $ 201,307.00 $ 109,817.00 $ 1,691,307.00 $ 1,599,817.00 $ 4,316,598.00 $ 3,776,711.00 a. Comment on the short-term debt position, including computations of current ratio, acid-test ratio, cash ratio, and operating cash flow/current maturities of long-term debt and current notes payable. b. If you were a supplier to this company, what would you be concerned about? c. Comment on the long-term debt position, including computations of the debt ratio, debt/equity, debt to tangible net worth, and operating cash flow/total debt. Review the statement of operating cash flows. d. If you were a banker, what would you be concerned about if this company approached you for a long-term loan to continue its expansion program? e. What should management consider doing at this point with regard to the company's expansion program? 2011 Cash flows from operating activities: Net income Noncash expenses, revenues, losses, and gains included in income: Depreciation Increase in Accounts Receivable Increase in inventories Decrease in prepaid expenses in 2011, increase in 2010 Increase in accounts payable and accrued liabilities Net cash provided by operating activities Cash flows from investing activities: Proceeds from retirement of property, plant, and equipment Purchases of property, plant, and equipment Increase in cash currender value of life insurance Other Net cash used for investing activities Cash flows from financing activities: Retirement of long-term debt Increase in notes and mortgages payable Cash dividends Net cash provided by financing activities Net increase (decrease) in cash $ 151,490.00 $ 2010 86,800.00 $ 134,755.00 $ 102,180.00 $ (70,400.00) $ (10,180.00) $ (97,080.00) $ (15,349.00) $ 1,695.00 $ (1,058.00) $ 309,031.00 $ 15,265.00 $ 429,491.00 $ 177,658.00 $ 10,115.00 $ 3,865.00 $ (524,435.00) $ (218,650.00) $ (2,470.00) $ (1,848.00) $ (1,742.00) $ (1,630.00) $ (518,532.00) $ (218,263.00) $ (225,659.00) $ (50,000.00) $ 365,025.00 $ 159,155.00 $ (60,000.00) $ (60,000.00) $ 79,366.00 $ 49,155.00 $ (9,675.00) $ 8,550.00

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

Financial And Managerial Accounting

Authors: Carl S. Warren, Jefferson P. Jones, William Tayler

16th Edition

0357714040, 9780357714041

More Books

Students also viewed these Accounting questions

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago