Question
The accountant for Ericas Dress Shop prepared the following cash budget. Ericas desires to maintain a cash cushion of $20,000 at the end of each
The accountant for Erica’s Dress Shop prepared the following cash budget. Erica’s desires to maintain a cash cushion of $20,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 2 percent per month. |
Required |
a. | Complete the cash budget by filling in the missing amounts. (Any repayments should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) |
b. | Determine the amount of net cash flows from operating activities Erica’s will report on the third quarter pro forma statement of cash flows. (Enter any cash outflows with a minus sign. Round intermediate calculations and final answer to the nearest whole dollar amount.) |
c. | Determine the amount of net cash flows from financing activities Erica’s will report on the third quarter pro forma statement of cash flows. (Enter any cash outflows with a minus sign. Round intermediate calculations and final answer to the nearest whole dollar amount.) |
Cash Budget Section 1: Cash receipts Beginning cash balance Add cash receipts Total cash available Section 2: Cash payments For inventory purchases For S&A expenses For interest expense Total budgeted disbursements Section 3: Financing activities Surplus (shortage) Borrowing (repayments) Ending cash balance July $ 45,500 186,000 231,500 August September 226,026 206,000 246,600 168,526 143,230 57,500 63,560 0 177,152 64,432 5,474 14,526 $ 20,000 $ 20,000 $ 20,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
a Cash Budget July Section 1 Beginning cash balance 20000 Cash receipts 45500 Total cash available 2...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