Answered step by step
Verified Expert Solution
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
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 MarchStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started