Get instant live expert help on I need help with mortgage amortization excel

Hello I am trying to input a formula to compute a mortgage monthly payment in excel

Hello, I need help with a few excel formulas regarding a investment/savings, credit cards, and an amortization loan spreadsheet

Assume you purchase a home for $395,000. You find a bank that offers a 30-year mortgage with an APR of 4.65% but requires 20% down. You decide to finance your home through this bank. Prepare a 30-year amortization schedule showing your monthly payments. Show how much interest you will pay for this home over the 30 years of payments to the bank. Describe what change in your budget you and your spouse might make to find an additional $100 to make additional principle payments on your home. Prepare a second amortization schedule showing the new payment (include the extra $100 found in step #3). Show how much faster you will pay off your mortgage, and how much interest you will have saved by making the $100 additional payment.

Hi I need an amortization schedule for loans we have. What do you suggest?

hi can you please help me figure out the formulas to this question: In cell B11, create a formula using the PV function to determine the outstanding balance of the campground mortgage at the end of the current year using the parameters below: a. For the rate parameter, use the value in cell B5 (the yearly interest rate of the mortgage) divided by 12. b. For the nper parameter, subtract the value in cell B10 (the current year of the mortgage) from the value in cell B6 (the total number of years of the mortgage), and multiply that by 12.