Question

In: Finance

A customer has taken out a fully amortized loan for $56,000 at a 7.5% interest rate...

A customer has taken out a fully amortized loan for $56,000 at a 7.5% interest rate over 7 years.   The marginal tax rate is 30%.

What is the yearly payment?

a.$10,572.82

b.$10,143.93

c.$9,458.92

d.$8,496.73

What is the interest payment in year 2?

a.$2,835.00

b.$2,438.68

c.$3,208.23

d.$3,722.04

What are the tax savings from interest in year 1?

a.$11,116.61

b.$793.80

c.$1,260.00

d.$2,835.00

Solutions

Expert Solution

Q-1)

a). Loan Amount = $56,000

Calculating the Yearly payment of loan:-

Where, P = Loan amount = $56,000

r = Periodic Interest rate = 7.5%

n= no of periods = 7 years

Yearly Payment = $10,572.82

Option A

- Creating an amortization table to answer part (b) and (c) of this question:-

Year Beg bal. Payment Interest amount Principal Amount End Bal.
1 56,000.00            10,572.82                     4,200.00                           6,372.82               49,627.18
2                49,627.18            10,572.82                     3,722.04                           6,850.78               42,776.40

Note- The following Columns are calculated based on:

- Interest amount = beg. Balnace*Monthly interest rate

- Principal Amount = Payment - Interest amount

- End Bal. = Beg. Bal + Interest - Payment

b). Interest payment in Year 2 = $3722.04

Option D

c). Interest Payment in Year 1 = $4200

Tax saving of Interest Payment in Year 1 = Interest Payment in Year 1*(Tax rate) = $4200*30%

Tax saving of Interest Payment in Year 1 = $1260

Option C

If you need any clarification, you can ask in comments.    

If you like my answer, then please up-vote as it will be motivating       


Related Solutions

Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and...
Assume a $270,000 fully amortizing mortgage loan, which accrues interest at a 7.5% interest rate, and has a maturity of 25 years. Payments are monthly. What is the payoff of the loan in 12 years?
You have just taken out an amortized loan for $404,000. Assume that the loan will be...
You have just taken out an amortized loan for $404,000. Assume that the loan will be paid in 24 equal monthly installments of ​$18,345.62​ and that the first payment will be due 1 month from today. How much of your third monthly payment will go toward the repayment of​ principal? Fill in the worksheet below.   Month Interest Owing at End of Month​ ($) Principal Repayment​ ($) Principal Owing at End of Month​ ($) 1 2 3
Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%.
Show work through excel formulas: please actually show how you do it   on excel exactly! 1. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 6%. After your first mortgage payment, how much of the original loan balance is remaining? 
 A. $1,054.82 B. $120,603.78 C. $124,570.18 D. $124,875.56 2. Assume you have taken out a partially amortizing loan for $325,000 that has a term of...
Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $175,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 5.25%. After your first mortgage payment, how much of the original loan balance is remaining? Can you teach me how to do it on excel, please? I am confused on how to make it monthly compounding.
A borrower wishes to take out a 20 year loan of $350,000 with an interest rate of 7.5%.
A borrower wishes to take out a 20 year loan of $350,000 with an interest rate of 7.5%. The borrower will make semi-annual payments of X for 20 years, beginning 6 months after the original loan date. In addition, the borrower will pay a single lump sum payment of $25,000 after the 16th payment. Assuming the loan is paid off exactly with the last semi-annual payment of X, calculate X.
Ms. Jordan has just taken out a $150,000 mortgage loan at an interest rate of 6...
Ms. Jordan has just taken out a $150,000 mortgage loan at an interest rate of 6 percent. If the mortgage calls for equal monthly payments for 20 years, what is the amount of each payment? Also, work out an amortization table
1. You have taken out a loan of $300 000 at an interest rate of 3%...
1. You have taken out a loan of $300 000 at an interest rate of 3% per annum compounded quarterly. You plan to repay the loan in 240 reducing-principal payments made at the end of each quarter and starting at the end of the first quarter. (a) How much is the principal reduced by after each payment? (b) Write down an expression for the loan balance before repayment Am at the end of period m. This means that A1 should...
A person wants to take out a loan of $1,5000. 1 year simple interest amortized loan...
A person wants to take out a loan of $1,5000. 1 year simple interest amortized loan at 6%, with monthly payments. calculate the monthly payments. explain how you got your answer.
Fully amortized loan​ (annual payments for principal and interest with the same amount each​ year). Chuck...
Fully amortized loan​ (annual payments for principal and interest with the same amount each​ year). Chuck Ponzi has talked an elderly woman into loaning him ​$50 comma 000 for a new business venture. She​ has, however, successfully passed a finance class and requires Chuck to sign a binding contract on repayment of the ​$50 comma 000 with an annual interest rate of 11​% over the next 10 years. Determine the cash flow to the woman under a fully amortized​ loan,...
You have taken out a $700,000 blended payment loan. The interest rate is 4% and you...
You have taken out a $700,000 blended payment loan. The interest rate is 4% and you will repay your loan in 10 equal annual instalments (each payment is due at the end of the period). Each equal annual instalment is comprised of both principal and interest, the proportion of which varies per period. How much is the balance outstanding at the end of the third year (i.e. how much principal has not yet been repaid)? A) $581,061. B) $517,999. C)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT