Cash budget for the month of july

Assignment Help Financial Accounting
Reference no: EM13505173

The following information is used for Lucky's Inc. s monthly master budget.

June's balance sheet balances:

Cash

$10,500

Accounts payable

$53,760

Accounts receivable

$80,000

Capital stock

$260,000

Inventory

$26,000

Retained earnings

$2,740

Building and equipment (net)

$200,000



Actual sales for June and budgeted sales for July, August, and September:

June (actual)

$140,000

July (budget)

$320,000

August (budget)

$180,000

September (budget)

$200,000

Sales are 25% cash and 75% on credit. All credit sales are collected in the following month. There are no bad debts.

Gross margin percentage is 60% of sales.

The desired ending inventory is expected to be 20% of the following month's cost of goods sold. One fifth of the purchases are by Savings Addon" paid for in the month of purchase, and the remaining balance is purchased on credit and paid in the following month.

The monthly cash operating expenses are $80,000, including the monthly depreciation expense of $7,000.

During July, Lucky's Inc. will purchase new office equipment for $17,000 cash.

Dividends of $13,500 were declared and by Savings Addon" in paid in July.

The company must maintain a minimum cash balance of $25,000. A by Savings Addon" line of credit is used to maintain this balance.

Borrowing will be made in increments of $1,000. All borrowing is done at the beginning of the month, and repayments are made at the end of the month. The annual interest rate is 12%, paid when the loan is repaid (ignore accrual of interest).

Required:

Prepare a balance sheet, income statement, and cash budget for the month of July.

Reference no: EM13505173

Questions Cloud

Which products should be processed beyond split-off point : Each product may be sold at the split-off point or processed further. Joint production costs of $95,000 per year are allocated to the products based on the relative number of units produced.
What is the angular speed of precession : A bicycle wheel of radius 20 cm is mounted at the middle of an axle 43 cm long. The tire and rim weigh 24 N. The wheel is spun at 13 rev/s, What is the angular speed of precession
Define the henderson-hasslebach equation : A buffer solution contains acetic acid (HC2H3O2) at a concentration of 1.15 M and sodium acetate (NaC2H3O2) at a concentration of 2.05 * 10 to -2 M. The value of Ka for acetic acid is 1.75 * 10 to -5. Calculate the pH of this solution using the He..
What is the net monetary advantage : What is the net monetary advantage (disadvantage) of processing Product X beyond the split-off point?
Cash budget for the month of july : Prepare a balance sheet-income statement and cash budget for the month of July - fifth of the purchases are by Savings Addon" paid for in the month of purchase, and the remaining balance is purchased on credit and paid
Determine how far from the base of the hill does he end up : Josh starts his sled at the top of a 3.0 m high hill that has a constant slope of 25°. After reaching the bottom, he slides across a horizontal patch of snow. How far from the base of the hill does he end up
Explain the standardenthalpy of atomization for sodium : The standard enthalpy of atomization of an element is the energyrequired to convert 1 mole of an element in its most stable form at25 centigrade to 1 mole of monatomic gas. Given that the standardenthalpy of atomization for sodium is 108.4 kJ mol-..
Explain what is the new ph : Suppose you have 260.0 mL of a 0.320 M NaC2H3O2 solution. You add 260.0 mL of a 0.320 M HCl solution to it. What is the new pH
Explain completely neutralizes stomach acid : Completely neutralizes stomach acid (HCl, .10M) How much carbon dioxide is made at STP conditions (37C, 767 torr, 100% humid) by ingesting one 1.834 gram tablet

Reviews

Write a Review

Financial Accounting Questions & Answers

  Using the given information calculate the pricing

using the given information calculate the pricing decision.relevant costs special sales order-idle versus full capacity

  Multiple choice questions related to book value and

multiple choice questions related to book value and reinsurance1. on july 1 year 1 pampg company purchased 24000 of

  Make a flexible budgeted income statement

Make a Flexible Budgeted Income Statement using variable costing

  What are the basic financial statements

What are the limitations of the information that you provide to the management team? How can the management team ensure that they obtain a complete picture of the enterprise?

  Evidence of extensive research beyond the prescribed texts

Evidence of extensive research beyond the prescribed texts is required. Ensure these are referenced appropriately in your references using Harvard referencing.

  What is the amount of stockholders equity

On July 1 of the current year, the assets and liabilities of Wong Industries, are as follows: Cash, $15,000; Accounts Receivable, $12,300; Supplies, $3,100; Land, $35,000; Accounts Payable, $8,700. What is the amount of stockholders’ equity as of..

  Prepare the adjusting entry

Criss Company has a credit balance of $2,200 in Allowance for Doubtful Accounts before adjustment. The estimated uncollectibles under the percentage of receivables basis is $5,800. Prepare the adjusting entry. Prepare the adjusting entry.

  Illustrate what should campbell record enacted tax rates

Illustrate what should Campbell record as a net deferred tax asset or liability for the year ended Dec 31 2011 assuming that the enacted tax rates in effect are 40% in 2011 and 35% in 2012?

  What would be the proper way to handle these assets

Would I segregate them on the balance sheet as non revenue producing assets, not depreciate them but instead analyze them for impairment annually and then potentially write them down annually.

  Why are the traditional management accounting measure

why are the traditional management accounting measure performance misleaded and irrelevant in the new manufactoring evnironment.

  Compute the unit variable cost for a helmet

Compute the unit variable cost for a helmet - evaluatethe unit variable cost  with the given data.

  What consequences positive or negative might this have

The monitoring of costs has been continuing, and balance sheets are looking worse. What consequences, positive or negative, might this have for fraud prevention, both now and in the future?

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