Reference no: EM131178718
Saginaw Concrete is attempting to estimate their financial needs for the first 6 months of 2010. Sales forecasts for 2010 are as follows:
January $50,000 May $ 80,000
February 60,000 June 120,000
March 60,000 July 125,000
April 70,000
Actual sales in 2009 were:
October $100,000
November 150,000
December 200,000
The credit department estimates the collections as follows: collections within the month of sale, 20 percent; collections the month following the sale, 40 percent; collections the second month following the sale, 40 percent.
The cost of raw materials is 40 percent of sales. Raw materials are delivered and paid for in the month prior to sale. Labor costs are 24 percent of sales and are paid for in the month of the sale. Selling, administrative, and other expenses are 16 percent of sales and are paid for in the month of the sale. All goods sold are manufactured in the month of the sale.
A new mixer with a 12-year life and no salvage value will be delivered and paid for in May. The cost of the mixer is $144,000, on which depreciation of $20,160 will be charged on June 30 (assuming the mixer falls in the MACRS 7-year class life).
Semiannual interest charges on $345,833 of long-term bonds (12 percent coupon) are due in March. Quarterly common stock cash dividends of $10,000 are paid in March and June. Income tax prepayments of $18,000 are made in March.
Cash on hand December 31, 2009, is $60,000, and a minimum cash balance of $50,000 should be maintained. All short-term borrowing is repaid as soon as cash is available. The interest rate on short-term borrowing is 12 percent per annum. All borrowing and repayments take place on the first day of the month. Interest payments are due the first day of the month following the borrowing.
1. Prepare a cash budget for Saginaw Concrete for the first 6 months of 2010. Indicate the amount of excess cash or the amount of financing required to maintain the $50,000 minimum cash balance.
2. If Saginaw Concrete changed all sales to a cash basis, no credit, would their outside financing needs for the cash budget period studied increase or decrease? Do not rework the problem but simply explain why it would increase or decrease.
|
Capital budge-influence firm decision to use payback
: A firm has a $100 million capital budge. It is considering two projects that each cost $100 million. Project A has an IRR of 20 percent, and NPV of $9 million, and will be terminated after 1 year at a profit of $20 million, resulting in an immediate ..
|
|
Government-funded pension plan
: A junior employee, who just turned 25, decides to set up a personal retirement fund to supplement her government-funded pension plan during her first 20 years of retirement. She wants to have an annual income of $50,000 starting when she turns 65 and..
|
|
What is the company days sales in receivables
: A company has net income of $181,000, a profit margin of 8.1 percent, and an accounts receivable balance of $120,370. Assuming 70 percent of sales are on credit, what is the company’s days’ sales in receivables?
|
|
What would be the total market value of the firm
: The company has no growth opportunities (g = 0), so the company pays out all of its earnings as dividends (EPS = DPS). The consultant believes that if the company moves to a capital structure financed with 20 percent debt and 80 percent equity (based..
|
|
Prepare cash budget for saginaw concrete
: Saginaw Concrete is attempting to estimate their financial needs for the first 6 months of 2010. The credit department estimates the collections as follows: collections within the month of sale, 20 percent; collections the month following the sale, 4..
|
|
Recycle paper to save the environment
: Paper is the requirement of daily need in today's world. Paper is made from the pulp of wood. And for this reason every year millions of trees are cut around the world to fulfill our demand for paper. Recycling paper is the only method to save trees ..
|
|
What conclusion do these percentage returns imply
: Investor A makes a cash purchase of 100 shares of AB&C common stock for $55 a share. Investor B also buys 100 shares of AB&C but uses margin. Each holds the stock for one year, during which dividends of $5 a share are distributed. If the margin requi..
|
|
The pension fund from fluctuations in interest rates
: You are to design for a small pension fund a bond portfolio to fund a $10 million obligation due in 4 years. The fund managers would like to use a 2-year zero along with an 8-year zero to fund the obligation. Currently, the yield curve is flat at aro..
|
|
Company weighted average flotation cost
: Suppose your company needs $20 million to build a new assembly line. Your target debt−equity ratio is 0.80. The flotation cost for new equity is 9 percent, but the flotation cost for debt is only 6 percent. What is your company’s weighted average flo..
|