Garden Sales, Inc. December 31, 2017 Cash $ 40,000 Account Payable 5 23,250 Accounts Receivable $...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Garden Sales, Inc. December 31, 2017 Cash $ 40,000 Account Payable 5 23,250 Accounts Receivable $ 112,500 Working Capital Line S Inventory $ 57,000 Note Payable $ 50,000 Prepaid Rent S 12,000 $ 500,000 Common Stock $ 200,000 Prop, Plant & Equip Accum Depr $ Retained Earnings $ 748,220 (100,000) 800,000 Net PP&E S Total Assets 1,021.500 $ 1,021,500 You are the Business Manager of Garden Sales, Inc and the bank has asked you to prepare a cash and earnings budget/forecast and Pro-Forma Balance Sheet and Income Statement for the next quarter. After your discussion with the various departments, you have come up with the following information/assumptions: November 2017 and December 2017 sales were $100,000, each month Sales for the following three months will decrease by $3,000 each month, beginning January through April. . Cost of Sales represents 60% of sales, each month. . Cash Operating Expenses are 10% of sales, exclusive of Depreciation expense . Depreciation Expense is $10,000, per month and prepaid rent is amortized at $3,000 per month . of the month's sales, 25% is collected as cash with the remaining placed on customer's account. . Customer's accounts are usually paid off over a 2 month period (50% each month) beginning the month following the sale The CFO just informed you that one customer has filed bankruptcy therefore, $15,000 from Nov A/R Sales will be written of in Jan to Bad Debt Exp. . The company purchases 100% of the next month's cost of sales. They pay for 60%, in cash, in the month they purchase and pay the remaining 40% in the following month. . In March, the company is planning on replacing an outdated machine. The new machine will cost $35,000. The old machin originally cost $15,000, with a Net Book Value of $5,000 and will be sold for $3,000, . The Company does not pay or accrue for taxes until the end of December. The Company plans to pay a cash dividend of $30,000 at the end of March. Assume all operating expenses incurred during the month are paid, in cash, during the same month incurred . The Note Payable requires a principal payment of $10,000, plus interest of $750, at the end of March. For this note, no interest is Accrual/Expense until interest is paid . The minimum cash month end balance required according to the bank agreement is $60,000 for any given month beginning Jan 30, 2018. . A working capital line of credit is available, up to $100,000, and if needed, money is taken out at the beginning of the month. Interest is 1.5% per month. Interest is paid on the working capital line when principal payments are paid on the debt; at the end of any given month. Interest is accrued on the working capital line effective the beginning of the month when money is received. 1. Prepare a detailed Cash Budget/Forecast for each month of Jan, Feb and March, 2018 2. Prepare an Income Statement for the 3-month period ending March 2018 (good form) 3. Prepare a Balance Sheet as of March 31, 2018 (good form) 4. Assignment must be turned in as HAND WRITTEN document. Check Figures for 03/31 Total Interest Exp: (3mo) $991.91 Total Assets: $1,018,100.00 Garden Sales, Inc. December 31, 2017 Cash $ 40,000 Account Payable 5 23,250 Accounts Receivable $ 112,500 Working Capital Line S Inventory $ 57,000 Note Payable $ 50,000 Prepaid Rent S 12,000 $ 500,000 Common Stock $ 200,000 Prop, Plant & Equip Accum Depr $ Retained Earnings $ 748,220 (100,000) 800,000 Net PP&E S Total Assets 1,021.500 $ 1,021,500 You are the Business Manager of Garden Sales, Inc and the bank has asked you to prepare a cash and earnings budget/forecast and Pro-Forma Balance Sheet and Income Statement for the next quarter. After your discussion with the various departments, you have come up with the following information/assumptions: November 2017 and December 2017 sales were $100,000, each month Sales for the following three months will decrease by $3,000 each month, beginning January through April. . Cost of Sales represents 60% of sales, each month. . Cash Operating Expenses are 10% of sales, exclusive of Depreciation expense . Depreciation Expense is $10,000, per month and prepaid rent is amortized at $3,000 per month . of the month's sales, 25% is collected as cash with the remaining placed on customer's account. . Customer's accounts are usually paid off over a 2 month period (50% each month) beginning the month following the sale The CFO just informed you that one customer has filed bankruptcy therefore, $15,000 from Nov A/R Sales will be written of in Jan to Bad Debt Exp. . The company purchases 100% of the next month's cost of sales. They pay for 60%, in cash, in the month they purchase and pay the remaining 40% in the following month. . In March, the company is planning on replacing an outdated machine. The new machine will cost $35,000. The old machin originally cost $15,000, with a Net Book Value of $5,000 and will be sold for $3,000, . The Company does not pay or accrue for taxes until the end of December. The Company plans to pay a cash dividend of $30,000 at the end of March. Assume all operating expenses incurred during the month are paid, in cash, during the same month incurred . The Note Payable requires a principal payment of $10,000, plus interest of $750, at the end of March. For this note, no interest is Accrual/Expense until interest is paid . The minimum cash month end balance required according to the bank agreement is $60,000 for any given month beginning Jan 30, 2018. . A working capital line of credit is available, up to $100,000, and if needed, money is taken out at the beginning of the month. Interest is 1.5% per month. Interest is paid on the working capital line when principal payments are paid on the debt; at the end of any given month. Interest is accrued on the working capital line effective the beginning of the month when money is received. 1. Prepare a detailed Cash Budget/Forecast for each month of Jan, Feb and March, 2018 2. Prepare an Income Statement for the 3-month period ending March 2018 (good form) 3. Prepare a Balance Sheet as of March 31, 2018 (good form) 4. Assignment must be turned in as HAND WRITTEN document. Check Figures for 03/31 Total Interest Exp: (3mo) $991.91 Total Assets: $1,018,100.00
Expert Answer:
Answer rating: 100% (QA)
Workings Cash budget Req 1 Cash balance beginning Add Cash collections From Customer sal... View the full answer
Related Book For
Accounting
ISBN: 978-1337899451
27th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
You are the business manager of P. Bunyan Forests, Inc., and are trying to decide when you should cut your trees. The market value of the lumber that you will get if you let your trees reach the age...
-
The Garcia Industries balance sheet and income statement for the year ended 2005 are as follows: Income Statement (in Millions of Dollars) Net sales ............... $100.0 Cost of sales...
-
The simplified balance sheet and income statement for a company appear below. Balance Sheet December 31, 20ÃÃ Income Statement For the Year Ended December 31, 20ÃÃ Net...
-
Lionel Train Company has the following information for this year and next year. Current Next Year Year Trains purchased 40,000 48,000 Trains scrapped in production 4,000 3,000 Trains sold 36,000...
-
What alternative strategies or approaches could U.S. regulatory agencies consider invoking to ensure that the audits of non-U.S. companies with securities traded on U.S. markets are adequate?
-
In Problems 2542, establish each identity. sin 0 [sin (30) + sin(50)] = cos 0 [cos (30) cos (50)]
-
Implement a Minimax algorithm using your static evaluator for tic-tac-toe, and write a simple program that plays the game. Have the program output how many nodes in the game tree it had to examine as...
-
During 2013, Jeff Smallwood worked for two different employers. Until May, he worked for Rowland Constructions Company in Ames, Iowa, and earned $22,000. The state unemployment rate for Rowland is...
-
What is the present value of the following future amount? $488,901 to be received 13 years from now, discounted back tothe present at 5 percent, compounded annually? Round the answer to two decimal...
-
You work for the 3T company, which expects to earn at least 18 percent on its investments. You have to choose between two similar projects. Below is the cash information for each project. Your...
-
As of January 1, 2017, Coronado Inc. adopted the retail method of accounting for its merchandise inventory. To prepare the stores financial statements at June 30, 2017, you obtain the following data....
-
Bill's 2022 income tax return, which was for a full year, showed an AGI of $140,000 and an income tax liability of $32,100. He estimates his 2023 income tax to be $38,000 and his total wage...
-
In the United States, the accounting for normal research and development costs is different from the accounting for software development costs. For software development costs, some costs are reported...
-
What information or resources did you uncover from your research into professional expectations that you found useful for planning your degree in accounting?
-
Greg. age 45, has a whole life policy with a death benefit, cash value, annual premium. What is the amount of the pure fife insurance protection element at age 45 ?
-
Explain how Repo 105 worked by showing the effect of a 50 billion repo 105 transaction. Where does the name come from? Why would Lehman have an incentive to undertake the transaction? What is the...
-
Hi, this is a project where we are supposed make a choose-your-own path story. I was wondering if this code can be shortened in any way. For example, I use (console.next()).equalsIgnoreCase("yes")...
-
Extend Algorithms 3.4 and 3.5 to include as output the first and second derivatives of the spline at the nodes.
-
The balances for the accounts that follow appear in the Adjusted Trial Balance columns of the end-of-period spreadsheet. Indicate whether each account would flow into the income statement, statement...
-
Myles Etter and Crystal Santori are partners who share in the income equally and have capital balances of $210,000 and $62,500, respectively. Etter, with the consent of Santori, sells one-third of...
-
On May 23, Stoltz Realty Inc. issued for cash 80,000 shares of no-par common stock (with a stated value of $3) at $12. On July 6, Stoltz Realty Inc. issued at par value 18,000 shares of preferred 1%...
-
With reference to Exercise 10.42, verify that the mean of the observed distribution is 1.6 , corresponding to \(40 \%\) of the cars requiring repairs. Then look up the probabilities for \(n=5\) and...
-
The following is the distribution of the hourly number of trucks arriving at a company's warehouse: Find the mean of this distribution, and using it (rounded to one decimal place) as the parameter...
-
Among 100 purification filters used in an experiment, 46 had a service life of less than 20 hours, 19 had a service life of 20 or more but less than 40 hours, 17 had a service life of 40 or more but...
Study smarter with the SolutionInn App