Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use excelnand show working Golden State Company has applied at a local bank for a short-term loan of $150,000 starting on October 1, 2019.

image text in transcribed
please use excelnand show working
Golden State Company has applied at a local bank for a short-term loan of $150,000 starting on October 1, 2019. The bank's loan officer has requested a cash budget from the company for the quarter ending December 31, 2019. The following information is needed to prepare the cash budget: Sales Purchases Salaries and wages to be paid Rent payments Supplies (payments for) Insurance payments Other cash payments $600,000 350,000 125,000 7,000 4,500 1,500 22,000 A cash balance of $24,000 is planned for October 1 (beginning of quarter). Accounts receivable are expected to be $48,000 on October 1. All of these accounts will be collected in the quarter ending December 31. In general, Sales are collected as follows: 90% in the quarter of the sale and 10% in the quarter after the sale. Accounts Payable are planned to be $480,000 at October 1 and will be paid during the quarter ended December 31. All purchases are paid for in the quarter after the purchase. a. Prepare a cash budget for the quarter ending December 31, 2019. Assume that the $150,000 loan will be made on October 1 and will be repaid with interest at 10% on December 31. (Use the format for the Cash Budget in the comprehensive example posted to Canvas. Don't forget the include the loan proceeds and the interest.) b. If the company desires a minimum cash balance of $18,000, will the company be able to repay the loan as planned on December 31

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

Audit Analytics Data Science For The Accounting Profession

Authors: J. Christopher Westland

1st Edition

3030490904, 9783030490904

More Books

Students also viewed these Accounting questions