1. John is seeking a loan from Capital One bank for $500,000. He seeks your advice in determining what should be his monthly payment if he wants to make the payment at the beginning of each month. The loan is for 30 years and is charged an annual interest rate of 4.25%.

SHOW ON EXECEL PLEASE

Prepare a cash flow statement to record the following information:
60% cash is received for sales made in the current month
35% of cash is received in the month following the sale
5% of the sale will not be collected. This is considered bad debt.
	June	July	Aug	Sept	Oct	Nov		Jan	Feb
Sales (units)	1,250	1,725	3,578	1,795	2,875	3,102	Dec	3,304	4,388
Price (per unit)	$ 10.00	$10.50	$ 10.75	$11.70	$ 11.90	$ 12.00	2,794	$ 13.50	$ 14.00
SHOW	ON	EXCEL	PLEASE				$ 12.75