Question: In effort to describe the two tables [=TABLE]...one-variable data table should point to the APR, while the other [=TABLE] should incorporate both the Cost of
| In effort to describe the two tables [=TABLE]...one-variable data table should point to the APR, while the other [=TABLE] should incorporate both the Cost of Home and the APR.
This assignment requires a PMT, SUM, Subtraction, Multiplication, Division, and the utilization of developing Tables - both one-variable and two-variable data tables.
Morgatage Calulator | |||||||||||
| Input Area | One-Variable Data Table: APR | Two-Variable Data Table: APR and Cost of Home | |||||||||
| Cost of home | $ 150,000.00 | Calculated Results for Each APR | Monthly Payment by Cost/APR | ||||||||
| Down Payment | $ 10,000.00 | APR | Payment | Total Repaid | Total Interest | APR | $ 200,000.00 | $ 225,000.00 | $ 250,000.00 | ||
| APR | 4.00% | 4.00% | 4.00% | ||||||||
| No. Years for Loan | 30 | 4.25% | 4.25% | ||||||||
| Payments Per Year | 12 | 4.50% | 4.50% | ||||||||
| 4.75% | 4.75% | ||||||||||
| Output Area | 5.00% | 5.00% | |||||||||
| Amount of Loan | 5.25% | 5.25% | |||||||||
| Periodic Rate | 5.50% | 5.50% | |||||||||
| No. Payment Periods | 5.75% | 5.75% | |||||||||
| Monthly Payment | 6.00% | 6.00% | |||||||||
| Total to Repay Loan | 6.25% | ||||||||||
| Total Interest Paid | 6.50% | ||||||||||
| 6.75% | |||||||||||
| 7.00% | |||||||||||
| 7.25% | |||||||||||
| 7.50% | |||||||||||
| 7.75% | |||||||||||
| 8.00% | |||||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help