Statement of Cash Flows:
Southwestern Rentals, Inc., rents equipment to customers ranging from homeowners to large construction companies. The financial information shown below was gathered from its accounting records for 2006. Assume any increase or decrease in the balances from 1/1/06 to 12/31/06 resulted from either receiving or paying cash in the transaction. For example, during 2006 the balance on loans for land holdings increased $150,000 because the company received $150,000 in cash by taking out an additional loan on the land.
Balance as of Balance as of
Items 1/1/06 12/31/06
Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 20,000 $ 50,000
Cash receipts from customers . . . . . . . . . . . . . . . . - 600,000
Loans on land holdings . . . . . . . . . . . . . . . . . . . . . 100,000 250,000
Cash distributions to owners . . . . . . . . . . . . . . . . . - 150,000
Loan on building . . . . . . . . . . . . . . . . . . . . . . . . . . 100,000 70,000
Investments in securities . . . . . . . . . . . . . . . . . . . 850,000 1,050,000
Cash payments for other expenses . . . . . . . . . . . . - 50,000
Cash payments for taxes . . . . . . . . . . . . . . . . . . . - 55,000
Cash payments for operating expenses . . . . . . . . . - 135,000
Cash payments for wages and salaries . . . . . . . . . - 100,000
Required:
1. Prepare a statement of cash flows for Southwestern Rentals, Inc., for the year ended December 31, 2006.
2. Does Southwestern Rentals, Inc. appear to be in good shape from a cash flow standpoint? What other information would help you analyze the situation?
Financial Statements. As you can see, someone has spilled ink over some of the entries in the balance sheet and income statement of Transylvania Railroad. Can you use the following information to work out the missing entries:
|
Long-term Debt Ratio
|
OA
|
|
|
Times Interest Earned
|
8.0
|
|
|
Current Ratio
|
1A
|
|
|
Quick Ratio
|
1.0
|
|
|
Cash Ratio
|
02
|
|
|
ROA
|
18%
|
|
|
ROE
|
41%
|
|
|
Inventory Tumover
|
5.0
|
|
|
Average Collection Period
|
712
|
days
|
|
Income Statement
|
|
|
(figures in millions of dollars)
|
|
|
Net Sales
|
???
|
|
|
Cost of Goods Sold
|
???
|
|
|
SGA Expenses
|
|
10
|
|
Depreciation
|
|
20
|
|
EB1T
|
???
|
|
|
Interest Expense
|
???
|
|
|
EBT
|
???
|
|
|
Tax
|
???
|
|
|
Net Income
|
???
|
|
|
Balance Sheet
|
|
(figures in millions of dol ars)
|
|
|
This Year
|
Last Year
|
|
Assets
|
|
|
|
Cash and marketable securities
|
|
20
|
|
Receivables
|
|
34
|
|
Inventories
|
|
26
|
|
Total Current Assets
|
|
80
|
|
Net property plant, and equipment
|
|
25
|
|
Total Assets
|
|
105
|
|
Liabilities and Shareholders Equity
|
|
|
|
Accounts payable
|
25
|
20
|
|
Notes payable
|
30
|
35
|
|
Total Current Liabilities
|
|
55
|
|
Long-term debt
|
???
|
20
|
|
Shareholders' EquJ'
|
???
|
30
|
|
Total Liabilities and Shareholders' Equity
|
115
|
105
|
Break-Even Analysis:
Jane Tamlyn paid $225 to rent a carnival booth for four days. She has to decide whether to sell doughnuts or popcorn. Doughnuts cost $1.80 per dozen and can be sold for $3.60 per dozen. Popcorn will require a $113 rental fee for the popcorn maker and $0.08 per bag of popcorn for the popcorn, butter, salt, and bags; a bag of popcorn could sell for $0.45.
Required:
1. Compute the break-even point in dozens of doughnuts if Jane decides to sell doughnuts exclusively and the break-even point in bags of popcorn if she decides to sell popcorn exclusively.
2. Jane estimates that she can sell either 75 doughnuts or 45 bags of popcorn every hour the carnival is open (10 hours a day for four days). Which product should she sell?
3. Jane can sell back to the baker at half cost any doughnuts she fails to sell at the carnival. Unused popcorn must be thrown away. If Jane sells only 70% of her original estimate, which product should she sell? (Assume that she bought or produced just enough to satisfy the demands she originally estimated.)