Question: Build a amortization table for the loan below add extra payment to pay off early by no more the 6 months (the loan payment must

Build a amortization table for the loan below add extra payment to pay off early by no more the 6 months (the loan payment must last 4.5 years even with early payoff) . Show the money saved.

$35,000 loan, 5 years, 5.9% interest, monthly payments with no balloon.

Create an annuity solution to find the payment in Excel (that's the N I/Y PV PMT FV) and then do the amortization table for it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

!!!!!!ONLY ANSWER USING EXCEL PLEASE!!!!!! 4 You are financing a new home. 5 The loan is for $191,000 and you are getting rate of 4.1% per year. 56 You have decided on a 15 year mortgage and will...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

B DE Enter your name in this box F G H ANN L M N 5 6 Tutorial 6 - Calculating Loan Payments and Loan Amortization You will determine the loan payment and amortization schedule fee a fixed rate loan...

PART I"Basic Building Block" Excel Model Creation (Groups of up to 3individuals for Part I) Reference any all CCIM/G-M modules/chapters in course textbook or the library for any required supporting...

Change Janets Schedule In question 5 above, you calculated what the schedule would look like if Janet had made one $285.05 payment in January 2022. You did it by hand, but the Bankrate calculator has...

Different cash flow.Given the following cash inflow at the end of each year, LOADING... , what is the future value of this cash flow at 5 % , 10 % , and 15 % interest rates at the end of year 7? What...

In question 5 on the previous homework, you calculated what the schedule would look like if Janet had made one $285.05 payment in January 2022. This new calculation has Janet curious -- how would the...

Change Janets Schedule In Question 5 Above, You Calculated What The Schedule Would Look Like If Janet Had Made One $285.05 Payment In January 2022. You Did It By Hand, But The Bankrate Calculator Has...

D F F G H ! K M P R T U V w Y 2 question 1. Carleen Monte Instructions and to the right |MomN B Prindipol Ayindpal APR n $ $ 12,000.00 4.99% IPLES 12 Question 1-A car loan A popular way to pay off a...

10 of sales are made for cash Proon expects to receive 60 in the month following the sale and 25 in the second month following the sale The remaining 5 are expected to be un collectible Gross margin...

Assume that I have just conducted a study comparing cognitive development of lowbirthweight (premature) and normal-birthweight babies at one year of age. Using a score of my own devising, I found the...

4. Even when exploring the same theme, different writers use language in different ways. Look at these quotations describing the age and appearance of each grandmother: . Her wet head felt delicate...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.