HomeworkLib
Question

I am trying to use the PMT formula on excel to create an amortization for 15...

I am trying to use the PMT formula on excel to create an amortization for 15 and 30 years respectively. the loan 220,000. interest rate 15 years 3.125 and 20years 3.625.' every time I am using the excel the data is not accurate . Please show me how to use PMT for amortization

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

Homework Answers

Answer #1

Formulas Used :-

E155 =PMT(D155,C155,C152)

E156 =PMT(D156,C156,C152)

I hope my efforts will be fruitful to you..

0 0
Add a comment
Know the answer?
Add Answer to:
I am trying to use the PMT formula on excel to create an amortization for 15...
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

  • 1. In Cell D8 create formula PMT=PV/((1-1/(1+k)^n)/k), to calculate the periodic payment on a loan. 2....

    1. In Cell D8 create formula PMT=PV/((1-1/(1+k)^n)/k), to calculate the periodic payment on a loan. 2. In cell F8 use built-in function =PMT(k,n,PV). You should get identical answers. 3. Create amortization table (use absolute and relative addressing where appropriate). 4. Print worksheet. 5. Change loan amount and the rate (everything should adjust automatically) and print it again. 6. Print the cell formulas (force to one page). 7. Write report and explain all formulas and procedures. 8. Submit four printouts. PMT=$1589.99...

  • Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the format shown below: Scenario:...

    Spreadsheet 1: Amortization Table Create an amortization table in MS-Excel in the format shown below: Scenario: 2 years ago Janice got a $100,000, 15-year mortgage with an annual interest rate of 6% and monthly payments. 1) What is her monthly payment? 2) How much does she owe today (after 24 payments)? 3) How much will she owe in 3 years (after 60 payments)? 4) How much will she owe in 3 years (after 60 payments) if she makes an extra...

  • Create an amortization schedule via excel, using the following data listed above. Skills & Knowledge: Calculate...

    Create an amortization schedule via excel, using the following data listed above. Skills & Knowledge: Calculate the selling price of bonds using Excel and create a bond amortization schedule using Excel Task: Use Excel and the data provided below to: 1. Calculate the price of the bond and 2.Create an amortization schedule Use the amortization schedule format reflected in Chapter 14 of the required textbook. st" 1 in eto tting e il' wad nam asf ond Once you save and...

  • In trying to apply my knowledge in the real world, I am trying to create a...

    In trying to apply my knowledge in the real world, I am trying to create a realistic retirement schedule. However, I am running into difficulties using both a financial calculator as well as our equations from class in doing this. I am trying to do the following: plan a retirement schedule between the ages of 25 and 70, in which I would deposit 20% of my income each year. The income starts at 80,000 with an annual growth rate of...

  • Topic: ALUs I am trying to create an ALU with an operation for multiplying by 15....

    Topic: ALUs I am trying to create an ALU with an operation for multiplying by 15. The inputs are A (8 bit), 1 OP 3 bit, and an 8 bit output. I need to create a circuit multiplying the 8 bit A value by 15 giving us an 8 bit output value, but I don't know what to do. If someone could explain this to me, I would highly appreciate it. Thank you so much! PLEASE INCLUDE EXPLANATIONS

  • Create an Amortization Table from scratch in Excel. Make it for a 30-year loan and have...

    Create an Amortization Table from scratch in Excel. Make it for a 30-year loan and have the payments start in January 2019. Use a loan amount of $200,000 and an interest rate of 5.5%. Then, do the following: 1. Highlight remaining balance as of January 2020. 2. Highlight the total interest paid on the loan.

  • Please show the formula and answer in Excel f.   Find the PV of an ordinary annuity...

    Please show the formula and answer in Excel f.   Find the PV of an ordinary annuity that pays $1,000 at the end of each of the next 5 years if the interest rate is 15%. Then find the FV of that same annuity. Inputs: PMT = $      1,000 N = 5 I/YR = 15% PV: Use function wizard (PV) PV   = FV: Use function wizard (FV) FV   =

  • 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.

  • Need to generate Amortization Table in Excel for the following problem. The correct answers are given...

    Need to generate Amortization Table in Excel for the following problem. The correct answers are given but they need to be generated using Financial Functions. Marley has been saving and is soon planning to buy a house. The maximum amount she wants to mortgage is $220,000 and is considering either a 20 or 30 year mortgage. Assume payment is made at beginning of the period 1) What will her payment be for a 20 or 30 year mortgage. Assume a...

  • i dont think those answers are correct and i am trying to find the total interest...

    i dont think those answers are correct and i am trying to find the total interest Question 5 (of 35) Save & Exit Submit Time remaining: 2.51:03 8.00 points Problem 5-55 Amortization with Equal Payments (LO 3] Prepare an amortization schedule for a three year loan of $81,00). The interest rate is 8 percent per year, and the loan cals for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank....

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