The president of univax inc has just approached the

Assignment Help Accounting Basics
Reference no: EM13595055

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 MerchandisePurchasesYear 1: Fourth quarter actual $250,000 $150,000 Year 2: First quarter estimated $350,000 $230,000 Second quarter estimated $450,000 $280,000 Third quarter estimated $550,000 $340,000 Fourth quarter estimated $430,000 $210,000 b. The company typically collects 48% of a quarter's sales before the quarter ends and another 50% 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 20% 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 $85,000 per quarter plus 10% of sales. Of the fixed amount, $15,000 each quarter is depreciation.e. The company will pay $10,000 in cash dividends each quarter.f. Land purchases will be made as follows during the year: $86,000 in the second quarter and $47,500 in the third quarter.g. The Cash account contained $26,000 at the end of Year 1. The company must maintain a minimum cash balance of at least $24,000.h. The company has an agreement with a local bank that allows the company to borrow in increments of $10,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.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 "tiny_mce_markerquot; sign in your response.)Univax, Inc.Cash BudgetYear 2 QuarterFirst Second Third Fourth YearCash balance, beginning $ $ $ $ $ Add collections from sales Total cash available Less disbursements: Merchandise purchases Operating expenses Dividends Land Total disbursements Excess of receiptsover disbursements Financing: Borrowings Repayments Interest Total financing Cash balance, ending $ $ $ $ $

Reference no: EM13595055

Questions Cloud

What is the molar concentration of 200 ml of an aqueous : question what is the molar concentration of 20.0 ml of an aqueous solution of hcl that requires 32.0 ml of 0.0260 m
Troto company has total fixed costs of 6000000 and total : troto company has total fixed costs of 6000000 and total variable cost of 3000000 at a volume level of 300000 units.
The mermaid company sells one product with a variable cost : the mermaid company sells one product with a variable cost of 5 per unit. the company is unsure what price to charge in
Assess the value obtained indicating why the result is only : given that the density of solid sodium is 0.968 gcm3 estimate the atomic metallic radius of a na atom. assess the value
The president of univax inc has just approached the : the president of univax inc. has just approached the companys bank seeking short-term financing for the coming year
A glycine buffer is prepared by mixing 100 ml of 10m : question a glycine buffer is prepared by mixing 100 ml of 1.0m glycine ph 6.0 with 100 ml of 0.5m naoh and 300 ml of
The west division of cecchetti coporation had average : the west division of cecchetti coporation had average operating assets of 240000 and net operating income of 42200 in
The specific heat of toluene c7h8 is 113 jg k how many : the specific heat of toluene c7h8 is 1.13 jg k. how many joules of heat are needed to raise the temperature of 50.0 g
Land inc has retained earnings of 800000 and total : land inc. has retained earnings of 800000 and total stockholders equity of 2000000. it has 200000 shares of 5 par value

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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