On July 1, 2018, Ace Enterprises purchased a building for $325,000, signing a 5%, 20-year mortgage. Installment payments
Posted: Mon Apr 25, 2022 7:54 am
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
$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