Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following information, construct the firm s cash budget for the given months and answer the questions. All sales are for credit and collections

Given the following information, construct the firms cash budget for the given months and answer the questions.
All sales are for credit and collections occur after 30 days.
A $100,000 Treasury bill matures in March.
Monthly fixed disbursements are $20,000.
Variable disbursements are 35 percent of sales and occur one month prior to sales. (Variable cash disbursements are given for April.)
A tax payment of $40,000 is due in April.
A payment of $50,000 is to be received in February.
The initial cash is $20,000.
The minimum required cash balance is $9,000.
Enter the disbursements values and required level of cash as positive values. Use a minus sign to enter cash outflows, shortage of cash values, negative beginning and ending cash positions, if any. Do not leave any cells blank. If the answer is zero, enter "0".
January February March April
Sales $
$ 180,000 $ 200,000 $ 180,000
Cash sales $
$
$
$
Collections $
$
$
$
Other receipts $
$
$
$
Total cash receipts $
$
$
$
Variable disbursements $
$
$
$ 90,000
Fixed disbursements $
$
$
$
Other disbursements $
$
$
$
Total cash disbursements $
$
$
$
Net change during the month $
$
$
$
Beginning cash $ 20,000 $
$
$
Ending cash $
$
$
$
Required cash $ 9,000 $
$
$
Excess (shortage) of cash $
$
$
$
At the end of March, what are the firms (1) accounts receivable, (2) marketable securities, and (3) accounts payable? Assume that the variable disbursements for April are owed at the end of March. Assume that excess cash may be invested in short-term securities. Round your answers to the nearest dollar.
Accounts receivable: $
Marketable securities: $
Accounts payable: $
What is the maximum amount that the firm may have to borrow? Round your answer to the nearest dollar. Enter your answer as a positive value.
$
If the firm used accelerated depreciation instead of straight-line depreciation, how would that affect the cash budget?
Any tax benefits associated with using accelerated depreciation may affect
-Select-
associated with tax payments, which would alter the cash budget.

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

Step: 3

blur-text-image

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

Financial Accounting an introduction to concepts, methods and uses

Authors: Clyde P. Stickney, Roman L. Weil, Katherine Schipper, Jennifer Francis

13th Edition

978-0538776080, 324651147, 538776080, 9780324651140, 978-0324789003

More Books

Students also viewed these Accounting questions

Question

=+a. What is the 84th percentile?

Answered: 1 week ago