User Account

All Pages

Prepare a cash budget for the quarter ending December

Assignment Help Managerial Accounting
Reference no: EM133014505

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 a 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: EM133014505

Questions Cloud

What is the one year real rate of interest : Treasury bills are yielding 6.87%. Based on the domestic Fisher effect (actual, not approximation), what is the one year real rate of interest
What are the equivalent units of production for conversion : As of September 1, the beginning WIP Inventory was 45% completed as to labor and overhead. What are the equivalent units of production for conversion
Discuss potential dangers of a cyberterrorist attack : What are the differences between cyberterrorists, hactivists, and state-sponsored attackers and Describe cyberterrorism and discuss potential dangers
What is the cost assigned to job at the end of the week : Assignment of $500 of raw materials inventory to Job 5. What is the cost assigned to Job 5 at the end of the week
Prepare a cash budget for the quarter ending December : Prepare a 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
Hotel and restaurant service management : Compose a professional email to adress the following questions:Why are you at Seneca
Provide an example of government economic intervention : Provide an example of government economic intervention designed to influence, regulate, or control trade for a specific industry from one of the articles and su
Disadvantages of the communication styles : 1. 3 advantages and 3 disadvantages of the following communication styles:
Define the adjustment process : Define the adjustment process and List and Explain its four stages.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  What was indiana corporation net operating income

Indiana Corporation produces a single product that it sells for $9 per unit. During the first year of operations, 100,000 units were produced, and 90,000 units were sold.

  Which one of the capital budgeting method

The time value of money is explicitly considered in which one of the following capital budgeting method(s)? Net present value (NPV) method.

  Determine for fy the inventory turnover ratio

Use the information to determine for FY 2017 the inventory turnover ratio (Round & enter your answers to one decimal place and enter the value.)

  Calculate the amounts for the month of october

Calculate the amounts for the month of October. The assignment of production costs to the October 31 work in process inventory and to goods transferred out.

  Discuss the relevance of standard costing

Briefly discuss the features of standard costing as a planning and control system and Discuss what target costing is and compare and contrast it from standard

  Compute the break-even sales under the proposed program

Compute the break-even sales (units) under the proposed program for the following year. Enter the final answers rounded to the nearest whole number.

  How should mm account for the given offering with stone

How should MM account for the above offering with Stone under new revenue recognition model? The app sold to Stone is actually downloaded more than 500K times.

  What is the cost of owning

Big Sky Mining Company must install $1.5 million,What is the cost of owning? What is the cost of leasing? What is the NAL of the lease?

  Compute erkens company predetermined overhead

Prepare journal entry to close overapplied or underapplied overhead into cost of goods sold on April 30. Compute Erkens Company's predetermined overhead

  How justify whether product w converted into product w-one

Product X (6,000 units at RM10 per unit) - RM60,000. Justify whether product W can be converted into product W1 solely on the basis of financial considerations.

  Should the company purchase the new warehouse

Provide one qualitative factor that might cause the company to reach a different conclusion than the one reached in requirement

  What are the advantages and limitation of ratio analysis

What are the advantages & limitation of Ratio Analysis? Calculate two ratios that can used to measure the firm's ability to meet its long-term obligations

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