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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Hello I am trying to input a formula to compute a mortgage monthly payment in excel
Solved by I. W. in 21 mins
Hello, I need help with a few excel formulas regarding a investment/savings, credit cards, and an amortization loan spreadsheet
Solved by S. Q. in 11 mins
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.
Solved by E. F. in 19 mins
Hi I need an amortization schedule for loans we have. What do you suggest?
Solved by E. Q. in 23 mins
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.
Solved by B. H. in 21 mins