Question

Han Company is preparing its financial records to get ready to apply for an important bank loan. In the past when Han has applied for bank loans, the bank loan officer has asked Han to provide a forecast of the amount of cash payments the company will have to make to its suppliers for inventory purchases. The bank loan officer needs this information in order to assess Han’s ability to repay any bank loans. Han was embarrassed in the past because he did not have that cash payment forecast. This time he will be prepared.

It is January 1 of Year 2. Purchases for Han Company for January, February, and March are forecasted to be as follows:

January, $200,000; February $400,000; March, $500,000

20% of purchases are for cash. Of the credit purchases, 30% are paid during the month of the purchase, 50% in the month following the purchase, and 20% in the second month following the purchases. Total purchases for November and December of Year 1 were $200,000 and $400,000, respectively.

What is the forecasted amount of total cash payments for purchases in March of Year 2? (Note: This is the sum of immediate payments from cash purchases, same-month cash payments of credit purchases, and cash payments for credit purchases made in prior months.)

Answer 1

Piurcjase can be in cash or on account

cash = 20%

credit = 80%

Credit purchase to be paid in same month = 30% (March )

Credit purchase to be paid in next month = 50% (Feb's 50% credit purchase will be paid in march)

Credit purchase to be paid in second month = 20% (January's 20% credit purchase will be paid in March)

	March
purchase	$500,000
Cash	$100,000($500,000*20%)
Credit	$400,000 [$500,000*80%]
30% of credit purchase of March	$120,000[$400,000*30%]
50% of credit purchase of February	$160,000[$400,000*80%*50%]
20% of credit purchase of January	$32,000[$200,000*80%*20%]
Total cash payment in March	$412,000[$100,000+$120,000+$160,000+$32,000]

Pleas eupvote if you find this helpful.Incase of query pelase comment.