Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi can you please help me with requirement 2. Lipman Auto Parts, a famly-owned auto parts store, began January with $10,900 cash. Management forecasts that
Hi can you please help me with requirement 2.
Lipman Auto Parts, a famly-owned auto parts store, began January with $10,900 cash. Management forecasts that collections from credit customers wil be $11,200 in January and $15,300 in February. The store is scheduled to receive $5,500 cash on a business note receivable in January, Projected cash payments include Inventory purchases ($13 300 in January and $13,100 in Fabruary) and selling and administrative expenses ($3,300 sach month) Click the icon to view additional information about Lipman Auto Parts.) Read the racuirements Prepare the cash budget by entering in the labels, then enter in the amounts for January first and February next (Complete all answer bones. For entries with a $0 balance, make sure to enter "U" in the appropriate cell. Use parentheses or a minus sign when entering a deficiency) Lipman Auto Parts Cash Budget January and February January February Beginning cash balance $ 10,900 s 11.000 Cash receials from customers 11,200 15,300 Gash rocnint on noin monivabla 5.500 Cash available $ 27,600 s 26,300 Cash payments: Purchases of inventory 13,300 13,100 3,300 Selling and administrative expenses 3,300 16,600 18,400 Total cash payments Encing cash balance before financing $ $ 11,000 S 9.900 Less: Minimurn cash balance desired 110,000) (10,000) Projected cash excess deficiency) S 1,000 S (100) Tolal effects of financing D 1,000 $ Ending cash balance 11,000 S 10,900 Requirement 2. How much cash will Lipiran Auto Parls borrow in February if collections for customers that run total $14.300 instead of $15,300? if cash collections in February are $14,300 instead of $15.300, the company will bom 3Step 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