Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted:

(15 points, please label your answer in a cash budget format) April May Sales ………………………………………………. $150,000 $157,500 Merchandise purchases …………………………… 107,000 112,400 Operating expenses: Payroll …………………………………………. 13,600 14,280 Advertising ……………………………………. 5,400 5,700 Rent ……………………………………………. 2,500 2,500 Depreciation …………………………………… 7,500 7,500 End of April balances: Cash ……………………………………………. 30,000 Bank loan payable ……………………………… 26,000 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. (2) Purchases are all on credit, with 40% paid in the month of purchase and 60% paid in the following month. (3) Operating expenses are paid in the month they are incurred. (4) A minimum cash balance of $25,000 is required at the end of each month. (5) Loans are used to maintain the minimum cash balance. At the end of each month, interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made at the end of the month if the cash balance exceeds $25,000. Prepare the company's cash budget for May. Show the ending loan balance at May 31.

Business

You might be interested in

Jessica is required to follow a forty-hour work schedule from 9:00 in the morning and ends at 5:00 each day, every week. However

Mariulka [3825]

Variable work timetable is an adaptable work arrangement that lacks a set structure. This type of schedule allows employees to fulfill their working hours on days when they are absent. In this instance, Jessica has a commitment of working forty hours weekly, specifically from 9:00 a.m. until 5:00 p.m. Should she miss a day, she must compensate by putting in additional hours later. This exemplifies a variable work schedule.

7 0

1 month ago

Nola and Charles both own party planning firms in the small town of Trident, IA. Because they are the only party planners in tow

marusya05 [3725]

Response:

In Trident, IA, Nola and Charles are both involved in a collusion agreement.

Scenarios that Assist:

Supporting Scenarios:

4. Nola and Charles frequently meet and chat at the same coffee shop.

5. Both charge a consistent rate per guest for events.

Scenarios that Hinder:

1. Charles creates a unique appetizer that becomes essential in Trident.

2. A training academy for event planning starts and graduates are eager to start planning!

3. Nola advertises her price drop on national TV.

6. Nola's costs exceed those of Charles.

7. A water bottling company, the area’s largest employer, hosts the majority of events.

Clarification:

Nola and Charles can only engage in a collusion agreement discreetly due to its illegality. The secretive nature of their agreement hinders its enforceability legally. They are highly likely to enter a prisoner's dilemma situation. Moreover, their diverse cost structures and skills make long-term collusion difficult. Graduates from event planning and other competitors, including the large company responsible for most local events, will likely disrupt the collusion soon.

4 0

1 month ago