Prepare an amortization schedule for a 3-year loan of $41,000. The interest rate is 11 percent per year, and the loan calls for equal annual payments.

Year Beginning Balance Total Payment Interest Payment Principal payment Ending Balance

1

2

3

Total Interest paid:

answer

watching

135

views

For unlimited access to Homework Help, a Homework+ subscription is required.

You have 0 free answers left.
Get unlimited access to 3.8 million step-by-step answers.

Get unlimited access

Already have an account? Log in

Nestor RutherfordLv2

28 Sep 2019

Unlock all answers

Get 1 free homework help answer.

Already have an account? Log in

Related questions

Prepare an amortization schedule for a three-year loan of $108,000. The interest rate is 9 percent per year, and the loan agreement calls for a principal reduction of $36,000 every year. How much total interest is paid over the life of the loan?

copperelephant293

Messineo LLC borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal annual end of year payments. As the CFO of Messineo, LLC you must prepare a report of the pertinent information in a short summary for the CEO.

Calculate the annual end of year loan payment amount.

Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.

Prepare a one page executive summary for the CEO, Linda Messineo,with the loan payment schedule explaining why the interest portion of each payment declines with the passage of time.

Also, be sure to remind her that the interest portion of the loan payment is tax deductible. You should include your spreadsheet as an appendix to your executive summary to prove your figures in the loan payment schedule.

Hint: Using a spreadsheet, you will start with the PMT function to calculate the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.

On a spreadsheet, set up a monthly amortization schedule for a 3-year car note of $20,000. The annual interest rate on this loan is 7%. Calculate the monthly payment.

What is the beginning loan balance on the 24th month?

What is the ending loan balance on the 30th month?

rosemouse486

Weekly leaderboard

Home

Homework Help 3,900,000

Finance 370,000

Year	Beginning Balance	Total Payment	Interest Payment	Principal payment	Ending Balance
1
2
3

Prepare an amortization schedule for a 3-year loan of $41,000. The interest rate is 11 percent per year, and the loan calls for equal annual payments. Year Beginning Balance Total Payment Interest Payment Principal payment Ending Balance 1 2 3 Total Interest paid:

Unlock all answers

Related questions

Weekly leaderboard

Prepare an amortization schedule for a 3-year loan of $41,000. The interest rate is 11 percent per year, and the loan calls for equal annual payments.

Year Beginning Balance Total Payment Interest Payment Principal payment Ending Balance

1

2

3

Total Interest paid: