h month. Interest is charged at the rate of 1 percent per month. Required Complete the cash budget by filling in the missing amounts. Determine the amount of net cash flows from operating activities Jean’s will report on the third quarter pro forma statement of cash flows. Determine the amount of net cash flows from financing activities Jean’s will report on the third quarter pro forma statement of ca

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter14: Statement Of Cash Flows (cashflow)
Section: Chapter Questions
Problem 5R
icon
Related questions
icon
Concept explainers
Question

The accountant for Jean’s Dress Shop prepared the following cash budget. Jean’s desires to maintain a cash cushion of $10,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 1 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 Jean’s will report on the third quarter pro forma statement of cash flows.

  3. Determine the amount of net cash flows from financing activities Jean’s will report on the third quarter pro forma statement of cash flows.

The accountant for Jean's Dress Shop prepared the following cash budget. Jean's desires to maintain a cash cushion of $10,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 1
percent per month.
Required
a. Complete the cash budget by filling in the missing amounts.
b. Determine the amount of net cash flows from operating activities Jean's will report on the third quarter pro forma statement of cash
flows.
c. Determine the amount of net cash flows from financing activities Jean'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
Determine the amount of net cash flows from both operating and financing activities Jean'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.)
Net cash (operating activities)
Net cash (financing activities)
Transcribed Image Text:The accountant for Jean's Dress Shop prepared the following cash budget. Jean's desires to maintain a cash cushion of $10,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 1 percent per month. Required a. Complete the cash budget by filling in the missing amounts. b. Determine the amount of net cash flows from operating activities Jean's will report on the third quarter pro forma statement of cash flows. c. Determine the amount of net cash flows from financing activities Jean'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 Determine the amount of net cash flows from both operating and financing activities Jean'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.) Net cash (operating activities) Net cash (financing activities)
flows.
c. Determine the amount of net cash flows from financing activities Jean'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.)
Cash Budget
July
August
September
Section 1: Cash receipts
Beginning cash balance
$
25,000 $
25,250
Add cash receipts
90,000
100,000
120,300
Total cash available
115,000
Section 2: Cash payments
For inventory purchases
82,750
70,115
87,076
For S&A expenses
27,250
30,280
30,716
For interest expense
Total budgeted disbursements
110,000
Section 3: Financing activities
Surplus (shortage)
5,000
Borrowing (repayments)
5,000
Ending cash balance
10,000 $
0 $
Transcribed Image Text:flows. c. Determine the amount of net cash flows from financing activities Jean'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.) Cash Budget July August September Section 1: Cash receipts Beginning cash balance $ 25,000 $ 25,250 Add cash receipts 90,000 100,000 120,300 Total cash available 115,000 Section 2: Cash payments For inventory purchases 82,750 70,115 87,076 For S&A expenses 27,250 30,280 30,716 For interest expense Total budgeted disbursements 110,000 Section 3: Financing activities Surplus (shortage) 5,000 Borrowing (repayments) 5,000 Ending cash balance 10,000 $ 0 $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub

Expert Answers to Latest Homework Questions

Q: Journalize the following transactions for Ivanhoe Company. (a) Purchased 6,800 units of raw…
Q: Calculate the energy the signal x(t)=te^-t u(t)
Q: Please correct answer and don't use hend raiting
Q: 3) (5+5+5 pts.) Let x(t) be a periodic signal whose Fourier series coefficients are as follows: ao =…
Q: 2) (10 pts.) For the continuous-time periodic signal 2π S 5π 12+6=17 x(t) = 2+ cos(t) + 4 sin( +4…
Q: 1) (10 pts.) A continuous-time periodic signal x(t) is real valued and has a fundamental period T 8.…
Q: 7) (10 pts.) Determine the Fourier series representation of the periodic signal x(t) whose plot is…
Q: Formula with answer
Q: k 1.3 For what set of real values of k is 1-√k+ √2-k real? 1 (3) 1.4 Show that the roots of the…
Q: Please provide explanations too
Q: Verano Inc. has two business divisions- a software product line and a waste water clean-up product…
Q: 1. Explain the different types of arteries with examples of each. 2. Explain the different…
Q: Please provide explanations too if possible. Thanks
Q: a 2.8 liter four cylinder square engine with two intake valves per cylinder is desighned to have a…
Q: Anne Hathaway Inc.'s common stock has 10,800 shares outstanding with $42 per share. The company's…
Q: Please correct answer and don't use hand rating
Q: Please correct answer and don't use hend raiting
Q: Don't use Ai
Q: Don't use Ai
Q: For the non-symmetric Z-section shown in Figure Q4 find the position of the horizontal (X) and…
Q: Using the same case, calculate the independent effects of a 2 percent increase in Gross Margin, a 2…