Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Month September October November December Sales $16,000,000 $14,000,000 $13,000,000 $14,000,000 Purchases $12,000,000 $10,000,000 $12,000,000 $12,000,000 Additional Data: Please, pay attention to the cash expenses and

Month September October November December Sales $16,000,000 $14,000,000 $13,000,000 $14,000,000 Purchases $12,000,000 $10,000,000 $12,000,000 $12,000,000 Additional Data: Please, pay attention to the cash expenses and non-cash expenses, and their implication when computing the Cash Budget: 1. The firm collects 70% of sales for cash same month, and 30% one month later based on history. 2. The firm will receive $100,000 in cash Dividends in December from investments it has on another corporation. 3. Interest Income of $150,000 on Marketable Securities investments will be received in November. 4. The firm will sell machinery for cash for $700,000 in November but will collect in cash only 50% the same month and the rest in December. 5. The firm expects to receive $40,000 in Interest from its investments in bonds in December. 6. The firm will pay in cash for 40% of its purchases (same month) and 60% of its purchases in cash the following month. 7. Salaries and Wages amount to 10% of the preceding months sales 8. Sales commissions paid amount to 5% of the preceding months sales. 9. Lease Payments of $250,000 must be made each month. 10. A principal and interest payment on an Outstanding loan is due in November for $700,000 11. The firm will purchase a truck for $80,000, at the end of November, and will pay 50% in the same month in cash and the rest in December. 12. The firm will pay cash dividends of $350,000 at the end of December. 13. Fixed assets costing $1,200,000 in cash will be purchased in November. 14. Depreciation expense is expected to be $100,000 each month. 15. The firm has a beginning cash balance in October of $600,000. 16. The firm wishes to maintain a monthly cash balance of $600,000.

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_2

Step: 3

blur-text-image_3

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

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert Hughes

4th Edition

0256147175, 978-0256147179

More Books

Students also viewed these Finance questions