Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. 4. make an amortization table for a plain vanilla

4. Make an amortization table for a plain vanilla CPM fully amortizing with the following terms....

60.1K

Verified Solution

Question

Finance

4. Make an amortization table for a plain vanilla CPM fullyamortizing with the following terms. 30 year monthly payments 4.5%Interest rate $1,000,000 initial loan amount. a. How much interestis paid on the loan over the first 2 years? b. How much interest ispaid on the loan over the last 2 years? c. If 25 years from nowinterest rates drop to 2%, would the borrower be likely torefinance? Why or why not? ****NEED THIS IN EXCEL*** PLS

Answer & Explanation Solved by verified expert
3.8 Ratings (704 Votes)
    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

Transcribed Image Text

4. Make an amortization table for a plain vanilla CPM fullyamortizing with the following terms. 30 year monthly payments 4.5%Interest rate $1,000,000 initial loan amount. a. How much interestis paid on the loan over the first 2 years? b. How much interest ispaid on the loan over the last 2 years? c. If 25 years from nowinterest rates drop to 2%, would the borrower be likely torefinance? Why or why not? ****NEED THIS IN EXCEL*** PLS

Other questions asked by students

Basic Math
1.2K views

A. Here is a bivariate data set. x y 25.7 52.5 29.4 64.7 21.8 54.9 35 63.4 31.4 74.7 21.6 46.5 40.8 69.7 37.9 77.7 16.7 41.1 29.6 78.1 13.1 45.5 36.1 78.4 32.1 68.2 45.2 76.8 36.1 57.9 Find the correlation coefficient and report it accurate to...

Chemistry
1.2K views

Calculate the pH after 0.16 mole of NaOH is added to 1.10 L of a solution...

Medical Sciences
1.2K views

Describe the antagonistic effects of the sympathetic and parasympathetic divisions in the function of: salivary glands, gastric...

Medical Sciences
1.2K views

Richard is a 55 year old man who has been diagnosed with rheumatoid arthritis. Before being...

Biology
1.2K views

Question Points 1 Which countries were known as the Allies The Ottoman Empire France and...

Physics
1.2K views

The contents of a well insulated tank are system heated by a resistor of 23...

Basic Math
1.2K views

Starting at noon, Brody observed the amount of snow on his lawn during a blizzard....

Calculus
1.2K views

Question 25 A fireplace arch is constructed in the shape of a semi ellipse The...

Algebra
1.2K views

uninterrupted for 2421 feet before entering the river below The height h above the river...

Accounting
1.2K views

True/False Questions / wz explanation 8. Managerial accounting places greater emphasis on the future than...

Accounting
1.2K views

Cost of goods sold is equal to the cost of goods: Multiple Choice available for...

Finance
1.2K views

Which of the following statements is incorrect? The expected cost of the warranty should be...