Questions
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...

Cash Budget

The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

September October November
Sales $97,000 $122,000 $162,000
Manufacturing costs 41,000 52,000 58,000
Selling and administrative expenses 34,000 37,000 62,000
Capital expenditures _ _ 39,000

The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $6,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of September 1 include cash of $37,000, marketable securities of $52,000, and accounts receivable of $108,400 ($85,000 from July sales and $23,400 from August sales). Sales on account for July and August were $78,000 and $85,000, respectively. Current liabilities as of September 1 include $6,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $15,000 will be made in October. Bridgeport’s regular quarterly dividend of $6,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $36,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

Bridgeport Housewares Inc.
Cash Budget
For the Three Months Ending November 30
September October November
Estimated cash receipts from:
Cash sales $ $ $
Collection of accounts receivable
Total cash receipts $ $ $
Less estimated cash payments for:
Manufacturing costs $ $ $
Selling and administrative expenses
Capital expenditures
Other purposes:
Income tax
Dividends
Total cash payments $ $ $
Cash increase or (decrease) $ $ $
Plus cash balance at beginning of month
Cash balance at end of month $ $ $
Less minimum cash balance
Excess or (deficiency) $ $ $

In: Accounting

You may have heard the statement that you should not include your home as an asset...

You may have heard the statement that you should not include your home as an asset in your investment portfolio. Assume that your house will compromise up to 75% of your assets in the early part of your investment life. Evaluate the implications of omitting it when calculating the risk of your overall investment portfolio:

In: Finance

A client is receiving oxytocin for induction. Which assessment finding would cause the RN to discontinue...

A client is receiving oxytocin for induction. Which assessment finding would cause the RN to discontinue the infusion and notify the physician?

Uterine contractions less than 50 mmHg pressure.

Early decelerations noted with several contractions.

Moderate fetal heart rate variability.

Uterine contractions occurring every 90 seconds.

In: Nursing

the economic development of the United States in the late 18th and early 19th centuries.HowdidindependencechangetheeconomiesoftheUS?Whatwasthedifference between...

the economic development of the United States in the late 18th and early 19th centuries.HowdidindependencechangetheeconomiesoftheUS?Whatwasthedifference between Hamilton’s (Federalist) approach to economic development as opposed to Jefferson and his supporters? What role did fraud play in the economic development of the US? How did the conflict over slavery in the US become an economic issue?

In: Economics

In very simple cryptograph, the intended message sometimes consists of the first letterof very word in...

In very simple cryptograph, the intended message sometimes consists of the first letterof very word in upper case in a string. Write a function cryptmessage that will receive a string or a character vector with the message and return the encrypted message.

>>messagestring=' the Early songbird tweets ';

>>m=cryptmessage(messagestring)

m=' TEST'

Please put it in MATLAB

In: Computer Science

Ori's marketing director suggests that it is incorrect to use the same discount rate each year...

Ori's marketing director suggests that it is incorrect to use the same discount rate each year for the investment in packaging as the early stages are riskier and should be discounted at a higher rate. Another board member disagrees, saying that more distant cashflow are riskier and should be discounted at a higher rate.
Discuss the validity of the views of the directors.

In: Finance

(cost of restrictive covenant) peachtree construction has a restrictive covenant in a loan contract that essentially...

(cost of restrictive covenant) peachtree construction has a restrictive covenant in a loan contract that essentially prohibits the expansion of the firm into a new line of business that it is considering. the cost of this restriction is estimated to be $20 million. The debt can be called off and paid early by paying a $5 million penalty. What should peachtree do?  

In: Finance

human computers interaction 1. What kind of data gathering would be appropriate to evaluate requirements? Why?...

human computers interaction

1. What kind of data gathering would be appropriate to evaluate requirements? Why?

2.What method(s) would you use to analyze the data?

3.What kind of prototype would you use to evaluate your design during an early stage of development? Why?

In: Computer Science

Pretend it is early 2002 and you are Senator Paul Sarbanes.  What would you do differently when...

Pretend it is early 2002 and you are Senator Paul Sarbanes.  What would you do differently when writing the Sarbanes-Oxley Act? (Do not say you think it is perfect and you would not do anything differently. Discuss at least two things you would do differently.please explain in detail.

In: Accounting

Rios Financial Co. is a regional insurance company that began operations on January 1, Year 1....

Rios Financial Co. is a regional insurance company that began operations on January 1, Year 1. The following transactions relate to trading securities acquired by Rios Financial Co., which has a fiscal year ending on December 31:

Record these transactions on page 10:

Year 1

Feb. 1. Purchased 7,400 shares of Caldwell Inc. as a trading security at $38 per share plus a brokerage commission of $740.
May 1. Purchased 1,700 shares of Holland Inc. as a trading security at $55 plus a brokerage commission of $187.
July 1. Sold 3,850 shares of Caldwell Inc. for $36 per share less a $105 brokerage commission.
31. Received an annual dividend of $0.25 per share on Caldwell Inc. stock.
Dec. 31. The portfolio of trading securities was adjusted to fair values of $36 and $54 per share for Caldwell Inc. and Holland Inc., respectively.

Record these transactions on page 11:

Year 2

Apr. 1. Purchased 3,000 shares of Fuller Inc. as a trading security at $25 per share plus a $150 brokerage commission.
July 31. Received an annual dividend of $0.45 per share on Caldwell Inc. stock.
Oct. 14. Sold 600 shares of Fuller Inc. for $27 per share less a $60 brokerage commission.
Dec. 31 The portfolio of trading securities had a cost of $289,062 and a fair value of $366,663, requiring a debit balance in Valuation Allowance for Trading Investments of $77,601 ($366,663 - $289,062). Thus, the credit balance from December 31, Year 1, is to be adjusted to the new balance.
Required:
1. Journalize the entries to record these transactions. Round all final amounts to the nearest whole dollar.*
2. Prepare the investment-related current asset balance sheet presentation for Rios Financial Co. on December 31, Year 2.*
3. How are unrealized gains or losses on trading investments presented in the financial statements of Rios Financial Co.?
*Refer to the information given and the Chart of Accounts and Amount Descriptions provided for the exact wording of the answer choices for text entries. “Less” or “Plus” will automatically appear if it is required. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Rios Financial Co. is a regional insurance company that began operations on January 1, Year 1. The following transactions relate to trading securities acquired by Rios Financial Co., which has a fiscal year ending on December 31:

Record these transactions on page 10:

Year 1

Feb. 1. Purchased 7,400 shares of Caldwell Inc. as a trading security at $38 per share plus a brokerage commission of $740.
May 1. Purchased 1,700 shares of Holland Inc. as a trading security at $55 plus a brokerage commission of $187.
July 1. Sold 3,850 shares of Caldwell Inc. for $36 per share less a $105 brokerage commission.
31. Received an annual dividend of $0.25 per share on Caldwell Inc. stock.
Dec. 31. The portfolio of trading securities was adjusted to fair values of $36 and $54 per share for Caldwell Inc. and Holland Inc., respectively.

Record these transactions on page 11:

Year 2

Apr. 1. Purchased 3,000 shares of Fuller Inc. as a trading security at $25 per share plus a $150 brokerage commission.
July 31. Received an annual dividend of $0.45 per share on Caldwell Inc. stock.
Oct. 14. Sold 600 shares of Fuller Inc. for $27 per share less a $60 brokerage commission.
Dec. 31 The portfolio of trading securities had a cost of $289,062 and a fair value of $366,663, requiring a debit balance in Valuation Allowance for Trading Investments of $77,601 ($366,663 - $289,062). Thus, the credit balance from December 31, Year 1, is to be adjusted to the new balance.
Required:
1. Journalize the entries to record these transactions. Round all final amounts to the nearest whole dollar.*
2. Prepare the investment-related current asset balance sheet presentation for Rios Financial Co. on December 31, Year 2.*
3. How are unrealized gains or losses on trading investments presented in the financial statements of Rios Financial Co.?
*Refer to the information given and the Chart of Accounts and Amount Descriptions provided for the exact wording of the answer choices for text entries. “Less” or “Plus” will automatically appear if it is required. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

X

Chart of Accounts

CHART OF ACCOUNTS
Rios Financial Co.
General Ledger
ASSETS
110 Cash
111 Petty Cash
120 Accounts Receivable
121 Allowance for Doubtful Accounts
131 Notes Receivable
132 Interest Receivable
141 Merchandise Inventory
145 Office Supplies
146 Store Supplies
151 Prepaid Insurance
161 Investments-Caldwell Inc.
162 Investments-Holland Inc.
163 Investments-Fuller Inc.
165 Valuation Allowance for Trading Investments
166 Valuation Allowance for Available-for-Sale Investments
181 Land
191 Store Equipment
192 Accumulated Depreciation-Store Equipment
193 Office Equipment
194 Accumulated Depreciation-Office Equipment
LIABILITIES
210 Accounts Payable
221 Notes Payable
231 Interest Payable
241 Salaries Payable
251 Sales Tax Payable
EQUITY
311 Common Stock
312 Paid-In Capital in Excess of Par-Common Stock
321 Preferred Stock
322 Paid-In Capital in Excess of Par-Preferred Stock
331 Treasury Stock
332 Paid-In Capital from Sale of Treasury Stock
340 Retained Earnings
350 Unrealized Gain (Loss) on Available-for-Sale Investments
351 Cash Dividends
352 Stock Dividends
390 Income Summary
REVENUE
410 Sales
611 Interest Revenue
612 Dividend Revenue
631 Gain on Sale of Investments
641 Unrealized Gain on Trading Investments
EXPENSES
511 Cost of Merchandise Sold
512 Bad Debt Expense
515 Credit Card Expense
516 Cash Short and Over
520 Salaries Expense
531 Advertising Expense
532 Delivery Expense
533 Repairs Expense
534 Selling Expenses
535 Rent Expense
536 Insurance Expense
537 Office Supplies Expense
538 Store Supplies Expense
561 Depreciation Expense-Store Equipment
562 Depreciation Expense-Office Equipment
590 Miscellaneous Expense
710 Interest Expense
731 Loss on Sale of Investments
741 Unrealized Loss on Trading Investments

Amount Descriptions

Increase in retained earnings
Net income
Net loss
Other comprehensive income (loss)
Other income (loss)
Retained earnings, December 31, Year 2
Retained earnings, January 1, Year 2
Trading investments (at cost)
Trading investments (at fair value)

In: Accounting