Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

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

A Course In Derivative Securities

Authors: Kerry Back

2005th Edition

3540253734, 978-3540253730

More Books

Students also viewed these Finance questions