Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cullumber Company expects to have a cash balance of $ 65,150 on January 1, 2017. These are the relevant monthly budget data for the first

Cullumber Company expects to have a cash balance of $ 65,150 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017.

1. Collections from customers: January $ 90,150, February $ 165,150.

2. Payments to suppliers: January $ 59,150, February $ 94,150.

3. Wages: January $ 31,120, February $ 41,120. Wages are paid in the month they are incurred.

4. Administrative expenses: January $ 22,120, February $ 25,120. These costs include depreciation of $ 1,000 per month. All other costs are paid as incurred.

5. Selling expenses: January $ 16,120, February $ 21,120. These costs are exclusive of depreciation. They are paid as incurred.

6. Sales of short-term investments in January are expected to realize $ 13,120 in cash. Cullumber Company has a line of credit at a local bank that enables it to borrow up to $ 25,000. The company wants to maintain a minimum monthly cash balance of $ 39,150.

Prepare a cash budget for January and February.

January February
------- $ $
Add/Less ----
----
----
----
----
Add/Less ----
----
----
----
----
----
----
----
Add/Less ----
Add/Less ----
----

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

Cornerstones Of Financial Accounting

Authors: Jay Rich, Jefferson Jones, Maryanne Mowen, Don Hansen, Donald Jones, Ralph Tassone

2nd Canadian Edition

0176707123, 978-0176707125

More Books

Students also viewed these Accounting questions