Liz received a loan of $15,000 at 5.50% compounded quarterly. She had to make payments at...

Liz received a loan of $15,000 at 5.50% compounded quarterly. She had to make payments at the end of every quarter for a period of 1 year to settle the loan.

a. Calculate the size of payments.

Round to the nearest cent

b. Fill in the amortization schedule, rounding the answers to two decimal places.

Payment Number	Amount Paid	Interest Portion	Principal Portion	Principal Balance
0				$15,000.00
1
2
3
4
Total

Expert Solution

a.	Size of payments	=-pmt(rate,nper,pv,fv)
		= $ 3,879.79


	Where,
	rate	=	5.50%/4	=	0.01375
	nper	=	1*4	=	4
	pv			=	$ 15,000
	fv			=	0


b.	Amortization Schedule:

	Payment	Amount Paid	Interest	Principal	Principal
	Number		Portion	Portion	Balance
	0				$ 15,000.00
	1	$ 3,879.79	$ 206.25	$ 3,673.54	$ 11,326.46
	2	$ 3,879.79	$ 155.74	$ 3,724.05	$ 7,602.42
	3	$ 3,879.79	$ 104.53	$ 3,775.25	$ 3,827.16
	4	$ 3,879.79	$ 52.62	$ 3,827.16	0

	Total	$ 15,519.15	$ 519.15	$ 15,000.00

	Working:
	Payment	Beginning Principal	Amount Paid	Interest	Principal	Ending Principal
	Number	Balance		Portion	Portion	Balance
		a	b	c=a5.50%3/12	d=b-c	e=a-d
	1	$ 15,000.00	$ 3,879.79	$ 206.25	$ 3,673.54	$ 11,326.46
	2	$ 11,326.46	$ 3,879.79	$ 155.74	$ 3,724.05	$ 7,602.42
	3	$ 7,602.42	$ 3,879.79	$ 104.53	$ 3,775.25	$ 3,827.16
	4	$ 3,827.16	$ 3,879.79	$ 52.62	$ 3,827.16	0

jeff jeffy answered 2 years ago

Sophie received a loan of $28,000 at 6.5% compounded quarterly. She had to make payments at...

Sophie received a loan of $28,000 at 6.5% compounded quarterly. She had to make payments at the end of every quarter for a period of 8 years to settle the loan. a. Calculate the size of payments. Round to the nearest cent b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Payment Number Payment Interest Portion Principal Portion Principal Balance 0 $28,000.00 1 2 : : : : : : : :...

Helen received a loan of $25,000 at 4.5% compounded quarterly. She had to make payments at...

Helen received a loan of $25,000 at 4.5% compounded quarterly. She had to make payments at the end of every quarter for a period of 7 years to settle the loan. a. Calculate the size of payments. Round to the nearest cent b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Payment Number Payment Interest Portion Principal Portion Principal Balance 0 $25,000.00 1 2 : : : : : : : :...

Ali received a loan of $28,000 at 6.5% compounded quarterly. He had to make payments at...

Ali received a loan of $28,000 at 6.5% compounded quarterly. He had to make payments at the end of every quarter for a period of 8 years to settle the loan. a. Calculate the size of payments. Round to the nearest cent b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Payment Number Payment Interest Portion Principal Portion Principal Balance 0 $28,000.00 1 2 : : : : : : : :...

The interest rate on a $100,000 loan is 7.5% compounded quarterly. What quarterly payments will reduce...

The interest rate on a $100,000 loan is 7.5% compounded quarterly. What quarterly payments will reduce the balance to $75,000 after five years? (Do not round intermediate calculations and round your final answer to 2 decimal places.)

Lucy received a loan of $8,700 at 5.75% compounded monthly. She settled the loan by making...

Lucy received a loan of $8,700 at 5.75% compounded monthly. She settled the loan by making periodic payments at the end of every three months for 4 years, with the first payment made 2 years and 3 months from now. What was the size of the periodic payments?

5. You have a bank loan at 6.75%, compounded monthly with quarterly payments. What is the...

5. You have a bank loan at 6.75%, compounded monthly with quarterly payments. What is the effective interest rate per payment period? 6. You lent $500 to your friend at 10% compounded every 2 months. You have asked her to pay the money back at the end of one year and to make an interest payment every six months (one at the 6 month mark and one at the end). What is the effective interest rate per payment period? 7....

Lionel’s student loan of $21,500 at 3.92% compounded quarterly was amortized over 4 years with payments...

Lionel’s student loan of $21,500 at 3.92% compounded quarterly was amortized over 4 years with payments made at the end of every month. What was the principal balance on the loan after 3 years? Round to the nearest cent

A borrower had a loan of 60,000 at 4% compounded annually with 9annual payments. Suppose...

A borrower had a loan of 60,000 at 4% compounded annually with 9 annual payments. Suppose the borrower paid off the loan after 5 years. Calculate the amount needed to pay off the loan.

Wayne Corporation had income from operations of $385,000, it received interest payments of $15,000, it paid...

Wayne Corporation had income from operations of $385,000, it received interest payments of $15,000, it paid interest of $20,000, it received dividends from another corporation of $10,000, and it paid $40,000 in dividends to its common stockholders. What is Wayne’s federal income tax? $141,700 $130,220 $122,760 $163,500 $155,200

Sarah is buying a home. Her loan will be $100,000. She will make annual payments for...

Sarah is buying a home. Her loan will be $100,000. She will make annual payments for the next 30 years to retire this loan. The interest rate on the loan is 4 %. A. How much will her annual payments be? B. How much interest will she pay over the life of the loan? C. How much of her first payment will be applied to principal? D. How much will she still owe on the loan after 10 years?

Question