Sipan Retail Company was recently created with a beginning cash balance of $12,000. The owner expects the following for the first month of operations: Cash sales to customers $8,000 Sales on account to customers $30,000 Cash collected from account customers $12,000 Cost of merchandise purchased $35,000 Cash paid for merchandise purchased $24,500 Cost of merchandise sold $26,600 Cash paid for display cases $9,600 Selling and administrative expenses $4,000 The display cases above were purchased at the beginning of the month and are being depreciated at a rate of $200 per month. This amount is included in the selling and administrative expenses figure above. All other selling and administrative expenses are paid as incurred. Sipan wants to maintain a cash balance of $10,000. Any amount below this can be borrowed from a local bank as needed in increments of $1,000. All borrowings are made at month end. 75. In Sipan's cash budget for this first month, how much money will Sipan need to borrow at month end? A) $7,000 B) $16,000 C) $17,000 D) $28,000
Sipan Retail Company was recently created with a beginning cash balance of $12,000. The owner expects the following for the first month of operations: Cash sales to customers $8,000 Sales on account to customers $30,000 Cash collected from account customers $12,000 Cost of merchandise purchased $35,000 Cash paid for merchandise purchased $24,500 Cost of merchandise sold $26,600 Cash paid for display cases $9,600 Selling and administrative expenses $4,000 The display cases above were purchased at the beginning of the month and are being depreciated at a rate of $200 per month. This amount is included in the selling and administrative expenses figure above. All other selling and administrative expenses are paid as incurred. Sipan wants to maintain a cash balance of $10,000. Any amount below this can be borrowed from a local bank as needed in increments of $1,000. All borrowings are made at month end. 75. In Sipan's cash budget for this first month, how much money will Sipan need to borrow at month end? A) $7,000 B) $16,000 C) $17,000 D) $28,000
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter21: Cash Budgeting (cashbud)
Section: Chapter Questions
Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...
Related questions
Question
Sipan Retail Company was recently created with a beginning cash balance of $12,000. The owner expects the following for the first month of operations:
Cash sales to customers $8,000
Sales on account to customers $30,000
Cash collected from account customers $12,000
Cost of merchandise purchased $35,000
Cash paid for merchandise purchased $24,500
Cost of merchandise sold $26,600
Cash paid for display cases $9,600
Selling and administrative expenses $4,000
The display cases above were purchased at the beginning of the month and are being depreciated at a rate of $200 per month. This amount is included in the selling and administrative expenses figure above. All other selling and administrative expenses are paid as incurred. Sipan wants to maintain a cash balance of $10,000. Any amount below this can be borrowed from a local bank as needed in increments of $1,000. All borrowings are made at month end.
75. In Sipan's cash budget for this first month, how much money will Sipan need to borrow at month end?
A) $7,000
B) $16,000
C) $17,000
D) $28,000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage