Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Donald Whittier, a financial analyst and your boss, has prepared the following sales and cash disbursement estimates for the period August through December of the

image text in transcribed
image text in transcribed
Donald Whittier, a financial analyst and your boss, has prepared the following sales and cash disbursement estimates for the period August through December of the current year. Sales 500 Month August September October November December Cash Disbursement $300 500 700 400 500 His assumptions are that ninety percent of sales are collected in cash the same month, and the remaining 10 percent are collected one month later. All disbursements are on a cash basis. The firm needs to maintain a minimum cash balance of $50, borrowing in each month as needed. Likewise, the firm will repay the loan balance each month with positive net cash flow; any net cash flow not needed to repay a loan balance will be kept in the cash account. The beginning cash balance in September is $25. Donald made a cash budget template, but has asked you to prepare the cash budget for the months of September October, November, and December Dec Aug 400 Sept 500 Oct 500 Nov 600 700 Cash Budget Sales Collections (Mo.) Collections (Mo, t-1) Total Receipts 100 500 500 600 700 Collections (Mo.t) Collections (Mo.t-1) Total Receipts Total Disbursements 0,0 Net Cash Flow - Beginning Cash Bal. Available Bal. Monthly Borrowing Monthly Repayment Ending Cash Bal. Cumulative Loan Bal. Which of the following statements is (are) correct? Total receipts in December is $590. The net cash flow in October is -$200. The avallable balance in September is $35. The cumulative loan balance in October is $235. The ending cash balance in December is $195

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_2

Step: 3

blur-text-image_3

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

Principles Of Managerial Finance

Authors: Lawrence J. Gitman, Chad J. Zutter

14th Global Edition

1292018208, 978-1292018201

More Books

Students also viewed these Accounting questions

Question

2 How do toys fit into Maslows hierarchy of needs?

Answered: 1 week ago