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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!