Question

Please complete the attached amortization schedule. This is a common task people in accounting and finance...

Please complete the attached amortization schedule. This is a common task people in accounting and finance do all the time. One example is how a car payment or a house payment is calculated.

Data
Period
Date Interest
Expense
Principal
Reduction
Cash Payment Unpaid
Balance
Loan Amount $6,000.00 issue date 3/1/18 6,000.00
Beginning Date 1/1/2018 1 3/1/19 1,811.52
Term (years) 4 2 3/2/20 1,811.52
Interest rate 8.00% 3 3/3/21 1,811.52
4 3/4/22 1,811.55
Annual Payment $1,811.52 Total 1,246.10 6,000.00 7,246.11

Homework Answers

Answer #1
Date Interest Period Date Interest Expenses Principal Cash Payment Unpaid
Expense Reduction Balance
Loan Amount $6,000.00 issue date 3/1/2018 $          -   $          -   $          -   $6,000.00
Beginning Date 1/1/2018 1 3/1/2019 $   480.00 $1,331.52 $1,811.52 $4,668.48
Term (years) 4 2 3/2/2020 $   373.48 $1,438.04 $1,811.52 $3,230.44
Interest rate 8.00% 3 3/3/2021 $   258.44 $1,553.08 $1,811.52 $1,677.35
4 3/4/2022 $   134.19 $1,677.36 $1,811.55 $     (0.01)
Annual Payment $1,811.52 Total $1,246.10 $6,000.00 $7,246.11
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Loan amortization schedule  Personal Finance Problem Joan Messineo borrowed 41,000 at a 4​% annual rate of...
Loan amortization schedule  Personal Finance Problem Joan Messineo borrowed 41,000 at a 4​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $230,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $230,000 for 3 years at 6% compounded annually Period Period Payment Interest Balance Reduction Unpaid Balance 1 $ $ $ $230,000 2 $ $ $ $ 3 $ $ $ $0.00 Payment Interest Balance Reduction Unpaid Balance
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $35,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $35,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $20,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $20,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $20,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $ $0.00
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49,000 at a 3% annual rate of...
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49,000 at a 3% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of the​ equal,...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $130,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $130,000 for 3 years at 7% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $130,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $0.00
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $250,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $250,000 for 3 years at 10% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $250,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $0.00
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $80,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $80,000 for 3 years at 10% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $80,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $0.00
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $50,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $50,000 for 3 years at 7% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $50,000 1 $ 2 $ 3 $0.00