Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

Mr

Finance Sep 29, 2020
  1. Mr. Smith bought an apartment house with $60,000 cash and a fixed-rate fully-amortizing constant payment mortgage (CPM) of $100,000.  The loan was made at an interest rate of 10 percent and requires monthly payments for 25 years.
  1. Complete the following amortization schedule with given information.                                                                                                                              (3 points)

Loan Amount

$ 100,000.00

Annual Interest Rate

10%

Loan Term

25 years

   
 

Beginning Balance

Monthly Payment

Interest

Amortization

Ending Balance

Month 1

         

Month 2

         

What would be the outstanding balance after 10 years?   

Expert Solution

Answer; Part (A)

Current Monthly Installment Amount =

No of Year = 25 Years

No of period = 25 X 12 = 300 monthly payments

Rate = 10% per annum

Monthly rate = 10 % / 12 = .8333%

Principal Amount = $ 100,000

Formula ; Monthly Installment = = P × r × (1 + r)n/((1 + r)^n - 1)

= 100,000 x .83333% [ (1.0083333)^300/ (1.008333)^300 -1]

= 833.33 x[12.05682545/(12.05682545-1)]

= 833.33 X 1.090441873

= $908.70 Per Month or $$909

Answer Part B

Ramaining Amount After 10 years = Formula

Ramaining Amount =

= 100000*(1.0083333)^120 - 908.70*[(1.008333)^120 - 1]/.008333

= 100000*2.707030752 - 908.70*[2.707030752 - 1]/.008333

= 100000*2.707030752 - 908.70*[1.707030752]/.008333

=270703.0752 - 908.70*204.8445096

=270703.0752-186142.2059

= $84560.87 or $84561

Please use this google drive link to download the answer file.       

https://drive.google.com/file/d/1SsgcE6feYBLk72ivxFOECEogfOe_MAwX/view?usp=sharing

Note: If you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process. 

https://helpinhomework.org/blog/how-to-obtain-answer-through-google-drive-link 

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment