Show how you got your answers in Excel.

Month	Sales $	Month	Sales $
Jan	28,593	July	36,903
Feb	28,465	Aug	41,735
Mar	41,735	Sep	28,593
Apr	36,903	Oct	41,735
May	28,593	Nov	28,465
June	28,465	Dec	36,903

The company has estimated expenses as follows: General and administrative expenses: $8,122 Material purchases are 47 percent of sales. Material purchases are paid in the month following the purchase. Interest payment per month: $3,415 Rent expenses per quarter starting March: $4,744

Calculate the cash outflows for June.

Month	Sales $	Month	Sales $
Jan	37,768	July	26,283
Feb	30,621	Aug	12,005
Mar	12,005	Sep	37,768
Apr	26,283	Oct	12,005
May	37,768	Nov	30,621
June	30,621	Dec	26,283

Sales are collected as follows:

In the month of Sales: 25% In the next month: 28% After 2 months: 8% After 3 months: remainder is collected

Calculate the cash collection for December.

OnJuly 15^th, you purchased $10,000 worth of goods. The terms of the sale were 1/9, net 46. What is the effective annual rate of interest for the credit period for this sale?

Enter your answer in percentages rounded off to two decimal points.

ABC Company writes 216 checks a day for an average amount of $625 each. These checks generally clear the bank in 3 days. In addition, the firm generally receives an average of $179,787 a day in checks that are deposited immediately. Deposited funds are available in 1 days. What is the firm's net float?