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 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 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 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 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 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 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?
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 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. 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.?
|
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.?
|
X
Chart of Accounts
CHART OF ACCOUNTS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Rios Financial Co. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
General Ledger | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
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