Question
?The accountant for Campbells Dress Shop prepared the following cash budget. Campbells desires to maintain a cash cushion of $18,000 at the end of each
?The accountant for Campbells Dress Shop prepared the following cash budget. Campbells desires to maintain a cash cushion of $18,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 3 percent per month.
Required
Complete the cash budget by filling in the missing amounts.
Determine the amount of net cash flows from operating activities Campbells will report on the third quarter pro forma statement of cash flows.
Determine the amount of net cash flows from financing activities Campbells will report on the third quarter pro forma statement of cash flows.
Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the cash budget by filling in the missing amounts. (Any shortages or repayments should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) July September Cash Budget Section 1: Cash receipts August |$18,000?$ Beginning cash balance Add cash receipts $44,500 184,000 228,500 | . 262,600 0 18,000 244,600 204,000 Total cash available 222.000 Section 2: Cash payments For inventory purchases For S&A expenses For interest expense 142,230 62,560 406 6 205.196 176,152 63,432 429 240,013 167,526 56,500 224,026 Total budgeted disbursements Section 3: Financing activities Surplus (shortage) Borrowing (repayments) 4,474 (188,392) 13,526 (17,584) 35,584 206,392 Ending cash balance S 18,000 S 18,000 18,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started