Loading
Home › Business Help › Assess a mortgage payment schedule. At the website http:/...
Status: Completed
 View Work

Assess a mortgage payment schedule. At the website http://realstate.yahoo.com/calculators/amortization.html. Assume a loan amount of $120,000, an interest rate of 7.4 percent, and a 30-year maturity. Given this information, what is the monthly payment? In the first month, how much of the monthly payment is interest, and how much is principal? What is the outstanding balance after the first year? In the last month of payment, how much of the monthly payment is interest, and how much is principal? whay is there such a diffrent in the composition of the principal versus interest payment over time ? I need it in excel

Date Posted: 14/03/2016
Category: Business
Due Date: 15/03/2016
Instruction
Assess a mortgage payment schedule. At the website http://realstate.yahoo.com/calculators/amortization.html. Assume a loan amount of $120,000, an interest rate of 7.4 percent, and a 30-year maturity. Given this information, what is the monthly payment? In the first month, how much of the monthly payment is interest, and how much is principal? What is the outstanding balance after the first year? In the last month of payment, how much of the monthly payment is interest, and how much is principal? whay is there such a diffrent in the composition of the principal versus interest payment over time ? I need it in excel
Attached
No File uploaded yet.
Tutor Uploads
Download File 1 (xls)
Download File 2 (doc)
Bidders
accountspro 10 years, 6 months ago
Rated 9.03 earned 41229.00 around 1104 assignments.
Hi, I can complete this amortization assignment for you. I guarantee excellent work. Thank you
$30.00
  • it is in finance and I need it in excel
    User_8950 | Mar 14, 2016, 06:04 AM
  • Yeah, I'm good at finance
    User_3964 | Mar 14, 2016, 06:06 AM
  • ok
    User_8950 | Mar 14, 2016, 06:07 AM
  • Hi, did you finish from the assignment
    User_8950 | Mar 15, 2016, 17:55 PM
  • Yeah, just a minute
    User_3964 | Mar 15, 2016, 18:20 PM
  • check it out
    User_3964 | Mar 15, 2016, 21:03 PM
  • hello, you forgot to release the funds
    User_3964 | Mar 18, 2016, 13:23 PM
  • hello? kindly release the funds; to release funds, click on the "release funds" icon. Thanks in advance
    User_3964 | Mar 25, 2016, 16:21 PM
  • I release it sorry for that
    User_8950 | Mar 25, 2016, 19:37 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
tutoring100 10 years, 6 months ago
Rated 8.95 earned 1113.00 around 44 assignments.
I can handle this for you
$30.00
  • I guarantee you 100%
    User_5597 | Mar 14, 2016, 06:09 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
Bestwritter_d_183 10 years, 6 months ago
hi whats app me +254729828092
$25.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}