Question 6	Prepare a cash flow statement to record the following information:
	50% cash is received for sales made in the current month
	45% of cash is received in the month following the sale
	5% of the sale will not be collected.
	(20 marks)
		June	July	Aug	Sept	Oct	Nov	Dec	Jan	Feb
	Sales (units)	800	950	6,845	900	1,255	1,125	2,050	2,400	3,125
	Price (per unit)	$ 10.00	$ 10.50	$ 10.75	$ 11.70	$ 11.90	$ 12.00	$ 12.75	$ 13.50	$ 14.00
Question 7	Your Dad asked you to tell him how much money he needs to invest today for your College. You are expected to pay tuition of $933.28 and boarding
	and lodging of $1,000 at the end of each month for the next 5 years. His bank will give him an annual interest rate of 6%.
	Use the Function formula to compute your answer. (5 marks). show the answer in excel please with formula