Personal Budget Scenario

Our personal budget will be modified to handle the following:

Our electric bill will increase 5% for the months, January - June. We will calculate the new amount using absolute cell reference.

We will track our food budget by using an IF statement.

Since our electric bill has increased, we MUST turn in the lease on our current car and purchase a less expensive vehicle. We will use the PMT function to calculate our monthly payment.

We will see (forecast) how much money we can save by using the FV function.

working on Excel Project 2-Personal Budget Saved justin mumay File Home Insert Draw Page Layout Formulas Data Review iew Add-ins Help Team Tell me what you want to do Share Cut 2 AutoSum , A Calibri General Copy Format painter 5818 Conditional Format as Cel Formatting Table Styles Insert Delete Formate -- Fill Clear, Paste 2. Merge & Cen er $ . % , -' Sort & Find & Filter Select- . Clipboard Font Alignment Number Styles Editing E15 Six Month Budget: January-June 6 Month Average $1,300.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 1,300.00 $7,800.00 1,300.00 $550.00$550.00 $550.00 $550.00 $550.00 $550.00 $3,300.00$550.00 $145.00$176.00 $230.00 $320.00 $275.00 $305.00 $1,451.00$241.83 350.00$375.00 $275.00 $175.00 $200.00 $225.00 $1,600.00$266.67 467.00$500.00 $542.00 $786.00 $664.00 $342.00 $3,301.00$550.17 250.00 $150.00$200.00 $175.00 $125.00 $225.00 $1,125.00$187.50 175.00 $175.00 $175.00 $175.00 $175.00 $175.00 $1,050.00$175.00 235.00$265.00 $235.00 $280.00 $235.00 $290.00 $1,540.00$256.67 January February March AprMay June Total 2 Expenses 3 Mortgage 4 Car Payment 5 Car Gas 6 Electric 7 Food 8 Entertainment 9 Phone 10 Cable 11 ITotal Yearly Total Jan-June uly-Dec Ready 150% 2:05 AM O Type here to search 11/12/2018