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

  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