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

  Problem 1a company issued a 50000 four-year 4 bond on

problem 1a company issued a 50000 four-year 4 bond on january 1. bond interest is paid each december 31. the bond was

  What are the different methods use to calculate depreciation

What are the different methods used to calculate depreciation? How does a company decide which method to use? How does its choice affect the financial statements? Should companies standardize the method of depreciation to enhance comparability?

  X company is considering dropping product a if it does it

1. assume that in 2012 andre has charged customers 15.00 per haircut has paid each of his six barbers a salary of 53000

  1 if you assume that the risk world in which your company

1 if you assume that the risk world in which your company operates is ergodic when in fact it is non-ergodic what

  Amounts should performance report for this company compare

Carlson, Inc. prepared a 2014 budget for 125,000 units of product. Actual production in 2014 was 130,000 units. To be most useful, what amounts should a performance report for this company compare?

  What is after-tax cost of capital for walgreens for bonds

The Walgreen's corporation is contemplating a new investment that it plans to finance using one-third debt. The firm can now sell new $1,000 par value bonds with a 15 year maturity at a price of $950 that carry a coupon interest of 12.9 percent that ..

  Adjusting entries affect balance sheet accounts at exclusion

For most large businesses, the cash basis of accounting will provide accurate financial statements for user needs. Adjusting entries affect balance sheet accounts at the exclusion of income statement accounts. An account for each supplier of merchand..

  What are tax aspects of this transaction for mark farris

The asset is sold at the end of 2008 for $130,800. What are tax aspects of this transaction for Mark Farris, a 60% owner of the company?

  Proposal present an ethical dilemma

The management of the Auto Parts Division of the Santana Corporation receives a bonus if the division's income achieves a specific target. For 2003 the target will be achieved by a wide margin. Does Mary Beth's proposal present an ethical dilemma? If..

  What the net income would have been in the second year

Second year net sales $684,000 wrote off $10,800 of accts. as uncollectible ussing the direct write off method and reported net income of $68,300. What the net income would have been in the second year if the allowance method [using 2.5% of net sales..

  Who relies on the financial statements

a) Who relies on the financial statements (external users) and why, what are they using the statements for?

  Calculate its markup percentage using variable-cost pricing

variable manufacturing overhead $18; fixed manufacturing overhead $42; variable selling and administrative expenses $14; and fixed selling and administrative expenses $28. Its desired ROI per unit is $30. Calculate its markup percentage using varia..

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