Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 24-05 Given the following information, construct the firm's cash budget for the given months and answer the questions All sales are for credit and
Problem 24-05 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 occur after 30 days A $90,000 Treasury bill matures in March Montsed disbursements are 515.000 Variable disbursements are so percent of rates and occur one month prior to sales. (Variable cash disbursements are given for Aprt) . A tax payment of $20,000 is due in April A payment of $60,000 is to be received in February The initial cash $10,000 The minimum required cash balance is $1,000, Encer the disbursements values and required level of cash as positive values. Use as sign to enter cash outlows, shortage of cash values, reportive beginning and ending cash pouliers, arw. Do not leave any cells blank. If the answer ismero, entero January February April Sales $ 170.000 5 220,000 $ 170,000 $ Collections $ S S Other receipts $ 5 Toch recept Vaste bursements $ 50.000 weddisbursements 5 5 Other distursements 5 Tot cash disbursements $ Net change during the $ 5 5 mont Beginning cash 10.000 5 Endog chi $ $ Required cash 5 0.0005 De (hor) of cash 5 At the end of March, what are there's (1) accounts recev () morate securities, and () counts par Ascome that the volumes for April are owed the end Mard. Assume that may be wested in short term Securities. Round your wars to the rest Accounts receivables Markets a. At the end of March, what are the firm's (1) accounts receivable. (2) marketable securities, and (3) accounts payable? Assume that the variable disbursements for April Mewed at the end of March. Assume that excess cash may be invested in short-term securities. Round your answers to the nearest dollar Accounts receivables Marketable securities: 5 Accounts payable What is the maximum amount that the firm may have to borrow Round your answer to the newest dolor. Enter your answer as a positive volum cut 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 affected Associated with tax payments, which would be the cash oudget
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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