Prepare the monthly cash budget for blue bill corporation

Assignment Help Financial Accounting
Reference no: EM131527566

Assignment: Cash Budget

Sales for Blue Bill Corporation are projected as follows for the months of June through November:

June $200,000
July 200,000
August 200,000
September 300,000
October 500,000
November 200,000

Credit sales account for 70% of the monthy sales and are collected one month after the sale.
Other receipts for October are $50,000.
Variable disbursements are 60% of sales each month.
Fixed disbursements are $10,000 each month.
$80,000 should be included in August for taxes.
The company is obligated to make a $400,000 debt repayment in November.
Beginning cash in June is $50,000.
Desired ending cash each month is $10,000.

Complete the monthly cash budget for Blue Bill Corporation for June through November.

Blue Bill Corporation
Cash Budget
 




 
  June July August September October  November
Sales            
Cash sales             
Collections            
Other Receipts            
Total cash receipts            
 




 
Variable disbursements             
Fixed disbursements            
Other disbursements            
Total cash disbursements            
 




 
Net change during the month            
 




 
Beginning cash            
Ending cash            
Required cash            
Excess cash to invest            
Cash borrowed            

Reference no: EM131527566

Questions Cloud

Determine the gross profit as a percent of net sales : Walgreen Company operates drugstores throughout the United States, selling prescription drugs, general merchandise, cosmetics, food, and beverages.
Allowing employees of an organization : State two advantages and two disadvantages of allowing employees of an organization, other than systems administrators and security personnel.
Determine cvs gross profit : Based upon the data shown in Exercises I and II, comment on the operating performance of CVS in comparison to Walgreen.
Letter ciphers and polyalphabetic ciphers : Describe multi letter ciphers and polyalphabetic ciphers. Discuss how secure they are.
Prepare the monthly cash budget for blue bill corporation : Sales for Blue Bill Corporation are projected. Prepare the monthly cash budget for Blue Bill Corporation for June through November.
The life of the average working american during this period : Summarize how industrialization affected the life of the average working American during this period. Use specific examples and details.
Search engine retain your searches : How long does your search engine retain your searches?
Compute the gross profit as a percent of sales : During the current year, merchandise is sold for $200,000 cash and for $950,000 on account. The cost of the merchandise sold is $805,000.
Why do browsers have these private modes : Why do browsers have these private modes? Take one of the above browsers and explain how to use the private mode.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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