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.

NOTE: THIS IS THE LINK TO THE EXCELL DOCUMENT

https://drive.google.com/file/d/15odVZYxrFhnFgoYhrKfEf9_zV18OBHjl/view?usp=sharing

BELOW ARE SCREENSHOTS OF THE EXCELL DOC AND QUESTIONS

TRM Excel Project 2 Instructions.pdf. Adobe Acrobat Reader DC ile Edit View Window Help Home Tools TKM. Excel Project. XExcel Praject 3 Instr... Sign In 1 13 130% Share Section 1: Using Absolute Cell Reference We have been notified that our electric bill will have a 5% increase for the months. January thru June 1. Open the "Excel Project 2 Personal Budget" file 2. Make sure you on the "Jan-June" worksheet. 3. In cell A15 type in the following: "Electric Increase Percentage" 4. In cell B15 type in the following: "Amount with Increase." Make sure the text is in 1 cell on 2 lines. HINT: If using Windows- use ALT+ENTER. If using a Mac-use CTRL+ALT+ENTER. 2 I- 3:54 AM O Type here to search 11/12/2018