Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer The Following 2. In April, a firm had an ending cash balance of $35,000. In May, the firm had total cash receipts of $40,000

image text in transcribed
image text in transcribed
Answer The Following 2. In April, a firm had an ending cash balance of $35,000. In May, the firm had total cash receipts of $40,000 and total cash disbursements of $50,000. The minimum cash balance required by the firm is $25,000. At the end of May, the firm had Lamia's House of Software (LHS) wants to prepare a cash budget for months of September through December. Using the following information, Sales were $50,000 in June and $60,000 in July. Sales have been forecasted to be $65,000, $72,000, $63,000, $59,000, and $56,000 for months of August, September October, November, and December, respectively. In the past, 10 percent of sales were on cash basis, and the collection were 50 percent in the first month, 30 percent in the second month, and 10 percent in the third month following the sales. Every four months (three times a year) $500 of dividends from investments are expected. The first dividend payment was received in January Purchases are 60 percent of sales, 15 percent of which are paid in cash, 65 percent are paid one month later, and the rest is paid two months after purchase. $8,000 dividends are paid twice a year (in March and September). The monthly rent is $2,000. Taxes are $6,500 payable in December. A new machine will be purchased in October for $2,300. $1,500 interest will be paid in November $1,000 loan payments are paid every month. Wages and salaries are $1,000 plus 5 percent of sales in each month. August's ending cash balance is $3,000. LHS would like to maintain a minimum cash balance of $10,000 October Cash $1,570 ExcessCash + X November Cash $36.900 Excess cash >

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

The Politics Of Internal Auditing

Authors: Dr. Larry Rittenberg, Patty Miller

1st Edition

0894139053, 978-0894139055

More Books

Students also viewed these Accounting questions