Business

FinanceQ&A LibrarySuppose you want to buy a $148,000 home. You found a bank that offers a 30-year loan at 3.5% APR.What will be your monthly payment? (Round to the nearest cent.)$How much would you end up paying the bank for the home after 30 years? (Round to the nearest cent.)$Suppose you wanted to reduce the time of your loan to 25 years. What would be your new monthly payment? (Round to the nearest cent.)$How much would you end up paying the bank for the home after 25 years? (Round to the nearest cent.)$How much did you save by reducing the time of your mortgage loan? (Round to the nearest cent.)$Question

Asked Feb 10, 2020

3 views

What will be your monthly payment? (Round to the nearest cent.)

$

How much would you end up paying the bank for the home after 30 years? (Round to the nearest cent.)

$

Suppose you wanted to reduce the time of your loan to 25 years. What would be your new monthly payment? (Round to the nearest cent.)

$

How much would you end up paying the bank for the home after 25 years? (Round to the nearest cent.)

$

How much did you save by reducing the time of your mortgage loan? (Round to the nearest cent.)

$

Step 1

Loan Amount = $148,000

Time Period = 30 years

Interest Rate = 3.5%

The calculation of the monthly payment using the PMT function of the excel is as follows:

To open the "PMT function" window - MS-Excel --> Formulas --> Financials --> PMT.

Hence, the monthly payment is $665.

Step 2

Monthly Payment = $665

Time Period = 30 years

Number of Payments in a Period (N) = 12

The calculation of the total amount paid at the end of 30 years is as follows:

Hence, the total amount paid at the end of 30 years is $239,400.

Step 3

Loan Amount = $148,000

Time Period = 25 years

Interest Rate = 3.5%

The calculation of the monthly payment using the PMT function of the excel is as follows:

To open the "PMT function" window - MS-Excel --> Formulas --> Financials --> PMT.

Hence, the mon...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

Q: What formula do I use to solve this? If John wants to retire with $10000 per month, how mich princip...

A: Simple Interest formula is used to solve this problem because in this question John wants to earn an...

Q: Dyl Inc's bonds currently sell for $1,180 and have a par value of $1,000. They pay a $65 annual coup...

A: Par Value of the Bond (fv) = $1,000Coupon Payment (pmt) = $65Time to Maturity (nper) = 15 yearsCurre...

Q: Hi There, I need ask a favor... How to calculate "Current Liabilites" if I only know, these followi...

A: Quick Ratio = 2.0/XQuick Assets = $209.59 The calculation of the current liabilities is as follows:

Q: ABC Company purchased a 3-year MACRS property for $11,279 3 years ago. What is the current book valu...

A: Calculation of current book value of the equipment:Answer:Current book value of the equipment is $83...

Q: (U2.3,Q25) The following table shows annual rates for various types of loans in 2015. Assume monthly...

A: Monthly payment on a 5year car loan with annual interest rate of 4.30% is calculated as below:

Q: A borrower can borrow $10 million at a fixed-rate loan at 7.5% for six years, or a floating-rate loa...

A: The borrower should select the lowest rate alternative among the fixed rate and floating rate plus L...

Q: Revenues generated by a new fad product are forecast as follows: Year Revenues 1 $55,000 2 ...

A: a) Initial Investment is the sum of working capital and plant and equipment cost. Answer: Initial I...

Q: How is a country’s economic well-being enhanced through free international trade in goods and servic...

A: We can understand how a country’s economic well being is enhanced through free international trade i...

Q: Problem 3(2): The rapper Drake generated $22ml. in royalties in 2019. Suppose that such royalties ...

A: The formula of present vlaue of perpetuity is the cash flow after first period dividend with the dif...