Question

The beginning cash balance is $10,000. Sales are forecasted at $800,000 of which 80% will be...

The beginning cash balance is $10,000. Sales are forecasted at $800,000 of which 80% will be on credit. 70% of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $9,000 will be collected in the current year. The company is required to make a $15,000 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $90,000, and the annual interest rate is 10%.

Homework Answers

Answer #1
Solution:
Computation of Closing Cash Balance
Particluars Amount ($) Amount ($)
Beginning Cash Balance      10,000.00
Add: Cash Sales
(800000*20%) 1,60,000.00
Add: Collection from credit sales
(800000*80%*70%) 4,48,000.00
Add: Collection from Accounts Receivable        9,000.00 6,17,000.00
Less: Cash Expenditure 4,75,000.00
Less: Loan payment      15,000.00
Less: Interest on Loan
(90000*10%)        9,000.00 4,99,000.00
Closing Cash Balance 1,28,000.00
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The beginning cash balance is $10,000. Sales are forecasted at $800,000 of which 80% will be...
The beginning cash balance is $10,000. Sales are forecasted at $800,000 of which 80% will be on credit. 70% of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $9,000 will be collected in the current year. The company is required to make a $15,000 loan payment and an annual interest payment on the last day of every year. The loan...
The beginning cash balance is $15,000. Sales are forecasted at $800,000 of which 80% will be...
The beginning cash balance is $15,000. Sales are forecasted at $800,000 of which 80% will be on credit. 70% of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $9,000 will be collected in the current year. The company is required to make a $15,000 loan payment and an annual interest payment on the last day of every year. The loan...
Determining Cash Collections through Account Analysis Lewis Company had a beginning balance and ending balance in...
Determining Cash Collections through Account Analysis Lewis Company had a beginning balance and ending balance in accounts receivable of $260,000, and $304,000, respectively. Sales on credit were $1,800,000 for the year and the company wrote off accounts totaling $1,320 during the year. What were cash collections from sales during the year? 1. Cash Collections $____
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow. July August September Budgeted sales $ 59,500 $ 75,500 $ 52,500 Budgeted cash payments for Direct materials 17,060 14,340 14,660 Direct labor 4,940 4,260 4,340 Factory overhead 21,100 17,700 18,100 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances...
Budgeting XYZ Corporation is preparing a cash budget for the first two months of the coming...
Budgeting XYZ Corporation is preparing a cash budget for the first two months of the coming year. The following data have been forecasted: January February Sales $ 750,000 $ 800,000 Purchases 450,000 480,000 Operating expenses: Payroll 146,800 167,400 Advertising 52,700 62,800 Rent 8,750 8,750 Depreciation 23,750 23,750 End-of-January balances: Cash 120,000 Bank loan 480,000 Additional data: Sales are 40% cash and 60% credit. The term of credit sales is 2/10, n/30. The collection pattern for credit sales is 80% in...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly 18½ years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% (APR), how much cash will you have from the sale once you pay off the mortgage? Sale price $        1,000,000 Initial balance $           800,000 Number of years                        30 Periods...
Cruises, Inc. has budgeted sales revenues as follows: June July August Credit Sales $135,000 $135,000 $90,000...
Cruises, Inc. has budgeted sales revenues as follows: June July August Credit Sales $135,000 $135,000 $90,000 Cash Sales 90,000 225,000 195,000 Total Sales $225,00 $380,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Cash disbursements were $421,000 for July and $250,500 for August. The company wishes to maintain a minimum cash balance of $50,000 at the end of each...
Develop a cash budget for the next two months using the information provided below Monthly sales...
Develop a cash budget for the next two months using the information provided below Monthly sales forecast are $210,000 and $30,000 for the next two months The current month's sales were $140,000 80% of sales are collected in the month of sale, with the remainder collected in the following month Cost of goods sold equal 70% of sales The monthly lease payment is $75,000 The cash position at the end of the current month is $70,000 The target cash balance...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
Jasper Company has sales on account and for cash. Specifically, 56% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 56% of its sales are on account and 44% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $519,000 for April, $529,000 for May, and $554,000 for June. The beginning balance of Accounts Receivable is $309,100 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT