Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedHi 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 3

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

Curriculum Auditing

Authors: Fenwick W. English

1st Edition

0877625921, 978-0877625926

More Books

Students also viewed these Accounting questions

Question

an element of formality in the workplace between different levels;

Answered: 1 week ago