ZuoTi.Pro
Question

5. Create a complete amortization table for the following loan: Plain vanilla fully amortizing constant payment...

5. Create a complete amortization table for the following loan: Plain vanilla fully amortizing constant payment loan with monthly payments 30 year term Rate on loan 4.5% Loan amount $777,777

****do work in excel please****

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

Homework Answers

Answer #1

Loan Amount = Present Value = $777777

Number of months = 12*30 = 360

Interest Rate = 4.5%

Excel Formula for monthly Payment = PMT(rate, periods, present value, future value)

Principal amount in each payment = PPMT(rate, month, periods, present value, future value)

Calculating using the above formula -

0 0
Add a comment
Know the answer?
Add Answer to:
5. Create a complete amortization table for the following loan: Plain vanilla fully amortizing constant payment...
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

  • Amortization of a Loan EXAMPLE EXERCISES For the following exercises, create an amortization table for a...

    Amortization of a Loan EXAMPLE EXERCISES For the following exercises, create an amortization table for a $21,500 car loan with 4.5% APR over 72 months. 1. What is the monthly payment? 2. How much is actually paid over the life of the loan? How much interest? 3. How much is saved if you round up to the next $50 increment? Next $100? For the following exercises, create an amortization table for $135,000 home purchase at 4.6% fixed APR. Remember mortgages...

  • 10. What is the payment in month 234 on a 30-year loan for $725,000 at 4.85%...

    10. What is the payment in month 234 on a 30-year loan for $725,000 at 4.85% that requires payments of $0 for the first five years and fully amortizing payments for the remaining years of the loan? (On Excel) Loan Amount: Years: Periods Per Year: Interest Rate: Balance at EOM 60: Total Amortization Years: What is the balloon payment due at maturity for a 10-year loan for $225,000 at 5.85% if the negotiated payment amount each month is $100 less...

  • Please use excel functions 6. What is the payment in month 234 on a 30-year loan...

    Please use excel functions 6. What is the payment in month 234 on a 30-year loan for $925,000 at 4.85% that requires no payments during the first five years and fully amortizing payments for the remaining years of the loan? Answer Loan Amount Years Periods Per Year Interest Rate Balance at EOM 60 Total Amortization Years 7 What is the balloon nayment du at maturity for a 10-year loan for $325 000 at 5 9507 if

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

  • Create an amortization table for a 25-year mortgage loan that has monthly payments. The values in...

    Create an amortization table for a 25-year mortgage loan that has monthly payments. The values in the input range should be loan face value ($500,000), APR (4.5%), and monthly prepayment amount ($100). Make sure the spreadsheet is fully interactive, so the entire sheet correctly updates when a change in any input is made Add a column to the right of the table developed in (a), to keep track of the month that the loan is paid off after taking prepayments...

  • Loan Amortization Schedule You purchase a fully loaded Honda Accord with an MSRP of $32,000 for...

    Loan Amortization Schedule You purchase a fully loaded Honda Accord with an MSRP of $32,000 for $27,000. You pay the 3% tax of $810 up front and put down $5,000. The dealer offers a simple interest installment loan with an annual rate of 5% for 3 years. The projected resale value of the car after 2 years is $17,000. Compute the loan value and monthly loan payments. (10 pts) Create a monthly amortization schedule over the entire loan period. (10...

  • 32) Given the following information on a 30-year fixed-payment fully amortizing loan, determine the owner's equity...

    32) Given the following information on a 30-year fixed-payment fully amortizing loan, determine the owner's equity in the property after seven years if the market value of the property is $240,000 at the end of year 7: rate: 7%; monthly payment: $1,200. use financial calculator A) $15,967.33 B) $59,630.92 C) $75,598.25 D) $164,401.75 Answer: C

  • You need to borrow $200,000. E-Click loans will make a 30 year, fully amortizing mortgage loan...

    You need to borrow $200,000. E-Click loans will make a 30 year, fully amortizing mortgage loan with monthly payments, with no points at an interest rate of 8%. (a) Construct a loan amortization schedule for the first 4 months of the loan. (b) What is the principal amount of your loan outstanding after 7 years (84 months) of making payments? Show that you can determine this by finding the FV of the loan after 7 years. Highlight your final answer

  • Create a monthly loan amortization schedule for the following loan: The amount to borrow is: 15,000.00...

    Create a monthly loan amortization schedule for the following loan: The amount to borrow is: 15,000.00 Term of the loan:     3 years Annual interest rate: 6% Loan payments are made monthly.

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