Prepare schedule that discloses firm total cash collections

Assignment Help Managerial Accounting
Reference no: EM132756289

Question - Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company's accounting records:

All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

Seventy percent of the merchandise purchases are paid for in the month of purchase; the remaining 30 percent are paid for in the month after acquisition.

The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $85,000; accounts receivable, $205,000; and accounts payable, $74,000.

Mary and Kay, Inc., maintains a $85,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

Additional data:

 

January

February

March

Sales revenue

$530,000

$620,000

$635,000

Merchandise purchases

350,000

380,000

500,000

Cash operating costs

101,000

80,000

143,000

Proceeds from sale of equipment

-

-

23,000

Required -

1. Prepare a schedule that discloses the firm's total cash collections for January through March.

2. Prepare a schedule that discloses the firm's total cash disbursements for January through March.

3. Prepare a schedule that summarizes the firm's financing cash flows for January through March.

Reference no: EM132756289

Questions Cloud

What is the pure bond value of this convertible bond : If similar bonds, which are not convertible, are currently yielding 10 percent, what is the pure bond value of this convertible bond
By how much does diversification reduce the var : The correlation between stock price returns is 0.2. What is a 10-day 99% VaR using only deltas? By how much does diversification reduce the VaR
Make journal entry to record issuance of convertible bonds : Metlock Corporation sold 15-year, 8% convertible bonds (par value of $1,000) for $900,000 cash. Make journal entry to record issuance of convertible bonds
Functional capability : Identify key functional areas of your venture. Critique the capability level of these functional areas;
Prepare schedule that discloses firm total cash collections : Mary and Kay, Inc., maintains a $85,000 minimum cash balance at all times. Prepare schedule that discloses firm total cash collections
Value chain analysis : Analyze the value chain of your entrepreneurial venture by looking at structural (such as capital requirements) and executional drivers
Management at company : Evaluate management's decision on its use of vendors and spokespersons. Indicate the organizational impact of these decisions.
Provide the journal entry for the period payroll : Retirement savings withheld from employee paychecks were $2,800 for the period. Provide the journal entry for the period's payroll
Donor motivations to increase fundraising effectiveness : How does a fundraiser use donor motivations to increase fundraising effectiveness?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd