Scribd Logo
Upload

Welcome to Scribd!

  • 42 views

    RELE 1318 Real Estate Finance: Input Area

    Uploaded by

    Pravish Khare
    The document contains information on 5 mortgage loans including the house cost, down payment, amount financed, mortgage rate, years, and monthly payments. It provides summary statistics on the total house costs, down payments, and amounts financed for the loans. The bottom section includes additional details for each loan such as the percentage down, APR, and monthly payments including principal, interest, and PMI where applicable.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    RELE 1318 Real Estate Finance: Input Area

    Uploaded by

    Pravish Khare
    42 views5 pages
    The document contains information on 5 mortgage loans including the house cost, down payment, amount financed, mortgage rate, years, and monthly payments. It provides summary statistics on the total house costs, down payments, and amounts financed for the loans. The bottom section includes additional details for each loan such as the percentage down, APR, and monthly payments including principal, interest, and PMI where applicable.

    Original Title

    e02_script_data

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains information on 5 mortgage loans including the house cost, down payment, amount financed, mortgage rate, years, and monthly payments. It provides summary statistics on the total house costs, down payments, and amounts financed for the loans. The bottom section includes additional details for each loan such as the percentage down, APR, and monthly payments including principal, interest, and PMI where applicable.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    42 views5 pages

    RELE 1318 Real Estate Finance: Input Area

    Uploaded by

    Pravish Khare
    The document contains information on 5 mortgage loans including the house cost, down payment, amount financed, mortgage rate, years, and monthly payments. It provides summary statistics on the total house costs, down payments, and amounts financed for the loans. The bottom section includes additional details for each loan such as the percentage down, APR, and monthly payments including principal, interest, and PMI where applicable.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    RELE 1318 Real Estate Finance

    Input Area
    Today's Date: 9/24/2020 18:03
    Pmts Per Year: 12

    Down Amount Mortgage Rate Per


    Loan # House Cost Payment Financed Rate Period Years
    221676 $ 600,000 $ 200,000 $ 400,000 4.250% 0.354% 30
    255089 $ 285,000 $ 60,000 $ 225,000 3.560% 0.297% 15
    272158 $ 155,500 $ 20,200 $ 135,300 3.980% 0.332% 30
    281550 $ 325,600 $ 45,600 $ 280,000 3.700% 0.308% 25
    297441 $ 457,000 $ 90,500 $ 366,500 3.230% 0.269% 15

    Summary Statistics

    Down Amount
    Statistics House Cost Payment Financed
    Total $ 1,823,100 $ 416,300 $ 1,406,800
    Average $ 364,620 $ 83,260 $ 281,360
    Median $ 325,600 $ 60,000 $ 280,000
    Least $ 155,500 $ 20,200 $ 135,300
    Most $ 600,000 $ 200,000 $ 400,000
    # of Mortgages 5 5 5
    # of % Date Payoff
    Payments Financed Financed Year
    360 0.66666667 6/28/2013 2043
    180 0.78947368 10/16/2014 2029
    360 0.87009646 5/17/2015 2045
    300 0.85995086 9/21/2015 2040
    180 0.80196937 1/20/2016 2031
    RELE 1318 Real Estate Finance
    Input Area Years Rate
    Today's Date: 9/24/2020 15 3.250%
    # Pmts Per Year: 12 25 3.675%
    PMI Rate: 0.50% 30 3.875%
    Down Pmt Rate: 20.0%

    Down Amount Monthly


    Loan # House Cost Payment Financed % Down Years APR Payment
    221676 $ 600,000 $ 200,000 $ 400,000 33.3% 30 3.875% $1,880.95
    255089 $ 285,000 $ 60,000 $ 225,000 21.1% 15 3.250% $1,581.00
    272158 $ 155,500 $ 20,200 $ 135,300 13.0% 30 3.875% $636.23
    281550 $ 325,600 $ 45,600 $ 280,000 14.0% 25 3.675% $1,428.16
    297441 $ 457,000 $ 90,500 $ 366,500 19.8% 15 3.250% $2,575.28
    Monthly
    PMI
    $ -
    $ -
    $ 56.38
    $ 116.67
    $ 152.71
    Customer Data Lookup Data
    Weight Location Shipping Weight Boston Chicago
    11 Boston 19.95 0 $9.95 $12.95
    4.4 Chicago 12.95 5 $14.95 $16.95
    8 Boston 14.95 10 $19.95 $22.95

    You might also like