Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Garden Sales, Inc. December 11, 2017 22.005.00 Cash Accounts Receivable Inventory Prepaid Rent $ S S s 50,000.00 135,000.00 72.350.00 12.000.00 Account Payable $ Working

image text in transcribed

Garden Sales, Inc. December 11, 2017 22.005.00 Cash Accounts Receivable Inventory Prepaid Rent $ S S s 50,000.00 135,000.00 72.350.00 12.000.00 Account Payable $ Working Capital Line $ Accrued interest Payable 5 Note Payable $ 50.000,00 Prop, Plant & Equip Accum Depr 5 S Net PPLES 900,000.00 (100,000.00) 300,000.00 Common Stock Retained Earnings $ $ 200,000.00 7901.345.00 Total Assets $1.070,350.00 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: 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 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 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. 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. 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. . . . . . . Check Figures for 03/31 Retained Earnings: S797.229.74 Total Assets: $1,067.230,00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: J. David Spiceland, Wayne Thomas, Don Herrmann

2nd Edition

0078110823, 9780078110825

More Books

Students also viewed these Accounting questions

Question

What are the parameters in a simple linear regression model?

Answered: 1 week ago