Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please full calculation and explanation. PetPlace requires a minimum cash balance of $30,000 at the end of March of the current year in order to

image text in transcribed

please full calculation and explanation.

PetPlace requires a minimum cash balance of $30,000 at the end of March of the current year in order to remodel its store. Any required borrowings take place in increments of $10,000 with interest of 1.5% per month. Repayments of borrowed funds are also made in increments of $10,000. Assume that borrowings are made on the first day of the month in which the cash is required, and that repayments are made on the last day of the month. The cash balance at the beginning of March is $7,000. During March, the store expects to collect $100,500 from sales made during January and February. The store expects monthly sales of $360,000 during March, $432,000 in April and $388,800 in May. Each unit sold has a price of $12.00. All sales are on credit. Experience indicates that the store will collect 60% of credit sales in the month of the sale, 30% in the month following the sale, and 7% in the second month following the sale. The remaining amount is uncollectible. In February, the store sold some display cases for $5,000 and expects to collect this amount in March. The inventory balance at the beginning of March is $50,000. Purchases in a given month average 50% of projected sales for that month. The owners pay all accounts payable arising from inventory purchases in time to receive a 2% discount. On average, 75% of the accounts payable related to inventory are paid for in the month of purchase, with the remaining 25% being paid in the following month. The accounts payable outstanding from February inventory purchases is $35,280 at the end of February Budgeted operating expenses for March include rent at 8% of sales, advertising ($27,000), employee compensation ($72,000 ), depreciation ($2,000 ), and insurance ($3,000 ). Depreciation is calculated on a straight-line basis and insurance is paid one a year in June, and the related expense is recorded in all other months by reducing the prepaid insurance account. Interest is paid monthly on the last day of the month. (Note that there will be interest expense in the month in which funds are borrowed. Required: Prepare a cash budget for PetPlace for March of the current year. How much, if any, will need to be borrowed at the end of March

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_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

Advanced Management Accounting

Authors: Robert S. Kaplan, Anthony A. Atkinson, Kaplan And Atkinson

3rd Edition

0132622882, 978-0132622882

More Books

Students also viewed these Accounting questions

Question

Why is it important to have a dream? (p. 49)

Answered: 1 week ago