On July 1, 2018, Ace Enterprises purchased a building for $325,000, signing a 5%, 20-year mortgage. Installment payments

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

On July 1, 2018, Ace Enterprises purchased a building for $325,000, signing a 5%, 20-year mortgage. Installment payments

Post by answerhappygod »

On July 1, 2018, Ace Enterprises purchased a building for
$325,000, signing a 5%, 20-year mortgage. Installment payments of
$2,144.86 are due at the end of each month, with the first payment
being due on July 31, 2018.
Required: Prepare an amortization of the loan using
Excel.(Please include the excel doc )
The following are required items in the amortization
schedule:
 You may not use an amortization template in Excel
 Input cells for the principle amount, interest rate, and
payment
 The last number of the amortization table will not equal zero
but it will be close
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply