The accountant for Munoz’s Dress Shop prepared the following cash budget. Munoz’s desires to maintain a cash cushion of $24,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 Munoz’s will report on the third quarter pro forma statement of cash flows. Determine the amount of net cash flows from financing activities Munoz’s will report on the third quarter pro forma statement of cash flows.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

The accountant for Munoz’s Dress Shop prepared the following cash budget. Munoz’s desires to maintain a cash cushion of $24,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

  1. Complete the cash budget by filling in the missing amounts.

  2. Determine the amount of net cash flows from operating activities Munoz’s will report on the third quarter pro forma statement of cash flows.

  3. Determine the amount of net cash flows from financing activities Munoz’s 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.)
August September
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
$
$
Net cash (operating activities)
Net cash (financing activities)
July
47,500
190,000
237,500
170,526
59,500
0
230,026
7,474
16,526
24,000
210,000
145,230
65,560
250,600
179,152
66,432
Complete this question by entering your answers in the tabs below.
Req A
Req B and C
Determine the amount of net cash flows from both operating and financing activities Munoz's will report on the third quarter
pro forma statement of cash flows. (Round intermediate calculations and final answers to the nearest whole dollar amount.)
J
Transcribed Image Text: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.) August September 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 $ $ Net cash (operating activities) Net cash (financing activities) July 47,500 190,000 237,500 170,526 59,500 0 230,026 7,474 16,526 24,000 210,000 145,230 65,560 250,600 179,152 66,432 Complete this question by entering your answers in the tabs below. Req A Req B and C Determine the amount of net cash flows from both operating and financing activities Munoz's will report on the third quarter pro forma statement of cash flows. (Round intermediate calculations and final answers to the nearest whole dollar amount.) J
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education