User Account

All Pages

Prepare a cash budget by quarter and in total for year 2

Assignment Help Accounting Basics
Reference no: EM13576455

The president of Univax, Inc., has just approached the company's bank seeking short-term financing for the coming year, Year 2. Univax is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be needed, as well as the amounts that will be needed and the quarters in which repayments can be made.

   To provide this information for the bank, the president has directed that the following data be gathered from which a cash budget can be prepared:
a.

Budgeted sales and merchandise purchases for Year 2, as well as actual sales and purchases for the last quarter of Year 1, are as follows:

Sales Merchandise
Purchases
  Year 1:

     Fourth quarter actual $420,000     $320,000    
  Year 2:      
     First quarter estimated $520,000     $400,000    
     Second quarter estimated $620,000     $450,000    
     Third quarter estimated $720,000     $510,000    
     Fourth quarter estimated $600,000     $380,000    

b.

The company typically collects 38% of a quarter's sales before the quarter ends and another 60% in the following quarter. The remainder is uncollectible. This pattern of collections is now being experienced in the actual data for the Year 1 fourth quarter.
c.

Some 10% of a quarter's merchandise purchases are paid for within the quarter. The remainder is paid in the following quarter.
d.

Selling and administrative expenses for Year 2 are budgeted at $81,000 per quarter plus 8% of sales. Of the fixed amount, $22,000 each quarter is depreciation.
e. The company will pay $11,000 in cash dividends each quarter.
f.

Land purchases will be made as follows during the year: $88,000 in the second quarter and $49,200 in the third quarter.
g.

The Cash account contained $43,000 at the end of Year 1. The company must maintain a minimum cash balance of at least $41,000.
h.

The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each quarter, up to a total loan balance of $100,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the year.
i. At present, the company has no loans outstanding.
Required:
1a.

Prepare a schedule of expected cash collections on sales by quarter and in total for Year 2. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)
Schedule of Expected Cash Collections

Year 2 Quarter

First Second Third Fourth Total
  Year 1 - Fourth quarter sales $    $    $    $    $   
  Year 2 - First quarter sales               
  Year 2 - Second quarter sales               
  Year 2 - Third quarter sales               
  Year 2 - Fourth quarter sales               






  Total cash collections $    $    $    $    $   







1b.

Prepare a schedule of expected cash disbursements for merchandise purchases, by quarter and in total for Year 2. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)
Schedule of Expected Cash Disbursements-Merchandise Purchases

Year 2 Quarter

First Second Third Fourth Total
  Year 1 - Fourth quarter purchases $    $    $    $    $   
  Year 2 - First quarter purchases               
  Year 2 - Second quarter purchases               
  Year 2 - Third quarter purchases               
  Year 2 - Fourth quarter purchases               






  Total cash disbursements $    $    $    $    $   







2.

Compute the expected cash disbursements for selling and administrative expenses, by quarter and in total, for Year 2. (Omit the "$" sign in your response.)

Cash
Disbursements
  First $    
  Second $    
  Third $    
  Fourth $    


  Year $    



3.

Prepare a cash budget by quarter and in total for Year 2. (Input all amounts as positive values except cash deficiency, repayments and interest which should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)
Univax, Inc.
Cash Budget

Year 2 Quarter

First Second Third Fourth Year
  Cash balance, beginning $    $    $    $    $   
  Add collections from sales               
  




  Total cash available               
  




  Less disbursements:               
     Merchandise purchases               
     Operating expenses               
     Dividends               
     Land               
  




  Total disbursements               
  




  Excess (deficiency) of receipts
  over disbursements		               
  




  Financing:               
     Borrowings               
     Repayments               
     Interest               
  




     Total financing               
  




  Cash balance, ending $    $    $    $    $   
  





Reference no: EM13576455

Questions Cloud

Action ltd owns 100 percent of the shares of jackson ltd : action ltd owns 100 percent of the shares of jackson ltd acquired on 1 july 2011 for 3.5 million when the shareholders
Many tax planning strategies are imbedded in provisions of : many tax planning strategies are imbedded in provisions of the tax law however tax planners and tax preparers may push
Using relative frequency assessment what is the probability : 1. the bw company produces two models of products as shown
Consider the ages of ceos of companies throughout the : question consider the ages of ceos of companies throughout the united states.event a ceo is under 40event b ceo is at
Prepare a cash budget by quarter and in total for year 2 : the president of univax inc. has just approached the companys bank seeking short-term financing for the coming year
Question in each of the following statements identify what : question in each of the following statements identify what is wrong.a. the probability that a randomly selected person
Bones and skeletal tissues case study on bone tissue : case study on bone tissue structure and repair ltbrgtmrs. debbie morgan is a 45-year-old female who works as a
Go to sec web site httpwwwsecgov under filings and forms : go to sec web site httpwww.sec.gov under filings and forms edgar click on search for company filings. click on
Prepare separate entries for each transaction for bristol : on june 10 lipizzaner crab shack purchased 6000 of merchandise from bristol company fob shipping point terms 210 n30.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What are impairments

Impairments are: a) recognized as a realized loss if the impairment is judged to be temporary. b) based on fair value for available-for-sale investments and on negotiated values for held-to-maturity investments.

  Analog computers needs to borrow 785000 from the midland

analog computers needs to borrow 785000 from the midland bank. the bank requires a 13 compensating balance. how much

  Computing-journalizing payroll amounts

Compute Welch's gross pay, payroll deductions, and net pay for the full year 2012. Round all amounts to the nearest dollar. Compute United's total 2012 payroll expense for Welch.

  Company p purchased an 80 interest in company s on january

company p purchased an 80 interest in company s on january 1 20x3 for 800000. on the purchase date company s

  Property tax purposes

Hurd Company acquired a building valued at $160,000 for property tax purposes in exchange for 10,000 shares of its $5 par common stock. The stock is widely traded and selling for $15 per share.

  Which of the following statements best explains segmenting

which of the following statements best describes segmenting in contrast to combining?a segmenting tends to focus more

  Journal entries to record transactions and adjustments

Prepare journal entries to record these transactions and adjustments for 2008 and 2009.

  Per unit selling price for product

The 30,000 units can be sold at this stage for $750,000. Alternatively, it can be further processed at a $450,000 total additional cost and be converted into 6,000 units of Product B and 12,000 units of Product C. Per unit selling price for Produc..

  Headings for a monthly bank reconciliation

Prepare a table with the headings for a monthly bank reconciliation dated September 30 - Bank service charge for September

  The company desires a 35 profit margin per hour of labor

padong remanufacturing rebuilds spot welders for manufacturers. the following budgeted cost data for 2006 is available

  Select two 2 public corporations in the industry with which

choose two 2 public corporations in an industry with which you are familiar - one 1 that has acquired another company

  Soon after beginning the year-end audit work on march 10 at

soon after beginning the year-end audit work on march 10 at engone company the auditor has the following conversation

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