Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Olde Corporation is preparing a cash budget for the first two months of the coming year. The following data have been forecasted: Sales

1|Olde Corporation is preparing a cash budget for the first two months of the coming year. The following data have been forecasted: ebruary $750,000 $800,000 450,000 480,000 anua ales rchases perating expenses Payroll Advertising Rent Depreciation 146,800 167,400 62,80 8,75 23,75 52,700 8,750 23,750 d of January balances Cash Bank loan 120,000 480,000 Additional data (1) Sales are 40% on cash and the collection pattern for credit sales is 40% in the month following the month of sale, and 20% in the month thereafter. Total sales in December of the prior year were S1,000,000. (2) Purchases are all on cash (3) Operating expenses are paid in the month incurred (4) The firm desires to maintain its cash balance at $150,000 at the end of each month (5) Loans are used to maintain the minimum cash balance. Repayments are made (at the end of the month) whenever the cash balance exceeds $150,000 What is the amount of the loan balance at the end of February (after loan repayments, if any)? 

1. Olde Corporation is preparing a cash budget for the first two months of the coming year. The following data have been forecasted: Sales Purchases Operating expenses: Payroll Advertising Rent Depreciation End of January balances: Cash Bank loan Additional data: January $750,000 450,000 146,800 52,700 8,750 23,750 120,000 480,000 February $800,000 480,000 167,400 62,800 8,750 23,750 (1) Sales are 40% on cash and the collection pattern for credit sales is 40% in the month following the month of sale, and 20% in the month thereafter. Total sales in December of the prior year were $1,000,000. (2) Purchases are all on cash (3) Operating expenses are paid in the month incurred. (4) The firm desires to maintain its cash balance at $150,000 at the end of each month. (5) Loans are used to maintain the minimum cash balance. Repayments are made (at the end of the month) whenever the cash balance exceeds $150,000. What is the amount of the loan balance at the end of February (after loan repayments, if any)?

Step by Step Solution

3.60 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Beginning cash balance Collection from sales Total Cash available to spend Less ... 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_2

Step: 3

blur-text-image_3

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

Managerial Accounting

Authors: Karen W. Braun, Wendy M. Tietz

3rd edition

132890542, 978-0132890540

More Books

Students also viewed these Accounting questions

Question

Cite ways to overcome fear of failure.

Answered: 1 week ago

Question

8. Name the three catecholamine neurotransmitters.

Answered: 1 week ago

Question

14. State the all-or-none law.

Answered: 1 week ago