Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello,if someone can someone please help how to calculate it on excel Original Balance Monthly Payment ($) Interest Rate (Annual %age) Loan Term (Years) Amortization

Hello,if someone can someone please help how to calculate it on excel

Original Balance Monthly Payment ($) Interest Rate (Annual %age) Loan Term (Years) Amortization Schedule (Years) Ending Balance
$98,700.00 $329.00 4.00% $98,700.00
$34,000.00 $85.00 3.00% $34,000.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Finance: An Object-Oriented Approach In C++

Authors: Erik Schlogl, Dilip B. Madan

1st Edition

1584884797, 978-1584884798

More Books

Students also viewed these Finance questions