Question

1 Approved Answer

Posted on Jul 11, 2024

Crain's Mortgage Calculator - Input formulas to match the ourcomes in the solution. This assignment required a PMT, SUM, Subtraction, Multiplication, Division, and the utilization

Crain's Mortgage Calculator - Input formulas to match the ourcomes in the solution. This assignment required a PMT, SUM, Subtraction, Multiplication, Division, and the utilization of developing tables. image text in transcribed

1 ZOOM + Crain's Morgatage Calulator Input Area Cost of home Down Payment APR No. Years for Loan Payments Per Year $ 150,000.00 $ 10,000.00 4.0096 30 12 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total Interest 4.00% $ 668.38 $ 240,617.31 S 100,61731 4.25% $ 688.72 S 247 937.71 $ 107,937.71 4.50% $ 709.36 $ 255,369.40 $ 115,369.40 4.755 $ 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.5096 $ 794.90 S 286,165,66 S 146,165,66 5.75% $ 817.00 $ 294,120.72 S 154,120.72 6.00% $ 839.37 S 302,173.46 S 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 s 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 S 1.145.80 4.25 $ 934.69 $ 1,057.67 S 1.180.66 4.SONS 962.70 S 1,089.37 S 1,216.04 4.75% S 991.13 S 1.121.54 S 1.251.95 5.0096 S 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.80 $ 1,220,75 $ 1,362.69 5.7596 S 1,108.79 $ 1.254.68 S 1,400.57 6.00 S 1,139.15 $ 1.289.03 S 1.438.92 6.2596 S 1.169.86 S 1,323.79 S 1.477.72 6.50% S 1,200.93 S 1,358.95 S 1,516.96 6,75% S 1.232.34 S 1,394.49 $ 1.556.64 7.00% S 1,264.07 S 1,430.40 S 1,596.73 7.25% S 1,296.13 S 1,466,68 $ 1,637.22 7.509 S 1.328.51 $ 1.503.31 S 1.678.11 7.75% S 1,361.18$ 1.540.29 S 1.719,39 8.00% S1,394,15 1577.59 $ 1.761 03 Note: Always replace my name with yours at the Top! This spreadsheet requires a Date Function! Vio File Home Insert Page Layout Formulas Data Review View Help G30 H1 M N E A C D 1 Crain's Morgatage Calulator $150,000.00 $ 10,000.00 4.00 30 12 2 3 Input Area 4 Cost of home 5 Down Payment 6 APR 7 No. Years for Loan Payments Per Year 9 10 Output Area 11 Amount of loan 12 Periodic Rate 13 No. Payment Periods 14 Monthly Payment 15 Total to Repay Loan 16 Total Interest Paid 17 30 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total interest 4.00% 4.25% 4.50X 4.75% SOON 5.25% 5.50% 5.75% 6.00% 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% 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.73% 8.00% 19 20 21 22 23 24 25 26 Note: Always replace my name with yours at the Top! 27 This spreadsheet requires a Date Function! 28 HERE 29 30 31 32 33 24 1 ZOOM + Crain's Morgatage Calulator Input Area Cost of home Down Payment APR No. Years for Loan Payments Per Year $ 150,000.00 $ 10,000.00 4.0096 30 12 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total Interest 4.00% $ 668.38 $ 240,617.31 S 100,61731 4.25% $ 688.72 S 247 937.71 $ 107,937.71 4.50% $ 709.36 $ 255,369.40 $ 115,369.40 4.755 $ 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.5096 $ 794.90 S 286,165,66 S 146,165,66 5.75% $ 817.00 $ 294,120.72 S 154,120.72 6.00% $ 839.37 S 302,173.46 S 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 s 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 S 1.145.80 4.25 $ 934.69 $ 1,057.67 S 1.180.66 4.SONS 962.70 S 1,089.37 S 1,216.04 4.75% S 991.13 S 1.121.54 S 1.251.95 5.0096 S 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.80 $ 1,220,75 $ 1,362.69 5.7596 S 1,108.79 $ 1.254.68 S 1,400.57 6.00 S 1,139.15 $ 1.289.03 S 1.438.92 6.2596 S 1.169.86 S 1,323.79 S 1.477.72 6.50% S 1,200.93 S 1,358.95 S 1,516.96 6,75% S 1.232.34 S 1,394.49 $ 1.556.64 7.00% S 1,264.07 S 1,430.40 S 1,596.73 7.25% S 1,296.13 S 1,466,68 $ 1,637.22 7.509 S 1.328.51 $ 1.503.31 S 1.678.11 7.75% S 1,361.18$ 1.540.29 S 1.719,39 8.00% S1,394,15 1577.59 $ 1.761 03 Note: Always replace my name with yours at the Top! This spreadsheet requires a Date Function! Vio File Home Insert Page Layout Formulas Data Review View Help G30 H1 M N E A C D 1 Crain's Morgatage Calulator $150,000.00 $ 10,000.00 4.00 30 12 2 3 Input Area 4 Cost of home 5 Down Payment 6 APR 7 No. Years for Loan Payments Per Year 9 10 Output Area 11 Amount of loan 12 Periodic Rate 13 No. Payment Periods 14 Monthly Payment 15 Total to Repay Loan 16 Total Interest Paid 17 30 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total interest 4.00% 4.25% 4.50X 4.75% SOON 5.25% 5.50% 5.75% 6.00% 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% 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.73% 8.00% 19 20 21 22 23 24 25 26 Note: Always replace my name with yours at the Top! 27 This spreadsheet requires a Date Function! 28 HERE 29 30 31 32 33 24