Question: please post how to do this in excel thank you! Suppose you buy a home and borrow $126,000 using a 30 year mortgage with an

please post how to do this in excel thank you!

Suppose you buy a home and borrow $126,000 using a 30 year mortgage with an annual interest rate of 5.30% (compounded monthly). You recall your FI 302 professor talking about how increasing your monthly payment can save you both time and money. You decided to pay 10% more each month than what the bank suggests your payment should be. Given this, in how many years will you pay off the loan? 24.3 32.1 21.1 27.9 18.4

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!

Analysis to be done using Excel. (Note go over Time value of money recorded lecture and also supplemental reading material on Time value OF money) Required format on Excel is shown below for each...

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

Download the Excel file that I provided Part A: Challenging Time Value Questions Suppose that a savings account is opened with an initial deposit of $2,000. Also, the account gets the interest that...

ACCT 211 Spring 2021 Individual Learning project for Chapter 13 Each part is a tab on the spreadsheet. You can use the tables provided, a financial calculator, or (preferably) Excel functions PV and...

Directions: Answer all questions. While you may use your calculator, be sure to show what calculations you do in the spil sure you fill out the summary sheet on the last page. 1. Before you buy a...

what formulas do you have to use to solve part b? and how do you do the equations in excel. FIN419: Fall 2016 Individual Project 2: TVM & Bond Duration (Due date: Oct 9, 2016) Please send your Excel...

ANY TUTOR PLEASE FOR THIS MACRO-ECON QUESTION OWN WORK NEEDED! *TYPED WORK. 1. Problem 1 Consider the Ramsey-Cass-Koopmans (RCK) model seen in class. The household seeks to maximize its lifetime...

Long time ago Lisa had put an amount of $50,000 into an investment in the securities market. Now she has $150,000 in her investment account. Required: a) If the average rate of return Lisa earned for...

You deposit $8,200 into a savings account with an annual percentage rate (APR) of 5.2%. a. Compute the amount of interest you earn after one year.____________ b. Complete the following table. Year...

An alloy of iron (71.0%), cobalt (12.0%), and molybdenum (17.0%) has a density of 8.20 g/cm3. How many cobalt atoms are there in a cylinder with a radius of 2.50 cm and a length of 10.0 cm?

Tunstall, Inc., a small service company, keeps company, keeps its records without the help of an accountant. After much effort, an outside accountant prepared the following unadjusted trial balance...

Which of the following portfolio weighting approaches describes assigning higher ( lower ) portolio weights to stocks with higher ( lower ) prices? 1 5 0 1 2 5 Select one: a . Technical analysis D ....

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

1. To what extent do you agree with the criticisms of Stephen Elops memo to his staff?

define the term outplacement

describe the services that an outplacement consultancy may provide.