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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started