Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How would you analyze these two cash budgets? 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if

How would you analyze these two cash budgets?

image text in transcribed
1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Cash Budget January February March Beginning Balance $ 50,000 $ 69,000 $ 169,000 Cash Reciepts $ 650,000 $ +25,000 $ 475,000 Total Cash Available $ 600,000 $ 194,000 $ 644,000 Cash payments | $ 430,000 325,000 $ 550,000 Interest expense 1,000 3 Prelimnary cash balance $ 169,000 $ 169,000 $ 94,000 Additional loan/ loan repayment (100,000) Ending Cash Balance 59,000 $ 169,000 $ 94,000 Loan Balance at the beginning of month 100,000 Additional loan/ loan repayment 100,000) Loan Balance-End of Month If the cash receipts and cash payments were as follows, how would the cash budget change. 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated in parentheses "()".) Cash Receipts Cash Payments January 350,000 $ 430,000 February 400,000 $ 325,000 March 575,000 $ 400,000 Cash Budget January February March Beginning Balance $ 50,000 $ 50,000 | $ 50,000 Cash Receipts 350,000 $ 400,000 $ 575,000 Total Cash Available 400,000 450,000 $ 625,000 Cash payments 430,000 $ 325,000 S 400,000 Interest expense 1,000 $ 1,810 $ 1,078 Prelimnary cash balance 31,000) $ 123,190 $ 223,922 Additional loan/ loan repayment 81,000 $ (73,190) $ (107,810) Ending Cash Balance S 50,000 $ 50,000 $ 116,112 Loan Balance at the beginning of month 100,000 $ 181,000 $ 107,810 Additional loan/ loan repayment 31,000 $ (73,190) $ (107,810) Loan Balance-End of Month 181,000 $ 107,810

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

Corporate Financial Strategy

Authors: Ruth Bender

4th Edition

1136181105, 9781136181108

More Books

Students also viewed these Accounting questions

Question

An improvement in the exchange of information in negotiations.

Answered: 1 week ago