spreadsheet project

Project Description:

need by today
a- 1. construct a loan amortization schedule for a 30-year, 7.85% loan of $25,000,000. the loan requires equal, end-of-year payments, and interest is compounded monthly.

- what is the total amount of interest paid over the life of the
loan?


2. re-construct this amortization schedule assuming that
interest is compounded annually.

- what total amount of interest is paid over the life of the loan?

- what is the difference between those total interest amounts?

3. assume that in sections 1 and 2 above, there is a balloon payment requirement
after 15 years.

- what is the balloon payment in section 1?
- what is the balloon payment in section 2?
- what is the difference between these balloon-payment amounts?




b.- 1. construct a loan amortization schedule for a $5,000,000, 3-year loan, made at
7.50% quoted annual rate. interest is compounded daily, and the loan requires equal end-of-period monthly payments.

- what is the total amount of interest paid on this loan?
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $0 to $10
Expired
Total Proposals: 6
1 Current viewersl
36 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.4
    84 Jobs 35 Reviews
    $30 in 2 Days
  • 4.7
    74 Jobs 28 Reviews
    $40 in 10 Hours
  • 4.9
    14 Jobs 9 Reviews
    $15 in 1 Day
  • 4.9
    308 Jobs 184 Reviews
    $40 in 1 Day
  • 4.3
    309 Jobs 189 Reviews
    $20 in 12 Hours
  • 4.8
    546 Jobs 386 Reviews
    $14 in 1 Day