Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I need help on how to construct the two variable table. second picture is the stufy guide I was given. Thanks! H - M N

I need help on how to construct the two variable table. second picture is the stufy guide I was given. Thanks! image text in transcribed
image text in transcribed
H - M N o P G for Each APR aid Total Interest .31 $ 100,617.31 .71 $ 107,937.71 .40 $ 115,369.40 0.26 $ 122,910.26 3.10 $ 130,558.10 0.67 $ 138,310.67 5.66 $ 146,165.66 3.72 $ 154,120.72 3.46 $ 162,173.46 R Monthly Payment by Cost/APR APR $ 200,000.00 $ 225,000.00 $ 250,000.00 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 7.50% 7.75% 8.00% RI 9:57 A 7/25/20 DOLL a Home End FG F7 PrtScr F11 FB F9 Insert F12 F10 & 7 6 00* ( 9 O OL 2 1 P input Arca Cost of home Down Payment APR No. Years for Loan Payments Per Year $ 150,000.00 $ 10,000.00 4.00% 30 12 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total Interest 4.00% S 668 38 $ 240,617.31 $ 100,617.31 4.25% $ 688.72 $ 247,937.71 $ 107,937.71 4.50% $ 709.36 S 255,369.40 $ 115,369.40 4.75% $ 730.31 $ 262,910.26 $ 122,910 26 5.00% $ 751.55 $ 270,558.10 $ 130,558.10 5.25% $ 773.09 $ 278,310.67 $ 138,310.67 5.50% $ 794.90 $ 286,165.66 $ 146,165.66 5.75% $ 817.00 $ 294,120.72 $ 154,120.72 6.00% $ 839.37 S 302,173.46 $ 162,173.46 Output Area Amount of loan Periodic Rate No. Payment Periods Monthly Payment Total to Repay Loan Total Interest Paid $ 140,000.00 0.33% 360 $ 668.38 $ 240,617.31 $ 100,617.31 Two-Variable Data Table: APR and Cost of Home Monthly Payment by Cost/APR APR $ 200,000.00 $ 225,000.00 $ 250,000.00 4.00% $ 907.09 $ 1,026.44 $ 1,145.80 4.25% $ 934.69 $ 1,057.67 5 1,180.66 4.50% 5 962.70 $ 1,089.375 1,216.04 4.75% $ 991.13 $ 1,121.54 $ 1,251.95 5.00% $ 1,019.96 $ 1.154.17 S 1,288.37 5.25% $ 1,049.19 $ 1,187.24 $ 1,325.29 5.50% S 1,078 805 1.220.75$ 1,362.69 5.75% $ 1,108.79 $ 1,254.68 $ 1,400.57 6.00% 5 1,139.15 S 1,289.03 $ 1.438.92 6.25 1,169.86 $ 1,323.79 $ 1,477.72 6.50% $ 1,200.93 $ 1,358.95 $ 1.51696 6.75% $ 1,232.34 $ 1,394.49 $ 1,556.64 7.00% $ 1,264.07 $ 1.430.40 $ 1.596.73 7.25% $ 1.296.13 $ 1,466.68 $ 1,637.22 7.50% $ 1,328.51 $ 1,503.31 $ 1,678.11 7.75% $ 1,361.18 $ 1.540.29 $ 1,719.39 8.00% $ 1,394.155 1,577.59 $ 1,761.03 H - M N o P G for Each APR aid Total Interest .31 $ 100,617.31 .71 $ 107,937.71 .40 $ 115,369.40 0.26 $ 122,910.26 3.10 $ 130,558.10 0.67 $ 138,310.67 5.66 $ 146,165.66 3.72 $ 154,120.72 3.46 $ 162,173.46 R Monthly Payment by Cost/APR APR $ 200,000.00 $ 225,000.00 $ 250,000.00 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 7.50% 7.75% 8.00% RI 9:57 A 7/25/20 DOLL a Home End FG F7 PrtScr F11 FB F9 Insert F12 F10 & 7 6 00* ( 9 O OL 2 1 P input Arca Cost of home Down Payment APR No. Years for Loan Payments Per Year $ 150,000.00 $ 10,000.00 4.00% 30 12 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total Interest 4.00% S 668 38 $ 240,617.31 $ 100,617.31 4.25% $ 688.72 $ 247,937.71 $ 107,937.71 4.50% $ 709.36 S 255,369.40 $ 115,369.40 4.75% $ 730.31 $ 262,910.26 $ 122,910 26 5.00% $ 751.55 $ 270,558.10 $ 130,558.10 5.25% $ 773.09 $ 278,310.67 $ 138,310.67 5.50% $ 794.90 $ 286,165.66 $ 146,165.66 5.75% $ 817.00 $ 294,120.72 $ 154,120.72 6.00% $ 839.37 S 302,173.46 $ 162,173.46 Output Area Amount of loan Periodic Rate No. Payment Periods Monthly Payment Total to Repay Loan Total Interest Paid $ 140,000.00 0.33% 360 $ 668.38 $ 240,617.31 $ 100,617.31 Two-Variable Data Table: APR and Cost of Home Monthly Payment by Cost/APR APR $ 200,000.00 $ 225,000.00 $ 250,000.00 4.00% $ 907.09 $ 1,026.44 $ 1,145.80 4.25% $ 934.69 $ 1,057.67 5 1,180.66 4.50% 5 962.70 $ 1,089.375 1,216.04 4.75% $ 991.13 $ 1,121.54 $ 1,251.95 5.00% $ 1,019.96 $ 1.154.17 S 1,288.37 5.25% $ 1,049.19 $ 1,187.24 $ 1,325.29 5.50% S 1,078 805 1.220.75$ 1,362.69 5.75% $ 1,108.79 $ 1,254.68 $ 1,400.57 6.00% 5 1,139.15 S 1,289.03 $ 1.438.92 6.25 1,169.86 $ 1,323.79 $ 1,477.72 6.50% $ 1,200.93 $ 1,358.95 $ 1.51696 6.75% $ 1,232.34 $ 1,394.49 $ 1,556.64 7.00% $ 1,264.07 $ 1.430.40 $ 1.596.73 7.25% $ 1.296.13 $ 1,466.68 $ 1,637.22 7.50% $ 1,328.51 $ 1,503.31 $ 1,678.11 7.75% $ 1,361.18 $ 1.540.29 $ 1,719.39 8.00% $ 1,394.155 1,577.59 $ 1,761.03

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions