Question

This problem involves creating a monthly budget. The column headings for your expenses are given as well as a column for any deposits and a column for the balance in your checking account. The spreadsheet gives you several rows with values inserted. a.) In cell L4, enter 2,387.12 and format as accounting. b.) In cell L6, enter a formula which takes the starting balance in cell L4 and subtracts any expenses for this row (Hint: you may subtract the SUM of the expenses) and then adds in the deposit for that day. Remember that in a template like this our formulas should include blank cells. Next month we may have a deposit or a miscellaneous expense on this first day and our formula should be ready for this. c.) We cannot fill the formula in cell L6 down to L7 because the cell reference in L4 will change to L5, but there is not a number in L5, only the word "Balance". In cell L7, enter a formula which takes the previous balance in cell L6 and subtracts any expenses for that row (Hint: you may subtract the SUM of the expenses) and then adds in the deposit for that day. d.) Now fill the formula in cell L7 down to L24. In row 24 for January 19, enter 22.37 for Gas, 128.99 for Phone, and 75.43 for Electric. Format all as accounting. e.) In A25:A36, enter the dates Jan 20 to Jan 31. Format as in the cells above. In cells L25:L36 fill down the formula from L24.

Answer 1

Monthly Budget									Beginning Balance		2,387.12
Date	Gas	Groceries	Dinning Out	Phone	Insurance	Cable	Rent	Electric	Miscelleneous	Deposit	Balance
01-Jan	$    36.75		$          42.50		$   113.72	$ 145.63	$ 750.00				$    1,298.52
02-Jan											$    1,298.52
03-Jan											$    1,298.52
04-Jan		$   102.35							$                  4.35		$    1,191.82
05-Jan											$    1,191.82
06-Jan	$    43.78										$    1,148.04
07-Jan											$    1,148.04
08-Jan											$    1,148.04
09-Jan											$    1,148.04
10-Jan											$    1,148.04
11-Jan											$    1,148.04
12-Jan											$    1,148.04
13-Jan											$    1,148.04
14-Jan											$    1,148.04
15-Jan											$    1,148.04
16-Jan											$    1,148.04
17-Jan											$    1,148.04
18-Jan											$    1,148.04
19-Jan	$    22.37			$ 128.99				$ 75.43			$        921.25
20-Jan											$        921.25
21-Jan											$        921.25
22-Jan											$        921.25
23-Jan											$        921.25
24-Jan											$        921.25
25-Jan											$        921.25
26-Jan											$        921.25
27-Jan											$        921.25
28-Jan											$        921.25
29-Jan											$        921.25
30-Jan											$        921.25
31-Jan											$        921.25
SUM	$ 102.90	$   102.35	$          42.50	$ 128.99	$   113.72	$ 145.63	$ 750.00	$ 75.43	$                  4.35	$        -	$ 33,179.97
AVERAGE	$    34.30	$   102.35	$          42.50	$ 128.99	$   113.72	$ 145.63	$ 750.00	$ 75.43	$                  4.35	$        -	$    1,070.32
COUNT	3	1	1	1	1	1	1	1	1	-	31.00
MAX	$    43.78	$   102.35	$          42.50	$ 128.99	$   113.72	$ 145.63	$ 750.00	$ 75.43	$                  4.35	$        -	$    1,298.52
MIN	$    22.37	$   102.35	$          42.50	$ 128.99	$   113.72	$ 145.63	$ 750.00	$ 75.43	$                  4.35	$        -	$        921.25
									Part g	i	B39
										ii	C42
										iii	D38
										iv	K40
										v	L4
									Part h	L38