Question: Please Help. I am working on this excel annual budget project where my last step is to find two variable table. Please help me how
Please Help.
I am working on this excel annual budget project where my last step is to find two variable table. Please help me how to do it.
"Make a 2-variable data table using APR as variable 1 with a range of 4-7%, changing by .25%. You will then use cost of house as variable 2. Cost of house option 1 will be your first 6 digits of your z-id, then option 2 will take that plus $15,000 and option 3 will take option 2 plus $15,000 again. (For example, if my z-id is 1234567, Option 1 is 123456, Option 2 is 123456+15000=138456, and Option 3 is 138456+15000=153456.) This will show you how much your monthly payments would increase based on each APR and each different house cost"
This is the budget analysis data.
| Input Area | |
| Cost of House | $186,247.00 |
| Down Payment | $37,249.40 |
| APR | 4% |
| No. of Years for Loan | 15 |
| Payments per Year | 12 |
| Output Area | |
| Amount of Loan | $148,997.60 |
| Periodic Rate | 0.00333333 |
| No. Payment Periods | 180 |
| Monthly Payment | $1,102.12 |
| Total to Repay Loan | $198,381.11 |
| Total Interest Paid | $49,383.51 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
