HomeworkLib
Question

You just took a $10,000, 5-year loan. Payments at the end of each year are f...

You just took a $10,000, 5-year loan. Payments at the end of each year are f at (equal in every year) at an interest rate of 15%. Calculate the appropriate loan table, showing the breakdown in each year between principal and interest.

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut aCopy Σ AutoSum ー E ゴWrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number Cells W83 68 69 70 71 72 73 74 75 76 15% 10000 RATE LOAN YEARS PMT 2,983.16 EXCEL-PMT(15%,5,-10000) BALANCE FORWARD PORTION TO INTEREST C- A*0.15 PORTION TO PRINCIPAL NEW BALANCE E-A-D PAYMENT $ 10,000.00 $ 2,983.16 1,500.00$1,483.16 $ 8,516.84 $8,516.84 $ 2,983.16 $ 1,277.53 $1,705.63 $ 6,811.22 $1,961.47$4,849.74 $4,849.74 $2,983.16$ 727.462,255.69 $2,594.05 78 79 80 81 82 83 84 85 86 11 トトー MÍN VAR PORT BEST CAL BİNOMIAL 2 TIME- SINKING AMORTIZA Sheet2 $6,811.22 2,983.16 $ 1,021.68 $ 2,594.05 2,983.16$ 389.11 $2,594.05 $ ORDAN INSURANCE 福 130% 04-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
You just took a $10,000, 5-year loan. Payments at the end of each year are f...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Please use excel, need help with functions because I am only used to using a financial...

    Please use excel, need help with functions because I am only used to using a financial calculator, thanks! You just took a $25,000, five-year loan. Payments at the end of each year are flat (equal in every year) at an interest rate of 12%. Calculate the appropriate loan table, showing the breakdown in each year between principal and interest.

  • You took a 5 year, $100,000 loan. The loan has equal principal payments. The loan carries...

    You took a 5 year, $100,000 loan. The loan has equal principal payments. The loan carries a 6% annual interest rate and is paid back in annual payments. 1. What is the outstanding balance of the loan after 3 years? 2. Compute an amortization table for the loan. 3. What is the interest payment on the fourth installment?

  • 9 of 10 (0 complete) T... You just took out a $12,000 loan for your small business. The loan has a four year term...

    9 of 10 (0 complete) T... You just took out a $12,000 loan for your small business. The loan has a four year term and repayment is in the form of four equal end of -year payments. The interest rate on the loan is 11.5%. Consider the final loan payment. How much principal do you pay in the final payment? O A. $3,506.09 O B. $2,820.16 O C. $3,144.48 O D. $2,529.29 O E. $3,909.29 10 of 10 (0 complete)...

  • You took out a loan that must be repaid with level payments at the end of...

    You took out a loan that must be repaid with level payments at the end of each year. The loan has an annual effective rate of interest of 8%. The outstanding balance at the end of the ninth year was $22,000 and the outstanding balance at the end of the twelfth year was $15,000. What is your payment on the loan? Round your answers to two decimal places. 3914.6 X

  • A 10-year loan of 2000 is to be repaid with payments at the end of each...

    A 10-year loan of 2000 is to be repaid with payments at the end of each year. It can be repaid under the following two options: (i) Equal annual payments at an annual effective interest rate of 5%. (ii) Installments of 200 each year plus interest on the unpaid balance at an annual effective interest rate of i. The sum of the payments under option (i) equals the sum of the payments under option (ii). Calculate i.

  • Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% annual...

    Loan amortization schedule  Personal Finance Problem   Joan Messineo borrowed ​$49 comma 00049,000 at a 66​% annual rate of interest to be repaid over 3 years. The loan is amortized into three​ equal, annual,​ end-of-year payments. a.  Calculate the​ annual, end-of-year loan payment. b.  Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a.  The amount of...

  • A loan of $470,000 is amortized over 30 years with payments at the end of each...

    A loan of $470,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.5%, 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...

  • Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of...

    Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual end-of-year payments Calculate the annual end of year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of the...

  • A 15 year loan of $1000 is repaid with payments at the end of each year....

    A 15 year loan of $1000 is repaid with payments at the end of each year. Each of the first ten payments is 120% of the amount of interest due. Each of the last five payment is $X. The lender charges interest at an annual effective rate of 8%. Calculate X.

  • A $100,000 loan requires equal annual end-of-year payments of $38,803.35 for three years. a. What is...

    A $100,000 loan requires equal annual end-of-year payments of $38,803.35 for three years. a. What is the annual interest rate? b. Construct a loan amortization schedule to include the amount of interest and principal paid each year as well as the remaining balance at the end of each year. Enter the last principal number in year 3: for example in problem 13: you would enter 5735.84 (which was the last principal for 4 years).

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