Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets Instruments And Institutions

Authors: Anthony M. Santomero, David Babbel

2nd Edition

0072358688, 9780072358681

More Books

Students also viewed these Finance questions

Question

Different types of Grading?

Answered: 1 week ago

Question

Explain the functions of financial management.

Answered: 1 week ago

Question

HOW MANY TOTAL WORLD WAR?

Answered: 1 week ago

Question

Discuss the scope of financial management.

Answered: 1 week ago