Description
Part I: Select a piece of real estate (residential, commercial, warehouse, land), any number of resources can be used (www.realtor.com is one option). You will need to include a listing sheet/link with your submitted assignment.
Part II: Determine a down payment. (a standard down payment is 20%, however you may offer justification for any amount/percent you choose)
Part III: Research 2 different financing options
Part IV: Use Excel (or other approved spread sheet) to create a complete amortization schedule for the lif of both financing options.
Part V: Write an analysis that compares and contrasts the two financing options in detail. Be specific. Include justifications for selecting an option.
A real estate listing sheet | _____ / 5 |
A description, explanation, or calculation of the down payment for the property | _____ / 5 |
A description of the two financing options/products being compared | _____ / 5 |
A "hand-made" Excel spread sheet containing side by side amortization schedules | _____ / 15 |
Written analysis (20 points total) | |
- Explanation of any background information and/or further description of loan types selected | _____ / 5 |
- Analysis of the similarities and differences in the amortization schedules | _____ / 5 |
- Justification for selection of either option | _____ / 5 |
- Use of proper grammar, spelling, sentence structure and paragraph structure | _____ / 5 |
TOTAL | _____ /50 |
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Amount
Years
Rate
$347.600
20
8
Monthly Payment $2.907,47
Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Payment Total Interest Total
$347.600,00
$27.542,50
$340.252,90
$26.932,66
$332.295,99
$26.272,24
$323.678,66
$25.557,04
$314.346,09
$24.782,43
$304.238,93
$23.943,55
$293.292,88
$23.035,03
$281.438,31
$22.051,10
$268.599,82
$20.985,50
$254.695,74
$19.831,48
$239.637,63
$18.581,65
$223.329,70
$17.228,11
$205.668,22
$15.762,21
$186.540,85
$14.174,66
$165.825,92
$12.455,33
$143.391,65
$10.593,28
$119.095,36
$8.576,71
$92.782,48
$6.392,77
$64.285,65
$4.027,53
$33.423,59
$1.465,98
You Own
$7.347,14
$7.956,98
$8.617,40
$9.332,60
$10.107,21
$10.946,09
$11.854,61
$12.838,54
$13.904,14
$15.058,16
$16.307,99
$17.661,53
$19.127,43
$20.714,98
$22.434,31
$24.296,36
$26.312,93
$28.496,87
$30.862,11
$33.423,66
Balance
$340.252,90
$332.295,99
$323.678,66
$314.346,09
$304.238,93
$293.292,88
$281.438,31
$268.599,82
$254.695,74
$239.637,63
$223.329,70
$205.668,22
$186.540,85
$165.825,92
$143.391,65
$119.095,36
$92.782,48
$64.285,65
$33.423,59
$0,00
Property ID: 1603125
Address: 10609 Doyle Road - Deerfield, NY 13502
Price: $434,500
School District: Whitesboro
Township: Deerfield
County: Oneida
Property Type: Residential Existing
Total SqFt: 3632
Lot Size: 220 X IRREGULAR
Year Built: 1998
Style: Contemporary...