Completed the budget schedules for newport

Assignment Help Financial Accounting
Reference no: EM131293788

The following is available for the Newport Stationery Store:

Balance Sheet Information for September 30, 2016:

Current Assets .

Cash $12,000

Accounts Receivable 10,000

Inventory 63,600

Equipment (net) 100,000

Liabilities 0

Recent and Anticipated Sales

September $40,000

October 48,000

November 60,000

December 80,000

January 36,000

Sales: Sales are for cash (75%) and credit (25%).

Assume that all credit sales are collected within 30 days of sale. All accounts receivable on September 30 are from September sales.

Operating Costs: Rent, $750; Salaries and wages average 15% of monthly sales; other operating expenses excluding depreciation, 4%; Depreciation is $1000 per month. Assume all expenditures are paid each month.

Purchases: Newport maintains an ending merchandise inventory each month equal to next month’s sales plus $30,000. Terms on purchases are 2/10, n/30. Newport takes all discounts and treats these discounts as other income on the income statement. Gross margin averages 30% of sales.

Cash Balances: Newport must maintain a minimum cash balance of $8,000. Assume all borrowing is made on the 1st of the month and repaid at the end of the month when funds are available. Loans are made in increments of $1000 and management does not want to borrow any more than necessary. The interest rate is 6% and is repaid when funds are available.

Other Information: Newport is replacing some store fixtures and is planning on spending $600 in October and $400 in November. Newport is capitalizing these expenditures.

Required:

1. Completed the budget schedules for Newport.

2. Prepare a budgeted income statement and balance sheet for the 4th quarter 2016.

Reference no: EM131293788

Questions Cloud

Prepare appropriate adjusting entry for vacations earned : JWS Transport Company’s employees earn vacation time at the rate of 1 hour per 40-hour work period. The vacation pay vests immediately (that is, an employee is entitled to the pay even if employment terminates). Prepare the appropriate adjusting entr..
Represents an above the line deductions : The UNICAP rules tell you what expenditures must be. Which of the following represents an “above the line” deductions?
Prepare a case brief on wesley henson vs allen reddin : Prepare CASE BRIEF on Wesley Henson v. Allen Reddin, Ivancic v. Olmstead and Kim Gallegly Wesson v. Wal-Mart stores. This must be orginial work. No plagriam. Instructions are attached. Only bid if you are fimilar with case briefs.
Determine the outlet temperature of the cooling air : Determine the outlet temperature of the cooling air and the rate of entropy production in the air passing through the projector.
Completed the budget schedules for newport : The following is available for the Newport Stationery Store:  Assume that all credit sales are collected within 30 days of sale. All accounts receivable on September 30 are from September sales. Completed the budget schedules for Newport. Prepare a b..
Organization system archetypes : For the fifth section of your Term Project you are to write a 3 page paper, APA formatted. The paper will include an effective Introduction and Conclusion.
Determine total entropy production rate for heat exchanger : Determine the total entropy production rate for the heat exchanger shown in Figure.- In addition to the air-water heat transfer within the heat exchanger, the air also loses an unknown amount of heat to the surroundings while the water receives an ..
College education is prospect of improved future earnings : One aspect of obtaining a college education is the prospect of improved future earnings in comparison to non-college graduates. Sharon Shay estimates that a college education has a $28,000 equivalent cost at graduation. During the last 20 years of em..
Describe key campaign strategies that a us candidate can use : Describe key campaign strategies that a U.S. presidential candidate can use in order to ascend to presidency in today's political environment.

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