Question: How do you calculate this function on Excel to get the answer provided? Rutherford Hayes has borrowed $80000 as mortgage loan at 7.5% interest rate

How do you calculate this function on Excel to get the answer provided?

Rutherford Hayes has borrowed $80000 as mortgage loan at 7.5% interest rate and 30-year term. He has to pay the loan in monthly installments. After how many payments will the unpaid balance become $40000? (Answer: 264.94 months)

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!

How do you calculate this function on Excel to get the answer provided? Cooper corporation has borrowed $120,000 from the bank at 8% annual interest rate, compounded monthly. The company plans to pay...

Rutherford Hayes has borrowed $80000 as mortgage loan at 7.5% interest rate and 30-year term. He has to pay the loan in monthly installments. After how many payments will the unpaid balance become...

Wondering how you show theese calculations through excel? youre 55 years old today, and you wish to start saving for your pension. Here are the parameters: You intend to make a deposit today and at...

Project 1: Loans Winter 2023 Brief Description You will use Google Sheets or Excel to construct several amortization tables for a potential home or vehicle loan. You will answer questions based on...

pls answer ques. 3 & 4...work is required to be shown on excel if possible. Thank you Project Assignment No. 1 PROBLEM 2- Maria is interested in financing the purchase of a property for sale for...

Dear Dr Fids, Can you please help these questions? It is about MBS cash flow. R Generating MBS cash flows can be messy so we are going to write some functions in R that allows us to generate the cash...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Need help figuring out problem #40, #42, and #45 in the attached document. I have the answers for the problems, but need to see how they are worked out. FIN 142 - Real Estate Finance Problem Set 2 1....

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

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...

The Hickory Cabinet and Furniture Company makes chairs. The fixed cost per month of making chairs is $7,500, and the variable cost per chair is $40. Price is related to demand, according to the...

1 With the TVM solver calculate the amounts at age 65 that would result from making a monthly deposit of $300 starting at age 16 into a saving account that earns 3% interest per annum, compounded...

In Financial markets, borrowers and lenders must both be located in the same country. True False

don't use third party content 1 8 5 . How does a gas - cooled fast reactor work?

Lets say a company has nine divisions, and each division has a different check number based on its divisionso one starts with 1, another with 2, and so on. Would Benfords law work in this situation?

How does the computation of summary statistics (mean, mode, median, max, min, etc.) meet the definition of descriptive analytics?

A sequence check will help us to see if there is a duplicate payment to vendors. Why is that important for the auditor to find?