Make a cash budget for the quarter ending December

Assignment Help Managerial Accounting
Reference no: EM133011524

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) Make 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: EM133011524

Questions Cloud

How will impact their financial statements for current year : How will impact their financial statements for the current year? In the current year, Stuffy the Bear sold teddy bears they bought for $30,000
What is the ocf for the project : The project is estimated to generate $2.23 million in annual sales, with costs of $1.25 million. If the tax rate is 30% what is the OCF for this project?
What level of sales growth can it sustain : Question - Rowan Ltd has a profit margin of 7.6 per cent, a debt ratio of 56 per cent, total assets of $5,236,350, what level of sales growth can it sustain
What is the npv of project for happy jacks hot dogs : System requires an initial investment in net working capital of $35,000. If the tax rate is 30% and the discount rate is 8%, what is the NPV of this project?
Make a cash budget for the quarter ending December : Make 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
What is henry purchase price : Henry is planning to purchase a Treasury bond with a coupon rate of 2.16%. If Henry purchased this bond on 6 March 2020, what is his purchase price?
What is the balance of the unearned interest income : The interest rate on the loan is 10% payable annually starting December 31, 2020. What is the balance of the unearned interest income
What is purchase price for henry : If Henry purchased this bond on 6 March 2020, what is purchase price (rounded to four decimal places)? Assume a yield rate of 3.12% p.a. compounded half-yearly.
What was the depreciation expense for the asset : The equipment cost $60,000 and has an estimated life of 8 years and a salvage value of $8,000. What was the depreciation expense for the asset

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