. . . . . Cash Accounts Receivable Inventory Prepaid Rent . Prop,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
. ♦ . ● • . . . Cash Accounts Receivable Inventory Prepaid Rent . Prop, Plant & Equip Accum Depr . . $ $ $ $ Total Assets $ 1,070,350.00 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: 5 $ Net PP&E S Garden Sales, Inc. December 31, 2017 November 2017 and December 2017 sales were $100,000, each month Sales for the following three months will decrease by $2,200 each month, beginning January through April. Cost of Sales represents 75% of sales, each month. . Cash Operating Expenses are 14% of sales, exclusive of Depreciation expense • Depreciation Expense is $4,000, per month and prepaid rent is amortized at $750 per month ● 50,000.00 135,000.00 73,350.00 12,000.00 900,000.00 (100,000.00) 800,000.00 Account Payable Working Capital Line $ Accrued Interest Payable S Note Payable 5 Common Stock Retained Earnings of the month's sales, 10% 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, $1,000 from Nov A/R Sales will be written off in Jan to Bad Debt Exp. • To maintain sufficient inventory, the company purchases 100% of the next month's cost of sales. They pay for 70%, in cash, in the month they purchase and pay the remaining 30% in the following month. In March, the company is planning on replacing an outdated machine. The new machine will cost $14,000. The old machine originally cost $20,000 with a Net Book Value of 15,000 and will be sold for $5,000 $ S 22.005.00 The Company does not pay or accrue for taxes until the end of December. The Company plans to pay a cash dividend of $6,500 at the end of March. 50,000.00 200,000.00 798,345.00 1.070.350.00 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 (in good form) 3. Prepare a Balance Sheet as of March 31, 2018 (in good form) 4. Assignment must be turned in as HAND WRITTEN document and include this sheet. 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 $9,000, plus interest of $750, at the end of March. For this note, no interest is Accrued/Expensed until interest is paid The minimum cash month end balance required according to the bank agreement is $75,000 for any given month beginning Jan 30, 2018. A working capital line of credit is available, up to $25,000, and if needed, money is taken out at the beginning of the month. Interest is ½ % 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. . Check Figures for 03/31 Retained Earnings: $797,229.74 Total Assets: $1,067.230.00 . ♦ . ● • . . . Cash Accounts Receivable Inventory Prepaid Rent . Prop, Plant & Equip Accum Depr . . $ $ $ $ Total Assets $ 1,070,350.00 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: 5 $ Net PP&E S Garden Sales, Inc. December 31, 2017 November 2017 and December 2017 sales were $100,000, each month Sales for the following three months will decrease by $2,200 each month, beginning January through April. Cost of Sales represents 75% of sales, each month. . Cash Operating Expenses are 14% of sales, exclusive of Depreciation expense • Depreciation Expense is $4,000, per month and prepaid rent is amortized at $750 per month ● 50,000.00 135,000.00 73,350.00 12,000.00 900,000.00 (100,000.00) 800,000.00 Account Payable Working Capital Line $ Accrued Interest Payable S Note Payable 5 Common Stock Retained Earnings of the month's sales, 10% 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, $1,000 from Nov A/R Sales will be written off in Jan to Bad Debt Exp. • To maintain sufficient inventory, the company purchases 100% of the next month's cost of sales. They pay for 70%, in cash, in the month they purchase and pay the remaining 30% in the following month. In March, the company is planning on replacing an outdated machine. The new machine will cost $14,000. The old machine originally cost $20,000 with a Net Book Value of 15,000 and will be sold for $5,000 $ S 22.005.00 The Company does not pay or accrue for taxes until the end of December. The Company plans to pay a cash dividend of $6,500 at the end of March. 50,000.00 200,000.00 798,345.00 1.070.350.00 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 (in good form) 3. Prepare a Balance Sheet as of March 31, 2018 (in good form) 4. Assignment must be turned in as HAND WRITTEN document and include this sheet. 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 $9,000, plus interest of $750, at the end of March. For this note, no interest is Accrued/Expensed until interest is paid The minimum cash month end balance required according to the bank agreement is $75,000 for any given month beginning Jan 30, 2018. A working capital line of credit is available, up to $25,000, and if needed, money is taken out at the beginning of the month. Interest is ½ % 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. . Check Figures for 03/31 Retained Earnings: $797,229.74 Total Assets: $1,067.230.00
Expert Answer:
Related Book For
Understanding Financial Accounting
ISBN: 978-1118849385
1st Canadian Edition
Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald
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 following is the balance sheet and income statement for YUM, Inc. (the company that operates Kentucky Fried Chicken and Pizza Hut), in condensed form, plus some information from the cash flow...
-
The 2009 balance sheet and income statement for the Woods Company are shown here: Woods Company: Income Statement for the Year Ending December 31, 2009 ($ thousands)...
-
A nutritionally defective E. coli strain grows only on a medium containing thymine, whereas another nutritionally defective strain grows only on a medium containing leucine. When these two strains...
-
Wageweb conducts surveys of salary data and presents summaries on its website. Based on salary data as of October 1, 2002, Wageweb reported that the average annual salary for sales vice presidents...
-
Benchmark the performance of Inditex, H&M, and Gap on the supply chain trade-off triangle for the years 20152018. To do so, you may construct three two-dimensional plots on the following metrics:...
-
For any pure substance, the difference between \(C_{P}\) and \(C_{V}\) can be expressed in terms of the isothermal compressibility \(\alpha\) and volume expansivity \(\beta\) as (a)...
-
AnderSet Laboratories produces rough lenses that will ultimately be ground into precision lenses for use in laboratory equipment. The company has developed the following thickness measures, based on...
-
Oakwood Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March April May $175,000 161,000...
-
Segment the wind-generated power industry in a way that shows where Windspire Energy, the subject of the You Be the VC 1.1 feature, is located in the industry. How does Windspires awareness of the...
-
How do chloroplasts participate in retrograde signaling pathways to communicate with the nucleus and regulate nuclear gene expression in response to chloroplast dysfunction or environmental stressors?
-
Analyze the Navier-Stokes equations in the context of fluid dynamics, focusing on their mathematical complexity and physical interpretation, and discuss the conditions under which these equations...
-
Examine the emerging trends and challenges in computational fluid dynamics (CFD) research, including the development of high-fidelity simulation methods, uncertainty quantification, and optimization...
-
Weller Company's budgeted unit sales for next year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 26,000 27,000 19,000 24,000 The company's variable selling...
-
Geneva Conventions are customary approved agreements for international treaties that was created in Geneva Switzerland between 1864 and 1949. These treaties serve as a guide to restrain unsparing...
-
3 The following information is available for ADT Company, which produces special-order security products and uses a job order costing system. Overhead is applied using a predetermined overhead rate...
-
You currently work as an economic advisor to the US President. Assume that America's Aggregate Demand Shortfall is $900 billion. The MPC in America is 0.90. In order to restore a Full-Employment...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
Pharma Shop Ltd. was a mid-sized public company that had been in operation for many years. On December 31, 2015, it had an unlimited number of common shares authorized and 5.2 million shares issued...
-
Suppose that you are the vice-president in charge of marketing and sales in a large company. You want to boost sales, so you have developed an incentive plan that will provide a bonus to the...
-
Under the cash basis of accounting, the purchase of a new piece of equipment for cash would be treated as an expense of the accounting period when the purchase occurred. Required: a. If you were a...
-
Fill in the Blank. For a shaft carrying masses \(m_{1}, m_{2}, \ldots\), Rayleigh's method gives the natural frequency as \[\omega=\left\{\frac{g\left(m_{1} w_{1}+m_{2} w_{2}+\cdots ight)}{m_{1}...
-
True or False. In the matrix iteration method, any computational error will not yield incorrect results.
-
Rayleigh's method a. Finds the natural frequencies and mode shapes of the system, one at a time, using several trial values for each frequency. b. Finds all the natural frequencies using trial...
Study smarter with the SolutionInn App