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?

User Account

All Pages