Question

A loan of $10,000 is amortized by equal annual payments for 30 years at an effective annual interest rate of 5%. The income tax rate level is at 25%. Assume the tax on the interest earned is based on the amortization schedule.

a) Determine the income tax in the 10th year

b) Determine the total income taxes over the life of the loan

c) Calculate the present value of the after-tax payments using the before-tax yield rate. Answer to the nearest dollar.

Answer 1

We are given the following data:

Principal (P) = $10,000
No. of years N = 30
Interest rate r = 5%
Tax rate t = 25%

To answer the questions, we first need to prepare the amortization schedule. The annual payment or installment (I) on the loan can be calculated by using the formula to find the present value of future cash flows.

Rearranging the above equation, we get

Substituting the values in the above formula, the installment I comes to $651. From this, we can the prepare the below amortization schedule. In addition to the columns forming part of the standard amoritzation schedule, the below schedule also includes the columns 'Income tax', 'Interest after tax' and 'Present value of interest after tax' for ease of reference. Please note that the amounts in the table are in $.

Year	Installment (A)	Interest (B)	Principal (A - B)	Loan Balance	Income tax (C = B*25%)	Interest after tax (B - C)	Present value of interest after tax
1	651	500	151	9,849	125	375	357
2	651	492	158	9,691	123	369	335
3	651	485	166	9,526	121	363	314
4	651	476	174	9,351	119	357	294
5	651	468	183	9,168	117	351	275
6	651	458	192	8,976	115	344	257
7	651	449	202	8,775	112	337	239
8	651	439	212	8,563	110	329	223
9	651	428	222	8,340	107	321	207
10	651	417	233	8,107	104	313	192
11	651	405	245	7,862	101	304	178
12	651	393	257	7,604	98	295	164
13	651	380	270	7,334	95	285	151
14	651	367	284	7,050	92	275	139
15	651	353	298	6,752	88	264	127
16	651	338	313	6,439	84	253	116
17	651	322	329	6,111	80	241	105
18	651	306	345	5,766	76	229	95
19	651	288	362	5,403	72	216	86
20	651	270	380	5,023	68	203	76
21	651	251	399	4,624	63	188	68
22	651	231	419	4,204	58	173	59
23	651	210	440	3,764	53	158	51
24	651	188	462	3,302	47	141	44
25	651	165	485	2,816	41	124	37
26	jeff jeffy Next > < Previous Related Solutions A loan of $330,000 is amortized over 30 years with payments at the end of each... A loan of $330,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.9%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the... A loan of $490,000 is amortized over 30 years with payments at the end of each... A loan of $490,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.1%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the... A $10,000 loan is to be repaid in monthly equal payments in 10 years with an... A $10,000 loan is to be repaid in monthly equal payments in 10 years with an annual effective interest rate of 19.56% charged against the unpaid balance. What principal remains to be paid after the third payment? Loan of $20000 with interest at j2 = 10%, is to be amortized by equal payments... Loan of $20000 with interest at j2 = 10%, is to be amortized by equal payments at the end of each 6 months over a period of 20 half-years. Using the Retrospective Method, Determine the outstanding balance at the end of 12 half-years. choose 25549.22 10374.36 10367.9 Loan of $10000 with interest at j4 = 12%, is to be amortized by equal payments... Loan of $10000 with interest at j4 = 12%, is to be amortized by equal payments at the end of each quarter over a period of 30 quarters. Using the Retrospective Method, Determine the outstanding balance at the end of 12 quarters. 7017.04 14257.61 7016.84 A loan is amortized over five years with monthly payments at an annual nominal interest rate... A loan is amortized over five years with monthly payments at an annual nominal interest rate of 6% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made. Roberto borrows $10,000 and repays the loan with three equal annual payments. The interest rate for... Roberto borrows $10,000 and repays the loan with three equal annual payments. The interest rate for the first year of the loan is 4% compounded annually; for the second year of the loan the interest rate is 5% compounded annually; for the third year of the loan the interest rate is 6% compounded annually. a. Determine the size of the equal annual payments. b. Would interchanging the interest rates for first year and third year change the answer to part... A loan of EGP 30,000 is to be amortized with 10 equal monthly payments at j12... A loan of EGP 30,000 is to be amortized with 10 equal monthly payments at j12 = 12%. Find the outstanding principal after paying the third monthly payment. choose: 21310.04 3167.9 24235.56 You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You... You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You are required to pay closing costs and fees of 2% of the loan amount to the lender. What is the yield of the loan if paid off at the end of 5 years? QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments.... QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments. Which of these statements is CORRECT? a. The proportion of interest versus principal repayment would be the same for each of the 7 payments. b. The proportion of each payment that represents interest versus repayment of principal would be higher if the interest rate were higher. c. The proportion of each payment that represents interest as opposed to repayment of principal would be higher... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions What is the master and servant relationship in collective agreements C++ Parse text (with delimiter) read from file. If a Text file has input formatted such... 2. What were the main obstacles the AppleWatch team faced and how did the team deal... 6. Compute the frame check sequence using Cyclic Redundancy Check (CRC) for the following information: Message... You are considering an option to purchase or rent a single residential property. You can rent... This week involves a case scenario that is loosely based on real events that I'm aware... Code: please use in visual studio 2019 c++ (not java) In total you will write 6... ADVERTISEMENT About @ 2020 WizEdu