Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jim Danjels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mc

image text in transcribed
image text in transcribed
Jim Danjels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mc Hewitt, the banker, will finance construction if the firm can present an acceptoble three-month finoncial plan for January through March. Following are actual and forecasted sales figures: Of the firm's sales, 30 percent ore for cash and the temaining 70 percent ore on credit. Of credit sales, 25 percent are paid in the month after sole and 75 percent are paid in the second month ofter the sale. Materials cost 40 percent of sales and are purchased and received each month in an amount sufficient to cover the current month's expected soles. Moteriois are paid for in the month they are recelved. Lobour expense is 30 percent of soles and is poid in the month of soles. Seling ond odiministrotive expense is 4 percent of sales and is also poid in the month of sales. Overhead is $28.500 in cash per month, omortization expense is $10.100 per month. Toxes of $8,100 will be poid in January and dividends of $2,500 wil be paid in March. Cash at the beginning of Januacy is $82,000 and the minimum desired cash bolonce is $77,000. a. Prepare a schedule of monthly cosh receipts for Jonuary. February and March. b. Prepare a schedule of monthly cash payments for January, February and March c. Prepare a schedule of monthly cash budget with borrowings and repayments for Jonuary. February and March. (Do not leave any empty spaces: input a 0 wherever it is required. Negative answers and amounts to be deducted should be indicated by a minus sign.)

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

Auditing And Systems Exam Questions And Explanations

Authors: Ph.D. Gleim, Irvin N., Ph.D. Hillison, William A., Grady M. Irwin

17th Edition

1581949278, 978-1581949278

More Books

Students also viewed these Accounting questions