Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. 1. construct a loan amortization schedule for a 15

1. Construct a loan amortization schedule for a 15-year, 7.25% loan of $7,000,000. The loan requires...

50.1K

Verified Solution

Question

Finance

1. Construct a loan amortization schedule for a15-year, 7.25% loan of $7,000,000. The loan requires equal,end-of-year payments, and interest is compoundedmonthly.

         
     -  What is the total amount ofinterest paid over the life of the  
         loan?

    
     2. Re-construct this amortizationschedule assumingthat                     
     interest is compounded annually.

  -  What total amount of interest ispaid over the life of the loan?

  -  What is the difference betweenthose total interest amounts?

3. Assume that in sections 1 and 2 above, there is arequirement to repay the whole remaining loan balance at the end ofthe tenth year, immediately after making the last equalpayment.

What is the loan balance to be paid in section1?


What is the loan balance to be paid in Section2?


What is the difference between theseamounts?

    

 B.-  1. Construct a loan amortizationschedule for a $3,000,000, 3-year loan, made at
6.50% quoted annual rate. Interest is compounded daily, and theloan requires equal end-of-period monthly payments.(use 360-dayyear for computation) 

-    What is the total amount of interestpaid on this loan?

Answer & Explanation Solved by verified expert
4.1 Ratings (695 Votes)
As per rules I am answering the first 4 subparts of thequestion1 TableLoan AmountInterest RateTerm in YearsMonthly    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

1.Consider the function: f(x, y) = 2020 + y3-3xy + x3. a) Find fx(x, y), and fye(x,...

Biology
1.2K views

[AP Bio] Light wavelength significance for photosynthesis? I am writing an analysis based on a theoretical...

Psychology
1.2K views

Is Depression Really On The Rise? If So, Why? November 2016 - If you look at...

Physics
1.2K views

Time standards are now based on atomic clocks. A promising second standard is based on pulsars,...

Physics
1.2K views

R 38 A spherical hole of radius is made in a solid sphere 2 of...

Physics
1.2K views

42 A plano convex glass lens 3 2 of radius of curvature R 20 cm...

Basic Math
1.2K views

For what values of on the interval 0 2n does f x 2 cos z...

Basic Math
1.2K views

There is a line that includes the point (5, 5) and has a slope of...

Accounting
1.2K views

Homework - Chapter 20 Operating leverage Asha Inc. and Samir Inc. have the following...

Accounting
1.2K views

Marigold Holdings Inc. purchased 338000 shares of Ivanhoe Corp. for $18 a share. This transaction...

Finance
1.2K views

2.One year ago, Bill bought 300 shares of Conglomerated Inc. Now, one year later, the...

Finance
1.2K views

Brandon is an analyst at a wealth management firm. One of his clients holds a...