Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company has a cash balance on June 1 of $9,740 and has no outstanding loans. The company requires a minimum $8,340 cash balance at

A company has a cash balance on June 1 of $9,740 and has no outstanding loans. The company requires a minimum $8,340 cash balance at each month-end. Loans taken to keep this minimum balance require payment of 1% interest at each month-end. Any preliminary cash balance of more than $8,340 at month-end is used to repay loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for interest or loan payments) follow.

image text in transcribed

Cash receipts (other than for loans received) Cash payments (other than for interest or loan payments) Prepare a cash budget for June, July, and August. June July August $ 28,400 32,900 $ 36,400 34,400 $ 44,400 36,400 Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round final answers to the nearest whole dollar. Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on loan Cash payments Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance Loan balance, Beginning of month Additional loan (loan repayment) Loan balance, End of month Cash Budget June July August $ 9,740 $ 8,340 $ 8,340 28,400 36,400 44,400 38,140 44,740 52,740 0 0 0 Loan balance $ 0

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

Intermediate Accounting

Authors: kieso, weygandt and warfield.

IFRS Edition

978-1118443965, 1118800532, 9781118800539, 978-0470873991

More Books

Students also viewed these Accounting questions

Question

Describe three types of guided media.

Answered: 1 week ago

Question

What are the major parts of an email message?

Answered: 1 week ago