Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help with excel formulas Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the

need help with excel formulas

image text in transcribed

Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the loan are shown below): Correct Answers 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 3. How many months will it take to pay off the loan if you pay an extra $323.81 per month? Note: Enter the month when the whole principal is paid off. Also, remember to show the amortization table for the original payment before you submit. Payment Beginning Payment Amount Interest Paid Principle Paid Ending Balance No. Balance Amount Loan Input Data Principal Amount $590,000.00 Annual Interest Rate 6.90% Periods Per Year 12 360 Total Number of Payments Percentage Rate Per Period Extra Payment per month $323.81 1 2 3 4 5 6 7

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_2

Step: 3

blur-text-image_3

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

States And The Reemergence Of Global Finance

Authors: Eric Helleiner

1st Edition

0801428599, 978-0801428593

More Books

Students also viewed these Finance questions

Question

600 lb 20 0.5 ft 30 30 5 ft

Answered: 1 week ago

Question

Identify the cause of a performance problem. page 363

Answered: 1 week ago