User Account

All Pages

Prepare cash budget for the quarter ending december

Assignment Help Managerial Accounting
Reference no: EM132999606

Question - Golden Point Company has applied at a local bank for a short-term loan of $150,000 starting on October 1, 2020. The bank's loan officer has requested a cash budget from the company for the quarter ending December 31, 2020. The following information is needed to prepare the cash budget:

Sales $600,000

Purchases 350,000

Salaries and wages to be paid 125,000

Rent payments 7,000

Supplies (payments for) 4,500

Insurance payments 1,500

Other cash payments 22,000

A cash balance of $24,000 is planned for October 1. Accounts receivables are expected to be $48,000 on October 1. All of these accounts will be collected in the quarter ending December 31. In general, sales are collected as follows: 90% in the quarter of sale, and 10% in the quarter after sale. Accounts payable will be $480,000 on October 1 and will be paid during the quarter ending December 31. All purchases are paid in the quarter after purchase.

Required -

a) Prepare cash budget for the quarter ending December 31, 2020. Assume that the $150,000 loan will be made on October 1 and will be repaid with interest at 10% on December 31.

b) If the company desires a minimum cash balance of $18,000, will the company be able to repay the loan as planned on December 31?

Reference no: EM132999606

Questions Cloud

What is the correct estimated premiums payable : The company sold 12,000 units of washing machine during the current year. What is the correct estimated premiums payable as of December 31, 2020
Prepare the corrected unadjusted trial balance at june : A $400 purchase of supplies on account was neither journalized nor posted. Prepare the corrected unadjusted trial balance at June 30, 2020
Develop a cost benefit analysis for dmc : Develop a cost benefit analysis for DMC regarding fixing potholes and repairing other damages In its parking lots and driveways. Report presenting g to CFO to a
Journalize the above transactions in a two-column journal : Journalize the above transactions in a two-column journal and Post the journal entries to "T" accounts
Prepare cash budget for the quarter ending december : Prepare cash budget for the quarter ending December 31, 2020. Assume that the $150,000 loan will be made on October 1 and will be repaid
Describe one substantive test of detail : For each assertion at risk outlined in (b), describe one substantive test of detail that is specifically responsive to each risk of material misstatement
How could the market shortage for the concert tickets : However, there were only 30,000 tickets available to distribute. How could the market shortage for the concert tickets be avoided
Find out total value of sales : In respect of a factory the following figures have been obtained for the year 2020: Cost of material RM600,000; Find out total value of sales
Calculate the amount of revenue and gross profit : Westgate recognizes revenue over time according to percentage of completion. Calculate the amount of revenue and gross profit

Reviews

Write a Review

Managerial Accounting Questions & Answers

  What productive asset should generally be classified as cash

In a statement of cash flows, receipts from sales of property , plant and equipment and other productive assets should generally be classified as cash inflows

  Calculate and explain variances that would help blake assess

Calculate and explain the variances that would help Blake assess whether renting the new milling machine reduced material waste and labor time

  Net operating income will increase by what amount

If sales increase by 10%, net operating income will increase by what amount? Bloomington Corporation reported on their contribution format.

  Calculate the breakeven point give the cost structure

Calculate the breakeven point give the following cost structure. Be sure to properly label your answer and watch your decimals

  How calculate the copy department costs allocated to sales

During the year, 2,613,100 for sales and 2,074,800 for administration, calculate the copy department costs allocated to sales and administration.

  What is the net income under the absorption costing

Fixed manufacturing costs - P2,000; Fixed selling, general, and administrative costs - P1,000; What is the net income under the absorption costing

  Find how can firms use the budget and other information

Find How can firms use the budget and other information to evaluate the performance of individuals and of the firm. What are some method that can be used.

  Compute cost of direct material used month of december

Compute the cost of direct materials used during the month of December.

  Should nolan tell the appropriate softech officials

Should Nolan tell the appropriate SofTech officials that Borman has postponed the paper order and Describe the steps that Nolan should take to resolve

  Do you need additional training in specific areas

Do you need additional training in specific areas of communication? How might you improve your current communication skills to prepare you for advancement in your profession? Use 3-4 references to support your analysis.

  What is actual total direct labor cost for current period

Direct labor rate variance and a $4,260 favorable direct labor efficiency variance. What is the actual total direct labor cost for the current period?

  What the income or loss under variable costing is

What the income (loss) under variable costing is? variable selling and administrative costs per unit, $1; and fixed selling and administrative costs, $224,000.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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