Question

Your company is planning to borrow $100,000 on a 10-year, 16.50% annual payment, fully amortized term loan. What fraction of
0 0
Add a comment Improve this question Transcribed image text
Answer #1
PVOrdinary Annuity = C*[(1-(1+i/100)^(-n))/(i/100)]
C = Cash flow per period
i = interest rate
n = number of payments
10000= Cash Flow*((1-(1+ 16.5/100)^-10)/(16.5/100))
Cash Flow = 2107.66
Annual rate(M)= yearly rate/1= 16.50% Annual payment= 2107.66
Year Beginning balance (A) Annual payment Interest = M*A Principal paid Ending balance
1 10000.00 2107.66 1650.00 457.66 9542.34
2 9542.34 2107.66 1574.49 533.17 9009.17
3 9009.17 2107.66 1486.51 621.14 8388.03
Where
Interest paid = Beginning balance * Annual interest rate
Principal = Annual payment – interest paid
Ending balance = beginning balance – principal paid
Beginning balance = previous Year ending balance

Principal %age = 621.14/2107.66 = 29.5%

Add a comment
Know the answer?
Add Answer to:
Your company is planning to borrow $100,000 on a 10-year, 16.50% annual payment, fully amortized term...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • DMR company is planning to borrow $10,000 on a 5-year, 9%, annual payment, fully amortized term...

    DMR company is planning to borrow $10,000 on a 5-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? C) a) 44.1% b) 48.0% c) 51.8% d) 62.98% C) e) 70.84%

  • O 28-17: Amortized Loans Problem 28-30 Loan Amortization Your company is planning to borrow $2.25 million...

    O 28-17: Amortized Loans Problem 28-30 Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 12%, 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. 1%

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

    Your company is planning to borrow $0.75 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. __________% the answer is not .5 92....

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

    Your company is planning to borrow $0.75 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. ________ % screenshot of spreadsheet attached just...

  • Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 8%, annual payment,...

    Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 8%, annual payment, ly amortize 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 Loan Amortization Assume that your aunt sold her house on December 31, and to his close the sale she took a second mortgage in the amount of $30,000 as part...

  • 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 $45,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 $45,000 with an annual interest rate of 7% over the next 20 years. Determine the cash flow to the woman under a fully amortized loan, in which Ponzi will...

  • 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 $40,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 $40,000 with an annual interest rate of 6% over the next 20 years. Determine the cash flow to the woman under a fully amortized loan, in which Ponzi will...

  • Please answer all the questions posted. the 2 pictures in this case. thank you very much...

    Please answer all the questions posted. the 2 pictures in this case. thank you very much you mean this format? please let me know if this is it We were unable to transcribe this imageActivity: Loan Amortization Excel Online Structured Activity: Loan Amortization Your company is planning to borrow $3 million on a 5-year, 16%, 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...

  • Suppose C&Y restaurant borrow a 5-year loan of $85,000 at an annual interest rate of 5%....

    Suppose C&Y restaurant borrow a 5-year loan of $85,000 at an annual interest rate of 5%. The loan agreement states that the repayment of principal and the loan interest has to be paid by the end of each year. The instalment of each repayment is fixed amount throughout the loan period. You are instructed to construct an amortization schedule for loan repayment including beginning balance, annual payment, interest and ending balance.

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT