Question

In: Finance

Your company is planning to borrow $3 million on a 5-year, 13%, annual payment, fully amortized...

Your company is planning to borrow $3 million on a 5-year, 13%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places.

Solutions

Expert Solution

Yearly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                       3,000,000
Rate of interest per period:
Annual rate of interest 13.0000000%
Frequency of payment = Once in 12 month period
Numer of payments in a year = 12/12 = 1
Rate of interest per period R 0.13 /1 = 13.0000%
Total number of payments:
Frequency of payment = Once in 12 month period
Number of years of loan repayment =                                                                     5.00
Total number of payments N 5 × 1 = 5
Period payment using the formula = [ 3000000 × 0.13 × (1+0.13)^5] / [(1+0.13 ^5 -1]
Yearly payment = $                                                    852,943.63
Period Beginning liability Uniform monthly payment Interest owed Principal payment Total owed at end of month
N A C B= A* 0.130000 D=C-B E=A-D
1        3,000,000.00 852,943.63         390,000.00 462,943.63 2,537,056.37
2        2,537,056.37 852,943.63         329,817.33 523,126.30 2,013,930.07

Fraction =

523,126.30 / 852,943.63

= 61.33%

Answer is:

61.33%

Please rate.


Related Solutions

Your company is planning to borrow $3 million on a 5-year, 10%, annual payment, fully amortized...
Your company is planning to borrow $3 million on a 5-year, 10%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places
Your company is planning to borrow $1.25 million on a 5-year, 14%, annual payment, fully amortized...
Your company is planning to borrow $1.25 million on a 5-year, 14%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places.
Your company is planning to borrow $1.75 million on a 5-year, 11%, annual payment, fully amortized...
Your company is planning to borrow $1.75 million on a 5-year, 11%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places.
Your company is planning to borrow $1.75 million on a 5-year, 12%, annual payment, fully amortized...
Your company is planning to borrow $1.75 million on a 5-year, 12%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Loan amount $1,750,000 Term in years 5 Annual coupon rate 12.00% Calculation of Loan Payment Formula Loan payment = #N/A Loan Amortization Schedule Year Beginning Balance Payment Interest Principal Ending Balance 1 2 3 4 5 Formulas...
Your company is planning to borrow $1.5 million on a 3-year, 10%, annual payment, fully amortized...
Your company is planning to borrow $1.5 million on a 3-year, 10%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places.
Your company is planning to borrow $1.5 million on a 9-year, 14%, annual payment, fully amortized...
Your company is planning to borrow $1.5 million on a 9-year, 14%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places.
Your company is planning to borrow $0.75 million on a 9-year, 9%, annual payment, fully amortized...
Your company is planning to borrow $0.75 million on a 9-year, 9%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places.
Your company is planning to borrow $2.75 million on a 7-year, 15%, annual payment, fully amortized...
Your company is planning to borrow $2.75 million on a 7-year, 15%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places.
your company is planning to borrow $100000 on a 10 year 7% annual payment, fully amortized...
your company is planning to borrow $100000 on a 10 year 7% annual payment, fully amortized term loan. What fraction of the payment made at the end of the third year will represent repayment of principal?
Question 1: a. Your company is planning to borrow $2.5 million on a 3-year, 8%, annual...
Question 1: a. Your company is planning to borrow $2.5 million on a 3-year, 8%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places. b. Assume that your aunt sold her house on December 31, and to help close the sale she took a second mortgage in the amount of $40,000 as part of the payment. The mortgage...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT