The company plans to purchase $22,000 in new equipment during May and $52,000 in new equipment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The company plans to purchase $22,000 in new equipment during May and $52,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $24,000 each quarter, payable in the first month of the following quarter. The company's balance sheet as of March 31 is given below: Assets Cash $ ৪6, 000 Accounta receivable (545,440 February sales; $542, 720 March sales) Inventory Prepaid insurance Property and equipment (net) 588, 160 140,192 27,000 1,070,000 $ 1,911,352 Total assets Liabilities and Stockholders' Equity Accounts payable Dividenda payable $ 112,000 24,000 1,040,000 735,352 $ 1,911,352 Common stock Retained earnings Total liabilities and stockholders equity The company maintains a minimum cash balance of $62,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month. The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded, At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $62,000 in cash. Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. C. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $62,000. 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. C. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the mi cash balance of $62,000. 3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach. 4. A budgeted balance sheet as of June 30. Complete this question by entering your answers in the tabs below. Req 1A Req 18 Reg 10 Req 1D Req 2 Req 3 Reg 4 Prepare a master budget for the three-month period ending June 30 that includes a sales budget, by month and in total. Sales Budget April May June Quarter Budgeted unit sales Selling price per unit Total sales Reg 1A Req 18 > Complete this question by entering your answers in the tabs below. Req 1A Reg IB Req 10 Reg 2 Reg 3 Req 4 Req 1D Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, by month and in total. Earrings Unlimited Schedule of Expected Cash Collections April May June Quarter February sales March sales April sales May sales 0. June sales Total cash collections 0. 2$ < Req 1A Req 10 > Complete this question by entering your answers in the tabs below. Req 1A Req 18 Req 10 Req 1D Req 2 Req 3 Req 4 Prepare a master budget for the three-month period ending June 30 that includes a merchandise purchases budget in units and in dollars. Show the budget by month and in total. (Round unit cost to 2 decimal places.) Earrings Unlimited Merchandise Purchases Budget April May June Quarter Budgeted unit sales Total needs Required purchases Unit cost Required dollar purchases 24 0 $ $ 이 $ < Req 18 Req 1D > Complete this question by entering your answers in the tabs below. Req 1A Req 18 Req 10 Red 1D Req 2 Req 3 Req 4 Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash disbursements for merchandise purchases, by month and in total. Earrings Unlimited Budgeted Cash Disbursements for Merchandise Purchases April May June Quarter Accounts payable April purchases May purchases June purchases 0. Total cash payments < Req 10 Req 2 > oloo Prepare a master budget for the three-month period ending June 30 that includes a cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $62,000. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Earrings Unlimited Cash Budget For the Three Months Ending June 30 April May June Quarter Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Merchandise purchases Advertising Rent Salaries Commissions OOo Oo Prepare a master budget for the three-month period ending June 30 that includes a budgeted income statement for the three- month period ending June 30. Use the contribution approach. Earrings Unlimited Budgeted Income Statement For the Three Months Ended June 30 Variable expenses: Fixed expenses: Prepare a master budget for the three-month period ending June 30 that includes a budgeted balance sheet as of June 30. Earrings Unlimited Budgeted Balance Sheet June 30 Assets Total assets Liabilities and Stockholders' Equity Total liabilities and stockholders' equity < Req 3 Reg 4 The company plans to purchase $22,000 in new equipment during May and $52,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $24,000 each quarter, payable in the first month of the following quarter. The company's balance sheet as of March 31 is given below: Assets Cash $ ৪6, 000 Accounta receivable (545,440 February sales; $542, 720 March sales) Inventory Prepaid insurance Property and equipment (net) 588, 160 140,192 27,000 1,070,000 $ 1,911,352 Total assets Liabilities and Stockholders' Equity Accounts payable Dividenda payable $ 112,000 24,000 1,040,000 735,352 $ 1,911,352 Common stock Retained earnings Total liabilities and stockholders equity The company maintains a minimum cash balance of $62,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month. The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded, At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $62,000 in cash. Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. C. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $62,000. 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. C. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the mi cash balance of $62,000. 3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach. 4. A budgeted balance sheet as of June 30. Complete this question by entering your answers in the tabs below. Req 1A Req 18 Reg 10 Req 1D Req 2 Req 3 Reg 4 Prepare a master budget for the three-month period ending June 30 that includes a sales budget, by month and in total. Sales Budget April May June Quarter Budgeted unit sales Selling price per unit Total sales Reg 1A Req 18 > Complete this question by entering your answers in the tabs below. Req 1A Reg IB Req 10 Reg 2 Reg 3 Req 4 Req 1D Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, by month and in total. Earrings Unlimited Schedule of Expected Cash Collections April May June Quarter February sales March sales April sales May sales 0. June sales Total cash collections 0. 2$ < Req 1A Req 10 > Complete this question by entering your answers in the tabs below. Req 1A Req 18 Req 10 Req 1D Req 2 Req 3 Req 4 Prepare a master budget for the three-month period ending June 30 that includes a merchandise purchases budget in units and in dollars. Show the budget by month and in total. (Round unit cost to 2 decimal places.) Earrings Unlimited Merchandise Purchases Budget April May June Quarter Budgeted unit sales Total needs Required purchases Unit cost Required dollar purchases 24 0 $ $ 이 $ < Req 18 Req 1D > Complete this question by entering your answers in the tabs below. Req 1A Req 18 Req 10 Red 1D Req 2 Req 3 Req 4 Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash disbursements for merchandise purchases, by month and in total. Earrings Unlimited Budgeted Cash Disbursements for Merchandise Purchases April May June Quarter Accounts payable April purchases May purchases June purchases 0. Total cash payments < Req 10 Req 2 > oloo Prepare a master budget for the three-month period ending June 30 that includes a cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $62,000. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Earrings Unlimited Cash Budget For the Three Months Ending June 30 April May June Quarter Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Merchandise purchases Advertising Rent Salaries Commissions OOo Oo Prepare a master budget for the three-month period ending June 30 that includes a budgeted income statement for the three- month period ending June 30. Use the contribution approach. Earrings Unlimited Budgeted Income Statement For the Three Months Ended June 30 Variable expenses: Fixed expenses: Prepare a master budget for the three-month period ending June 30 that includes a budgeted balance sheet as of June 30. Earrings Unlimited Budgeted Balance Sheet June 30 Assets Total assets Liabilities and Stockholders' Equity Total liabilities and stockholders' equity < Req 3 Reg 4
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Fraser had an agreement with ABC Bank that any overdrafts in his chequing account would be automatically covered by a cash advance charged to his credit card. On such advances, Fraser was charged...
-
No More Books Corporation has an agreement with Floyd Bank whereby the bank handles $4 million in collections a day and requires a $400,000 compensating balance. No More Books is contemplating...
-
An oil company plans to purchase a piece of vacan1 land on the comer of two busy streets for $70,000. On properties of this type, the company installs businesses of four different types. *Cost of...
-
Consider a property investment that you finance with 20% down payment. For the remaining, you borrow 2'300'000 at a 6% rate monthly amortized loan for 25 years. This property, with 2% of EBITDA as...
-
Condensed financial information for Prince Company and South Company follows: Separate Statements of Income and Retained Earnings for the Year Ended December 31, 2011 Prince Company purchased 80% of...
-
Find the indicated maximum and minimum values by the method of linear programming. The constraints are shown below the objective function. Maximum P: P = x + 2y x 1, y 0 3x + y 6 2x + 3y 8
-
Distinguish between a financial statement audit, performed by external auditors, and a financial audit, performed by internal auditors.
-
Horace Culpepper, CPA, was retained by Pulsar Cable to prepare financial statements for April 2020. Horace accumulated all the ledger balances per Pulsars records and found the following. Horace...
-
Two Firefighter/Paramedics who work on opposite shifts have an ongoing personality conflict. One of the paramedics Bill Jones (a 40 year old Army veteran) has come to the supervisor on several...
-
Alan and Angel Young are both 36 years old. Mr. Young recently accepted a new job making $93,000 a year and Mrs. Young is currently unemployed. The Youngs have two children (ages 4 and 2), a dog, and...
-
Consider a project for which AoN network and associated crash data are given as follows. Budget for crashing the project is limited to 5 thousand dollars. Define your decision variables and construct...
-
Write the equation for the DuPont equation.
-
Explain in words the difference between net working capital and net operating working capital.
-
Read the following paragraph carefully and answer the question that follows: Clearly, a parallel exists between ecology where humans are viewed as an external factor (disturbance) to the natural...
-
How much would $1,000,000 due in 100 years be worth today if the discount rate was 5%? If the discount rate was 20%?
-
Please read the following quoted remark from Ausubel (1996) very carefully: Segments of the energy economy have advanced impressively toward local ceilings of 100 percent efficiency. However, modern...
-
Which of the following is NOT a typical step during the Adaptation Process of a Climate Change Action Plan? Group of answer choices Greenhouse Gas Inventory Identify Possible Actions Scenario...
-
Using Apple, demonstrate how the differentiation strategy can be well implemented.
-
During the credit crisis in the 2008-2009 periods, banks were criticized for restricting their credit. Write a short essay to explain why you think banks should or should not be allowed to restrict...
-
How do insurance companies finance the real estate market?
-
Explain why many savings institutions experience financial problems at the same time.
-
When a contracting hot ball of gas spins into a disk shape, it cools faster due to (a) increased radiation transfer. (b) increased surface area. (c) decreased insulation. (d) increased convection...
-
The Sun contains what percentage of the solar systems mass? (a) about 35% (b) 85% (c) the percentage varies over time (d) over 99%
-
The nebular theory is based on the observation that the solar system (a) follows patterns indicating that it formed progressively from physical processes. (b) has a structure much like an atom. (c)...
Study smarter with the SolutionInn App