Question: 2. (0-5pts) Write an Excel function in cell F5 to determine the yearly interest rate being charged by the bank on your $175,000 30- year

2. (0-5pts) Write an Excel function in cell F5 to determine the yearly interest rate being charged by the bank on your $175,000 30- year mortgage. You make a monthly mortgage payment of $2000 and the value of the loan at the end of thirty years is zero. Interest is compounded monthly. (Hint: Use the RATE() function here then multiply by # periods per year to get interest rate per year.) =RATE(

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 Economics Questions!

I need help doing Present Value. Must use all 3 files to answer the questions. Direction: The first 5 pages will teach you about the basics of the present value calculation. Following are three...

using excel functions 10 points) I found a cookie jar with a bank note in it from 1900. The value in 1900 was $100 and the Da which is still in existence promises to pay 3% per year year compounded...

Could someone help me do this please. I dont know how to do any of this :( 119,500 1Selling Price Enough for AnnualDown interest! Payment|n years! Durationpriods Loan Interest 1st Payment per down...

how am i supposed to do the right formulas. #3 letter d especially Safari File Edit View History Bookmarks Window Help Instructions... Destan Layout Reference Com A. Font Paragraph Styles Dictate...

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

Data link: https://drive.google.com/drive/folders/1txHtl8_W2u1rUnGwdgDONyfg22KVKWUP?usp=sharing CAS 171 - Final Project: Computer Warehouse Data Files: ComputerWarehouse.accdb,...

Hello. I'm looking for some help completing my finance project. (10% total course grade) There are quite a few questions. (40 total) I can check the answers one time before submitting. Hoping for...

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

Project Description: You are the executive assistant to the director of sales at B-Trendz, Inc., a trendy retail store that has locations in only ten states. The company is considering branching into...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

Compare the energies required to reach the Moon for a 105-kg spacecraft and a 103-kg satellite. Explain why it takes more fuel for a spacecraft to travel from the Earth to the Moon than for the...

You own a manufacturing facility in Northern California. The damage expected if an earthquake occurs is $20 million. The probability of an earthquake over the life of your plant (20 yrs) in Northern...

Explain why taxation is both an advantage and a disadvantage for sole proprietorships. View keyboard shortcuts EditViewInsertFormatToolsTable 1 2 pt Paragraph

2. 3. Do you think that the marketing research industry should be concerned about Google Consumer Surveys? Why? Most traditional consumer surveys conclude with a series of demographic questions such...

1. Discuss the following statements: (a) The dangers of mountain driving in an old Lada 4 4, and safety concerns. (b) We perceive the world backwards. (c) Numbers are different from words, but they...

5. How can a sender (utterer) directly influence the interpreter (receiver)?

10. Find a news article in a daily newspaper, and answer the following questions: (a) Does the information in the article support your views and attitudes or does it conflict with them? (b) Does the...