Prepare schedule of expected cash collections from sales

Assignment Help Accounting Basics
Reference no: EM131914750

Problem - The balance sheet of Phototec, Inc., a distributor of photographic supplies, as of May 31 is given below:

Phototec, Inc. Balance Sheet May 31

Assets

Cash

$7,000

Accounts receivable

91,000

Inventory

36,000

Buildings and equipment, net of depreciation

690,000

Total assets

$824,000

Liabilities and Stockholders' Equity

Accounts payable

$75,000

Note payable

34,000

Capital stock

610,000

Retained earnings

105,000

Total liabilities and stockholders' equity

$824,000

The company is in the process of preparing a budget for June and has assembled the following data:

a. Sales are budgeted at $450,000 for June. Of these sales, $70,000 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder is collected the following month. All of the May 31 accounts receivable will be collected in June.

b. Purchases of inventory are expected to total $390,000 during June. These purchases will all be on account. Forty percent of all inventory purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the May 31 accounts payable to suppliers will be paid during June.

c. The June 30 inventory balance is budgeted at $50,000 .

d. Selling and administrative expenses for June are budgeted at $65,000 , exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $3,900 for the month.

e. The note payable on the May 31 balance sheet will be paid during June. The company's interest expense for June (on all borrowing) will be $800 , which will be paid in cash.

f. New warehouse equipment costing $14,000 will be purchased for cash during June.

g. During June, the company will borrow $37,000 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.

Required:

1a. Prepare schedule of expected cash collections from sales and a schedule of expected cash disbursements for inventory purchases.

1b. Prepare a cash budget for June.

2. Prepare a budgeted income statement for June.

3. Prepare a budgeted balance sheet as of June 30.

Reference no: EM131914750

Questions Cloud

Calculate minis total income tax expense : Assuming that the U. S. tax rate is 35%, calculate Mini's total income tax expense, current income tax expense, and deferred income tax expense.
Drawbacks of video evidence : Video is normally pretty solid evidence, but what are some of the drawbacks of video evidence that, as a prosecutor, you should be aware of?
Did supreme court reach a wise decision in the heller case : In Chicago, 32 public school students died of gunshot wounds in 2009.4 In all of Australia in 2008, by contrast, 30 people died by gun homicide.
What are the primary permissions in a posix file system : What are the three primary permissions in a POSIX file system? Can you explain their meaning? What do you think might happen to permissions on a file that leave
Prepare schedule of expected cash collections from sales : Prepare schedule of expected cash collections from sales and a schedule of expected cash disbursements for inventory purchases
Reviews and information available : If you did not see the movie, there are many reviews and information available on it.
Display a javascript program : Display a JavaScript program that asks the user to enter the weight of a person in kilograms and outputs the equivalent weight in pounds
Explain marketing role in coordinating : Select two of the following departments and explain marketing's role in coordinating their distinct functions:
What value should be attributed to land in a balance sheet : Mittelstaedt Inc.,buys 60 percent of the outstanding stock. What value should be attributed to the land in a consolidated balance sheet at the date of takeover?

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