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

  How the company treats uncollectible accounts

After reviewing the notes to the financial statements, list the types of information you found about the following.

  Schedules of expected cash collections and disbursements

Schedules of Expected Cash Collections and Disbursements [LO8-2, LO8-4, LO8-8] You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. Prepare a schedule of expected cash collections for December..

  Describe the differentiation between product versus general

Describe the differentiation between product versus general, selling, and administrative costs by setting up financial statements from the transactions in the problem. Respond to at least two of your classmates’ postings.

  Describe process that jesse should use

Describe process that Jesse should use to determine which payment option he prefers. Ignore all taxes and assume that Jesse will live for at least 45 more years.

  Costing method for the material component of raw materials

On January 31, 2011, we elected to change our costing method for the material component of raw materials, work in process, and finished goods inventory to the lower of cost or market using the first-in first-out (“FIFO”) method, from the lower of cos..

  Dividing net income available for the common shareholders

Lois Kenseth, president of Sycamore Corporation, is concerned about Several large stockholders who have been very vocal lately in their criticisms of her leadership. She thinks they might mount a campaign to have her removed as the corporation’s CEO...

  Calculate the maximum depreciation expense

Beth's business purchased only one asset during the current year. It placed in service machinery (7-year property) on December 1 with a basis of $50,000. Calculate the maximum depreciation expense

  Capital budgeting models

Capital Budgeting models (like all forecasts) are driven primarily by educated assumptions about outcomes

  Question 1find the comments letters received on a current

question 1find the comments letters received on a current exposure draft or proposal for a new accounting standard.

  Preparing and interpreting the balance sheet

CP2-3 Recording Transactions (in a Journal and T-Accounts); Preparing and Interpreting the Balance Sheet - Analyze transactions (a)-(f) to determine their effects on the accounting equation and Prepare a classified balance sheet at December 31.

  Analyze the accounting for fixed asset

Analyze the accounting for fixed asset class using US GAAP and IFRS. Assume the Company uses straight-line depreciation for all its fixed assets and takes a full year of depreciation in the year of the addition.

  Compute the unit product cost for one barbecue grill

Chuck Wagon Grills, Inc., makes a single product—a handmade specialty barbecue grill that it sells for $210. Data for last year’s operations follow: Assume that the company uses absorption costing. Compute the unit product cost for one barbecue grill..

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