ZuoTi.Pro
Question
Please show formula(s) and work.
Problem 1: You take out an amortized loan for $10,000. The loan is to be paid in equal installments at the end of each of the next 5 years. The interest rate is 8%. Construct an amortization schedule.
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 SCREENSHOT. ANY DOUBTS, HAPPY TO HELP YOU. THANK YOU. THUMBS UP PLEASE.

I HAVE FOUND "PMT" USING EXCEL AND THEN PREPARED AMORTIZATION SCHEDULE.

IN SECOND IMAGE, I HAVE FOUND "PMT" USING FORMULA AS WELL.

Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy Σ AutoSum Wrap Text B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 conditional Format . Cell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number Cells H41 41 43 LOAN RATE YEARS PMT 10000 3% 5 45 46 47 48 49 YEAR 50 51 52 53 54 $2,504.56 EXCEL FORMULA-PMT(8%,5-10000) LOAN BALANCE PORTION TO INTEREST C A*0.08 PORTION TONEW PRINCIPAL D- B-C PAYMENT BALANCE 1 $10,000.00 2 $ 8,295.44 3 6,454.51 4 S 4,466.30 5 2,319.04 $2,504.56 $ 2,504.56 $ $2,504.56 $ 2,504.56 $ $ 2,504.56 $ 800.00 663.63 516.36 357.30 185.52 E-A-D 1,704.56 $ 8,295.44 1,840.93 $6,454.51 1,988.20 4,466.30 $2,147.26 $ 2,319.04 2,319.04 $ 56 57 58 59 11 トトー MÍN VAR PORT BEST CAL BINOMIAL 2 TIME- SINKING AMORTIZA A Sheet2 JORDAN INSURANCE 01:44Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Font Alignment Number Cells K72 61 62 63 64 65 WE CAN FIND AMOUNT OF INSTALMENT USING FORMULA ALSO WE HAVE TO USE PRESENT VALUE OF ANNUITY FORMULA PVA = 10000A/0.08 *(1-(1/(1+0.08)A5) 10000 A/0.08 (0.319416803) 67 68 69 70 71 72 73 74 75 76 10000*0.08/0.319416803 2504.56 78 79 11 トトー MÍN VAR PORT BEST CAL BİNOMIAL 2 TIME- SINKING AMORTIZA Sheet2 JORDAN INSURANCE 01:47

0 0
Add a comment
Know the answer?
Add Answer to:
Please show formula(s) and work. Problem 1: You take out an amortized loan for $10,000. The...
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 show formulas and work. No excel formulas please. Problem 1 You take out an amortized...

    Please show formulas and work. No excel formulas please. Problem 1 You take out an amortized loan for $10,000. The loan is to be paid in equal installments at the end of each of the next 5 years. The interest rate is 8%. Construct an amortization schedule. Problem 2: A. Calculate the PV of $100 due in 5 years compounded daily at 12%. B. Calculate the FV of $1000 due in 3 years at 6% compounded quarterly. C. Calculate the...

  • HW 2

    Problem 1 You take out an amortized loan for $10,000. The loan is to be paid in equal installments at the end of each of the next 5 years. The interest rate is 8%. Construct an amortization schedule. Problem 2: A. Calculate the PV of $100 due in 5 years compounded daily at 12%. B. Calculate the FV of $1000 due in 3 years at 6% compounded quarterly. C. Calculate the FVA of $300 due at the end of each...

  • 2) You have received a 3-year $10,000 loan from your bank. This is an amortized loan...

    2) You have received a 3-year $10,000 loan from your bank. This is an amortized loan which means you have to make 3 equal annual payments to the bank. The bank is charging you 12% APR (annual percentage rate) for this loan. a. Complete the following amortization schedule. (25 points) Amortization schedule Beginning Balance Annual Payment Interest Balance Reduction year End Balance Expense $10,000 $0.00 How much in total you end up paying back to the bank? (5 points) Assume...

  • Amortized loan: The next three questions will be based on the following information. Prepare an amortization...

    Amortized loan: The next three questions will be based on the following information. Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment. For the above loan, how much is the total interest paid over three years?

  • Amortization schedules a. Set up an amortization schedule for a $250,000 mortgage to be repaid in...

    Amortization schedules a. Set up an amortization schedule for a $250,000 mortgage to be repaid in equal monthly installments at the end of each month for the next 15 years. The mortgage rate is an APR of 4.5%. b. How large must each monthly payment be if the loan is for $500,000? Assume that the interest rate remains at 4.5% and that the loan is paid off over 15 years. c. How large must each monthly payment be if the...

  • Please show the works P5-48 Loan amortization schedule Joan Messineo borrowed $45,000 at a 4% annual...

    Please show the works P5-48 Loan amortization schedule Joan Messineo borrowed $45,000 at a 4% annual rate of interest that she must repay over 3 years. The loan is amortized into three equal, end-of-year payments. a. Calculate the end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal break- down of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.

  • 13-19 odd please 13. A $10,000 loan is to be amortized for 10 years with quarterly...

    13-19 odd please 13. A $10,000 loan is to be amortized for 10 years with quarterly payments of $334.27. If the interest rate is 6% compounded quarterly, what is the unpaid balance immediately after the sixth payment? 14. A debt of $8000 is to be amortized with 8 equal semi- annual payments of $1288.29. If the interest rate is 12% compounded semiannually, find the unpaid balance immediately after the fifth payment. 15. When Maria Acosta bought a car 2 years...

  • Amortization schedules a. Set up an amortization schedule for a $250,000 mortgage to be repaid in...

    Amortization schedules a. Set up an amortization schedule for a $250,000 mortgage to be repaid in equal monthly installments at the end of each month for the next 15 years. The mortgage rate is an APR of 5%. b. How large must each monthly payment be if the loan is for $500,000? Assume that the interest rate remains at 5% and that the loan is paid off over 15 years. c. How large must each monthly payment be if the...

  • You take out a 30-year loan in the amount of $450,000 at a 6 percent rate...

    You take out a 30-year loan in the amount of $450,000 at a 6 percent rate annually. The loan is to be paid off by equal monthly installments over 30 years. How much is the total interest payment for the first five months? Draw an amortization table to support your answer showing the beginning balance, total payment, principal repayment, interest payment and ending balance. (Note: You need to show only five months on the table. You may use excel and...

  • You borrowed ​$100,000 exactly 5 years ago. The loan is structured as an amortized loan. The...

    You borrowed ​$100,000 exactly 5 years ago. The loan is structured as an amortized loan. The interest rate is 7% and you make quarterly​ (end-of-quarter) payments of ​$2124.88. The loan is amortized over 25 years. How much principal have you paid over the first 5 ​years? Use Excel to calculate. Please show all Excel formulas.

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