The Net Income (3mo) should be $49,203.19, not $51,203.19. DUE MONDAY, NOV 16 Garden...
90.2K
Verified Solution
Question
Accounting
The Net Income (3mo) should be $49,203.19, not $51,203.19.
DUE MONDAY, NOV 16 Garden Sales, Inc. December 31, 2017 25 200 Cash Accounts Receivable Inventory Prepaid Rent 5 5 $ 5 50,000 112.500 61,300 12.000 Account Payable Working Capital line Note Payable 5 $ 5 50,000 Prop. Plant & Equip Accum Depr s s Net PPEE 5 900,000 1100.000) 800,000 Common Stock Retained Earnings s $ 200,000 761,100 Total Assets 1,036,300 S 1.036 300 - . . . . . . You are the Business Manager of Garden Sales, Inc and the bank has asked you to prepare a cash and carings 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 increase by $5,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 $8,000, per month and prepaid rent is amortized at $1,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, $20,000 from Nov NR Sales will be written off in lan 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 $25,000. The old machine originally cost $10,000, with a Net Book Value of $2,000 and will be sold for $1,000 The Company does not pay or accrue for taxes until the end of December The Company plans to pay a cash dividend of $7,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 $22,000, plus interest of S1,500, 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 $65,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% 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 tine 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 Net Income: (3mo) S51,203.19 Total Assets: 51,071,300.00Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.