Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your friend, Catherine Ross, owns Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces. She has contacted you for some assistance because the accounting

Your friend, Catherine Ross, owns Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces. She has contacted you for some assistance because the accounting clerk, George Forrest, recently won a sum of money and decided to resign immediately. Catherine knows that you are completing an accounting course at Cape Breton University and hopes you can prepare the cash budget for the upcoming quarter (April, May and June, 2021).

Catherine has provided you with the budgets completed by George. She has also provided you with additional information that will assist with the completion of the cash budget. Completed Budgets (April, May, June, and Quarter Total, 2021)

Continued on the next page. ADDITIONAL INFORMATION: Cash balance, April 1, 2021 = $8,000 The companys monthly selling and administrative expenses are provided below. All selling and administrative expenses are paid in the month incurred, with the exception of depreciation and insurance. Insurance is paid on an annual basis in December of each year.

Variable expenses: Commissions 5% of sales

Fixed expenses: Advertising $19,000 Rent 20,500 Wages & salaries 125,000 Utilities 9,000 Insurance 3,000 Depreciation 18,000

The company plans to purchase new equipment for cash in May ($18,000) and June ($45,000). The company wants to have an ending cash balance each month of $40,000. All borrowing is done at the beginning of the month. The interest on outstanding loans is 1% per month. Loan repayments and interest is only paid at the end of the month when there is sufficient cash to do so. (The company does not borrow to pay interest or repay loans.)

REQUIRED: a. Prepare a cash budget in good form. Show the budget by month and in total. b. What will be reported on the budgeted balance sheet at June 30, 2021 for accounts receivable? Supporting calculations required. c. What will be reported on the budgeted balance sheet at June 30, 2021 for merchandise purchases payable? Supporting calculations required.

You may use the template on the next page for the cash budget if you wish.

Adapted from Managerial Accounting, 12th Edition.

Knockoffs Unlimited Cash Budget April, May, June (& Quarter Total), 2021

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

Rethinking Clinical Audit Psychotherapy Services In The NHS

Authors: Rachael Davenhill, Matthew Patrick

1st Edition

0415162084, 978-0415162081

More Books

Students also viewed these Accounting questions