Prepare a cash receipts schedule for each month

Assignment Help Managerial Accounting
Reference no: EM132719830

Cash dividends for the store of $710 thousand are declared during the third month of each quarter and are paid during the first month of the following quarter. Operating expenses, except insurance, rent, and depreciation are paid as incurred. The prepaid insurance is for five more months. Cost of goods sold is equal to 60% of sales. Ending inventories are sufficient for 150% of the next month's cost of sales. Purchases during any given month are paid in full during the following month. Cash sales account for 50% of the revenue. Of the credit sales, 60% are collected in the next month and 40% are collected in the month after. Money can be borrowed and repaid in multiples of $100 thousand at an interest rate of 12% per year. The company desires a minimum cash balance of $2 million on the first of each month. At the time the principal is repaid, interest is paid on the portion of principal that is repaid. All borrowing is at the beginning of the month, and all repayment is at the end of the month. Money is never repaid at the end of the month it is borrowed.

Question 1: Prepare a cash receipts schedule for each month of the second quarter ending June 30.

Reference no: EM132719830

Questions Cloud

What was akshara cash flow to creditors : What was Akshara's cash flow to creditors in 2019? Explain briefly about this cash flow. Akshara Bhd.'s long term debt in 2018 and 2019 were, respectively, RM3.
Demonstrate expert english language skills : Demonstrate a critical awareness of previous research in an IT context within a chosen topic area through a basic understanding of research theory and technique
How does cultural values and norms influence the issue : We are at the halfway point if you can believe it! This week you are going to compose the second half of your paper. This part of the paper explores.
What is this manager MSP : The minimum labor cost for staying open one extra hour is 125.00 Rounded up to the nearest dollar, what is this manager's MSP
Prepare a cash receipts schedule for each month : Cash dividends for the store of $710 thousand are declared. Prepare a cash receipts schedule for each month of the second quarter ending June 30.
Compute the common fixed expenses for Meyer Corporation : Meyer Corporation reported a total net operating income of $52,000. Compute the common fixed expenses for Meyer Corporation
Compute what is the present value of the po mbs : Principal-Only MBS and Interest-Only MBS, What is the present value of the PO MBS if we use an annual risk-free rate of 4.5% to value the cash-flows?
What is the share price at the end of the first year : The last dividend was $0.45, and the required rate of return on the shares is 11%. What is the share price (estimated) at the end of the first year
What is the total amount of the prepayments : What is the total amount of the prepayments if the rate of prepayments increases to 200 PSA? What is the total amount of the prepayments?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  How much cash can kayapa plan to collect in september

How much cash can Kayapa plan to collect in September from sales made in August? Kayapa Corporation is a retailer whose sales are all made on credit.

  Determine whatpredetermined manufacturing overhead rate

Determine What is the predetermined overhead rate? Estimated manufacturing overhead cost, Estimated total amount of the allocation Base

  Prepare the acquisition analysis at acquisition date

ACC204 Corporate Accounting and Reporting Assignment, King's Own Institute, Australia. Prepare the acquisition analysis at acquisition date

  Find what is total amount of interest paid to pass-through

Mortgage Pass-Throughs, Assuming a prepayment multiplier of 100 PSA what is the total amount of interest paid to the pass-through investors?

  Compute the price and quantity variances

Monthly budgeted fixed overhead is $14,000. Revenues for the month were $75,000, and selling and administrative expenses were $5,000. Compute the price and quantity variances for direct materials and direct labor. Compute the total overhead variance

  Find what is collection period

If a firm has total accounts receivable of $6,000,000 and its average daily credit sales are $45,000 what is its collection period? Provide the suitable example

  How the direct materials quantity variance is

Georgia, Inc. has collected the following data on one of its products. The direct materials quantity variance is?Direct materials standard (3 lbs @ $1/lb)

  How will impact the holding of a Responsibility Center

How can/should the Accounting Department make this determination and how will this impact the holding of a Responsibility Center accountable

  Should green cord accept the outside offer

Should Green Cord accept the outside offer? How many boxes of cords should be purchased from the outside supplier and how many should be made by Green Cord?

  Prepare the appropriate journal entry for brook to record

Prepare the appropriate journal entry for Brook to record its income taxes for the year. At what amount would Brook measure the tax benefit

  Calculate the profit per unit and the return on sales

Calculate the profit per unit and the return on sales for both products using The traditional absorption method(on a direct-labour-hour basis)

  Make a direct materials budget for april and may and june

Prepare a direct materials budget for April, May, and June. Ramos Co. provides the sales forecast and production budget for the next four months

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