SHOW WORK PLEASE!!!!!

Using the following spreadsheet, prepare a cash budget for New Tech for the next year (Jan Dec).

What would happen to New Techs need for external financing if sales varied plus or minus 10%, 20%, and 30% from the forecasted level? Prepare a sensitivity analysis.

What would happen to New Techs financing needs if the customers began to pay 15% in the month of sale, 60% the month after, and rest in 2 months? Assume 3% bad debt remains.

SHOW WORK PLEASE!!!!!

New Tech	Oct	Nov	Dec
Sales (Prior Year)	325	325	325
Purchases			59.2
Payment Schedule
Cash Sales	10%
30 day payment	70%
60 day payment	20%
Purchase Schedule
Paid first 30 days	40%
Paid second 60 days	60%
	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Sales	325	300	275	325	350	375	400	375	350	300	275	250
Purchases	59	59.2	59.2	59.2	59.2	59.2	59.2	59.2	59.2	59.2	59.2	59.2
Disbursements
Freight in	4.2	4	5.1	5.4	7.3	6.5	6.7	6.6	6.1	7	5.8	5.7
Labor	40	39	38	42	38.4	44.3	42.5	41	38	39	39.5	38
Utilities	2.5	2.2	2.4	2.5	2.5	2.8	2.7	2.5	2.6	2.6	2.6	2.4
Salaries (Sales)	60	62	65.8	62.8	62.7	67.9	71.6	62.8	64.9	66.9	68	65
Commissions	5.9	5	5.8	6.8	6.9	7.4	8	7.8	6.5	6.8	6.4	6.4
Travel	7	7.1	6.9	6.8	7.6	7.8	8.4	7.5	7.7	7.7	7.9	7.4
Advertising	6	6.5	7	9	8.5	8.7	8.3	8.1	7	7.2	6	7.5
Other charges	5	6	3	40	50	21.5	18.3	18.7	18.9	16	8.5	14
Selling
Salaries (Admin)	35	35	34	33	36	36	38	39	35	33	32	34
Leasing	5.8	5.8	5.8	5.8	5.8	5.8	5.8	5.8	5.8	5.8	5.8	5.8
R and D	8.3	10.3	15.6	7.5	8.3	7.7	7.9	6.2	6.7	6.9	6.3	8.3
Taxes	9.3	9.3	9.3	9.3	9.3	9.3	9.3	9.3	9.3	9.3	9.3	9.3
Purchase of assets	40	45	33	350	500	16.8	23.8	23	18	20	20	10