Sheridan Company expects to have a cash balance of $59,450 on January 1, 2017. These are...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sheridan Company expects to have a cash balance of $59,450 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $84,450, February $159,450. 2. Payments to suppliers: January $53,450, February $88,450. 3. Wages: January $30,400, February $40,400. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,400, February $24,400. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $15,400, February $20,400. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $12,400 in cash. Sheridan Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $33,450. Prepare a cash budget for January and February. F F Beginning cash balance Add X SHERIDAN COMPANY Cash Budget For the Two Months Ending February 28, 2017 Collections from customers. Collections from customers Sale of short-term investments January 59540 84450 12400 February 159450 X M Total available cash Less M Less Less Cash disbursements Payments to suppliers x Wages Total disbursements Administrative expenses Excess (deficiency) of available cash over disbursements Selling expenses Financing Borrowings Ending cash balance 0 000000 000 0 0000.00 0.00 Sheridan Company expects to have a cash balance of $59,450 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $84,450, February $159,450. 2. Payments to suppliers: January $53,450, February $88,450. 3. Wages: January $30,400, February $40,400. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,400, February $24,400. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $15,400, February $20,400. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $12,400 in cash. Sheridan Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $33,450. Prepare a cash budget for January and February. F F Beginning cash balance Add X SHERIDAN COMPANY Cash Budget For the Two Months Ending February 28, 2017 Collections from customers. Collections from customers Sale of short-term investments January 59540 84450 12400 February 159450 X M Total available cash Less M Less Less Cash disbursements Payments to suppliers x Wages Total disbursements Administrative expenses Excess (deficiency) of available cash over disbursements Selling expenses Financing Borrowings Ending cash balance 0 000000 000 0 0000.00 0.00
Expert Answer:
Answer rating: 100% (QA)
prepare a cash budget for January and February as follows prepare a cash bu... View the full answer
Related Book For
Financial Accounting Tools for business decision making
ISBN: 978-0470534779
6th Edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
Garza Company expects to have a cash balance of $46,000 on January 1, 2010. Relevant monthly budget data for the first 2 months of 2010 are as follows. Collections from customers: January $85,000,...
-
Merrick Company expects to have a cash balance of $46,000 on January 1, 2012. These are the relevant monthly budget data for the first two months of 2012. 1. Collections from customers: January...
-
Ming Company expects to have a cash balance of $46,000 on January 1, 2012. Relevant monthly budget data for the first 2 months of 2012 are as follows. Collections from customers: January $85,000,...
-
Your examination of the records of Wilson Ltd, which was established on 1 March 2015, reveals that the accountant debited the Land, Buildings and Equipment account with the following items (ignore...
-
Colt Company uses budgets in controlling costs. The August 2011 budget report for the company's Assembling Department is as follows. The monthly budget amounts in the report were based on an expected...
-
Discuss the relationship of queries to database forms and reports used by the accounting interface.
-
\(\sqrt{2,400}\) Simplify the square root by expressing it in lowest terms.
-
On December 31, 2008, Ed Abbey Co. performed environmental consulting services for Hayduke Co. Hayduke was short of cash, and Abbey Co. agreed to accept a $200,000 zero-interest-bearing note due...
-
Hello! I am confused as to how the person got $115,000 on line one for wages, salaries, and such. This problem is having Ryan file separately from Diana. I would like to know how to calculate Ryan'...
-
In 1879, A.A. Michelson measured the velocity of light in air using a modification of a method proposed by the French physicist Foucault. Twenty of these measurements are in table 6E.27 (the value...
-
Two steel spheres approach each other head on with same speed and collide elastically. After the collision one of the sphere's radius 'r' comes to rest. The radius of the other sphere is (A) 31/a (B)...
-
how can collective arguments be useful in the NBA and NFS? explain.
-
Arctica manufactures snowmobiles and ATVs. These products are made in different departments, and each department has its own manager. Each responsibility performance report includes only those costs...
-
Which country has the highest GINI index in the world? Why this country has the highest GINI index in the world? Has this country had the highest GINI index in the world for several years? Why is...
-
1.Discuss the changes that have been made by the Government to strengthen the Malaysian Financial Markets during the pandemic period. You may share the specific steps taken by the Securities...
-
An investor is considering adding commodities to his portfolio. Explain the benefits, and discuss how it can be done.
-
Consider the following information about a risky portfolio that you manage and a risk-free asset: E(rp) = 11%, p = 10%, rf = 6%. a. Your client wants to invest a proportion of her total investment...
-
What are the four types of poultry production systems? Explain each type.
-
What is the difference between the current ratio and working capital?
-
On January 1, Krivitz Company issued $300,000, 8%, 10-year bonds at face value. Interest is payable annually on January 1. Instructions Prepare journal entries to record the following events. (a) The...
-
Here is Maple Companys portfolio of long-term available-for-sale securities at December 31, 2011: Cost 1,400 shares of Wickham Inc. common stock $73,500 1,200 shares of Kerry Corporation common stock...
-
On September 1, 1998, Susan Chao bought a motorcycle for \($10,000.\) She paid \($1,000\) down and financed the balance with a five-year loan at a stated annual interest rate of 9.6 percent,...
-
You have recently won the super jackpot in the Illinois state lottery. On reading the fine print, you discover that you have the following two options: a. You receive \($160,000\) at the beginning of...
-
Peter Green bought a \($15,000\) Honda Civic with 20 percent down and financed the rest with a four-year loan at 8 percent stated annual interest rate, compounded monthly. What is his monthly payment...
Study smarter with the SolutionInn App