Personal Budget Scenario Our personal budget will be modified to handle the following: Our electric bill will increase 5% for the months, January -...

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.

Please kindly use the link below to get the questions and help me. Thanks

Question link: https://drive.google.com/file/d/1Ou4wLehVCf_ociOrixVrZybTrPv3Cm0A/view?usp=sharing

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