Edwards signs a 30 year mortgage at 35 compounded monthly, Ask an Expert

Finance

Edwards signs a 30 year mortgage at 3.5% compounded monthly. The price of his house is $200,000. He makes a down payment of $40,000.

A) What will be his monthly payments? Please show excel functions to solve

B) After 5 years he makes a one-time payment of $50,000 against the remaining principle. How many months will he have remaining on his mortgage? (He had exactly 25 years remaining before he makes the $50,000 payment) Please show excel functions to solve

C) Instead of reducing the NPER after making the $50,000, he requests the bank to keep the NPER to 25 years and reduce his monthly payment instead. What will be his monthly payment going forward? Please show excel functions to solve.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92714977

Have any Question?Write your Review or question?

Related Questions in Financial Management

This week will develop the theory and application of

This week will develop the theory and application of capital budget analysis. The theory was robust, the calculations mathematically and logically defined, and many of the real-world problems, likely to be encountered, w ...

Question 1 what is marketing research what are the two

Question 1: What is marketing research? What are the two primary types of research? Question 2: What factors influence marketing research? Question 3: The role of statistics in business decision-making? Assignment : Sele ...

Corporate financial management questions -part a -q1 200

Corporate Financial Management Questions - Part A - Q1. $200 invested today and earning 8 per cent per annum compounded semi-annually will grow to what amount at the end of three years? (A) $158.80 (B) $251.94 (C) $380.7 ...

Capital structure and tax shields go to yahoo finances

"Capital Structure and Tax Shields" Go to Yahoo! Finance's Website, and select a publicly traded company which interests you. Determine the company's symbol (i.e., Apple = APPL) and navigate to the "SEC Filings" link on ...

Assignment1before the truth in lending act auto dealers

Assignment 1. Before the Truth in Lending Act, auto dealers used to use a trick called add on interest. Suppose you bought a $30,000 car and financed it over 5 years at 6% interest. To calculate your payment, they'd take ...

Topic dash dietthere are many different diets weight loss

Topic: DASH DIET There are many different diets, weight loss treatments, and medications that proclaim to be the panacea for weight loss. For this discussion forum, you will be researching a diet or treatment approach fo ...

Discussion as an initial response to the discussion topic

Discussion As an initial response to the discussion topic please create a Power Point presentation of 5 slides plus the title slide that contains the main results of part 2 of the Research Project. These slides should in ...

You will be conducting an interview with a market research

You will be conducting an interview with a market research professional or a company representative. Use the results of your research to make specific recommendations on how market research can be applied to the Marketpl ...

Assignment problems1 on the day harry was born his parents

Assignment Problems 1. On the day Harry was born, his parents put $1600 into an investment account that promises to pay a fixed interest rate of 5 percent per year. How much money will Harry have in this account when he ...

Financial management project -overview this assignment

Financial Management Project - Overview: This assignment consists of 2 questions covering Bond Valuation and Portfolio Analysis. Question 1: Bond Valuation Let's suppose today is 16/01/2018, and you are observing the inf ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert