Concept explainers
General Manager of Marketing, has recently completed a sales
Cash$55,000
Jack Hanson, the assistant controller, is now preparing a monthly budget for the first quarter of 20x1. In the process, the following information has been accumulated:
Projected sales for December of 20x0 are $480,000. Credit sales typically are 75 percent of total sales. Intercoastal’s credit experience indicates that 10 percent of the credit sales are collected during the month of sale, and the remainder are collected during the following month.
Intercoastal’s cost of goods sold generally runs at 80 percent of sales. Inventory is purchased on account, and 40 percent of each month’s purchases are paid during the month of purchase. The remainder is paid during the following month. In order to have adequate stocks of inventory on hand, the firm attempts to have inventory at the end of each month equal to half of the next month’s projected cost of goods sold.
Hanson has estimated that Intercoastal’s other monthly expenses will be as follows:
Sales salaries$12,000 Advertising and promotion 10,000 Administrative salaries 12,000 Depreciation 25,000 Interest on bonds 1,250 Property taxes 1,500
In addition, sales commissions run at the rate of 2 percent of sales.
Intercoastal’s president, Davies-Lowry, has indicated that the firm should invest $120,000 in an automated inventory-handling system to control the movement of inventory in the firm’s warehouse just after the new year begins. These equipment purchases will be financed primarily from the firm’s cash and marketable securities. However, Davies-Lowry believes that Intercoastal needs to keep a minimum cash balance of $30,000. If necessary, the remainder of the equipment purchases will be financed using short-term credit from a local bank. The minimum period for such a loan is three months. Hanson believes short-term interest rates will be 10 percent per year at the time of the equipment purchases. If a loan is necessary, Davies-Lowry has decided it should be paid off by the end of the first quarter if possible.
Intercoastal’s board of directors has indicated an intention to declare and pay dividends of $25,000 on the last day of each quarter.
The interest on any short-term borrowing will be paid when the loan is repaid. Interest on Intercoastal’s bonds is paid semiannually on January 31 and July 31 for the preceding six-month period.
Property taxes are paid semiannually on February 28 and August 31 for the preceding six-month period.
1. what is sales revenue for first quarter 2x1?
2. fill the blanks on the following chart.
Budgeted Balance Sheet | March 31, 20x1 |
Cash | ? |
Accounts receivable | ? |
Inventory | 255,552selected answer correct |
Buildings and equipmentselected answer correct | ? |
Total assets | $255,552 |
Accounts payable | ? |
Bond interest payableselected answer correct | 2,500selected answer correct |
Property taxes payableselected answer correct | 1,500selected answer correct |
Bonds payableselected answer correct | ? |
Common stockselected answer correct | ? |
Retained earnings | ? |
Total liabilities and stockholder`s equity | ? |
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 4 images
- Philip Inc. expects their sales to increase by $900,000 next month. If their CMR is calculated as 48%, operating income of the next month would be expected to: Group of answer choices Increase by $432,000 Decrease by $468,000 Decrease by $432,000 Increase by $468,000arrow_forwardVikings Inc., is developing a pro forma income statement for the coming year. The chief financial officer estimates that sales will be $150,000,000. If gross profits are historically 36% of sales, what is the expected cost of goods sold (in dollars)? a) $36,000,000 b) $54,000,000 c) $64,000,000 d) $96,000,000 NOTE: In your Excel spreadsheet, all calculations must be includedarrow_forwardSuppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 2020?arrow_forward
- A company is launching a new sales initiative and expects sales of $598,427 during the first year. To prepare for this, they plan to acquire 35 days worth of inventory. If their gross profit margin is 29%, how much inventory must they acquire as part of their initial investment? Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 Type your answer...arrow_forwardFairchild Garden Supply expects $580 million of sales this year, and it forecasts a 15% increase for next year. The CFO uses this equation to forecast inventory requirements at different levels of sales: Inventories = $30.2 + 0.25(Sales). All dollars are in millions. The firm's cost of goods sold is expected to be 70% of sales. What is the projected inventory turnover ratio for the coming year? Please explain process and show calculations.arrow_forwardGrant Communications is forecasting its financial statements for the upcoming year. Highlights include: Current assets of $6 million Current ratio of 2.0 Sales of $20 million Inventory turnover ratio (Sales/Inventory) of 6 The company's CFO is concerned about the forecasted inventory turnover ratio. Her goal is cut inventory enough to obtain an inventory turnover ratio of X, which is the industry average, while still maintaining sales at $20 million. If the company can accomplish this goal, the cash generated from the cut in inventories will be used to cut accounts payable. This will give the firm a Quick Ratio [(Current Assets - Inventory) / Current Liabilities] of 1.50. What is X, the desired inventory turnover ratio? Enter your answer, truncated to 2 decimal places. For example, enter 7.777 as 7.77.arrow_forward
- Your company collected $340.00 million and spent $381.00 million this month. If previous month's cash position (cumulative cash) is $14.31 million and your company target cash position is $20.00 million. What's your company's cash surplus/shortage at the end of this month, with positive number indicates a surplus and negative number indicates a shortage? Note: your answer should be in millions of dollarsarrow_forwardMooney Equipment is putting together its cash budget for the following year and has forecasted expected cash collections over the next five quarters (one year plus the first quarter of the next year). The cash collection estimates are based on sales projections and expected collection of receivables. The sales and cash collection estimates are shown in the following table (in millions of dollars): Q1 Q2 Q3 Q4 Q5 Sales $1,100 $1,400 $1,450 $1,250 $1,500 Total cash collections $1,100 $1,150 $1,200 $1,200 You also have the following information about Mooney Equipment: • In any given period, Mooney’s purchases from suppliers generally account for 72% of the expected sales in the next period, and wages, supplies, and taxes are expected to be 15% of next period’s sales. • In the third quarter, Mooney expects to expand one of its plants, which will require an additional $1,072 million investment. • Every quarter, Mooney pays $60 million in interest and…arrow_forwardCash budgets are essential to all small businesses. In this case, middletown construction company has estimated the following sales forecast in the next 12 months. January $0 February $0 March $275,000 April $275,000 May $312,000 June $417,000 July $714,000 August $611,000 September $827,000 October $500,000 November $116,000 December $0 The company also gathered the following collection estimates regarding the forecast sales: Payment collection within the month of sale = 20% Payment collection the month following sales = 60% Payment collection the second month following sales = 20% Payments for raw materials and labor costs are paid the month after the purchase and are estimated as follows: March $220,000 April $240,000 May $225,000 June $287,000 July $350,000 August $415,000 September $242,000 October $214,000 November $222,000 Additional financial information is as follows: Administrative salaries will approximately amount to…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education