Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What necessary steps do I need to do to complete this: Complete the two variable data table using the range I3:L20 and reference cells B2
What necessary steps do I need to do to complete this:
Complete the two variable data table using the range I3:L20 and reference cells B2 and B4.
Apply a custom number format to cell I3 to display APR.
e06h2Mortgage Excel R Share Home Insert Page Layout Formulas Data Review View 9 Tell me what you want to do SIMS Auto Sum A A Calibri Er Wrap Text Percent tage B I u A- E E 3E E Merge & Center 96, %8 Format as Cel Insert Delete Forrmat clear. Sort & Find & Formatting Table Styles Select Paste Clipboard Alignment Editing M16 1 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 Payment Total Repaid Total Interest 3 $668.38 $150,000.00 $175,000.00 $200,000.00 4 APR 4.00% 4.00% 668.38 $240,617.31 100,617.31 4.00% 30 4.25% 5 No. Years for Loan 4.25% 688.72 $247,937.71 $107,937.71 6 Payments per Year 12 4.50% 709.36 $255,369.40 $115,369.40 4.50% 4.75% 4.7596 730.31 $262,910.26 $122,910.26 S.00% S 7s1.5S $270,558.10 $130,558.10 5.00% output Area 9 Amount of Loan $140,000.00 5.2596 773.09 $278,310.67 $138,310.67 5.25% 0.33% 5.50% 794.90 $286,165.66 146,165.66 10 Periodic Rate 5.50% 11 No. Payment periods 360 5.75% 817.00 294,120.72 154,120.72 5.7S%, 12 Monthly payment $668.38 6.00% 839.37 302,173.46 $162,173.46 13 Total to Repay Loan $240,617.31 6.25% Home Loan Range Names 100
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started